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: );
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;
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:
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;
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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: