APPS.BOM_IMPORT_PUB dependencies on BOM_REF_DESGS_INTERFACE

Line 142: FROM bom_ref_desgs_interface

138: IS
139: CURSOR Get_Src_RefDs
140: IS
141: SELECT *
142: FROM bom_ref_desgs_interface
143: WHERE batch_id = p_batch_id
144: AND (component_sequence_id = p_comp_seq_id
145: OR (component_item_id = p_comp_id
146: AND organization_id = p_org_id

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

157: FROM bom_reference_designators
158: WHERE component_sequence_id = p_comp_seq_id
159: ORDER BY component_reference_designator;
160:
161: TYPE ref_intf_type IS TABLE OF bom_ref_desgs_interface%ROWTYPE;
162: TYPE ref_pimdh_type IS TABLE OF bom_reference_designators%ROWTYPE;
163:
164: l_src_refds ref_intf_type;
165: l_pimdh_refds ref_pimdh_type;

Line 197: INSERT INTO bom_ref_desgs_interface

193: END LOOP; -- pimdh loop
194: END LOOP; -- src loop
195: FOR i in 1..l_pimdh_count LOOP
196: IF nvl(l_pimdh_refds(i).attribute1,'N') <> 'Y' THEN
197: INSERT INTO bom_ref_desgs_interface
198: (
199: COMPONENT_REFERENCE_DESIGNATOR,
200: REF_DESIGNATOR_COMMENT,
201: CHANGE_NOTICE,

Line 235: INSERT INTO bom_ref_desgs_interface

231: l_delete := false;
232: END IF;
233: END LOOP; -- pimdh loop
234: IF l_delete THEN
235: INSERT INTO bom_ref_desgs_interface
236: (
237: COMPONENT_REFERENCE_DESIGNATOR,
238: REF_DESIGNATOR_COMMENT,
239: CHANGE_NOTICE,

Line 356: BOM_REF_DESGS_INTERFACE

352: and batch_id = p_batch_id
353: and process_flag = 1;
354:
355: update
356: BOM_REF_DESGS_INTERFACE
357: set
358: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
359: where
360: transaction_id is null

Line 2844: FROM bom_ref_desgs_interface

2840: IS
2841: CURSOR c_src_ref_desg ( p_batch_id IN NUMBER,p_ss_ref IN VARCHAR2,p_comp_seq_id IN NUMBER)
2842: IS
2843: SELECT component_reference_designator
2844: FROM bom_ref_desgs_interface
2845: WHERE batch_id = p_batch_id
2846: AND ( ( (comp_source_system_reference = p_ss_ref OR component_item_number = p_ss_ref OR component_item_id = p_item_id )
2847: -- AND effectivity_date = p_effec_date
2848: -- AND operation_seq_num = p_op_seq_num

Line 3877: UPDATE bom_ref_desgs_interface

3873: --AND new_effectivity_date = l_effectivity_table(i)
3874: AND batch_id = p_batch_id;
3875: END IF;
3876:
3877: UPDATE bom_ref_desgs_interface
3878: SET component_sequence_id = l_comp_seq_table(i),
3879: component_item_id = l_comp_item_id_table(i),
3880: organization_id = l_org_id_table(i),
3881: assembly_item_id = l_head_item_id_table(i)

Line 4758: DELETE bom_ref_desgs_interface

4754:
4755: stmt_num := 3;
4756: Write_Debug('Deleting the Ref Desgs interface');
4757:
4758: DELETE bom_ref_desgs_interface
4759: WHERE batch_id = p_batch_id;
4760:
4761: stmt_num := 4;
4762: Write_Debug('Deleting the Sub Comps Rows');

Line 5155: FROM bom_ref_desgs_interface

5151:
5152: CURSOR Get_Ref_Desgs
5153: IS
5154: SELECT COMPONENT_REFERENCE_DESIGNATOR,MAX(interface_table_unique_id)
5155: FROM bom_ref_desgs_interface
5156: where batch_id = p_batch_id
5157: and process_flag = 1
5158: and ( component_sequence_id = p_comp_seq_id
5159: OR ( (component_item_number = p_comp_name OR comp_source_system_reference = p_comp_ref)

Line 5181: UPDATE bom_ref_desgs_interface

5177: l_count := l_max_unique_id.COUNT;
5178:
5179: FOR i in 1..l_count
5180: LOOP
5181: UPDATE bom_ref_desgs_interface
5182: SET process_flag = -1
5183: WHERE batch_id = p_batch_id
5184: AND ( process_flag = 1 OR process_flag = 5)
5185: AND ( component_sequence_id = p_comp_seq_id

Line 5396: UPDATE bom_ref_desgs_interface

5392: WHERE batch_id = p_batch_id
5393: AND process_flag = 1;
5394:
5395: --Update other entities also
5396: UPDATE bom_ref_desgs_interface
5397: SET process_flag = 5
5398: WHERE batch_id = p_batch_id
5399: AND process_flag = 1;
5400:

Line 5464: UPDATE bom_ref_desgs_interface

5460: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5461: )
5462: );
5463:
5464: UPDATE bom_ref_desgs_interface
5465: SET process_flag = 5
5466: WHERE batch_id = p_batch_id
5467: AND process_flag = 1
5468: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id