DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_BATCH_PKG dependencies on FND_GLOBAL

Line 892: FND_GLOBAL.user_id,

888: l_shipment_batch_tbl(l_cnt).freight_terms_code,
889: l_shipment_batch_tbl(l_cnt).fob_code,
890: 'Y',
891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,

Line 894: FND_GLOBAL.user_id,

890: 'Y',
891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,

Line 895: FND_GLOBAL.Login_Id,

891: SYSDATE,
892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );

Line 896: FND_GLOBAL.Conc_Request_Id,

892: FND_GLOBAL.user_id,
893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;

Line 897: FND_GLOBAL.Prog_Appl_Id,

893: SYSDATE,
894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;
901: --} Seperating Batches Ends Here

Line 898: FND_GLOBAL.Conc_Program_Id,

894: FND_GLOBAL.user_id,
895: FND_GLOBAL.Login_Id,
896: FND_GLOBAL.Conc_Request_Id,
897: FND_GLOBAL.Prog_Appl_Id,
898: FND_GLOBAL.Conc_Program_Id,
899: SYSDATE );
900: END IF;
901: --} Seperating Batches Ends Here
902:

Line 926: last_updated_by = FND_GLOBAL.User_Id,

922: set shipment_batch_id = l_dd_batch_id_tbl(i),
923: shipment_line_number = l_dd_line_num_tbl(i),
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,

Line 927: last_update_login = FND_GLOBAL.Login_Id,

923: shipment_line_number = l_dd_line_num_tbl(i),
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE

Line 928: request_id = FND_GLOBAL.Conc_Request_Id,

924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)

Line 929: program_application_id = FND_GLOBAL.Prog_Appl_Id,

925: last_update_date = SYSDATE,
926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)
933: and l_wdd_update_flag(i) = 'Y';

Line 930: program_id = FND_GLOBAL.Conc_Program_Id,

926: last_updated_by = FND_GLOBAL.User_Id,
927: last_update_login = FND_GLOBAL.Login_Id,
928: request_id = FND_GLOBAL.Conc_Request_Id,
929: program_application_id = FND_GLOBAL.Prog_Appl_Id,
930: program_id = FND_GLOBAL.Conc_Program_Id,
931: program_update_date = SYSDATE
932: where rowid = l_rowid_tbl(i)
933: and l_wdd_update_flag(i) = 'Y';
934:

Line 1032: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN

1028: --
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.log(l_module_name, 'Total No. of shipment batches created', l_batch_tbl.count);
1031: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------------');
1032: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1033: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of shipment batches created => ' || l_batch_tbl.count);
1034: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------');
1035: END IF;
1036: --

Line 1040: nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0

1036: --
1037:
1038: --
1039: IF l_debug_on OR
1040: nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0
1041: THEN
1042: IF l_batch_tbl.count > 0 THEN
1043: FOR i in l_batch_tbl.first..l_batch_tbl.last
1044: LOOP

Line 1047: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN

1043: FOR i in l_batch_tbl.first..l_batch_tbl.last
1044: LOOP
1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.logmsg(l_module_name, i || '. Shipment Batch Id => ' || l_batch_tbl(i));
1047: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1048: FND_FILE.put_line(FND_FILE.LOG, i || '. Shipment Batch Id => ' || l_batch_tbl(i));
1049: END IF;
1050: END LOOP;
1051: END IF;

Line 1059: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN

1055: --
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------------');
1058: WSH_DEBUG_SV.pop(l_module_name);
1059: ELSIF nvl(FND_GLOBAL.Conc_Request_Id, 0) > 0 THEN
1060: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------');
1061: END IF;
1062: --
1063:

Line 1232: last_updated_by = FND_GLOBAL.User_Id,

1228: set shipment_batch_id = null,
1229: shipment_line_number = null,
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,

Line 1233: last_update_login = FND_GLOBAL.Login_Id,

1229: shipment_line_number = null,
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE

Line 1234: request_id = FND_GLOBAL.Conc_Request_Id,

1230: reference_line_id = null,
1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);

Line 1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,

1231: last_update_date = SYSDATE,
1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);
1239:

Line 1236: program_id = FND_GLOBAL.Conc_Program_Id,

1232: last_updated_by = FND_GLOBAL.User_Id,
1233: last_update_login = FND_GLOBAL.Login_Id,
1234: request_id = FND_GLOBAL.Conc_Request_Id,
1235: program_application_id = FND_GLOBAL.Prog_Appl_Id,
1236: program_id = FND_GLOBAL.Conc_Program_Id,
1237: program_update_date = SYSDATE
1238: where delivery_detail_id = l_unassign_detail_tab(i);
1239:
1240: --