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 877: REQUEST_ID = Fnd_Global.Conc_Request_Id,

873: end if;
874:
875: Update BOM_OP_ROUTINGS_INTERFACE
876: set process_flag = l_process_flag,
877: REQUEST_ID = Fnd_Global.Conc_Request_Id,
878: PROGRAM_ID = Fnd_Global.Conc_program_Id,
879: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
880: PROGRAM_UPDATE_DATE = sysdate
881: where transaction_id = g_rtg_header_rec.Row_Identifier;

Line 878: PROGRAM_ID = Fnd_Global.Conc_program_Id,

874:
875: Update BOM_OP_ROUTINGS_INTERFACE
876: set process_flag = l_process_flag,
877: REQUEST_ID = Fnd_Global.Conc_Request_Id,
878: PROGRAM_ID = Fnd_Global.Conc_program_Id,
879: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
880: PROGRAM_UPDATE_DATE = sysdate
881: where transaction_id = g_rtg_header_rec.Row_Identifier;
882:

Line 879: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

875: Update BOM_OP_ROUTINGS_INTERFACE
876: set process_flag = l_process_flag,
877: REQUEST_ID = Fnd_Global.Conc_Request_Id,
878: PROGRAM_ID = Fnd_Global.Conc_program_Id,
879: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
880: PROGRAM_UPDATE_DATE = sysdate
881: where transaction_id = g_rtg_header_rec.Row_Identifier;
882:
883: stmt_num := 1;

Line 899: REQUEST_ID = Fnd_Global.Conc_Request_Id,

895: end if;
896:
897: Update MTL_RTG_ITEM_REVS_INTERFACE
898: set process_flag = l_process_flag,
899: REQUEST_ID = Fnd_Global.Conc_Request_Id,
900: PROGRAM_ID = Fnd_Global.Conc_program_Id,
901: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
902: PROGRAM_UPDATE_DATE = sysdate
903: where transaction_id = g_rtg_revision_rec.row_identifier;

Line 900: PROGRAM_ID = Fnd_Global.Conc_program_Id,

896:
897: Update MTL_RTG_ITEM_REVS_INTERFACE
898: set process_flag = l_process_flag,
899: REQUEST_ID = Fnd_Global.Conc_Request_Id,
900: PROGRAM_ID = Fnd_Global.Conc_program_Id,
901: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
902: PROGRAM_UPDATE_DATE = sysdate
903: where transaction_id = g_rtg_revision_rec.row_identifier;
904: END LOOP;

Line 901: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

897: Update MTL_RTG_ITEM_REVS_INTERFACE
898: set process_flag = l_process_flag,
899: REQUEST_ID = Fnd_Global.Conc_Request_Id,
900: PROGRAM_ID = Fnd_Global.Conc_program_Id,
901: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
902: PROGRAM_UPDATE_DATE = sysdate
903: where transaction_id = g_rtg_revision_rec.row_identifier;
904: END LOOP;
905:

Line 922: REQUEST_ID = Fnd_Global.Conc_Request_Id,

918: end if;
919:
920: Update BOM_OP_SEQUENCES_INTERFACE
921: set process_flag = l_process_flag,
922: REQUEST_ID = Fnd_Global.Conc_Request_Id,
923: PROGRAM_ID = Fnd_Global.Conc_program_Id,
924: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
925: PROGRAM_UPDATE_DATE = sysdate
926: where transaction_id = g_op_rec.row_identifier;

Line 923: PROGRAM_ID = Fnd_Global.Conc_program_Id,

919:
920: Update BOM_OP_SEQUENCES_INTERFACE
921: set process_flag = l_process_flag,
922: REQUEST_ID = Fnd_Global.Conc_Request_Id,
923: PROGRAM_ID = Fnd_Global.Conc_program_Id,
924: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
925: PROGRAM_UPDATE_DATE = sysdate
926: where transaction_id = g_op_rec.row_identifier;
927: END LOOP;

Line 924: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

920: Update BOM_OP_SEQUENCES_INTERFACE
921: set process_flag = l_process_flag,
922: REQUEST_ID = Fnd_Global.Conc_Request_Id,
923: PROGRAM_ID = Fnd_Global.Conc_program_Id,
924: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
925: PROGRAM_UPDATE_DATE = sysdate
926: where transaction_id = g_op_rec.row_identifier;
927: END LOOP;
928:

Line 945: REQUEST_ID = Fnd_Global.Conc_Request_Id,

941: end if;
942:
943: Update BOM_OP_RESOURCES_INTERFACE
944: set process_flag = l_process_flag,
945: REQUEST_ID = Fnd_Global.Conc_Request_Id,
946: PROGRAM_ID = Fnd_Global.Conc_program_Id,
947: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
948: PROGRAM_UPDATE_DATE = sysdate
949: where transaction_id = g_op_res_rec.row_identifier;

Line 946: PROGRAM_ID = Fnd_Global.Conc_program_Id,

942:
943: Update BOM_OP_RESOURCES_INTERFACE
944: set process_flag = l_process_flag,
945: REQUEST_ID = Fnd_Global.Conc_Request_Id,
946: PROGRAM_ID = Fnd_Global.Conc_program_Id,
947: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
948: PROGRAM_UPDATE_DATE = sysdate
949: where transaction_id = g_op_res_rec.row_identifier;
950: END LOOP;

Line 947: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

943: Update BOM_OP_RESOURCES_INTERFACE
944: set process_flag = l_process_flag,
945: REQUEST_ID = Fnd_Global.Conc_Request_Id,
946: PROGRAM_ID = Fnd_Global.Conc_program_Id,
947: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
948: PROGRAM_UPDATE_DATE = sysdate
949: where transaction_id = g_op_res_rec.row_identifier;
950: END LOOP;
951:

Line 967: REQUEST_ID = Fnd_Global.Conc_Request_Id,

963: end if;
964:
965: Update BOM_SUB_OP_RESOURCES_INTERFACE
966: set process_flag = l_process_flag,
967: REQUEST_ID = Fnd_Global.Conc_Request_Id,
968: PROGRAM_ID = Fnd_Global.Conc_program_Id,
969: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
970: PROGRAM_UPDATE_DATE = sysdate
971: where transaction_id = g_sub_op_res_rec.row_identifier;

Line 968: PROGRAM_ID = Fnd_Global.Conc_program_Id,

964:
965: Update BOM_SUB_OP_RESOURCES_INTERFACE
966: set process_flag = l_process_flag,
967: REQUEST_ID = Fnd_Global.Conc_Request_Id,
968: PROGRAM_ID = Fnd_Global.Conc_program_Id,
969: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
970: PROGRAM_UPDATE_DATE = sysdate
971: where transaction_id = g_sub_op_res_rec.row_identifier;
972: END LOOP;

Line 969: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

965: Update BOM_SUB_OP_RESOURCES_INTERFACE
966: set process_flag = l_process_flag,
967: REQUEST_ID = Fnd_Global.Conc_Request_Id,
968: PROGRAM_ID = Fnd_Global.Conc_program_Id,
969: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
970: PROGRAM_UPDATE_DATE = sysdate
971: where transaction_id = g_sub_op_res_rec.row_identifier;
972: END LOOP;
973:

Line 989: REQUEST_ID = Fnd_Global.Conc_Request_Id,

985: end if;
986:
987: Update BOM_OP_NETWORKS_INTERFACE
988: set process_flag = l_process_flag,
989: REQUEST_ID = Fnd_Global.Conc_Request_Id,
990: PROGRAM_ID = Fnd_Global.Conc_program_Id,
991: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
992: PROGRAM_UPDATE_DATE = sysdate
993: where transaction_id = g_nwk_rec.row_identifier;

Line 990: PROGRAM_ID = Fnd_Global.Conc_program_Id,

986:
987: Update BOM_OP_NETWORKS_INTERFACE
988: set process_flag = l_process_flag,
989: REQUEST_ID = Fnd_Global.Conc_Request_Id,
990: PROGRAM_ID = Fnd_Global.Conc_program_Id,
991: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
992: PROGRAM_UPDATE_DATE = sysdate
993: where transaction_id = g_nwk_rec.row_identifier;
994: END LOOP;

Line 991: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

987: Update BOM_OP_NETWORKS_INTERFACE
988: set process_flag = l_process_flag,
989: REQUEST_ID = Fnd_Global.Conc_Request_Id,
990: PROGRAM_ID = Fnd_Global.Conc_program_Id,
991: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
992: PROGRAM_UPDATE_DATE = sysdate
993: where transaction_id = g_nwk_rec.row_identifier;
994: END LOOP;
995: