4 -- Update ACQ cancel reason names, but only those that
5 -- have not already been locally modified from stock values.
7 UPDATE acq.cancel_reason
8 SET label = oils_i18n_gettext(1,'Canceled: Invalid ISBN', 'acqcr', 'label')
9 WHERE id = 1 AND label = 'invalid_isbn';
11 UPDATE acq.cancel_reason
12 SET label = oils_i18n_gettext(1,'Canceled: Postpone', 'acqcr', 'label')
13 WHERE id = 2 AND label = 'postpone';
15 UPDATE acq.cancel_reason
16 SET label = oils_i18n_gettext(1,'Delayed: Delivered but Lost', 'acqcr', 'label')
17 WHERE id = 3 AND label = 'delivered_but_lost';
19 UPDATE acq.cancel_reason
20 SET label = oils_i18n_gettext(1,'Canceled: Deleted', 'acqcr', 'label')
21 WHERE id = 1002 AND label = 'Deleted';
23 UPDATE acq.cancel_reason
24 SET label = oils_i18n_gettext(1,'Delayed: Changed', 'acqcr', 'label')
25 WHERE id = 1003 AND label = 'Changed';
27 UPDATE acq.cancel_reason
28 SET label = oils_i18n_gettext(1,'Delayed: No Action', 'acqcr', 'label')
29 WHERE id = 1004 AND label = 'No action';
31 UPDATE acq.cancel_reason
32 SET label = oils_i18n_gettext(1,'Delayed: Accepted without amendment', 'acqcr', 'label')
33 WHERE id = 1005 AND label = 'Accepted without amendment';
35 UPDATE acq.cancel_reason
36 SET label = oils_i18n_gettext(1,'Canceled: Not Accepted', 'acqcr', 'label')
37 WHERE id = 1007 AND label = 'Not accepted';
39 UPDATE acq.cancel_reason
40 SET label = oils_i18n_gettext(1,'Canceled: Not Found', 'acqcr', 'label')
41 WHERE id = 1010 AND label = 'Not found';
43 UPDATE acq.cancel_reason
44 SET label = oils_i18n_gettext(1,'Delayed : Accepted with amendment', 'acqcr', 'label')
45 WHERE id = 1024 AND label = 'Accepted with amendment, no confirmation required';
47 UPDATE acq.cancel_reason
48 SET label = oils_i18n_gettext(1,'Delayed : Split Quantity', 'acqcr', 'label')
49 WHERE id = 1211 AND label = 'Split quantity';
51 UPDATE acq.cancel_reason
52 SET label = oils_i18n_gettext(1,'Delayed : Ordered Quantity', 'acqcr', 'label')
53 WHERE id = 1221 AND label = 'Ordered quantity';
55 UPDATE acq.cancel_reason
56 SET label = oils_i18n_gettext(1,'Delayed : Pieces Delivered', 'acqcr', 'label')
57 WHERE id = 1246 AND label = 'Pieces delivered';
59 UPDATE acq.cancel_reason
60 SET label = oils_i18n_gettext(1,'Delayed : Backorder', 'acqcr', 'label')
61 WHERE id = 1283 AND label = 'Backorder quantity';