DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_API dependencies on FND_GLOBAL

Line 328: fnd_global.apps_initialize

324:
325: stmt_num := 1;
326: --commented by vhymavat for bug 3179687
327: /*
328: fnd_global.apps_initialize
329: ( user_id => user_id,
330: resp_id =>FND_PROFILE.value('RESP_ID'),
331: resp_appl_id => prog_appid
332: );

Line 884: REQUEST_ID = Fnd_Global.Conc_Request_Id,

880: end if;
881:
882: Update bom_bill_of_mtls_interface
883: set process_flag = l_process_flag,
884: REQUEST_ID = Fnd_Global.Conc_Request_Id,
885: PROGRAM_ID = Fnd_Global.Conc_program_Id,
886: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
887: PROGRAM_UPDATE_DATE = sysdate
888: where transaction_id = l_bom_header_rec.Row_Identifier;

Line 885: PROGRAM_ID = Fnd_Global.Conc_program_Id,

881:
882: Update bom_bill_of_mtls_interface
883: set process_flag = l_process_flag,
884: REQUEST_ID = Fnd_Global.Conc_Request_Id,
885: PROGRAM_ID = Fnd_Global.Conc_program_Id,
886: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
887: PROGRAM_UPDATE_DATE = sysdate
888: where transaction_id = l_bom_header_rec.Row_Identifier;
889:

Line 886: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

882: Update bom_bill_of_mtls_interface
883: set process_flag = l_process_flag,
884: REQUEST_ID = Fnd_Global.Conc_Request_Id,
885: PROGRAM_ID = Fnd_Global.Conc_program_Id,
886: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
887: PROGRAM_UPDATE_DATE = sysdate
888: where transaction_id = l_bom_header_rec.Row_Identifier;
889:
890: stmt_num :=1;

Line 906: REQUEST_ID = Fnd_Global.Conc_Request_Id,

902: end if;
903:
904: Update mtl_item_revisions_interface
905: set process_flag = l_process_flag,
906: REQUEST_ID = Fnd_Global.Conc_Request_Id,
907: PROGRAM_ID = Fnd_Global.Conc_program_Id,
908: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
909: PROGRAM_UPDATE_DATE = sysdate
910: where transaction_id = l_bom_revision_rec.row_identifier;

Line 907: PROGRAM_ID = Fnd_Global.Conc_program_Id,

903:
904: Update mtl_item_revisions_interface
905: set process_flag = l_process_flag,
906: REQUEST_ID = Fnd_Global.Conc_Request_Id,
907: PROGRAM_ID = Fnd_Global.Conc_program_Id,
908: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
909: PROGRAM_UPDATE_DATE = sysdate
910: where transaction_id = l_bom_revision_rec.row_identifier;
911: END LOOP;

Line 908: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

904: Update mtl_item_revisions_interface
905: set process_flag = l_process_flag,
906: REQUEST_ID = Fnd_Global.Conc_Request_Id,
907: PROGRAM_ID = Fnd_Global.Conc_program_Id,
908: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
909: PROGRAM_UPDATE_DATE = sysdate
910: where transaction_id = l_bom_revision_rec.row_identifier;
911: END LOOP;
912:

Line 929: REQUEST_ID = Fnd_Global.Conc_Request_Id,

925: end if;
926:
927: Update bom_inventory_comps_interface
928: set process_flag = l_process_flag,
929: REQUEST_ID = Fnd_Global.Conc_Request_Id,
930: PROGRAM_ID = Fnd_Global.Conc_program_Id,
931: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
932: PROGRAM_UPDATE_DATE = sysdate
933: where transaction_id = l_bom_component_rec.row_identifier;

Line 930: PROGRAM_ID = Fnd_Global.Conc_program_Id,

926:
927: Update bom_inventory_comps_interface
928: set process_flag = l_process_flag,
929: REQUEST_ID = Fnd_Global.Conc_Request_Id,
930: PROGRAM_ID = Fnd_Global.Conc_program_Id,
931: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
932: PROGRAM_UPDATE_DATE = sysdate
933: where transaction_id = l_bom_component_rec.row_identifier;
934: END LOOP;

Line 931: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

927: Update bom_inventory_comps_interface
928: set process_flag = l_process_flag,
929: REQUEST_ID = Fnd_Global.Conc_Request_Id,
930: PROGRAM_ID = Fnd_Global.Conc_program_Id,
931: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
932: PROGRAM_UPDATE_DATE = sysdate
933: where transaction_id = l_bom_component_rec.row_identifier;
934: END LOOP;
935:

Line 952: REQUEST_ID = Fnd_Global.Conc_Request_Id,

948: end if;
949:
950: Update bom_ref_desgs_interface
951: set process_flag = l_process_flag,
952: REQUEST_ID = Fnd_Global.Conc_Request_Id,
953: PROGRAM_ID = Fnd_Global.Conc_program_Id,
954: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
955: PROGRAM_UPDATE_DATE = sysdate
956: where transaction_id = l_bom_ref_designator_rec.row_identifier;

Line 953: PROGRAM_ID = Fnd_Global.Conc_program_Id,

949:
950: Update bom_ref_desgs_interface
951: set process_flag = l_process_flag,
952: REQUEST_ID = Fnd_Global.Conc_Request_Id,
953: PROGRAM_ID = Fnd_Global.Conc_program_Id,
954: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
955: PROGRAM_UPDATE_DATE = sysdate
956: where transaction_id = l_bom_ref_designator_rec.row_identifier;
957: END LOOP;

Line 954: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

950: Update bom_ref_desgs_interface
951: set process_flag = l_process_flag,
952: REQUEST_ID = Fnd_Global.Conc_Request_Id,
953: PROGRAM_ID = Fnd_Global.Conc_program_Id,
954: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
955: PROGRAM_UPDATE_DATE = sysdate
956: where transaction_id = l_bom_ref_designator_rec.row_identifier;
957: END LOOP;
958:

Line 974: REQUEST_ID = Fnd_Global.Conc_Request_Id,

970: end if;
971:
972: Update BOM_SUB_COMPS_INTERFACE
973: set process_flag = l_process_flag,
974: REQUEST_ID = Fnd_Global.Conc_Request_Id,
975: PROGRAM_ID = Fnd_Global.Conc_program_Id,
976: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
977: PROGRAM_UPDATE_DATE = sysdate
978: where transaction_id = l_bom_sub_component_rec.row_identifier;

Line 975: PROGRAM_ID = Fnd_Global.Conc_program_Id,

971:
972: Update BOM_SUB_COMPS_INTERFACE
973: set process_flag = l_process_flag,
974: REQUEST_ID = Fnd_Global.Conc_Request_Id,
975: PROGRAM_ID = Fnd_Global.Conc_program_Id,
976: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
977: PROGRAM_UPDATE_DATE = sysdate
978: where transaction_id = l_bom_sub_component_rec.row_identifier;
979: END LOOP;

Line 976: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

972: Update BOM_SUB_COMPS_INTERFACE
973: set process_flag = l_process_flag,
974: REQUEST_ID = Fnd_Global.Conc_Request_Id,
975: PROGRAM_ID = Fnd_Global.Conc_program_Id,
976: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
977: PROGRAM_UPDATE_DATE = sysdate
978: where transaction_id = l_bom_sub_component_rec.row_identifier;
979: END LOOP;
980:

Line 996: REQUEST_ID = Fnd_Global.Conc_Request_Id,

992: end if;
993:
994: Update BOM_COMPONENT_OPS_INTERFACE
995: set process_flag = l_process_flag,
996: REQUEST_ID = Fnd_Global.Conc_Request_Id,
997: PROGRAM_ID = Fnd_Global.Conc_program_Id,
998: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
999: PROGRAM_UPDATE_DATE = sysdate
1000: where transaction_id = l_bom_comp_ops_rec.row_identifier;

Line 997: PROGRAM_ID = Fnd_Global.Conc_program_Id,

993:
994: Update BOM_COMPONENT_OPS_INTERFACE
995: set process_flag = l_process_flag,
996: REQUEST_ID = Fnd_Global.Conc_Request_Id,
997: PROGRAM_ID = Fnd_Global.Conc_program_Id,
998: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
999: PROGRAM_UPDATE_DATE = sysdate
1000: where transaction_id = l_bom_comp_ops_rec.row_identifier;
1001: END LOOP;

Line 998: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

994: Update BOM_COMPONENT_OPS_INTERFACE
995: set process_flag = l_process_flag,
996: REQUEST_ID = Fnd_Global.Conc_Request_Id,
997: PROGRAM_ID = Fnd_Global.Conc_program_Id,
998: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,
999: PROGRAM_UPDATE_DATE = sysdate
1000: where transaction_id = l_bom_comp_ops_rec.row_identifier;
1001: END LOOP;
1002: