88: sysdate,
89: sysdate,
90: 'DRC',
91: sysdate,
92: FND_GLOBAL.USER_ID,
93: sysdate,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.LOGIN_ID
96: );
90: 'DRC',
91: sysdate,
92: FND_GLOBAL.USER_ID,
93: sysdate,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.LOGIN_ID
96: );
97:
98: insert into xdp_order_line_items
91: sysdate,
92: FND_GLOBAL.USER_ID,
93: sysdate,
94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.LOGIN_ID
96: );
97:
98: insert into xdp_order_line_items
99: (
130: 0,
131: sysdate,
132: p_workitem_id,
133: sysdate,
134: FND_GLOBAL.USER_ID,
135: sysdate,
136: FND_GLOBAL.USER_ID,
137: FND_GLOBAL.LOGIN_ID
138: )
132: p_workitem_id,
133: sysdate,
134: FND_GLOBAL.USER_ID,
135: sysdate,
136: FND_GLOBAL.USER_ID,
137: FND_GLOBAL.LOGIN_ID
138: )
139: returning line_item_id into lv_line_id;
140:
133: sysdate,
134: FND_GLOBAL.USER_ID,
135: sysdate,
136: FND_GLOBAL.USER_ID,
137: FND_GLOBAL.LOGIN_ID
138: )
139: returning line_item_id into lv_line_id;
140:
141: IF p_task_parameter.count > 0 THEN
157: lv_line_id,
158: p_task_parameter(lv_index).parameter_name,
159: p_task_parameter(lv_index).parameter_value,
160: sysdate,
161: FND_GLOBAL.USER_ID,
162: sysdate,
163: FND_GLOBAL.USER_ID,
164: FND_GLOBAL.LOGIN_ID
165: );
159: p_task_parameter(lv_index).parameter_value,
160: sysdate,
161: FND_GLOBAL.USER_ID,
162: sysdate,
163: FND_GLOBAL.USER_ID,
164: FND_GLOBAL.LOGIN_ID
165: );
166: lv_index := p_task_parameter.next(lv_index);
167: end loop;
160: sysdate,
161: FND_GLOBAL.USER_ID,
162: sysdate,
163: FND_GLOBAL.USER_ID,
164: FND_GLOBAL.LOGIN_ID
165: );
166: lv_index := p_task_parameter.next(lv_index);
167: end loop;
168: END IF;
201: update xdp_order_headers
202: set status_code = 'COMPLETED',
203: state = 'COMPLETED',
204: last_update_date = sysdate,
205: last_updated_by = FND_GLOBAL.USER_ID,
206: last_update_login = FND_GLOBAL.LOGIN_ID
207: where order_id = x_sdp_order_id;
208:
209: update xdp_order_line_items
202: set status_code = 'COMPLETED',
203: state = 'COMPLETED',
204: last_update_date = sysdate,
205: last_updated_by = FND_GLOBAL.USER_ID,
206: last_update_login = FND_GLOBAL.LOGIN_ID
207: where order_id = x_sdp_order_id;
208:
209: update xdp_order_line_items
210: set status_code = 'COMPLETED',
209: update xdp_order_line_items
210: set status_code = 'COMPLETED',
211: state = 'COMPLETED',
212: last_update_date = sysdate,
213: last_updated_by = FND_GLOBAL.USER_ID,
214: last_update_login = FND_GLOBAL.LOGIN_ID
215: where line_item_id = lv_line_id;
216: Else
217: update xdp_order_headers
210: set status_code = 'COMPLETED',
211: state = 'COMPLETED',
212: last_update_date = sysdate,
213: last_updated_by = FND_GLOBAL.USER_ID,
214: last_update_login = FND_GLOBAL.LOGIN_ID
215: where line_item_id = lv_line_id;
216: Else
217: update xdp_order_headers
218: set status_code = 'ERROR',
217: update xdp_order_headers
218: set status_code = 'ERROR',
219: state = 'COMPLETED',
220: last_update_date = sysdate,
221: last_updated_by = FND_GLOBAL.USER_ID,
222: last_update_login = FND_GLOBAL.LOGIN_ID
223: where order_id = x_sdp_order_id;
224:
225: update xdp_order_line_items
218: set status_code = 'ERROR',
219: state = 'COMPLETED',
220: last_update_date = sysdate,
221: last_updated_by = FND_GLOBAL.USER_ID,
222: last_update_login = FND_GLOBAL.LOGIN_ID
223: where order_id = x_sdp_order_id;
224:
225: update xdp_order_line_items
226: set status_code = 'ERROR',
225: update xdp_order_line_items
226: set status_code = 'ERROR',
227: state = 'COMPLETED',
228: last_update_date = sysdate,
229: last_updated_by = FND_GLOBAL.USER_ID,
230: last_update_login = FND_GLOBAL.LOGIN_ID
231: where line_item_id = lv_line_id;
232:
233: END IF;
226: set status_code = 'ERROR',
227: state = 'COMPLETED',
228: last_update_date = sysdate,
229: last_updated_by = FND_GLOBAL.USER_ID,
230: last_update_login = FND_GLOBAL.LOGIN_ID
231: where line_item_id = lv_line_id;
232:
233: END IF;
234:
389: UPDATE XDP_FULFILL_WORKLIST
390: set status_code = 'ERROR',
391: -- error_ref_id = lv_ref_id,
392: last_update_date = sysdate,
393: last_updated_by = FND_GLOBAL.USER_ID,
394: last_update_login = FND_GLOBAL.LOGIN_ID
395: where
396: workitem_instance_id = p_workitem_instance_id;
397: /*COMMIT;*/
390: set status_code = 'ERROR',
391: -- error_ref_id = lv_ref_id,
392: last_update_date = sysdate,
393: last_updated_by = FND_GLOBAL.USER_ID,
394: last_update_login = FND_GLOBAL.LOGIN_ID
395: where
396: workitem_instance_id = p_workitem_instance_id;
397: /*COMMIT;*/
398:
423: UPDATE XDP_FULFILL_WORKLIST
424: set status_code = 'ERROR',
425: -- error_ref_id = lv_ref_id,
426: last_update_date = sysdate,
427: last_updated_by = FND_GLOBAL.USER_ID,
428: last_update_login = FND_GLOBAL.LOGIN_ID
429: where
430: workitem_instance_id = p_workitem_instance_id;
431: /*COMMIT;*/
424: set status_code = 'ERROR',
425: -- error_ref_id = lv_ref_id,
426: last_update_date = sysdate,
427: last_updated_by = FND_GLOBAL.USER_ID,
428: last_update_login = FND_GLOBAL.LOGIN_ID
429: where
430: workitem_instance_id = p_workitem_instance_id;
431: /*COMMIT;*/
432:
447: update XDP_FULFILL_WORKLIST
448: set status_code = 'ERROR',
449: state = 'COMPLETED',
450: last_update_date = sysdate,
451: last_updated_by = FND_GLOBAL.USER_ID,
452: last_update_login = FND_GLOBAL.LOGIN_ID
453: where workitem_instance_id = p_workitem_instance_id;
454: ELSE
455: update XDP_FULFILL_WORKLIST
448: set status_code = 'ERROR',
449: state = 'COMPLETED',
450: last_update_date = sysdate,
451: last_updated_by = FND_GLOBAL.USER_ID,
452: last_update_login = FND_GLOBAL.LOGIN_ID
453: where workitem_instance_id = p_workitem_instance_id;
454: ELSE
455: update XDP_FULFILL_WORKLIST
456: set status_code = 'COMPLETED',
455: update XDP_FULFILL_WORKLIST
456: set status_code = 'COMPLETED',
457: state = 'COMPLETED',
458: last_update_date = sysdate,
459: last_updated_by = FND_GLOBAL.USER_ID,
460: last_update_login = FND_GLOBAL.LOGIN_ID
461: where workitem_instance_id = p_workitem_instance_id;
462: END IF;
463: /*COMMIT;*/
456: set status_code = 'COMPLETED',
457: state = 'COMPLETED',
458: last_update_date = sysdate,
459: last_updated_by = FND_GLOBAL.USER_ID,
460: last_update_login = FND_GLOBAL.LOGIN_ID
461: where workitem_instance_id = p_workitem_instance_id;
462: END IF;
463: /*COMMIT;*/
464:
489: UPDATE XDP_FULFILL_WORKLIST
490: set status_code = 'ERROR',
491: state = 'COMPLETED',
492: last_update_date = sysdate,
493: last_updated_by = FND_GLOBAL.USER_ID,
494: last_update_login = FND_GLOBAL.LOGIN_ID
495: -- ,error_ref_id = lv_ref_id
496: where
497: workitem_instance_id = p_workitem_instance_id;
490: set status_code = 'ERROR',
491: state = 'COMPLETED',
492: last_update_date = sysdate,
493: last_updated_by = FND_GLOBAL.USER_ID,
494: last_update_login = FND_GLOBAL.LOGIN_ID
495: -- ,error_ref_id = lv_ref_id
496: where
497: workitem_instance_id = p_workitem_instance_id;
498: /*COMMIT;*/
588: UPDATE xdp_fa_runtime_list
589: set status_code = 'ERROR',
590: state = 'COMPLETED',
591: last_update_date = sysdate,
592: last_updated_by = FND_GLOBAL.USER_ID,
593: last_update_login = FND_GLOBAL.LOGIN_ID
594: -- , error_ref_id = lv_ref_id
595: where
596: fa_instance_id = p_fa_instance_id;
589: set status_code = 'ERROR',
590: state = 'COMPLETED',
591: last_update_date = sysdate,
592: last_updated_by = FND_GLOBAL.USER_ID,
593: last_update_login = FND_GLOBAL.LOGIN_ID
594: -- , error_ref_id = lv_ref_id
595: where
596: fa_instance_id = p_fa_instance_id;
597: /*COMMIT;*/
668: UPDATE xdp_fa_runtime_list
669: set status_code = 'ERROR',
670: state = 'COMPLETED',
671: last_update_date = sysdate,
672: last_updated_by = FND_GLOBAL.USER_ID,
673: last_update_login = FND_GLOBAL.LOGIN_ID
674: -- ,error_ref_id = lv_ref_id
675: where
676: fa_instance_id = p_fa_instance_id;
669: set status_code = 'ERROR',
670: state = 'COMPLETED',
671: last_update_date = sysdate,
672: last_updated_by = FND_GLOBAL.USER_ID,
673: last_update_login = FND_GLOBAL.LOGIN_ID
674: -- ,error_ref_id = lv_ref_id
675: where
676: fa_instance_id = p_fa_instance_id;
677: /*COMMIT;*/
697: UPDATE xdp_fa_runtime_list
698: set status_code = 'ERROR',
699: state = 'COMPLETED',
700: last_update_date = sysdate,
701: last_updated_by = FND_GLOBAL.USER_ID,
702: last_update_login = FND_GLOBAL.LOGIN_ID
703: -- ,error_ref_id = lv_ref_id
704: where
705: fa_instance_id = p_fa_instance_id;
698: set status_code = 'ERROR',
699: state = 'COMPLETED',
700: last_update_date = sysdate,
701: last_updated_by = FND_GLOBAL.USER_ID,
702: last_update_login = FND_GLOBAL.LOGIN_ID
703: -- ,error_ref_id = lv_ref_id
704: where
705: fa_instance_id = p_fa_instance_id;
706: /*COMMIT;*/
724: UPDATE xdp_fa_runtime_list
725: set status_code = 'COMPLETED',
726: state = 'COMPLETED',
727: last_update_date = sysdate,
728: last_updated_by = FND_GLOBAL.USER_ID,
729: last_update_login = FND_GLOBAL.LOGIN_ID
730: where
731: fa_instance_id = p_fa_instance_id;
732: /*COMMIT;*/
725: set status_code = 'COMPLETED',
726: state = 'COMPLETED',
727: last_update_date = sysdate,
728: last_updated_by = FND_GLOBAL.USER_ID,
729: last_update_login = FND_GLOBAL.LOGIN_ID
730: where
731: fa_instance_id = p_fa_instance_id;
732: /*COMMIT;*/
733:
752: UPDATE xdp_fa_runtime_list
753: set status_code = 'ERROR',
754: state = 'COMPLETED',
755: last_update_date = sysdate,
756: last_updated_by = FND_GLOBAL.USER_ID,
757: last_update_login = FND_GLOBAL.LOGIN_ID
758: -- ,error_ref_id = lv_ref_id
759: where
760: fa_instance_id = p_fa_instance_id;
753: set status_code = 'ERROR',
754: state = 'COMPLETED',
755: last_update_date = sysdate,
756: last_updated_by = FND_GLOBAL.USER_ID,
757: last_update_login = FND_GLOBAL.LOGIN_ID
758: -- ,error_ref_id = lv_ref_id
759: where
760: fa_instance_id = p_fa_instance_id;
761: /*COMMIT;*/
791: UPDATE xdp_fa_runtime_list
792: set status_code = 'ERROR',
793: state = 'COMPLETED',
794: last_update_date = sysdate,
795: last_updated_by = FND_GLOBAL.USER_ID,
796: last_update_login = FND_GLOBAL.LOGIN_ID
797: -- ,error_ref_id = lv_ref_id
798: where
799: fa_instance_id = p_fa_instance_id;
792: set status_code = 'ERROR',
793: state = 'COMPLETED',
794: last_update_date = sysdate,
795: last_updated_by = FND_GLOBAL.USER_ID,
796: last_update_login = FND_GLOBAL.LOGIN_ID
797: -- ,error_ref_id = lv_ref_id
798: where
799: fa_instance_id = p_fa_instance_id;
800: /*COMMIT;*/