APPS.BOM_RTG_OPEN_INTERFACE dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 124: select * from BOM_OP_SEQUENCES_INTERFACE A

120:
121: orphan_revs_rec get_orphan_revs%ROWTYPE;
122:
123: cursor get_op_seqs(cp_ass_item_name varchar2, cp_org_code varchar2, cp_alt_rtg_des varchar2) is
124: select * from BOM_OP_SEQUENCES_INTERFACE A
125: Where process_flag = 1
126: and (p_all_org = 1 or (p_all_org = 2 and organization_id = p_organization_id))
127: and assembly_item_number = cp_ass_item_name
128: and organization_code = cp_org_code

Line 142: select * from BOM_OP_SEQUENCES_INTERFACE A

138: op_seqs_rec get_op_seqs%ROWTYPE;
139:
140: /* Modified cursor for bug 4350033 */
141: cursor get_orphan_op_seqs is
142: select * from BOM_OP_SEQUENCES_INTERFACE A
143: Where process_flag = 1
144: and p_all_org = 1
145: and transaction_id is not null
146: and

Line 153: SELECT * from BOM_OP_SEQUENCES_INTERFACE A

149: or ( p_batch_id = batch_id )
150: )
151: and rownum = 1
152: UNION ALL
153: SELECT * from BOM_OP_SEQUENCES_INTERFACE A
154: Where process_flag = 1
155: and p_all_org = 2 and organization_Id = p_organization_id
156: and transaction_id is not null
157: and rownum = 1

Line 935: Update BOM_OP_SEQUENCES_INTERFACE

931: l_process_flag := 3;
932: l_ret_status := 1;
933: end if;
934:
935: Update BOM_OP_SEQUENCES_INTERFACE
936: set process_flag = l_process_flag,
937: REQUEST_ID = Fnd_Global.Conc_Request_Id,
938: PROGRAM_ID = Fnd_Global.Conc_program_Id,
939: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1044: DELETE FROM BOM_OP_SEQUENCES_INTERFACE

1040: end loop;
1041:
1042: stmt_num := 2;
1043: loop
1044: DELETE FROM BOM_OP_SEQUENCES_INTERFACE
1045: WHERE PROCESS_FLAG = 7
1046: AND
1047: (
1048: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )