APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_SUB_COMPS_INTERFACE

Line 229: select * from bom_sub_comps_interface

225:
226: orp_ref_rec get_orphan_ref_desg%ROWTYPE;
227:
228: cursor get_sub_comps (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
229: select * from bom_sub_comps_interface
230: where process_flag = 1
231: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
232: and assembly_item_number = cp_ass_item_name
233: and organization_code = cp_org_code

Line 247: SELECT * FROM BOM_SUB_COMPS_INTERFACE

243:
244: sub_rec get_sub_comps%ROWTYPE;
245:
246: cursor get_orphan_sub_comps is
247: SELECT * FROM BOM_SUB_COMPS_INTERFACE
248: where process_flag = 1
249: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
250: and transaction_id is not null
251: and

Line 963: Update BOM_SUB_COMPS_INTERFACE

959: l_process_flag := 3;
960: l_ret_status := 1;
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,

Line 1072: DELETE FROM BOM_SUB_COMPS_INTERFACE

1068: end loop;
1069:
1070: stmt_num := 5;
1071: loop
1072: DELETE FROM BOM_SUB_COMPS_INTERFACE
1073: WHERE PROCESS_FLAG = 7
1074: AND
1075: (
1076: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )