DBA Data[Home] [Help]

APPS.XDP_DRC_UTIL_PVT dependencies on FND_GLOBAL

Line 92: FND_GLOBAL.USER_ID,

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: );

Line 94: FND_GLOBAL.USER_ID,

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

Line 95: FND_GLOBAL.LOGIN_ID

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: (

Line 134: FND_GLOBAL.USER_ID,

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: )

Line 136: FND_GLOBAL.USER_ID,

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:

Line 137: FND_GLOBAL.LOGIN_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:
141: IF p_task_parameter.count > 0 THEN

Line 161: FND_GLOBAL.USER_ID,

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: );

Line 163: FND_GLOBAL.USER_ID,

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;

Line 164: FND_GLOBAL.LOGIN_ID

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;

Line 205: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 206: last_update_login = FND_GLOBAL.LOGIN_ID

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',

Line 213: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 214: last_update_login = FND_GLOBAL.LOGIN_ID

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',

Line 221: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 222: last_update_login = FND_GLOBAL.LOGIN_ID

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',

Line 229: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 230: last_update_login = FND_GLOBAL.LOGIN_ID

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:

Line 393: last_updated_by = FND_GLOBAL.USER_ID,

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;*/

Line 394: last_update_login = FND_GLOBAL.LOGIN_ID

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:

Line 427: last_updated_by = FND_GLOBAL.USER_ID,

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;*/

Line 428: last_update_login = FND_GLOBAL.LOGIN_ID

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:

Line 451: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 452: last_update_login = FND_GLOBAL.LOGIN_ID

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',

Line 459: last_updated_by = FND_GLOBAL.USER_ID,

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;*/

Line 460: last_update_login = FND_GLOBAL.LOGIN_ID

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:

Line 493: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 494: last_update_login = FND_GLOBAL.LOGIN_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;*/

Line 592: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 593: last_update_login = FND_GLOBAL.LOGIN_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;*/

Line 672: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 673: last_update_login = FND_GLOBAL.LOGIN_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;*/

Line 701: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 702: last_update_login = FND_GLOBAL.LOGIN_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;*/

Line 728: last_updated_by = FND_GLOBAL.USER_ID,

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;*/

Line 729: last_update_login = FND_GLOBAL.LOGIN_ID

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:

Line 756: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 757: last_update_login = FND_GLOBAL.LOGIN_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;*/

Line 795: last_updated_by = FND_GLOBAL.USER_ID,

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;

Line 796: last_update_login = FND_GLOBAL.LOGIN_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;*/