1: PACKAGE BODY BOM_RTG_Val_To_Id AS
2: /* $Header: BOMRVIDB.pls 120.1.12020000.2 2012/07/05 09:33:08 ntungare ship $*/
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
2446: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2447: ) ;
2448:
2449: -- Call Rev_Op_Resource_UUI_To_UI
2450: Bom_Rtg_Val_To_Id.Rev_Op_Resource_UUI_To_UI
2451: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2452: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2453: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2454: , x_return_status => x_return_status
2936: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2937: ) ;
2938:
2939: -- Call Rev_Op_resource_UUI_To_UI
2940: Bom_Rtg_Val_To_Id.Rev_Op_Resource_VID
2941: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2942: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2943: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2944: , x_return_status => x_return_status
3191: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3192: ) ;
3193:
3194: -- Call Rev_Sub_Resource_UUI_To_UI
3195: Bom_Rtg_Val_To_Id.Rev_Sub_Resource_UUI_To_UI
3196: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3197: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3198: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3199: , x_return_status => x_return_status
3827: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3828: ) ;
3829:
3830: -- Call Rev_Sub_resource_UUI_To_UI
3831: Bom_Rtg_Val_To_Id.Rev_Sub_resource_VID
3832: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
3833: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3834: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
3835: , x_return_status => x_return_status
4754: END OP_Network_UUI_To_UI;
4755:
4756:
4757:
4758: END BOM_Rtg_Val_To_Id;