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 920: Update BOM_OP_SEQUENCES_INTERFACE

916: l_process_flag := 3;
917: l_ret_status := 1;
918: end if;
919:
920: Update BOM_OP_SEQUENCES_INTERFACE
921: set process_flag = l_process_flag,
922: REQUEST_ID = Fnd_Global.Conc_Request_Id,
923: PROGRAM_ID = Fnd_Global.Conc_program_Id,
924: PROGRAM_APPLICATION_ID = Fnd_Global.prog_appl_id,

Line 1029: DELETE FROM BOM_OP_SEQUENCES_INTERFACE

1025: end loop;
1026:
1027: stmt_num := 2;
1028: loop
1029: DELETE FROM BOM_OP_SEQUENCES_INTERFACE
1030: WHERE PROCESS_FLAG = 7
1031: AND
1032: (
1033: ( (p_batch_id IS NULL) AND (BATCH_ID IS NULL) )