eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_RTG_PUB dependencies on BOM_RTG_PUB

Line 1: PACKAGE BODY Bom_Rtg_Pub AS

1: PACKAGE BODY Bom_Rtg_Pub AS
2: /* $Header: BOMBRTGB.pls 120.7.12020000.2 2012/08/06 22:49:26 umajumde ship $*/
3: /***************************************************************************
4: --
5: -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA

Line 14: -- Body of package Bom_Rtg_Pub

10: -- BOMBRTGB.pls
11: --
12: -- DESCRIPTION
13: --
14: -- Body of package Bom_Rtg_Pub
15: --
16: -- NOTES
17: --
18: -- HISTORY

Line 43: ( p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

39: * by field basis.
40: ******************************************************************/
41: -- From Routing To Common
42: PROCEDURE Convert_RtgOp_To_ComOp
43: ( p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
44: , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
45: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
46: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
47: )

Line 44: , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

40: ******************************************************************/
41: -- From Routing To Common
42: PROCEDURE Convert_RtgOp_To_ComOp
43: ( p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
44: , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
45: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
46: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
47: )
48: IS

Line 45: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

41: -- From Routing To Common
42: PROCEDURE Convert_RtgOp_To_ComOp
43: ( p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
44: , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
45: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
46: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
47: )
48: IS
49: BEGIN

Line 46: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

42: PROCEDURE Convert_RtgOp_To_ComOp
43: ( p_rtg_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
44: , p_rtg_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
45: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
46: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
47: )
48: IS
49: BEGIN
50: x_com_operation_rec.Eco_Name := NULL;

Line 246: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

242: * by field basis.
243: ******************************************************************/
244: -- From Common To Routing
245: PROCEDURE Convert_ComOp_To_RtgOp
246: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
247: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
248: , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
249: , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
250: )

Line 247: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

243: ******************************************************************/
244: -- From Common To Routing
245: PROCEDURE Convert_ComOp_To_RtgOp
246: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
247: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
248: , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
249: , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
250: )
251: IS

Line 248: , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

244: -- From Common To Routing
245: PROCEDURE Convert_ComOp_To_RtgOp
246: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
247: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
248: , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
249: , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
250: )
251: IS
252: BEGIN

Line 249: , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

245: PROCEDURE Convert_ComOp_To_RtgOp
246: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
247: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
248: , x_rtg_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
249: , x_rtg_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
250: )
251: IS
252: BEGIN
253:

Line 438: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

434: * by field basis.
435: ******************************************************************/
436: -- From Eco To Common
437: PROCEDURE Convert_EcoOp_To_ComOp
438: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
439: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
440: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
441: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
442: )

Line 439: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

435: ******************************************************************/
436: -- From Eco To Common
437: PROCEDURE Convert_EcoOp_To_ComOp
438: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
439: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
440: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
441: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
442: )
443: IS

Line 440: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

436: -- From Eco To Common
437: PROCEDURE Convert_EcoOp_To_ComOp
438: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
439: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
440: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
441: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
442: )
443: IS
444: BEGIN

Line 441: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

437: PROCEDURE Convert_EcoOp_To_ComOp
438: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
439: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
440: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
441: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
442: )
443: IS
444: BEGIN
445:

Line 617: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

613: * by field basis.
614: ******************************************************************/
615: -- From Common To Eco
616: PROCEDURE Convert_ComOp_To_EcoOp
617: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
618: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
619: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
620: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
621: )

Line 618: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

614: ******************************************************************/
615: -- From Common To Eco
616: PROCEDURE Convert_ComOp_To_EcoOp
617: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
618: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
619: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
620: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
621: )
622: IS

Line 619: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

615: -- From Common To Eco
616: PROCEDURE Convert_ComOp_To_EcoOp
617: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
618: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
619: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
620: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
621: )
622: IS
623: BEGIN

Line 620: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

616: PROCEDURE Convert_ComOp_To_EcoOp
617: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
618: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
619: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
620: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
621: )
622: IS
623: BEGIN
624:

Line 754: ( p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

750: * by field basis.
751: ******************************************************************/
752: -- Operation Resource Entity
753: PROCEDURE Convert_RtgRes_To_EcoRes
754: ( p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
755: , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
756: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
757: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
758: )

Line 755: , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

751: ******************************************************************/
752: -- Operation Resource Entity
753: PROCEDURE Convert_RtgRes_To_EcoRes
754: ( p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
755: , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
756: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
757: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
758: )
759: IS

Line 756: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

752: -- Operation Resource Entity
753: PROCEDURE Convert_RtgRes_To_EcoRes
754: ( p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
755: , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
756: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
757: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
758: )
759: IS
760: BEGIN

Line 757: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

753: PROCEDURE Convert_RtgRes_To_EcoRes
754: ( p_rtg_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
755: , p_rtg_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
756: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
757: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
758: )
759: IS
760: BEGIN
761: x_rev_op_resource_rec.Eco_Name := p_rtg_op_resource_rec.eco_name; --Bug 14286614

Line 882: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

878: * records is different, this has to done on a field
879: * by field basis.
880: ******************************************************************/
881: PROCEDURE Convert_EcoRes_To_RtgRes
882: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
883: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
884: , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
885: , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
886: )

Line 883: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

879: * by field basis.
880: ******************************************************************/
881: PROCEDURE Convert_EcoRes_To_RtgRes
882: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
883: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
884: , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
885: , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
886: )
887: IS

Line 884: , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

880: ******************************************************************/
881: PROCEDURE Convert_EcoRes_To_RtgRes
882: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
883: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
884: , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
885: , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
886: )
887: IS
888: BEGIN

Line 885: , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

881: PROCEDURE Convert_EcoRes_To_RtgRes
882: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
883: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
884: , x_rtg_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
885: , x_rtg_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
886: )
887: IS
888: BEGIN
889: x_rtg_op_resource_rec.Organization_Code :=

Line 1009: ( p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

1005: * by field basis.
1006: ******************************************************************/
1007: -- Sub Operation Resource Entity
1008: PROCEDURE Convert_RtgSubRes_To_EcoSubRes
1009: ( p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
1010: , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1011: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1012: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1013: )

Line 1010: , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

1006: ******************************************************************/
1007: -- Sub Operation Resource Entity
1008: PROCEDURE Convert_RtgSubRes_To_EcoSubRes
1009: ( p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
1010: , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1011: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1012: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1013: )
1014: IS

Line 1011: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

1007: -- Sub Operation Resource Entity
1008: PROCEDURE Convert_RtgSubRes_To_EcoSubRes
1009: ( p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
1010: , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1011: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1012: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1013: )
1014: IS
1015: BEGIN

Line 1012: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

1008: PROCEDURE Convert_RtgSubRes_To_EcoSubRes
1009: ( p_rtg_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
1010: , p_rtg_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1011: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1012: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1013: )
1014: IS
1015: BEGIN
1016:

Line 1149: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

1145: * records is different, this has to done on a field
1146: * by field basis.
1147: ******************************************************************/
1148: PROCEDURE Convert_EcoSubRes_To_RtgSubRes
1149: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1150: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1151: , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
1152: , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1153: )

Line 1150: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

1146: * by field basis.
1147: ******************************************************************/
1148: PROCEDURE Convert_EcoSubRes_To_RtgSubRes
1149: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1150: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1151: , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
1152: , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1153: )
1154: IS

Line 1151: , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

1147: ******************************************************************/
1148: PROCEDURE Convert_EcoSubRes_To_RtgSubRes
1149: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1150: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1151: , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
1152: , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1153: )
1154: IS
1155: BEGIN

Line 1152: , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

1148: PROCEDURE Convert_EcoSubRes_To_RtgSubRes
1149: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
1150: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
1151: , x_rtg_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
1152: , x_rtg_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
1153: )
1154: IS
1155: BEGIN
1156:

Line 1284: ( p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

1280: * This function is callled in the procedure
1281: * Check_Records_In_Same_BOM
1282: *********************************************************************/
1283: FUNCTION Does_Rev_Have_Same_Rtg
1284: ( p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1285: , p_assembly_item_name IN VARCHAR2
1286: , p_organization_code IN VARCHAR2
1287: ) RETURN BOOLEAN
1288: IS

Line 1323: ( p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type

1319: * This function is callled in the procedure
1320: * Check_Records_In_Same_BOM
1321: *********************************************************************/
1322: FUNCTION Does_Op_Have_Same_Rtg
1323: ( p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1324: , p_assembly_item_name IN VARCHAR2
1325: , p_organization_code IN VARCHAR2
1326: , p_alternate_routing_code IN VARCHAR2
1327: ) RETURN BOOLEAN

Line 1370: (p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type

1366: * This function is callled in the procedure
1367: * Check_Records_In_Same_BOM
1368: *********************************************************************/
1369: FUNCTION Does_Res_Have_Same_Rtg
1370: (p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1371: , p_assembly_item_name IN VARCHAR2
1372: , p_organization_code IN VARCHAR2
1373: , p_alternate_routing_code IN VARCHAR2
1374: ) RETURN BOOLEAN

Line 1415: ( p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type

1411: * This function is callled in the procedure
1412: * Check_Records_In_Same_BOM
1413: *********************************************************************/
1414: FUNCTION Does_SubRes_Have_Same_Rtg
1415: ( p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1416: , p_assembly_item_name IN VARCHAR2
1417: , p_organization_code IN VARCHAR2
1418: , p_alternate_routing_code IN VARCHAR2
1419: ) RETURN BOOLEAN

Line 1460: ( p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type

1456: * This function is callled in the procedure
1457: * Check_Records_In_Same_BOM
1458: *********************************************************************/
1459: FUNCTION Does_OpNw_Have_Same_Rtg
1460: ( p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1461: , p_assembly_item_name IN VARCHAR2
1462: , p_organization_code IN VARCHAR2
1463: , p_alternate_routing_code IN VARCHAR2
1464: ) RETURN BOOLEAN

Line 1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

1505: * Process_Rtg.
1506: *********************************************************************/
1507:
1508: FUNCTION Check_Records_In_Same_RTG
1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type

Line 1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

1506: *********************************************************************/
1507:
1508: FUNCTION Check_Records_In_Same_RTG
1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type

Line 1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type

1507:
1508: FUNCTION Check_Records_In_Same_RTG
1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type
1515: , x_assembly_item_name IN OUT NOCOPY VARCHAR2

Line 1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type

1508: FUNCTION Check_Records_In_Same_RTG
1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type
1515: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
1516: , x_organization_code IN OUT NOCOPY VARCHAR2

Line 1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type

1509: ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type
1515: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
1516: , x_organization_code IN OUT NOCOPY VARCHAR2
1517: , x_alternate_routing_code IN OUT NOCOPY VARCHAR2

Line 1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type

1510: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1511: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1512: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_resource_Tbl_Type
1513: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1514: , p_op_network_tbl IN Bom_Rtg_Pub.Op_network_Tbl_Type
1515: , x_assembly_item_name IN OUT NOCOPY VARCHAR2
1516: , x_organization_code IN OUT NOCOPY VARCHAR2
1517: , x_alternate_routing_code IN OUT NOCOPY VARCHAR2
1518: )

Line 1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type

1940: PROCEDURE Process_Rtg
1941: ( p_bo_identifier IN VARCHAR2 := 'RTG'
1942: , p_api_version_number IN NUMBER := 1.0
1943: , p_init_msg_list IN BOOLEAN := FALSE
1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type

Line 1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC

1941: ( p_bo_identifier IN VARCHAR2 := 'RTG'
1942: , p_api_version_number IN NUMBER := 1.0
1943: , p_init_msg_list IN BOOLEAN := FALSE
1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL

Line 1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

1942: , p_api_version_number IN NUMBER := 1.0
1943: , p_init_msg_list IN BOOLEAN := FALSE
1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type

Line 1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL

1943: , p_init_msg_list IN BOOLEAN := FALSE
1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL

Line 1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type

1944: , p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type

Line 1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL

1945: :=Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL

Line 1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type

1946: , p_rtg_revision_tbl IN Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type

Line 1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL

1947: :=Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL

Line 1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type

1948: , p_operation_tbl IN Bom_Rtg_Pub.Operation_Tbl_Type
1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

Line 1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL

1949: := Bom_Rtg_Pub.G_MISS_OPERATION_TBL
1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

Line 1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type

1950: , p_op_resource_tbl IN Bom_Rtg_Pub.Op_Resource_Tbl_Type
1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type

Line 1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL

1951: := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type

Line 1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type

1952: , p_sub_resource_tbl IN Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type

Line 1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type

1953: := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type

Line 1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type

1954: , p_op_network_tbl IN Bom_Rtg_Pub.Op_Network_Tbl_Type
1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1962: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type

1955: := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1962: , x_return_status IN OUT NOCOPY VARCHAR2
1963: , x_msg_count IN OUT NOCOPY NUMBER

Line 1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type

1956: , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1962: , x_return_status IN OUT NOCOPY VARCHAR2
1963: , x_msg_count IN OUT NOCOPY NUMBER
1964: , p_debug IN VARCHAR2 := 'N'

Line 1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type

1957: , x_rtg_revision_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Tbl_Type
1958: , x_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Operation_Tbl_Type
1959: , x_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Tbl_Type
1960: , x_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Tbl_Type
1961: , x_op_network_tbl IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Tbl_Type
1962: , x_return_status IN OUT NOCOPY VARCHAR2
1963: , x_msg_count IN OUT NOCOPY NUMBER
1964: , p_debug IN VARCHAR2 := 'N'
1965: , p_output_dir IN VARCHAR2 := NULL

Line 1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

1977: l_assembly_item_name VARCHAR2(81);
1978: l_organization_code VARCHAR2(3);
1979: l_organization_id NUMBER;
1980: l_alternate_routing_code VARCHAR2(10);
1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;

1978: l_organization_code VARCHAR2(3);
1979: l_organization_id NUMBER;
1980: l_alternate_routing_code VARCHAR2(10);
1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

1979: l_organization_id NUMBER;
1980: l_alternate_routing_code VARCHAR2(10);
1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
1987: l_Debug_flag VARCHAR2(1) := p_debug;

Line 1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;

1980: l_alternate_routing_code VARCHAR2(10);
1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
1987: l_Debug_flag VARCHAR2(1) := p_debug;
1988:

Line 1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

1981: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
1987: l_Debug_flag VARCHAR2(1) := p_debug;
1988:
1989: BEGIN

Line 1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

1982: l_routing_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type ;
1983: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
1984: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type ;
1985: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
1986: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
1987: l_Debug_flag VARCHAR2(1) := p_debug;
1988:
1989: BEGIN
1990:

Line 2002: p_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;

1998: IF p_bo_identifier IS NULL THEN
1999: p_bo_identifier := 'RTG';
2000: END IF;
2001: IF p_rtg_header_rec IS NULL THEN
2002: p_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
2003: END IF;
2004: IF p_rtg_revision_tbl IS NULL THEN
2005: p_rtg_revision_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
2006: END IF;

Line 2005: p_rtg_revision_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;

2001: IF p_rtg_header_rec IS NULL THEN
2002: p_rtg_header_rec := Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC;
2003: END IF;
2004: IF p_rtg_revision_tbl IS NULL THEN
2005: p_rtg_revision_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
2006: END IF;
2007: IF p_operation_tbl IS NULL THEN
2008: p_operation_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
2009: END IF;

Line 2008: p_operation_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;

2004: IF p_rtg_revision_tbl IS NULL THEN
2005: p_rtg_revision_tbl := Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL;
2006: END IF;
2007: IF p_operation_tbl IS NULL THEN
2008: p_operation_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
2009: END IF;
2010: IF p_op_resource_tbl IS NULL THEN
2011: p_op_resource_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
2012: END IF;

Line 2011: p_op_resource_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;

2007: IF p_operation_tbl IS NULL THEN
2008: p_operation_tbl := Bom_Rtg_Pub.G_MISS_OPERATION_TBL;
2009: END IF;
2010: IF p_op_resource_tbl IS NULL THEN
2011: p_op_resource_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
2012: END IF;
2013: IF p_sub_resource_tbl IS NULL THEN
2014: p_sub_resource_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
2015: END IF;

Line 2014: p_sub_resource_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;

2010: IF p_op_resource_tbl IS NULL THEN
2011: p_op_resource_tbl := Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL;
2012: END IF;
2013: IF p_sub_resource_tbl IS NULL THEN
2014: p_sub_resource_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
2015: END IF;
2016: IF p_op_network_tbl IS NULL THEN
2017: p_op_network_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
2018: END IF;

Line 2017: p_op_network_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;

2013: IF p_sub_resource_tbl IS NULL THEN
2014: p_sub_resource_tbl := Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL;
2015: END IF;
2016: IF p_op_network_tbl IS NULL THEN
2017: p_op_network_tbl := Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL;
2018: END IF;
2019: */
2020: BOM_Rtg_Globals.Set_Bo_Identifier
2021: (p_bo_identifier => p_bo_identifier);

Line 2313: Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC

2309:
2310: Bom_Rtg_Error_Handler.Log_Error
2311: (
2312: p_rtg_header_rec =>
2313: Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2314: , p_rtg_revision_tbl =>
2315: Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2316: , p_operation_tbl =>
2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL

Line 2315: Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL

2311: (
2312: p_rtg_header_rec =>
2313: Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2314: , p_rtg_revision_tbl =>
2315: Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2316: , p_operation_tbl =>
2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2318: , p_op_resource_tbl =>
2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL

Line 2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL

2313: Bom_Rtg_Pub.G_MISS_RTG_HEADER_REC
2314: , p_rtg_revision_tbl =>
2315: Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2316: , p_operation_tbl =>
2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2318: , p_op_resource_tbl =>
2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2320: , p_sub_resource_tbl =>
2321: Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL

Line 2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL

2315: Bom_Rtg_Pub.G_MISS_RTG_REVISION_TBL
2316: , p_operation_tbl =>
2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2318: , p_op_resource_tbl =>
2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2320: , p_sub_resource_tbl =>
2321: Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
2322: , p_op_network_tbl =>
2323: Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL

Line 2321: Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL

2317: Bom_Rtg_Pub.G_MISS_OPERATION_TBL
2318: , p_op_resource_tbl =>
2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2320: , p_sub_resource_tbl =>
2321: Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
2322: , p_op_network_tbl =>
2323: Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2324: , p_Mesg_Token_tbl => Error_Handler.G_MISS_MESG_TOKEN_TBL
2325: , p_error_status => l_return_status

Line 2323: Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL

2319: Bom_Rtg_Pub.G_MISS_OP_RESOURCE_TBL
2320: , p_sub_resource_tbl =>
2321: Bom_Rtg_Pub.G_MISS_SUB_RESOURCE_TBL
2322: , p_op_network_tbl =>
2323: Bom_Rtg_Pub.G_MISS_OP_NETWORK_TBL
2324: , p_Mesg_Token_tbl => Error_Handler.G_MISS_MESG_TOKEN_TBL
2325: , p_error_status => l_return_status
2326: , p_error_scope => Error_Handler.G_SCOPE_ALL
2327: , p_error_level => Error_Handler.G_BO_LEVEL

Line 2420: END Bom_Rtg_Pub ;

2416: END IF;
2417:
2418: END Process_Rtg;
2419:
2420: END Bom_Rtg_Pub ;