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 965: Update BOM_SUB_OP_RESOURCES_INTERFACE

961: l_process_flag := 3;
962: l_ret_status := 1;
963: end if;
964:
965: Update BOM_SUB_OP_RESOURCES_INTERFACE
966: set process_flag = l_process_flag,
967: REQUEST_ID = Fnd_Global.Conc_Request_Id,
968: PROGRAM_ID = Fnd_Global.Conc_program_Id,
969: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1057: DELETE FROM BOM_SUB_OP_RESOURCES_INTERFACE

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