DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_API dependencies on FND_GLOBAL

Line 319: fnd_global.apps_initialize

315:
316: stmt_num := 1;
317: --commented by vhymavat for bug 3179687
318: /*
319: fnd_global.apps_initialize
320: ( user_id => user_id,
321: resp_id =>FND_PROFILE.value('RESP_ID'),
322: resp_appl_id => prog_appid
323: );

Line 875: REQUEST_ID = Fnd_Global.Conc_Request_Id,

871: end if;
872:
873: Update bom_bill_of_mtls_interface
874: set process_flag = l_process_flag,
875: REQUEST_ID = Fnd_Global.Conc_Request_Id,
876: PROGRAM_ID = Fnd_Global.Conc_program_Id,
877: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
878: PROGRAM_UPDATE_DATE = sysdate
879: where transaction_id = l_bom_header_rec.Row_Identifier;

Line 876: PROGRAM_ID = Fnd_Global.Conc_program_Id,

872:
873: Update bom_bill_of_mtls_interface
874: set process_flag = l_process_flag,
875: REQUEST_ID = Fnd_Global.Conc_Request_Id,
876: PROGRAM_ID = Fnd_Global.Conc_program_Id,
877: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
878: PROGRAM_UPDATE_DATE = sysdate
879: where transaction_id = l_bom_header_rec.Row_Identifier;
880:

Line 877: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

873: Update bom_bill_of_mtls_interface
874: set process_flag = l_process_flag,
875: REQUEST_ID = Fnd_Global.Conc_Request_Id,
876: PROGRAM_ID = Fnd_Global.Conc_program_Id,
877: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
878: PROGRAM_UPDATE_DATE = sysdate
879: where transaction_id = l_bom_header_rec.Row_Identifier;
880:
881: stmt_num :=1;

Line 897: REQUEST_ID = Fnd_Global.Conc_Request_Id,

893: end if;
894:
895: Update mtl_item_revisions_interface
896: set process_flag = l_process_flag,
897: REQUEST_ID = Fnd_Global.Conc_Request_Id,
898: PROGRAM_ID = Fnd_Global.Conc_program_Id,
899: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
900: PROGRAM_UPDATE_DATE = sysdate
901: where transaction_id = l_bom_revision_rec.row_identifier;

Line 898: PROGRAM_ID = Fnd_Global.Conc_program_Id,

894:
895: Update mtl_item_revisions_interface
896: set process_flag = l_process_flag,
897: REQUEST_ID = Fnd_Global.Conc_Request_Id,
898: PROGRAM_ID = Fnd_Global.Conc_program_Id,
899: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
900: PROGRAM_UPDATE_DATE = sysdate
901: where transaction_id = l_bom_revision_rec.row_identifier;
902: END LOOP;

Line 899: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

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

Line 920: REQUEST_ID = Fnd_Global.Conc_Request_Id,

916: end if;
917:
918: Update bom_inventory_comps_interface
919: set process_flag = l_process_flag,
920: REQUEST_ID = Fnd_Global.Conc_Request_Id,
921: PROGRAM_ID = Fnd_Global.Conc_program_Id,
922: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
923: PROGRAM_UPDATE_DATE = sysdate
924: where transaction_id = l_bom_component_rec.row_identifier;

Line 921: PROGRAM_ID = Fnd_Global.Conc_program_Id,

917:
918: Update bom_inventory_comps_interface
919: set process_flag = l_process_flag,
920: REQUEST_ID = Fnd_Global.Conc_Request_Id,
921: PROGRAM_ID = Fnd_Global.Conc_program_Id,
922: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
923: PROGRAM_UPDATE_DATE = sysdate
924: where transaction_id = l_bom_component_rec.row_identifier;
925: END LOOP;

Line 922: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

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

Line 943: REQUEST_ID = Fnd_Global.Conc_Request_Id,

939: end if;
940:
941: Update bom_ref_desgs_interface
942: set process_flag = l_process_flag,
943: REQUEST_ID = Fnd_Global.Conc_Request_Id,
944: PROGRAM_ID = Fnd_Global.Conc_program_Id,
945: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
946: PROGRAM_UPDATE_DATE = sysdate
947: where transaction_id = l_bom_ref_designator_rec.row_identifier;

Line 944: PROGRAM_ID = Fnd_Global.Conc_program_Id,

940:
941: Update bom_ref_desgs_interface
942: set process_flag = l_process_flag,
943: REQUEST_ID = Fnd_Global.Conc_Request_Id,
944: PROGRAM_ID = Fnd_Global.Conc_program_Id,
945: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
946: PROGRAM_UPDATE_DATE = sysdate
947: where transaction_id = l_bom_ref_designator_rec.row_identifier;
948: END LOOP;

Line 945: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

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

Line 965: REQUEST_ID = Fnd_Global.Conc_Request_Id,

961: end if;
962:
963: Update BOM_SUB_COMPS_INTERFACE
964: set process_flag = l_process_flag,
965: REQUEST_ID = Fnd_Global.Conc_Request_Id,
966: PROGRAM_ID = Fnd_Global.Conc_program_Id,
967: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
968: PROGRAM_UPDATE_DATE = sysdate
969: where transaction_id = l_bom_sub_component_rec.row_identifier;

Line 966: PROGRAM_ID = Fnd_Global.Conc_program_Id,

962:
963: Update BOM_SUB_COMPS_INTERFACE
964: set process_flag = l_process_flag,
965: REQUEST_ID = Fnd_Global.Conc_Request_Id,
966: PROGRAM_ID = Fnd_Global.Conc_program_Id,
967: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
968: PROGRAM_UPDATE_DATE = sysdate
969: where transaction_id = l_bom_sub_component_rec.row_identifier;
970: END LOOP;

Line 967: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

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

Line 987: REQUEST_ID = Fnd_Global.Conc_Request_Id,

983: end if;
984:
985: Update BOM_COMPONENT_OPS_INTERFACE
986: set process_flag = l_process_flag,
987: REQUEST_ID = Fnd_Global.Conc_Request_Id,
988: PROGRAM_ID = Fnd_Global.Conc_program_Id,
989: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
990: PROGRAM_UPDATE_DATE = sysdate
991: where transaction_id = l_bom_comp_ops_rec.row_identifier;

Line 988: PROGRAM_ID = Fnd_Global.Conc_program_Id,

984:
985: Update BOM_COMPONENT_OPS_INTERFACE
986: set process_flag = l_process_flag,
987: REQUEST_ID = Fnd_Global.Conc_Request_Id,
988: PROGRAM_ID = Fnd_Global.Conc_program_Id,
989: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
990: PROGRAM_UPDATE_DATE = sysdate
991: where transaction_id = l_bom_comp_ops_rec.row_identifier;
992: END LOOP;

Line 989: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

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