APPS.BOMPCMBM dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 2556: SELECT * from bom_substitute_components

2552: IS
2553:
2554: Cursor get_sub_comps(p_component_sequence_id NUMBER)
2555: is
2556: SELECT * from bom_substitute_components
2557: where component_sequence_id = p_component_sequence_id;
2558:
2559: Cursor get_destn_comps(p_comp_seq_id number)
2560: is

Line 2571: INSERT INTO BOM_SUBSTITUTE_COMPONENTS

2567: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2568: l_err_text VARCHAR2(2000);
2569:
2570: BEGIN
2571: INSERT INTO BOM_SUBSTITUTE_COMPONENTS
2572: ( SUBSTITUTE_COMPONENT_ID
2573: , LAST_UPDATE_DATE
2574: , LAST_UPDATED_BY
2575: , CREATION_DATE

Line 2640: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp

2636: , Bom_Globals.Get_Prog_Id
2637: , sub_comp.Original_System_Reference
2638: , sub_comp.enforce_int_requirements
2639: , sub_comp.component_sequence_id
2640: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp
2641: WHERE dest_comp.component_Sequence_id <> dest_comp.common_component_sequence_id
2642: AND dest_comp.common_component_sequence_id = sub_comp.component_sequence_id
2643: AND sub_comp.component_sequence_id = p_component_sequence_id
2644: AND NOT EXISTS

Line 2647: FROM bom_substitute_components bsc2

2643: AND sub_comp.component_sequence_id = p_component_sequence_id
2644: AND NOT EXISTS
2645: (
2646: SELECT 1
2647: FROM bom_substitute_components bsc2
2648: where bsc2.component_sequence_id = dest_comp.component_sequence_id
2649: and bsc2.substitute_component_id = sub_comp.substitute_component_id
2650: )
2651: ;

Line 2717: from bom_substitute_components

2713: Cursor get_sub_comp_details(p_comp_seq_id NUMBER,
2714: p_sub_comp_item_id NUMBER)
2715: IS
2716: select *
2717: from bom_substitute_components
2718: where component_sequence_id = p_comp_seq_id
2719: and substitute_component_id = p_sub_comp_item_id;
2720:
2721: Cursor get_destn_comps(p_comp_seq_id number)

Line 2741: INSERT INTO BOM_SUBSTITUTE_COMPONENTS

2737: loop
2738: for dest_comp in get_destn_comps(p_component_sequence_id)
2739: loop
2740:
2741: INSERT INTO BOM_SUBSTITUTE_COMPONENTS
2742: ( SUBSTITUTE_COMPONENT_ID
2743: , LAST_UPDATE_DATE
2744: , LAST_UPDATED_BY
2745: , CREATION_DATE

Line 2884: from bom_substitute_components

2880: Cursor get_sub_comp_details(p_comp_seq_id NUMBER,
2881: p_sub_comp_item_id NUMBER)
2882: IS
2883: select *
2884: from bom_substitute_components
2885: where component_sequence_id = p_comp_seq_id
2886: and substitute_component_id = p_new_sub_comp_item_id
2887: and nvl(acd_type, 0) = nvl(p_acd_type, 0);
2888:

Line 2902: UPDATE BOM_SUBSTITUTE_COMPONENTS

2898: loop
2899: /*for dest_comp in get_destn_comps(p_component_sequence_id)
2900: loop
2901: l_acd_type := sub_comp.acd_type;*/
2902: UPDATE BOM_SUBSTITUTE_COMPONENTS
2903: SET SUBSTITUTE_COMPONENT_ID = sub_comp.substitute_component_id
2904: , SUBSTITUTE_ITEM_QUANTITY = sub_comp.substitute_item_quantity
2905: , ATTRIBUTE_CATEGORY = sub_comp.attribute_category
2906: , ATTRIBUTE1 = sub_comp.attribute1

Line 3985: DELETE FROM BOM_SUBSTITUTE_COMPONENTS

3981: , p_sub_comp_item_id IN NUMBER
3982: , x_return_status IN OUT NOCOPY VARCHAR2)
3983: IS
3984: BEGIN
3985: DELETE FROM BOM_SUBSTITUTE_COMPONENTS
3986: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq
3987: AND SUBSTITUTE_COMPONENT_ID = p_sub_comp_item_id;
3988: EXCEPTION
3989: WHEN OTHERS THEN

Line 4132: DELETE BOM_SUBSTITUTE_COMPONENTS

4128: --Commented
4129: DELETE BOM_COMPONENTS_B
4130: WHERE common_component_sequence_id = p_src_comp_seq_id;
4131:
4132: DELETE BOM_SUBSTITUTE_COMPONENTS
4133: WHERE common_component_sequence_id = p_src_comp_seq_id;
4134:
4135: DELETE BOM_REFERENCE_DESIGNATORS
4136: WHERE common_component_sequence_id = p_src_comp_seq_id;