APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_REF_DESGS_INTERFACE

Line 197: select * from BOM_REF_DESGS_INTERFACE

193:
194: orp_rev_rec get_orphan_revs%ROWTYPE;
195:
196: cursor get_ref_desg (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
197: select * from BOM_REF_DESGS_INTERFACE
198: where process_flag = 1
199: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
200: and assembly_item_number = cp_ass_item_name
201: and organization_code = cp_org_code

Line 216: FROM BOM_REF_DESGS_INTERFACE

212: ref_rec get_ref_desg%ROWTYPE;
213:
214: cursor get_orphan_ref_desg is
215: SELECT *
216: FROM BOM_REF_DESGS_INTERFACE
217: where process_flag = 1
218: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
219: and transaction_id is not null
220: and

Line 941: Update bom_ref_desgs_interface

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

Line 1044: DELETE FROM BOM_REF_DESGS_INTERFACE

1040: end loop;
1041:
1042: stmt_num := 3;
1043: loop
1044: DELETE FROM BOM_REF_DESGS_INTERFACE
1045: WHERE PROCESS_FLAG = 7
1046: AND
1047: (
1048: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )