APPS.BOM_RTG_OPEN_INTERFACE dependencies on BOM_OP_RESOURCES_INTERFACE

Line 197: select * from BOM_OP_RESOURCES_INTERFACE A

193:
194: orphan_op_nwk_rec get_orphan_op_nwk%ROWTYPE;
195:
196: cursor get_op_resources(cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_rtg_des varchar2) is
197: select * from BOM_OP_RESOURCES_INTERFACE A
198: where process_flag = 1
199: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
200: and assembly_item_number = cp_ass_item_name
201: and organization_code = cp_org_code

Line 212: select * from BOM_OP_RESOURCES_INTERFACE

208: );
209: op_res_rec get_op_resources%ROWTYPE;
210:
211: cursor get_orphan_op_resources is
212: select * from BOM_OP_RESOURCES_INTERFACE
213: where process_flag = 1
214: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
215: and transaction_id is not null
216: and

Line 943: Update BOM_OP_RESOURCES_INTERFACE

939: l_process_flag := 3;
940: l_ret_status := 1;
941: end if;
942:
943: Update BOM_OP_RESOURCES_INTERFACE
944: set process_flag = l_process_flag,
945: REQUEST_ID = Fnd_Global.Conc_Request_Id,
946: PROGRAM_ID = Fnd_Global.Conc_program_Id,
947: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1043: DELETE FROM BOM_OP_RESOURCES_INTERFACE

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