APPS.BOM_IMPORT_PUB dependencies on BOM_REF_DESGS_INTERFACE

Line 149: FROM bom_ref_desgs_interface

145: IS
146: CURSOR Get_Src_RefDs
147: IS
148: SELECT *
149: FROM bom_ref_desgs_interface
150: WHERE batch_id = p_batch_id
151: AND (component_sequence_id = p_comp_seq_id
152: OR (component_item_id = p_comp_id
153: AND organization_id = p_org_id

Line 168: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;

164: FROM bom_reference_designators
165: WHERE component_sequence_id = p_comp_seq_id
166: ORDER BY component_reference_designator;
167:
168: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;
169: TYPE ref_pimdh_type IS TABLE OF bom_reference_designators%ROWTYPE;
170:
171: l_src_refds ref_intf_type;
172: l_pimdh_refds ref_pimdh_type;

Line 204: INSERT INTO bom_ref_desgs_interface

200: END LOOP; -- pimdh loop
201: END LOOP; -- src loop
202: FOR i in 1..l_pimdh_count LOOP
203: IF nvl(l_pimdh_refds(i).attribute1,'N') <> 'Y' THEN
204: INSERT INTO bom_ref_desgs_interface
205: (
206: COMPONENT_REFERENCE_DESIGNATOR,
207: REF_DESIGNATOR_COMMENT,
208: CHANGE_NOTICE,

Line 242: INSERT INTO bom_ref_desgs_interface

238: l_delete := false;
239: END IF;
240: END LOOP; -- pimdh loop
241: IF l_delete THEN
242: INSERT INTO bom_ref_desgs_interface
243: (
244: COMPONENT_REFERENCE_DESIGNATOR,
245: REF_DESIGNATOR_COMMENT,
246: CHANGE_NOTICE,

Line 363: BOM_REF_DESGS_INTERFACE

359: and batch_id = p_batch_id
360: and process_flag = 1;
361:
362: update
363: BOM_REF_DESGS_INTERFACE
364: set
365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
366: where
367: transaction_id is null

Line 2997: FROM bom_ref_desgs_interface

2993: IS
2994: CURSOR c_src_ref_desg ( p_batch_id IN NUMBER,p_ss_ref IN VARCHAR2,p_comp_seq_id IN NUMBER)
2995: IS
2996: SELECT component_reference_designator
2997: FROM bom_ref_desgs_interface
2998: WHERE batch_id = p_batch_id
2999: AND ( ( (comp_source_system_reference = p_ss_ref OR component_item_number = p_ss_ref OR component_item_id = p_item_id )
3000: -- AND effectivity_date = p_effec_date
3001: -- AND operation_seq_num = p_op_seq_num

Line 4269: UPDATE bom_ref_desgs_interface

4265: --AND new_effectivity_date = l_effectivity_table(i)
4266: AND batch_id = p_batch_id;
4267: END IF;
4268:
4269: UPDATE bom_ref_desgs_interface
4270: SET component_sequence_id = l_comp_seq_table(i),
4271: component_item_id = l_comp_item_id_table(i),
4272: organization_id = l_org_id_table(i),
4273: assembly_item_id = l_head_item_id_table(i)

Line 5150: DELETE bom_ref_desgs_interface

5146:
5147: stmt_num := 3;
5148: Write_Debug('Deleting the Ref Desgs interface');
5149:
5150: DELETE bom_ref_desgs_interface
5151: WHERE batch_id = p_batch_id;
5152:
5153: stmt_num := 4;
5154: Write_Debug('Deleting the Sub Comps Rows');

Line 5547: FROM bom_ref_desgs_interface

5543:
5544: CURSOR Get_Ref_Desgs
5545: IS
5546: SELECT COMPONENT_REFERENCE_DESIGNATOR,MAX(interface_table_unique_id)
5547: FROM bom_ref_desgs_interface
5548: where batch_id = p_batch_id
5549: and process_flag = 1
5550: and ( component_sequence_id = p_comp_seq_id
5551: OR ( (component_item_number = p_comp_name OR comp_source_system_reference = p_comp_ref)

Line 5573: UPDATE bom_ref_desgs_interface

5569: l_count := l_max_unique_id.COUNT;
5570:
5571: FOR i in 1..l_count
5572: LOOP
5573: UPDATE bom_ref_desgs_interface
5574: SET process_flag = -1
5575: WHERE batch_id = p_batch_id
5576: AND ( process_flag = 1 OR process_flag = 5)
5577: AND ( component_sequence_id = p_comp_seq_id

Line 5788: UPDATE bom_ref_desgs_interface

5784: WHERE batch_id = p_batch_id
5785: AND process_flag = 1;
5786:
5787: --Update other entities also
5788: UPDATE bom_ref_desgs_interface
5789: SET process_flag = 5
5790: WHERE batch_id = p_batch_id
5791: AND process_flag = 1;
5792:

Line 5856: UPDATE bom_ref_desgs_interface

5852: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5853: )
5854: );
5855:
5856: UPDATE bom_ref_desgs_interface
5857: SET process_flag = 5
5858: WHERE batch_id = p_batch_id
5859: AND process_flag = 1
5860: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id