APPS.BOM_RTG_OPEN_INTERFACE dependencies on BOM_OP_NETWORKS_INTERFACE

Line 169: select * from BOM_OP_NETWORKS_INTERFACE

165:
166: orphan_op_seqs_rec get_orphan_op_seqs%ROWTYPE;
167:
168: cursor get_op_nwk(cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_rtg_des varchar2) is
169: select * from BOM_OP_NETWORKS_INTERFACE
170: Where process_flag = 1
171: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
172: and assembly_item_number = cp_ass_item_name
173: and organization_code = cp_org_code

Line 184: select * from BOM_OP_NETWORKS_INTERFACE

180: );
181: op_nwk_rec get_op_nwk%ROWTYPE;
182:
183: cursor get_orphan_op_nwk is
184: select * from BOM_OP_NETWORKS_INTERFACE
185: Where process_flag = 1
186: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
187: and transaction_id is not null
188: and

Line 987: Update BOM_OP_NETWORKS_INTERFACE

983: l_process_flag := 3;
984: l_ret_status := 1;
985: end if;
986:
987: Update BOM_OP_NETWORKS_INTERFACE
988: set process_flag = l_process_flag,
989: REQUEST_ID = Fnd_Global.Conc_Request_Id,
990: PROGRAM_ID = Fnd_Global.Conc_program_Id,
991: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1071: DELETE FROM BOM_OP_NETWORKS_INTERFACE

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