eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_OA_UTIL dependencies on FND_GLOBAL

Line 265: FND_GLOBAL.USER_ID,

261: p_priority,
262: p_provisioning_seq ,
263: p_due_date,
264: p_customer_required_date,
265: FND_GLOBAL.USER_ID,
266: sysdate,
267: FND_GLOBAL.USER_ID,
268: sysdate,
269: FND_GLOBAL.LOGIN_ID

Line 267: FND_GLOBAL.USER_ID,

263: p_due_date,
264: p_customer_required_date,
265: FND_GLOBAL.USER_ID,
266: sysdate,
267: FND_GLOBAL.USER_ID,
268: sysdate,
269: FND_GLOBAL.LOGIN_ID
270: );
271:

Line 269: FND_GLOBAL.LOGIN_ID

265: FND_GLOBAL.USER_ID,
266: sysdate,
267: FND_GLOBAL.USER_ID,
268: sysdate,
269: FND_GLOBAL.LOGIN_ID
270: );
271:
272:
273: FOR lv_param_rec in lc_wi_param(lv_wi_id,p_line_item_id) LOOP

Line 388: FND_GLOBAL.USER_ID,

384: p_priority,
385: p_provisioning_seq ,
386: p_due_date,
387: p_customer_required_date,
388: FND_GLOBAL.USER_ID,
389: sysdate,
390: FND_GLOBAL.USER_ID,
391: sysdate,
392: FND_GLOBAL.LOGIN_ID

Line 390: FND_GLOBAL.USER_ID,

386: p_due_date,
387: p_customer_required_date,
388: FND_GLOBAL.USER_ID,
389: sysdate,
390: FND_GLOBAL.USER_ID,
391: sysdate,
392: FND_GLOBAL.LOGIN_ID
393: );
394:

Line 392: FND_GLOBAL.LOGIN_ID

388: FND_GLOBAL.USER_ID,
389: sysdate,
390: FND_GLOBAL.USER_ID,
391: sysdate,
392: FND_GLOBAL.LOGIN_ID
393: );
394:
395:
396: FOR lv_param_rec in lc_wi_param(lv_wi_id,p_line_item_id) LOOP

Line 566: set last_updated_by = FND_GLOBAL.USER_ID,

562: return_code => return_code,
563: error_description => error_description);
564: IF return_code = 0 THEN
565: update xdp_order_line_items
566: set last_updated_by = FND_GLOBAL.USER_ID,
567: last_update_date = sysdate,
568: last_update_login = FND_GLOBAL.LOGIN_ID,
569: status_code = 'CANCELED'
570: where line_item_id = p_line_item_id;

Line 568: last_update_login = FND_GLOBAL.LOGIN_ID,

564: IF return_code = 0 THEN
565: update xdp_order_line_items
566: set last_updated_by = FND_GLOBAL.USER_ID,
567: last_update_date = sysdate,
568: last_update_login = FND_GLOBAL.LOGIN_ID,
569: status_code = 'CANCELED'
570: where line_item_id = p_line_item_id;
571: return;
572: ELSE

Line 641: set last_updated_by = FND_GLOBAL.USER_ID,

637: error_description => error_description);
638:
639: IF return_code = 0 THEN
640: update XDP_FULFILL_WORKLIST
641: set last_updated_by = FND_GLOBAL.USER_ID,
642: last_update_date = sysdate,
643: last_update_login = FND_GLOBAL.LOGIN_ID,
644: status_code = 'CANCELED'
645: where workitem_instance_id = p_workitem_instance_id;

Line 643: last_update_login = FND_GLOBAL.LOGIN_ID,

639: IF return_code = 0 THEN
640: update XDP_FULFILL_WORKLIST
641: set last_updated_by = FND_GLOBAL.USER_ID,
642: last_update_date = sysdate,
643: last_update_login = FND_GLOBAL.LOGIN_ID,
644: status_code = 'CANCELED'
645: where workitem_instance_id = p_workitem_instance_id;
646: return;
647: ELSIF return_code = -54 THEN /*resource_busy exception */

Line 650: set last_updated_by = FND_GLOBAL.USER_ID,

646: return;
647: ELSIF return_code = -54 THEN /*resource_busy exception */
648: begin
649: update XDP_FULFILL_WORKLIST
650: set last_updated_by = FND_GLOBAL.USER_ID,
651: last_update_date = sysdate,
652: last_update_login = FND_GLOBAL.LOGIN_ID,
653: status_code = 'CANCELED'
654: where workitem_instance_id = p_workitem_instance_id;

Line 652: last_update_login = FND_GLOBAL.LOGIN_ID,

648: begin
649: update XDP_FULFILL_WORKLIST
650: set last_updated_by = FND_GLOBAL.USER_ID,
651: last_update_date = sysdate,
652: last_update_login = FND_GLOBAL.LOGIN_ID,
653: status_code = 'CANCELED'
654: where workitem_instance_id = p_workitem_instance_id;
655: return;
656: exception

Line 813: FND_GLOBAL.USER_ID,

809: VALUES
810: (p_curr_sdp_order_id,
811: p_related_sdp_order_id,
812: lv_relation,
813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: sysdate,
817: FND_GLOBAL.LOGIN_ID

Line 815: FND_GLOBAL.USER_ID,

811: p_related_sdp_order_id,
812: lv_relation,
813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: sysdate,
817: FND_GLOBAL.LOGIN_ID
818: );
819:

Line 817: FND_GLOBAL.LOGIN_ID

813: FND_GLOBAL.USER_ID,
814: sysdate,
815: FND_GLOBAL.USER_ID,
816: sysdate,
817: FND_GLOBAL.LOGIN_ID
818: );
819:
820: update xdp_order_headers
821: set

Line 822: last_updated_by = FND_GLOBAL.USER_ID,

818: );
819:
820: update xdp_order_headers
821: set
822: last_updated_by = FND_GLOBAL.USER_ID,
823: last_update_date = sysdate,
824: last_update_login = FND_GLOBAL.LOGIN_ID,
825: next_order_id = p_related_sdp_order_id
826: where order_id = p_curr_sdp_order_id;

Line 824: last_update_login = FND_GLOBAL.LOGIN_ID,

820: update xdp_order_headers
821: set
822: last_updated_by = FND_GLOBAL.USER_ID,
823: last_update_date = sysdate,
824: last_update_login = FND_GLOBAL.LOGIN_ID,
825: next_order_id = p_related_sdp_order_id
826: where order_id = p_curr_sdp_order_id;
827:
828: update xdp_order_headers

Line 830: last_updated_by = FND_GLOBAL.USER_ID,

826: where order_id = p_curr_sdp_order_id;
827:
828: update xdp_order_headers
829: set
830: last_updated_by = FND_GLOBAL.USER_ID,
831: last_update_date = sysdate,
832: last_update_login = FND_GLOBAL.LOGIN_ID,
833: previous_order_id = p_curr_sdp_order_id
834: where order_id = p_related_sdp_order_id;

Line 832: last_update_login = FND_GLOBAL.LOGIN_ID,

828: update xdp_order_headers
829: set
830: last_updated_by = FND_GLOBAL.USER_ID,
831: last_update_date = sysdate,
832: last_update_login = FND_GLOBAL.LOGIN_ID,
833: previous_order_id = p_curr_sdp_order_id
834: where order_id = p_related_sdp_order_id;
835:
836: return;

Line 840: last_updated_by = FND_GLOBAL.USER_ID,

836: return;
837: ELSE
838: UPDATE XDP_ORDER_RELATIONSHIPS
839: SET
840: last_updated_by = FND_GLOBAL.USER_ID,
841: last_update_date = sysdate,
842: last_update_login = FND_GLOBAL.LOGIN_ID,
843: ORDER_RELATIONSHIP = lv_relation
844: where order_id = p_curr_sdp_order_id AND

Line 842: last_update_login = FND_GLOBAL.LOGIN_ID,

838: UPDATE XDP_ORDER_RELATIONSHIPS
839: SET
840: last_updated_by = FND_GLOBAL.USER_ID,
841: last_update_date = sysdate,
842: last_update_login = FND_GLOBAL.LOGIN_ID,
843: ORDER_RELATIONSHIP = lv_relation
844: where order_id = p_curr_sdp_order_id AND
845: related_order_id = p_related_sdp_order_id;
846:

Line 849: last_updated_by = FND_GLOBAL.USER_ID,

845: related_order_id = p_related_sdp_order_id;
846:
847: update xdp_order_headers
848: set
849: last_updated_by = FND_GLOBAL.USER_ID,
850: last_update_date = sysdate,
851: last_update_login = FND_GLOBAL.LOGIN_ID,
852: next_order_id = p_related_sdp_order_id
853: where order_id = p_curr_sdp_order_id;

Line 851: last_update_login = FND_GLOBAL.LOGIN_ID,

847: update xdp_order_headers
848: set
849: last_updated_by = FND_GLOBAL.USER_ID,
850: last_update_date = sysdate,
851: last_update_login = FND_GLOBAL.LOGIN_ID,
852: next_order_id = p_related_sdp_order_id
853: where order_id = p_curr_sdp_order_id;
854:
855: update xdp_order_headers

Line 857: last_updated_by = FND_GLOBAL.USER_ID,

853: where order_id = p_curr_sdp_order_id;
854:
855: update xdp_order_headers
856: set
857: last_updated_by = FND_GLOBAL.USER_ID,
858: last_update_date = sysdate,
859: last_update_login = FND_GLOBAL.LOGIN_ID,
860: previous_order_id = p_curr_sdp_order_id
861: where order_id = p_related_sdp_order_id;

Line 859: last_update_login = FND_GLOBAL.LOGIN_ID,

855: update xdp_order_headers
856: set
857: last_updated_by = FND_GLOBAL.USER_ID,
858: last_update_date = sysdate,
859: last_update_login = FND_GLOBAL.LOGIN_ID,
860: previous_order_id = p_curr_sdp_order_id
861: where order_id = p_related_sdp_order_id;
862:
863: return;

Line 909: FND_GLOBAL.USER_ID,

905: VALUES
906: (p_curr_sdp_order_id,
907: p_related_sdp_order_id,
908: lv_relation,
909: FND_GLOBAL.USER_ID,
910: sysdate,
911: FND_GLOBAL.USER_ID,
912: sysdate,
913: FND_GLOBAL.LOGIN_ID

Line 911: FND_GLOBAL.USER_ID,

907: p_related_sdp_order_id,
908: lv_relation,
909: FND_GLOBAL.USER_ID,
910: sysdate,
911: FND_GLOBAL.USER_ID,
912: sysdate,
913: FND_GLOBAL.LOGIN_ID
914: );
915:

Line 913: FND_GLOBAL.LOGIN_ID

909: FND_GLOBAL.USER_ID,
910: sysdate,
911: FND_GLOBAL.USER_ID,
912: sysdate,
913: FND_GLOBAL.LOGIN_ID
914: );
915:
916: update xdp_order_headers
917: set

Line 918: last_updated_by = FND_GLOBAL.USER_ID,

914: );
915:
916: update xdp_order_headers
917: set
918: last_updated_by = FND_GLOBAL.USER_ID,
919: last_update_date = sysdate,
920: last_update_login = FND_GLOBAL.LOGIN_ID,
921: next_order_id = p_related_sdp_order_id
922: where order_id = p_curr_sdp_order_id;

Line 920: last_update_login = FND_GLOBAL.LOGIN_ID,

916: update xdp_order_headers
917: set
918: last_updated_by = FND_GLOBAL.USER_ID,
919: last_update_date = sysdate,
920: last_update_login = FND_GLOBAL.LOGIN_ID,
921: next_order_id = p_related_sdp_order_id
922: where order_id = p_curr_sdp_order_id;
923:
924: update xdp_order_headers

Line 926: last_updated_by = FND_GLOBAL.USER_ID,

922: where order_id = p_curr_sdp_order_id;
923:
924: update xdp_order_headers
925: set
926: last_updated_by = FND_GLOBAL.USER_ID,
927: last_update_date = sysdate,
928: last_update_login = FND_GLOBAL.LOGIN_ID,
929: previous_order_id = p_curr_sdp_order_id
930: where order_id = p_related_sdp_order_id;

Line 928: last_update_login = FND_GLOBAL.LOGIN_ID,

924: update xdp_order_headers
925: set
926: last_updated_by = FND_GLOBAL.USER_ID,
927: last_update_date = sysdate,
928: last_update_login = FND_GLOBAL.LOGIN_ID,
929: previous_order_id = p_curr_sdp_order_id
930: where order_id = p_related_sdp_order_id;
931:
932: return;

Line 936: last_updated_by = FND_GLOBAL.USER_ID,

932: return;
933: ELSE
934: UPDATE XDP_ORDER_RELATIONSHIPS
935: SET
936: last_updated_by = FND_GLOBAL.USER_ID,
937: last_update_date = sysdate,
938: last_update_login = FND_GLOBAL.LOGIN_ID,
939: ORDER_RELATIONSHIP = lv_relation
940: where order_id = p_curr_sdp_order_id AND

Line 938: last_update_login = FND_GLOBAL.LOGIN_ID,

934: UPDATE XDP_ORDER_RELATIONSHIPS
935: SET
936: last_updated_by = FND_GLOBAL.USER_ID,
937: last_update_date = sysdate,
938: last_update_login = FND_GLOBAL.LOGIN_ID,
939: ORDER_RELATIONSHIP = lv_relation
940: where order_id = p_curr_sdp_order_id AND
941: related_order_id = p_related_sdp_order_id;
942:

Line 945: last_updated_by = FND_GLOBAL.USER_ID,

941: related_order_id = p_related_sdp_order_id;
942:
943: update xdp_order_headers
944: set
945: last_updated_by = FND_GLOBAL.USER_ID,
946: last_update_date = sysdate,
947: last_update_login = FND_GLOBAL.LOGIN_ID,
948: next_order_id = p_related_sdp_order_id
949: where order_id = p_curr_sdp_order_id;

Line 947: last_update_login = FND_GLOBAL.LOGIN_ID,

943: update xdp_order_headers
944: set
945: last_updated_by = FND_GLOBAL.USER_ID,
946: last_update_date = sysdate,
947: last_update_login = FND_GLOBAL.LOGIN_ID,
948: next_order_id = p_related_sdp_order_id
949: where order_id = p_curr_sdp_order_id;
950:
951: update xdp_order_headers

Line 953: last_updated_by = FND_GLOBAL.USER_ID,

949: where order_id = p_curr_sdp_order_id;
950:
951: update xdp_order_headers
952: set
953: last_updated_by = FND_GLOBAL.USER_ID,
954: last_update_date = sysdate,
955: last_update_login = FND_GLOBAL.LOGIN_ID,
956: previous_order_id = p_curr_sdp_order_id
957: where order_id = p_related_sdp_order_id;

Line 955: last_update_login = FND_GLOBAL.LOGIN_ID,

951: update xdp_order_headers
952: set
953: last_updated_by = FND_GLOBAL.USER_ID,
954: last_update_date = sysdate,
955: last_update_login = FND_GLOBAL.LOGIN_ID,
956: previous_order_id = p_curr_sdp_order_id
957: where order_id = p_related_sdp_order_id;
958:
959: return;

Line 1032: FND_GLOBAL.USER_ID,

1028: VALUES
1029: (p_curr_sdp_order_id,
1030: p_related_sdp_order_id,
1031: lv_relation,
1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.LOGIN_ID

Line 1034: FND_GLOBAL.USER_ID,

1030: p_related_sdp_order_id,
1031: lv_relation,
1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.LOGIN_ID
1037: );
1038:

Line 1036: FND_GLOBAL.LOGIN_ID

1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.USER_ID,
1035: sysdate,
1036: FND_GLOBAL.LOGIN_ID
1037: );
1038:
1039: update xdp_order_headers
1040: set

Line 1041: last_updated_by = FND_GLOBAL.USER_ID,

1037: );
1038:
1039: update xdp_order_headers
1040: set
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_date = sysdate,
1043: last_update_login = FND_GLOBAL.LOGIN_ID,
1044: previous_order_id = p_related_sdp_order_id
1045: where order_id = p_curr_sdp_order_id;

Line 1043: last_update_login = FND_GLOBAL.LOGIN_ID,

1039: update xdp_order_headers
1040: set
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_date = sysdate,
1043: last_update_login = FND_GLOBAL.LOGIN_ID,
1044: previous_order_id = p_related_sdp_order_id
1045: where order_id = p_curr_sdp_order_id;
1046:
1047: update xdp_order_headers

Line 1049: last_updated_by = FND_GLOBAL.USER_ID,

1045: where order_id = p_curr_sdp_order_id;
1046:
1047: update xdp_order_headers
1048: set
1049: last_updated_by = FND_GLOBAL.USER_ID,
1050: last_update_date = sysdate,
1051: last_update_login = FND_GLOBAL.LOGIN_ID,
1052: next_order_id = p_curr_sdp_order_id
1053: where order_id = p_related_sdp_order_id;

Line 1051: last_update_login = FND_GLOBAL.LOGIN_ID,

1047: update xdp_order_headers
1048: set
1049: last_updated_by = FND_GLOBAL.USER_ID,
1050: last_update_date = sysdate,
1051: last_update_login = FND_GLOBAL.LOGIN_ID,
1052: next_order_id = p_curr_sdp_order_id
1053: where order_id = p_related_sdp_order_id;
1054:
1055: return;

Line 1059: last_updated_by = FND_GLOBAL.USER_ID,

1055: return;
1056: ELSE
1057: UPDATE XDP_ORDER_RELATIONSHIPS
1058: SET
1059: last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
1062: ORDER_RELATIONSHIP = lv_relation
1063: where order_id = p_curr_sdp_order_id AND

Line 1061: last_update_login = FND_GLOBAL.LOGIN_ID,

1057: UPDATE XDP_ORDER_RELATIONSHIPS
1058: SET
1059: last_updated_by = FND_GLOBAL.USER_ID,
1060: last_update_date = sysdate,
1061: last_update_login = FND_GLOBAL.LOGIN_ID,
1062: ORDER_RELATIONSHIP = lv_relation
1063: where order_id = p_curr_sdp_order_id AND
1064: related_order_id = p_related_sdp_order_id;
1065:

Line 1068: last_updated_by = FND_GLOBAL.USER_ID,

1064: related_order_id = p_related_sdp_order_id;
1065:
1066: update xdp_order_headers
1067: set
1068: last_updated_by = FND_GLOBAL.USER_ID,
1069: last_update_date = sysdate,
1070: last_update_login = FND_GLOBAL.LOGIN_ID,
1071: previous_order_id = p_related_sdp_order_id
1072: where order_id = p_curr_sdp_order_id;

Line 1070: last_update_login = FND_GLOBAL.LOGIN_ID,

1066: update xdp_order_headers
1067: set
1068: last_updated_by = FND_GLOBAL.USER_ID,
1069: last_update_date = sysdate,
1070: last_update_login = FND_GLOBAL.LOGIN_ID,
1071: previous_order_id = p_related_sdp_order_id
1072: where order_id = p_curr_sdp_order_id;
1073:
1074: update xdp_order_headers

Line 1076: last_updated_by = FND_GLOBAL.USER_ID,

1072: where order_id = p_curr_sdp_order_id;
1073:
1074: update xdp_order_headers
1075: set
1076: last_updated_by = FND_GLOBAL.USER_ID,
1077: last_update_date = sysdate,
1078: last_update_login = FND_GLOBAL.LOGIN_ID,
1079: next_order_id = p_curr_sdp_order_id
1080: where order_id = p_related_sdp_order_id;

Line 1078: last_update_login = FND_GLOBAL.LOGIN_ID,

1074: update xdp_order_headers
1075: set
1076: last_updated_by = FND_GLOBAL.USER_ID,
1077: last_update_date = sysdate,
1078: last_update_login = FND_GLOBAL.LOGIN_ID,
1079: next_order_id = p_curr_sdp_order_id
1080: where order_id = p_related_sdp_order_id;
1081:
1082: return;

Line 1123: FND_GLOBAL.USER_ID,

1119: VALUES
1120: (p_curr_sdp_order_id,
1121: p_related_sdp_order_id,
1122: lv_relation,
1123: FND_GLOBAL.USER_ID,
1124: sysdate,
1125: FND_GLOBAL.USER_ID,
1126: sysdate,
1127: FND_GLOBAL.LOGIN_ID

Line 1125: FND_GLOBAL.USER_ID,

1121: p_related_sdp_order_id,
1122: lv_relation,
1123: FND_GLOBAL.USER_ID,
1124: sysdate,
1125: FND_GLOBAL.USER_ID,
1126: sysdate,
1127: FND_GLOBAL.LOGIN_ID
1128: );
1129:

Line 1127: FND_GLOBAL.LOGIN_ID

1123: FND_GLOBAL.USER_ID,
1124: sysdate,
1125: FND_GLOBAL.USER_ID,
1126: sysdate,
1127: FND_GLOBAL.LOGIN_ID
1128: );
1129:
1130: update xdp_order_headers
1131: set

Line 1132: last_updated_by = FND_GLOBAL.USER_ID,

1128: );
1129:
1130: update xdp_order_headers
1131: set
1132: last_updated_by = FND_GLOBAL.USER_ID,
1133: last_update_date = sysdate,
1134: last_update_login = FND_GLOBAL.LOGIN_ID,
1135: previous_order_id = p_related_sdp_order_id
1136: where order_id = p_curr_sdp_order_id;

Line 1134: last_update_login = FND_GLOBAL.LOGIN_ID,

1130: update xdp_order_headers
1131: set
1132: last_updated_by = FND_GLOBAL.USER_ID,
1133: last_update_date = sysdate,
1134: last_update_login = FND_GLOBAL.LOGIN_ID,
1135: previous_order_id = p_related_sdp_order_id
1136: where order_id = p_curr_sdp_order_id;
1137:
1138: update xdp_order_headers

Line 1140: last_updated_by = FND_GLOBAL.USER_ID,

1136: where order_id = p_curr_sdp_order_id;
1137:
1138: update xdp_order_headers
1139: set
1140: last_updated_by = FND_GLOBAL.USER_ID,
1141: last_update_date = sysdate,
1142: last_update_login = FND_GLOBAL.LOGIN_ID,
1143: next_order_id = p_curr_sdp_order_id
1144: where order_id = p_related_sdp_order_id;

Line 1142: last_update_login = FND_GLOBAL.LOGIN_ID,

1138: update xdp_order_headers
1139: set
1140: last_updated_by = FND_GLOBAL.USER_ID,
1141: last_update_date = sysdate,
1142: last_update_login = FND_GLOBAL.LOGIN_ID,
1143: next_order_id = p_curr_sdp_order_id
1144: where order_id = p_related_sdp_order_id;
1145:
1146: return;

Line 1150: last_updated_by = FND_GLOBAL.USER_ID,

1146: return;
1147: ELSE
1148: UPDATE XDP_ORDER_RELATIONSHIPS
1149: SET
1150: last_updated_by = FND_GLOBAL.USER_ID,
1151: last_update_date = sysdate,
1152: last_update_login = FND_GLOBAL.LOGIN_ID,
1153: ORDER_RELATIONSHIP = lv_relation
1154: where order_id = p_curr_sdp_order_id AND

Line 1152: last_update_login = FND_GLOBAL.LOGIN_ID,

1148: UPDATE XDP_ORDER_RELATIONSHIPS
1149: SET
1150: last_updated_by = FND_GLOBAL.USER_ID,
1151: last_update_date = sysdate,
1152: last_update_login = FND_GLOBAL.LOGIN_ID,
1153: ORDER_RELATIONSHIP = lv_relation
1154: where order_id = p_curr_sdp_order_id AND
1155: related_order_id = p_related_sdp_order_id;
1156:

Line 1159: last_updated_by = FND_GLOBAL.USER_ID,

1155: related_order_id = p_related_sdp_order_id;
1156:
1157: update xdp_order_headers
1158: set
1159: last_updated_by = FND_GLOBAL.USER_ID,
1160: last_update_date = sysdate,
1161: last_update_login = FND_GLOBAL.LOGIN_ID,
1162: previous_order_id = p_related_sdp_order_id
1163: where order_id = p_curr_sdp_order_id;

Line 1161: last_update_login = FND_GLOBAL.LOGIN_ID,

1157: update xdp_order_headers
1158: set
1159: last_updated_by = FND_GLOBAL.USER_ID,
1160: last_update_date = sysdate,
1161: last_update_login = FND_GLOBAL.LOGIN_ID,
1162: previous_order_id = p_related_sdp_order_id
1163: where order_id = p_curr_sdp_order_id;
1164:
1165: update xdp_order_headers

Line 1167: last_updated_by = FND_GLOBAL.USER_ID,

1163: where order_id = p_curr_sdp_order_id;
1164:
1165: update xdp_order_headers
1166: set
1167: last_updated_by = FND_GLOBAL.USER_ID,
1168: last_update_date = sysdate,
1169: last_update_login = FND_GLOBAL.LOGIN_ID,
1170: next_order_id = p_curr_sdp_order_id
1171: where order_id = p_related_sdp_order_id;

Line 1169: last_update_login = FND_GLOBAL.LOGIN_ID,

1165: update xdp_order_headers
1166: set
1167: last_updated_by = FND_GLOBAL.USER_ID,
1168: last_update_date = sysdate,
1169: last_update_login = FND_GLOBAL.LOGIN_ID,
1170: next_order_id = p_curr_sdp_order_id
1171: where order_id = p_related_sdp_order_id;
1172:
1173: return;

Line 1216: FND_GLOBAL.USER_ID,

1212: VALUES
1213: (p_curr_sdp_order_id,
1214: p_related_sdp_order_id,
1215: lv_relation,
1216: FND_GLOBAL.USER_ID,
1217: sysdate,
1218: FND_GLOBAL.USER_ID,
1219: sysdate,
1220: FND_GLOBAL.LOGIN_ID

Line 1218: FND_GLOBAL.USER_ID,

1214: p_related_sdp_order_id,
1215: lv_relation,
1216: FND_GLOBAL.USER_ID,
1217: sysdate,
1218: FND_GLOBAL.USER_ID,
1219: sysdate,
1220: FND_GLOBAL.LOGIN_ID
1221: );
1222:

Line 1220: FND_GLOBAL.LOGIN_ID

1216: FND_GLOBAL.USER_ID,
1217: sysdate,
1218: FND_GLOBAL.USER_ID,
1219: sysdate,
1220: FND_GLOBAL.LOGIN_ID
1221: );
1222:
1223: return;
1224: ELSE

Line 1227: last_updated_by = FND_GLOBAL.USER_ID,

1223: return;
1224: ELSE
1225: UPDATE XDP_ORDER_RELATIONSHIPS
1226: SET
1227: last_updated_by = FND_GLOBAL.USER_ID,
1228: last_update_date = sysdate,
1229: last_update_login = FND_GLOBAL.LOGIN_ID,
1230: ORDER_RELATIONSHIP = lv_relation
1231: where order_id = p_curr_sdp_order_id AND

Line 1229: last_update_login = FND_GLOBAL.LOGIN_ID,

1225: UPDATE XDP_ORDER_RELATIONSHIPS
1226: SET
1227: last_updated_by = FND_GLOBAL.USER_ID,
1228: last_update_date = sysdate,
1229: last_update_login = FND_GLOBAL.LOGIN_ID,
1230: ORDER_RELATIONSHIP = lv_relation
1231: where order_id = p_curr_sdp_order_id AND
1232: related_order_id = p_related_sdp_order_id;
1233:

Line 1353: FND_GLOBAL.USER_ID,

1349: VALUES
1350: (p_curr_wi_instance_id ,
1351: p_related_wi_instance_id,
1352: lv_relation,
1353: FND_GLOBAL.USER_ID,
1354: sysdate,
1355: FND_GLOBAL.USER_ID,
1356: sysdate,
1357: FND_GLOBAL.LOGIN_ID

Line 1355: FND_GLOBAL.USER_ID,

1351: p_related_wi_instance_id,
1352: lv_relation,
1353: FND_GLOBAL.USER_ID,
1354: sysdate,
1355: FND_GLOBAL.USER_ID,
1356: sysdate,
1357: FND_GLOBAL.LOGIN_ID
1358: );
1359:

Line 1357: FND_GLOBAL.LOGIN_ID

1353: FND_GLOBAL.USER_ID,
1354: sysdate,
1355: FND_GLOBAL.USER_ID,
1356: sysdate,
1357: FND_GLOBAL.LOGIN_ID
1358: );
1359:
1360: UPDATE XDP_FULFILL_WORKLIST
1361: SET

Line 1362: last_updated_by = FND_GLOBAL.USER_ID,

1358: );
1359:
1360: UPDATE XDP_FULFILL_WORKLIST
1361: SET
1362: last_updated_by = FND_GLOBAL.USER_ID,
1363: last_update_date = sysdate,
1364: last_update_login = FND_GLOBAL.LOGIN_ID,
1365: status_code = 'MERGED'
1366: -- state = 'MERGERD'

Line 1364: last_update_login = FND_GLOBAL.LOGIN_ID,

1360: UPDATE XDP_FULFILL_WORKLIST
1361: SET
1362: last_updated_by = FND_GLOBAL.USER_ID,
1363: last_update_date = sysdate,
1364: last_update_login = FND_GLOBAL.LOGIN_ID,
1365: status_code = 'MERGED'
1366: -- state = 'MERGERD'
1367: where workitem_instance_id = p_related_wi_instance_id;
1368: return;

Line 1372: last_updated_by = FND_GLOBAL.USER_ID,

1368: return;
1369: ELSE
1370: UPDATE XDP_WI_RELATIONSHIPS
1371: SET
1372: last_updated_by = FND_GLOBAL.USER_ID,
1373: last_update_date = sysdate,
1374: last_update_login = FND_GLOBAL.LOGIN_ID,
1375: WI_RELATIONSHIP = lv_relation
1376: where workitem_instance_id = p_curr_wi_instance_id AND

Line 1374: last_update_login = FND_GLOBAL.LOGIN_ID,

1370: UPDATE XDP_WI_RELATIONSHIPS
1371: SET
1372: last_updated_by = FND_GLOBAL.USER_ID,
1373: last_update_date = sysdate,
1374: last_update_login = FND_GLOBAL.LOGIN_ID,
1375: WI_RELATIONSHIP = lv_relation
1376: where workitem_instance_id = p_curr_wi_instance_id AND
1377: related_wi_instance_id = p_related_wi_instance_id;
1378:

Line 1381: last_updated_by = FND_GLOBAL.USER_ID,

1377: related_wi_instance_id = p_related_wi_instance_id;
1378:
1379: UPDATE XDP_FULFILL_WORKLIST
1380: SET
1381: last_updated_by = FND_GLOBAL.USER_ID,
1382: last_update_date = sysdate,
1383: last_update_login = FND_GLOBAL.LOGIN_ID,
1384: status_code = 'MERGERD'
1385: -- state = 'MERGERD'

Line 1383: last_update_login = FND_GLOBAL.LOGIN_ID,

1379: UPDATE XDP_FULFILL_WORKLIST
1380: SET
1381: last_updated_by = FND_GLOBAL.USER_ID,
1382: last_update_date = sysdate,
1383: last_update_login = FND_GLOBAL.LOGIN_ID,
1384: status_code = 'MERGERD'
1385: -- state = 'MERGERD'
1386: where workitem_instance_id = p_related_wi_instance_id;
1387: