APPS.BOM_OPEN_INTERFACE_API dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 269: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE

265:
266: orp_sub_rec get_orphan_sub_comps%ROWTYPE;
267:
268: cursor get_comp_ops (cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_des varchar2) is
269: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE
270: where process_flag = 1
271: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
272: and assembly_item_number = cp_ass_item_name
273: and organization_code = cp_org_code

Line 287: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE

283:
284: ops_rec get_comp_ops%ROWTYPE;
285:
286: cursor get_orphan_comp_ops is
287: SELECT * FROM BOM_COMPONENT_OPS_INTERFACE
288: where process_flag = 1
289: and (all_org = 1 or (all_org = 2 and organization_id = org_id))
290: and transaction_id is not null
291: and

Line 994: Update BOM_COMPONENT_OPS_INTERFACE

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

Line 1067: DELETE FROM BOM_COMPONENT_OPS_INTERFACE

1063: end loop;
1064:
1065: stmt_num := 4;
1066: loop
1067: DELETE FROM BOM_COMPONENT_OPS_INTERFACE
1068: WHERE PROCESS_FLAG = 7
1069: AND
1070: (
1071: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )