1: PACKAGE BODY BOM_RTG_Val_To_Id AS
2: /* $Header: BOMRVIDB.pls 120.1 2005/11/16 22:58:12 bbpatel noship $*/
3: /****************************************************************************
4: --
5: -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
10: -- BOMRVIDB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package BOM_RTG_Val_To_Id
15: --
16: -- NOTES
17: --
18: -- HISTORY
129: , p_organization_id IN NUMBER
130: , x_err_text IN OUT NOCOPY VARCHAR2) RETURN NUMBER
131: IS
132: BEGIN
133: RETURN Bom_Rtg_Val_To_Id.Revised_Item
134: ( p_revised_item_num => p_assembly_item_name
135: , p_organization_id => p_organization_id
136: , x_err_text => x_err_text
137: );
158: l_id NUMBER;
159: ret_code NUMBER;
160: BEGIN
161:
162: RETURN Bom_Rtg_Val_To_Id.Revised_Item
163: ( p_revised_item_num => p_common_assembly_item_name
164: , p_organization_id => p_organization_id
165: , x_err_text => x_err_text
166: );
240: ) RETURN NUMBER
241: IS
242: l_common_rtg_seq_id NUMBER;
243: BEGIN
244: l_common_rtg_seq_id := Bom_Rtg_Val_To_Id.Routing_Sequence_id
245: ( p_assembly_item_id => p_common_assembly_item_id
246: , p_organization_id => p_organization_id
247: , p_alternate_routing_designator => p_alternate_routing_designator
248: , x_err_text => x_err_text
1473: ) ;
1474:
1475:
1476: -- Call Com_Operation_UUI_To_UI
1477: Bom_Rtg_Val_To_Id.Com_Operation_UUI_To_UI
1478: ( p_com_operation_rec => l_com_operation_rec
1479: , p_com_op_unexp_rec => l_com_op_unexp_rec
1480: , x_com_op_unexp_rec => l_com_op_unexp_rec
1481: , x_return_status => x_return_status
1528: ) ;
1529:
1530:
1531: -- Call Com_Operation_UUI_To_UI
1532: Bom_Rtg_Val_To_Id.Com_Operation_UUI_To_UI
1533: ( p_com_operation_rec => l_com_operation_rec
1534: , p_com_op_unexp_rec => l_com_op_unexp_rec
1535: , x_com_op_unexp_rec => l_com_op_unexp_rec
1536: , x_return_status => x_return_status
1910: ) ;
1911:
1912:
1913: -- Call Com_Operation_VID
1914: Bom_Rtg_Val_To_Id.Com_Operation_VID
1915: ( p_com_operation_rec => l_com_operation_rec
1916: , p_com_op_unexp_rec => l_com_op_unexp_rec
1917: , x_com_op_unexp_rec => l_com_op_unexp_rec
1918: , x_return_status => x_return_status
1966: ) ;
1967:
1968:
1969: -- Call Com_Operation_VID
1970: Bom_Rtg_Val_To_Id.Com_Operation_VID
1971: ( p_com_operation_rec => l_com_operation_rec
1972: , p_com_op_unexp_rec => l_com_op_unexp_rec
1973: , x_com_op_unexp_rec => l_com_op_unexp_rec
1974: , x_return_status => x_return_status
2443: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2444: ) ;
2445:
2446: -- Call Rev_Op_Resource_UUI_To_UI
2447: Bom_Rtg_Val_To_Id.Rev_Op_Resource_UUI_To_UI
2448: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2449: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2450: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2451: , x_return_status => x_return_status
2933: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2934: ) ;
2935:
2936: -- Call Rev_Op_resource_UUI_To_UI
2937: Bom_Rtg_Val_To_Id.Rev_Op_Resource_VID
2938: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2939: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2940: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2941: , x_return_status => x_return_status
3188: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3189: ) ;
3190:
3191: -- Call Rev_Sub_Resource_UUI_To_UI
3192: Bom_Rtg_Val_To_Id.Rev_Sub_Resource_UUI_To_UI
3193: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3194: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3195: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3196: , x_return_status => x_return_status
3824: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3825: ) ;
3826:
3827: -- Call Rev_Sub_resource_UUI_To_UI
3828: Bom_Rtg_Val_To_Id.Rev_Sub_resource_VID
3829: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3830: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3831: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3832: , x_return_status => x_return_status
4751: END OP_Network_UUI_To_UI;
4752:
4753:
4754:
4755: END BOM_Rtg_Val_To_Id;