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;
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
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: /*
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
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,
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: );
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;
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:
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;
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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: