APPS.BOMPCMBM dependencies on BOM_REFERENCE_DESIGNATORS

Line 2135: INSERT INTO BOM_REFERENCE_DESIGNATORS

2131: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2132: l_err_text VARCHAR2(2000);
2133:
2134: BEGIN
2135: INSERT INTO BOM_REFERENCE_DESIGNATORS
2136: ( COMPONENT_REFERENCE_DESIGNATOR
2137: , LAST_UPDATE_DATE
2138: , LAST_UPDATED_BY
2139: , CREATION_DATE

Line 2205: FROM BOM_COMPONENTS_B comp, BOM_REFERENCE_DESIGNATORS ref_desg

2201: , ref_desg.attribute14
2202: , ref_desg.attribute15
2203: , ref_desg.Original_System_Reference
2204: , p_component_sequence_id
2205: FROM BOM_COMPONENTS_B comp, BOM_REFERENCE_DESIGNATORS ref_desg
2206: WHERE comp.component_sequence_id <> comp.common_component_sequence_id
2207: AND comp.common_component_sequence_id = ref_desg.component_sequence_id
2208: AND ref_desg.component_sequence_id = p_component_sequence_id
2209: AND NOT EXISTS

Line 2212: FROM bom_reference_designators ref2

2208: AND ref_desg.component_sequence_id = p_component_sequence_id
2209: AND NOT EXISTS
2210: (
2211: SELECT 1
2212: FROM bom_reference_designators ref2
2213: where ref2.component_sequence_id = comp.component_sequence_id
2214: and ref2.component_reference_designator = ref_desg.component_reference_designator
2215: )
2216: ;

Line 2217: /*insert into bom_reference_designators()

2213: where ref2.component_sequence_id = comp.component_sequence_id
2214: and ref2.component_reference_designator = ref_desg.component_reference_designator
2215: )
2216: ;
2217: /*insert into bom_reference_designators()
2218: values();*/
2219: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2220: EXCEPTION
2221: WHEN OTHERS THEN

Line 2282: from bom_reference_designators

2278: Cursor get_ref_desg_details(p_comp_seq_id NUMBER,
2279: p_ref_desg VARCHAR2)
2280: IS
2281: select *
2282: from bom_reference_designators
2283: where component_sequence_id = p_comp_seq_id
2284: and component_reference_designator = p_ref_desg;
2285:
2286: Cursor get_destn_comps(p_comp_seq_id number)

Line 2305: INSERT INTO BOM_REFERENCE_DESIGNATORS

2301: for ref_desg in get_ref_desg_details(p_component_sequence_id, p_ref_desg)
2302: loop
2303: for dest_comp in get_destn_comps(p_component_sequence_id)
2304: loop
2305: INSERT INTO BOM_REFERENCE_DESIGNATORS
2306: ( COMPONENT_REFERENCE_DESIGNATOR
2307: , LAST_UPDATE_DATE
2308: , LAST_UPDATED_BY
2309: , CREATION_DATE

Line 2444: from bom_reference_designators

2440: Cursor get_ref_desg_details(p_comp_seq_id NUMBER,
2441: p_ref_desg VARCHAR2)
2442: IS
2443: select *
2444: from bom_reference_designators
2445: where component_sequence_id = p_comp_seq_id
2446: and component_reference_designator = p_ref_desg;
2447:
2448: Cursor get_destn_comps(p_comp_seq_id number)

Line 2460: UPDATE BOM_REFERENCE_DESIGNATORS

2456: for ref_desg in get_ref_desg_details(p_component_sequence_id, p_new_ref_desg)
2457: loop
2458: /*for dest_comp in get_destn_comps(p_component_sequence_id)
2459: loop*/
2460: UPDATE BOM_REFERENCE_DESIGNATORS
2461: SET COMPONENT_REFERENCE_DESIGNATOR = ref_desg.COMPONENT_REFERENCE_DESIGNATOR
2462: , LAST_UPDATE_DATE = SYSDATE
2463: , LAST_UPDATED_BY = ref_desg.LAST_UPDATED_BY
2464: , LAST_UPDATE_LOGIN = ref_desg.LAST_UPDATE_LOGIN

Line 3965: DELETE FROM BOM_REFERENCE_DESIGNATORS

3961: , p_ref_desg IN VARCHAR2
3962: , x_return_status IN OUT NOCOPY VARCHAR2)
3963: IS
3964: BEGIN
3965: DELETE FROM BOM_REFERENCE_DESIGNATORS
3966: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq
3967: AND COMPONENT_REFERENCE_DESIGNATOR = p_ref_desg;
3968: EXCEPTION
3969: WHEN OTHERS THEN

Line 4135: DELETE BOM_REFERENCE_DESIGNATORS

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;
4137:
4138: DELETE BOM_COMPONENT_OPERATIONS
4139: WHERE common_component_sequence_id = p_src_comp_seq_id;