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 1002: Update BOM_OP_NETWORKS_INTERFACE

998: l_process_flag := 3;
999: l_ret_status := 1;
1000: end if;
1001:
1002: Update BOM_OP_NETWORKS_INTERFACE
1003: set process_flag = l_process_flag,
1004: REQUEST_ID = Fnd_Global.Conc_Request_Id,
1005: PROGRAM_ID = Fnd_Global.Conc_program_Id,
1006: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1086: DELETE FROM BOM_OP_NETWORKS_INTERFACE

1082: end loop;
1083:
1084: stmt_num := 5;
1085: loop
1086: DELETE FROM BOM_OP_NETWORKS_INTERFACE
1087: WHERE PROCESS_FLAG = 7
1088: AND
1089: (
1090: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )