APPS.BOM_RTG_OPEN_INTERFACE dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 224: select * from BOM_SUB_OP_RESOURCES_INTERFACE

220: );
221: orphan_op_res_rec get_orphan_op_resources%ROWTYPE;
222:
223: cursor get_sub_op_resources(cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_rtg_des varchar2) is
224: select * from BOM_SUB_OP_RESOURCES_INTERFACE
225: where process_flag = 1
226: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
227: and assembly_item_number = cp_ass_item_name
228: and organization_code = cp_org_code

Line 239: select * from BOM_SUB_OP_RESOURCES_INTERFACE

235: );
236: sub_op_res_rec get_sub_op_resources%ROWTYPE;
237:
238: cursor get_orphan_sub_op_resources is
239: select * from BOM_SUB_OP_RESOURCES_INTERFACE
240: where process_flag = 1
241: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
242: and transaction_id is not null
243: and

Line 980: Update BOM_SUB_OP_RESOURCES_INTERFACE

976: l_process_flag := 3;
977: l_ret_status := 1;
978: end if;
979:
980: Update BOM_SUB_OP_RESOURCES_INTERFACE
981: set process_flag = l_process_flag,
982: REQUEST_ID = Fnd_Global.Conc_Request_Id,
983: PROGRAM_ID = Fnd_Global.Conc_program_Id,
984: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1072: DELETE FROM BOM_SUB_OP_RESOURCES_INTERFACE

1068: end loop;
1069:
1070: stmt_num := 4;
1071: loop
1072: DELETE FROM BOM_SUB_OP_RESOURCES_INTERFACE
1073: WHERE PROCESS_FLAG = 7
1074: AND
1075: (
1076: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )