APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 260: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE

256:
257: orp_sub_rec get_orphan_sub_comps%ROWTYPE;
258:
259: cursor get_comp_ops (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
260: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE
261: where process_flag = 1
262: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
263: and assembly_item_number = cp_ass_item_name
264: and organization_code = cp_org_code

Line 278: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE

274:
275: ops_rec get_comp_ops%ROWTYPE;
276:
277: cursor get_orphan_comp_ops is
278: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE
279: where process_flag = 1
280: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
281: and transaction_id is not null
282: and

Line 985: Update BOM_COMPONENT_OPS_INTERFACE

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

Line 1058: DELETE FROM BOM_COMPONENT_OPS_INTERFACE

1054: end loop;
1055:
1056: stmt_num := 4;
1057: loop
1058: DELETE FROM BOM_COMPONENT_OPS_INTERFACE
1059: WHERE PROCESS_FLAG = 7
1060: AND
1061: (
1062: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )