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 958: Update BOM_OP_RESOURCES_INTERFACE

954: l_process_flag := 3;
955: l_ret_status := 1;
956: end if;
957:
958: Update BOM_OP_RESOURCES_INTERFACE
959: set process_flag = l_process_flag,
960: REQUEST_ID = Fnd_Global.Conc_Request_Id,
961: PROGRAM_ID = Fnd_Global.Conc_program_Id,
962: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1058: DELETE FROM BOM_OP_RESOURCES_INTERFACE

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