DBA Data[Home] [Help]

APPS.BOM_RTG_OPEN_INTERFACE dependencies on FND_GLOBAL

Line 280: g_UserId := nvl(Fnd_Global.USER_ID, -1);

276: end if;
277:
278: stmt_num := 1;
279: -- who columns
280: g_UserId := nvl(Fnd_Global.USER_ID, -1);
281: g_LoginId := Fnd_Global.LOGIN_ID;
282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;
283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;

Line 281: g_LoginId := Fnd_Global.LOGIN_ID;

277:
278: stmt_num := 1;
279: -- who columns
280: g_UserId := nvl(Fnd_Global.USER_ID, -1);
281: g_LoginId := Fnd_Global.LOGIN_ID;
282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;
283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;
285: --commented by vhymavat for bug 3179687

Line 282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;

278: stmt_num := 1;
279: -- who columns
280: g_UserId := nvl(Fnd_Global.USER_ID, -1);
281: g_LoginId := Fnd_Global.LOGIN_ID;
282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;
283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;
285: --commented by vhymavat for bug 3179687
286: /*

Line 283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;

279: -- who columns
280: g_UserId := nvl(Fnd_Global.USER_ID, -1);
281: g_LoginId := Fnd_Global.LOGIN_ID;
282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;
283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;
285: --commented by vhymavat for bug 3179687
286: /*
287: fnd_global.apps_initialize

Line 284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;

280: g_UserId := nvl(Fnd_Global.USER_ID, -1);
281: g_LoginId := Fnd_Global.LOGIN_ID;
282: g_RequestId := Fnd_Global.CONC_REQUEST_ID;
283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;
285: --commented by vhymavat for bug 3179687
286: /*
287: fnd_global.apps_initialize
288: ( user_id => g_UserId,

Line 287: fnd_global.apps_initialize

283: g_ProgramId := Fnd_Global.CONC_PROGRAM_ID;
284: g_ApplicationId := Fnd_Global.PROG_APPL_ID;
285: --commented by vhymavat for bug 3179687
286: /*
287: fnd_global.apps_initialize
288: ( user_id => g_UserId,
289: resp_id => FND_PROFILE.value('RESP_ID'),
290: resp_appl_id => g_ApplicationId
291: );

Line 892: REQUEST_ID = Fnd_Global.Conc_Request_Id,

888: end if;
889:
890: Update BOM_OP_ROUTINGS_INTERFACE
891: set process_flag = l_process_flag,
892: REQUEST_ID = Fnd_Global.Conc_Request_Id,
893: PROGRAM_ID = Fnd_Global.Conc_program_Id,
894: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
895: PROGRAM_UPDATE_DATE = sysdate
896: where transaction_id = g_rtg_header_rec.Row_Identifier;

Line 893: PROGRAM_ID = Fnd_Global.Conc_program_Id,

889:
890: Update BOM_OP_ROUTINGS_INTERFACE
891: set process_flag = l_process_flag,
892: REQUEST_ID = Fnd_Global.Conc_Request_Id,
893: PROGRAM_ID = Fnd_Global.Conc_program_Id,
894: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
895: PROGRAM_UPDATE_DATE = sysdate
896: where transaction_id = g_rtg_header_rec.Row_Identifier;
897:

Line 894: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

890: Update BOM_OP_ROUTINGS_INTERFACE
891: set process_flag = l_process_flag,
892: REQUEST_ID = Fnd_Global.Conc_Request_Id,
893: PROGRAM_ID = Fnd_Global.Conc_program_Id,
894: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
895: PROGRAM_UPDATE_DATE = sysdate
896: where transaction_id = g_rtg_header_rec.Row_Identifier;
897:
898: stmt_num := 1;

Line 914: REQUEST_ID = Fnd_Global.Conc_Request_Id,

910: end if;
911:
912: Update MTL_RTG_ITEM_REVS_INTERFACE
913: set process_flag = l_process_flag,
914: REQUEST_ID = Fnd_Global.Conc_Request_Id,
915: PROGRAM_ID = Fnd_Global.Conc_program_Id,
916: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
917: PROGRAM_UPDATE_DATE = sysdate
918: where transaction_id = g_rtg_revision_rec.row_identifier;

Line 915: PROGRAM_ID = Fnd_Global.Conc_program_Id,

911:
912: Update MTL_RTG_ITEM_REVS_INTERFACE
913: set process_flag = l_process_flag,
914: REQUEST_ID = Fnd_Global.Conc_Request_Id,
915: PROGRAM_ID = Fnd_Global.Conc_program_Id,
916: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
917: PROGRAM_UPDATE_DATE = sysdate
918: where transaction_id = g_rtg_revision_rec.row_identifier;
919: END LOOP;

Line 916: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

912: Update MTL_RTG_ITEM_REVS_INTERFACE
913: set process_flag = l_process_flag,
914: REQUEST_ID = Fnd_Global.Conc_Request_Id,
915: PROGRAM_ID = Fnd_Global.Conc_program_Id,
916: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
917: PROGRAM_UPDATE_DATE = sysdate
918: where transaction_id = g_rtg_revision_rec.row_identifier;
919: END LOOP;
920:

Line 937: REQUEST_ID = Fnd_Global.Conc_Request_Id,

933: end if;
934:
935: Update BOM_OP_SEQUENCES_INTERFACE
936: set process_flag = l_process_flag,
937: REQUEST_ID = Fnd_Global.Conc_Request_Id,
938: PROGRAM_ID = Fnd_Global.Conc_program_Id,
939: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
940: PROGRAM_UPDATE_DATE = sysdate
941: where transaction_id = g_op_rec.row_identifier;

Line 938: PROGRAM_ID = Fnd_Global.Conc_program_Id,

934:
935: Update BOM_OP_SEQUENCES_INTERFACE
936: set process_flag = l_process_flag,
937: REQUEST_ID = Fnd_Global.Conc_Request_Id,
938: PROGRAM_ID = Fnd_Global.Conc_program_Id,
939: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
940: PROGRAM_UPDATE_DATE = sysdate
941: where transaction_id = g_op_rec.row_identifier;
942: END LOOP;

Line 939: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

935: Update BOM_OP_SEQUENCES_INTERFACE
936: set process_flag = l_process_flag,
937: REQUEST_ID = Fnd_Global.Conc_Request_Id,
938: PROGRAM_ID = Fnd_Global.Conc_program_Id,
939: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
940: PROGRAM_UPDATE_DATE = sysdate
941: where transaction_id = g_op_rec.row_identifier;
942: END LOOP;
943:

Line 960: REQUEST_ID = Fnd_Global.Conc_Request_Id,

956: end if;
957:
958: Update BOM_OP_RESOURCES_INTERFACE
959: set process_flag = l_process_flag,
960: REQUEST_ID = Fnd_Global.Conc_Request_Id,
961: PROGRAM_ID = Fnd_Global.Conc_program_Id,
962: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
963: PROGRAM_UPDATE_DATE = sysdate
964: where transaction_id = g_op_res_rec.row_identifier;

Line 961: PROGRAM_ID = Fnd_Global.Conc_program_Id,

957:
958: Update BOM_OP_RESOURCES_INTERFACE
959: set process_flag = l_process_flag,
960: REQUEST_ID = Fnd_Global.Conc_Request_Id,
961: PROGRAM_ID = Fnd_Global.Conc_program_Id,
962: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
963: PROGRAM_UPDATE_DATE = sysdate
964: where transaction_id = g_op_res_rec.row_identifier;
965: END LOOP;

Line 962: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

958: Update BOM_OP_RESOURCES_INTERFACE
959: set process_flag = l_process_flag,
960: REQUEST_ID = Fnd_Global.Conc_Request_Id,
961: PROGRAM_ID = Fnd_Global.Conc_program_Id,
962: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
963: PROGRAM_UPDATE_DATE = sysdate
964: where transaction_id = g_op_res_rec.row_identifier;
965: END LOOP;
966:

Line 982: REQUEST_ID = Fnd_Global.Conc_Request_Id,

978: end if;
979:
980: Update BOM_SUB_OP_RESOURCES_INTERFACE
981: set process_flag = l_process_flag,
982: REQUEST_ID = Fnd_Global.Conc_Request_Id,
983: PROGRAM_ID = Fnd_Global.Conc_program_Id,
984: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
985: PROGRAM_UPDATE_DATE = sysdate
986: where transaction_id = g_sub_op_res_rec.row_identifier;

Line 983: PROGRAM_ID = Fnd_Global.Conc_program_Id,

979:
980: Update BOM_SUB_OP_RESOURCES_INTERFACE
981: set process_flag = l_process_flag,
982: REQUEST_ID = Fnd_Global.Conc_Request_Id,
983: PROGRAM_ID = Fnd_Global.Conc_program_Id,
984: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
985: PROGRAM_UPDATE_DATE = sysdate
986: where transaction_id = g_sub_op_res_rec.row_identifier;
987: END LOOP;

Line 984: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

980: Update BOM_SUB_OP_RESOURCES_INTERFACE
981: set process_flag = l_process_flag,
982: REQUEST_ID = Fnd_Global.Conc_Request_Id,
983: PROGRAM_ID = Fnd_Global.Conc_program_Id,
984: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
985: PROGRAM_UPDATE_DATE = sysdate
986: where transaction_id = g_sub_op_res_rec.row_identifier;
987: END LOOP;
988:

Line 1004: REQUEST_ID = Fnd_Global.Conc_Request_Id,

1000: end if;
1001:
1002: Update BOM_OP_NETWORKS_INTERFACE
1003: set process_flag = l_process_flag,
1004: REQUEST_ID = Fnd_Global.Conc_Request_Id,
1005: PROGRAM_ID = Fnd_Global.Conc_program_Id,
1006: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
1007: PROGRAM_UPDATE_DATE = sysdate
1008: where transaction_id = g_nwk_rec.row_identifier;

Line 1005: PROGRAM_ID = Fnd_Global.Conc_program_Id,

1001:
1002: Update BOM_OP_NETWORKS_INTERFACE
1003: set process_flag = l_process_flag,
1004: REQUEST_ID = Fnd_Global.Conc_Request_Id,
1005: PROGRAM_ID = Fnd_Global.Conc_program_Id,
1006: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
1007: PROGRAM_UPDATE_DATE = sysdate
1008: where transaction_id = g_nwk_rec.row_identifier;
1009: END LOOP;

Line 1006: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

1002: Update BOM_OP_NETWORKS_INTERFACE
1003: set process_flag = l_process_flag,
1004: REQUEST_ID = Fnd_Global.Conc_Request_Id,
1005: PROGRAM_ID = Fnd_Global.Conc_program_Id,
1006: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
1007: PROGRAM_UPDATE_DATE = sysdate
1008: where transaction_id = g_nwk_rec.row_identifier;
1009: END LOOP;
1010: