APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_REF_DESGS_INTERFACE

Line 202: select * from BOM_REF_DESGS_INTERFACE

198:
199: orp_rev_rec get_orphan_revs%ROWTYPE;
200:
201: cursor get_ref_desg (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
202: select * from BOM_REF_DESGS_INTERFACE
203: where process_flag = 1
204: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
205: and assembly_item_number = cp_ass_item_name
206: and organization_code = cp_org_code

Line 222: FROM BOM_REF_DESGS_INTERFACE

218: ref_rec get_ref_desg%ROWTYPE;
219:
220: cursor get_orphan_ref_desg is
221: SELECT *
222: FROM BOM_REF_DESGS_INTERFACE
223: where process_flag = 1
224: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
225: and transaction_id is not null
226: and change_notice is null --added for bug 9447664

Line 950: Update bom_ref_desgs_interface

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

Line 1053: DELETE FROM BOM_REF_DESGS_INTERFACE

1049: end loop;
1050:
1051: stmt_num := 3;
1052: loop
1053: DELETE FROM BOM_REF_DESGS_INTERFACE
1054: WHERE PROCESS_FLAG = 7
1055: AND
1056: (
1057: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )