DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_ADVICE_PUB dependencies on FND_GLOBAL

Line 340: FND_GLOBAL.USER_ID,

336: p_delivery_rec.SHIP_TO_STATE,
337: p_delivery_rec.SHIP_TO_COUNTRY,
338: p_delivery_rec.SHIP_TO_POSTAL_CODE,
339: sysdate,
340: FND_GLOBAL.USER_ID,
341: sysdate,
342: FND_GLOBAL.USER_ID,
343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,

Line 342: FND_GLOBAL.USER_ID,

338: p_delivery_rec.SHIP_TO_POSTAL_CODE,
339: sysdate,
340: FND_GLOBAL.USER_ID,
341: sysdate,
342: FND_GLOBAL.USER_ID,
343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,
345: FND_GLOBAL.Conc_Program_Id,
346: sysdate,

Line 343: FND_GLOBAL.LOGIN_ID,

339: sysdate,
340: FND_GLOBAL.USER_ID,
341: sysdate,
342: FND_GLOBAL.USER_ID,
343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,
345: FND_GLOBAL.Conc_Program_Id,
346: sysdate,
347: FND_GLOBAL.Conc_Request_Id

Line 344: FND_GLOBAL.PROG_APPL_ID,

340: FND_GLOBAL.USER_ID,
341: sysdate,
342: FND_GLOBAL.USER_ID,
343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,
345: FND_GLOBAL.Conc_Program_Id,
346: sysdate,
347: FND_GLOBAL.Conc_Request_Id
348: )

Line 345: FND_GLOBAL.Conc_Program_Id,

341: sysdate,
342: FND_GLOBAL.USER_ID,
343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,
345: FND_GLOBAL.Conc_Program_Id,
346: sysdate,
347: FND_GLOBAL.Conc_Request_Id
348: )
349: RETURNING DELIVERY_INTERFACE_ID into l_delivery_interface_id;

Line 347: FND_GLOBAL.Conc_Request_Id

343: FND_GLOBAL.LOGIN_ID,
344: FND_GLOBAL.PROG_APPL_ID,
345: FND_GLOBAL.Conc_Program_Id,
346: sysdate,
347: FND_GLOBAL.Conc_Request_Id
348: )
349: RETURNING DELIVERY_INTERFACE_ID into l_delivery_interface_id;
350:
351: l_ins_rows := sql%rowcount;

Line 413: FND_GLOBAL.USER_ID,

409: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE13,
410: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE14,
411: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE15,
412: sysdate,
413: FND_GLOBAL.USER_ID,
414: sysdate,
415: FND_GLOBAL.USER_ID,
416: l_delivery_interface_id,
417: NULL,

Line 415: FND_GLOBAL.USER_ID,

411: p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE15,
412: sysdate,
413: FND_GLOBAL.USER_ID,
414: sysdate,
415: FND_GLOBAL.USER_ID,
416: l_delivery_interface_id,
417: NULL,
418: p_delivery_rec.delivery_freight_tab(k).FREIGHT_COST_TYPE_CODE,
419: p_delivery_rec.delivery_freight_tab(k).UNIT_AMOUNT,

Line 553: FND_GLOBAL.USER_ID,

549: 'N',
550: G_INTERFACE_ACTION_CODE,
551: p_delivery_rec.ORGANIZATION_CODE,
552: sysdate,
553: FND_GLOBAL.USER_ID,
554: sysdate,
555: FND_GLOBAL.USER_ID,
556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,

Line 555: FND_GLOBAL.USER_ID,

551: p_delivery_rec.ORGANIZATION_CODE,
552: sysdate,
553: FND_GLOBAL.USER_ID,
554: sysdate,
555: FND_GLOBAL.USER_ID,
556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,
558: FND_GLOBAL.Conc_Program_Id,
559: sysdate,

Line 556: FND_GLOBAL.LOGIN_ID,

552: sysdate,
553: FND_GLOBAL.USER_ID,
554: sysdate,
555: FND_GLOBAL.USER_ID,
556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,
558: FND_GLOBAL.Conc_Program_Id,
559: sysdate,
560: FND_GLOBAL.Conc_Request_Id)

Line 557: FND_GLOBAL.PROG_APPL_ID,

553: FND_GLOBAL.USER_ID,
554: sysdate,
555: FND_GLOBAL.USER_ID,
556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,
558: FND_GLOBAL.Conc_Program_Id,
559: sysdate,
560: FND_GLOBAL.Conc_Request_Id)
561: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;

Line 558: FND_GLOBAL.Conc_Program_Id,

554: sysdate,
555: FND_GLOBAL.USER_ID,
556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,
558: FND_GLOBAL.Conc_Program_Id,
559: sysdate,
560: FND_GLOBAL.Conc_Request_Id)
561: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
562:

Line 560: FND_GLOBAL.Conc_Request_Id)

556: FND_GLOBAL.LOGIN_ID,
557: FND_GLOBAL.PROG_APPL_ID,
558: FND_GLOBAL.Conc_Program_Id,
559: sysdate,
560: FND_GLOBAL.Conc_Request_Id)
561: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
562:
563: l_del_assgn_cnt := l_del_assgn_cnt +1;
564: l_WDAI_DEL_INTERFACE_ID(l_del_assgn_cnt) := L_DELIVERY_INTERFACE_ID;

Line 628: FND_GLOBAL.USER_ID,

624: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE13,
625: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE14,
626: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE15,
627: sysdate,
628: FND_GLOBAL.USER_ID,
629: sysdate,
630: FND_GLOBAL.USER_ID,
631: NULL,
632: l_del_detail_interface_id,

Line 630: FND_GLOBAL.USER_ID,

626: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE15,
627: sysdate,
628: FND_GLOBAL.USER_ID,
629: sysdate,
630: FND_GLOBAL.USER_ID,
631: NULL,
632: l_del_detail_interface_id,
633: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
634: p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).UNIT_AMOUNT,

Line 743: FND_GLOBAL.USER_ID,

739: p_delivery_rec.delivery_details_tab(i).line_direction,
740: p_delivery_rec.container_tab(i).DELIVERY_DETAIL_NUMBER,
741: p_delivery_rec.ORGANIZATION_CODE,
742: sysdate,
743: FND_GLOBAL.USER_ID,
744: sysdate,
745: FND_GLOBAL.USER_ID)
746: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
747: l_del_assgn_cnt := l_del_assgn_cnt +1;

Line 745: FND_GLOBAL.USER_ID)

741: p_delivery_rec.ORGANIZATION_CODE,
742: sysdate,
743: FND_GLOBAL.USER_ID,
744: sysdate,
745: FND_GLOBAL.USER_ID)
746: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
747: l_del_assgn_cnt := l_del_assgn_cnt +1;
748: l_WDAI_DEL_INTERFACE_ID(l_del_assgn_cnt) := L_DELIVERY_INTERFACE_ID ;
749: l_WDAI_DEL_DET_INTERFACE_ID(l_del_assgn_cnt) := l_del_detail_interface_id ;

Line 811: FND_GLOBAL.USER_ID,

807: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE13,
808: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE14,
809: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE15,
810: sysdate,
811: FND_GLOBAL.USER_ID,
812: sysdate,
813: FND_GLOBAL.USER_ID,
814: NULL,
815: l_del_detail_interface_id,

Line 813: FND_GLOBAL.USER_ID,

809: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE15,
810: sysdate,
811: FND_GLOBAL.USER_ID,
812: sysdate,
813: FND_GLOBAL.USER_ID,
814: NULL,
815: l_del_detail_interface_id,
816: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
817: p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).UNIT_AMOUNT,

Line 925: FND_GLOBAL.USER_ID,

921: p_delivery_rec.delivery_details_tab(i).line_direction,
922: p_delivery_rec.container_tab(i).container_tab(k).DELIVERY_DETAIL_NUMBER,
923: p_delivery_rec.ORGANIZATION_CODE,
924: sysdate,
925: FND_GLOBAL.USER_ID,
926: sysdate,
927: FND_GLOBAL.USER_ID)
928: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
929:

Line 927: FND_GLOBAL.USER_ID)

923: p_delivery_rec.ORGANIZATION_CODE,
924: sysdate,
925: FND_GLOBAL.USER_ID,
926: sysdate,
927: FND_GLOBAL.USER_ID)
928: RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
929:
930:
931: l_del_assgn_cnt := l_del_assgn_cnt +1;

Line 995: FND_GLOBAL.USER_ID,

991: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE13,
992: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE14,
993: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE15,
994: sysdate,
995: FND_GLOBAL.USER_ID,
996: sysdate,
997: FND_GLOBAL.USER_ID,
998: NULL,
999: l_del_detail_interface_id,

Line 997: FND_GLOBAL.USER_ID,

993: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE15,
994: sysdate,
995: FND_GLOBAL.USER_ID,
996: sysdate,
997: FND_GLOBAL.USER_ID,
998: NULL,
999: l_del_detail_interface_id,
1000: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).FREIGHT_COST_TYPE_CODE,
1001: p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).UNIT_AMOUNT,

Line 1048: FND_GLOBAL.USER_ID,

1044: VALUES(
1045: wsh_del_assgn_interface_s.nextval,
1046: G_INTERFACE_ACTION_CODE,
1047: sysdate,
1048: FND_GLOBAL.USER_ID,
1049: sysdate,
1050: FND_GLOBAL.USER_ID,
1051: l_WDAI_DEL_INTERFACE_ID(i),
1052: l_WDAI_DEL_DET_INTERFACE_ID(i),

Line 1050: FND_GLOBAL.USER_ID,

1046: G_INTERFACE_ACTION_CODE,
1047: sysdate,
1048: FND_GLOBAL.USER_ID,
1049: sysdate,
1050: FND_GLOBAL.USER_ID,
1051: l_WDAI_DEL_INTERFACE_ID(i),
1052: l_WDAI_DEL_DET_INTERFACE_ID(i),
1053: l_WDAI_DEL_DETAIL_ID(i),
1054: l_WDAI_PARENT_DEL_DETAIL_ID(i));

Line 1077: FND_GLOBAL.USER_ID,

1073: VALUES(
1074: wsh_del_assgn_interface_s.nextval,
1075: G_INTERFACE_ACTION_CODE,
1076: sysdate,
1077: FND_GLOBAL.USER_ID,
1078: sysdate,
1079: FND_GLOBAL.USER_ID,
1080: l_WDAI_DEL_INTERFACE_ID(i),
1081: l_WDAI_DEL_DET_INTERFACE_ID(i),

Line 1079: FND_GLOBAL.USER_ID,

1075: G_INTERFACE_ACTION_CODE,
1076: sysdate,
1077: FND_GLOBAL.USER_ID,
1078: sysdate,
1079: FND_GLOBAL.USER_ID,
1080: l_WDAI_DEL_INTERFACE_ID(i),
1081: l_WDAI_DEL_DET_INTERFACE_ID(i),
1082: l_WDAI_DEL_DETAIL_ID(i),
1083: l_WDAI_PARENT_DEL_DETAIL_ID(i));

Line 1137: FND_GLOBAL.USER_ID,

1133: l_delivery_interface_id,
1134: 'DLVY_INT',
1135: -1,
1136: sysdate,
1137: FND_GLOBAL.USER_ID,
1138: sysdate,
1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,

Line 1139: FND_GLOBAL.USER_ID,

1135: -1,
1136: sysdate,
1137: FND_GLOBAL.USER_ID,
1138: sysdate,
1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,
1142: FND_GLOBAL.PROG_APPL_ID,
1143: FND_GLOBAL.Conc_Program_Id,

Line 1140: FND_GLOBAL.LOGIN_ID,

1136: sysdate,
1137: FND_GLOBAL.USER_ID,
1138: sysdate,
1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,
1142: FND_GLOBAL.PROG_APPL_ID,
1143: FND_GLOBAL.Conc_Program_Id,
1144: sysdate);

Line 1141: FND_GLOBAL.Conc_Request_Id,

1137: FND_GLOBAL.USER_ID,
1138: sysdate,
1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,
1142: FND_GLOBAL.PROG_APPL_ID,
1143: FND_GLOBAL.Conc_Program_Id,
1144: sysdate);
1145:

Line 1142: FND_GLOBAL.PROG_APPL_ID,

1138: sysdate,
1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,
1142: FND_GLOBAL.PROG_APPL_ID,
1143: FND_GLOBAL.Conc_Program_Id,
1144: sysdate);
1145:
1146: --

Line 1143: FND_GLOBAL.Conc_Program_Id,

1139: FND_GLOBAL.USER_ID,
1140: FND_GLOBAL.LOGIN_ID,
1141: FND_GLOBAL.Conc_Request_Id,
1142: FND_GLOBAL.PROG_APPL_ID,
1143: FND_GLOBAL.Conc_Program_Id,
1144: sysdate);
1145:
1146: --
1147: IF l_debug_on THEN