139: LINE_ID,
140: CP_SERVICE_ID,
141: MASS_RENEW_TXN_TEMP_ID)
142: VALUES
143: (CS_ORDERS_INTERFACE_S.NEXTVAL,
144: V_LAST_UPDATED_BY,
145: SYSDATE,
146: 'Y',
147: 'DELETE',
171: LINE_ID,
172: CANCEL_CP_ID,
173: MASS_RENEW_TXN_TEMP_ID)
174: VALUES
175: (CS_ORDERS_INTERFACE_S.NEXTVAL,
176: V_LAST_UPDATED_BY,
177: SYSDATE,
178: 'N',
179: 'DELETE',
260: , CANCEL_QUANTITY
261: , CANCEL_CP_ID
262: )
263: VALUES
264: ( CS_ORDERS_INTERFACE_S.NEXTVAL
265: , V_LAST_UPDATED_BY
266: , 'Y'
267: , SYSDATE
268: , 'CANCEL'
656: , CANCEL_QUANTITY
657: , CANCEL_CP_ID
658: )
659: VALUES
660: ( CS_ORDERS_INTERFACE_S.NEXTVAL
661: , V_LAST_UPDATED_BY
662: , 'Y'
663: , SYSDATE
664: , 'CANCEL'