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.ENG_ECO_PVT dependencies on BOM_RTG_PUB

Line 16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1

12: G_MISS_REV_COMP_REC BOM_BO_PUB.Rev_Component_Rec_Type;
13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1
18: G_MISS_REV_SUB_RES_REC Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;--L1
19:
20: -- Bug 2918350 // kamohan

Line 17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1

13: G_MISS_REF_DESG_REC BOM_BO_PUB.Ref_Designator_Rec_Type;
14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1
18: G_MISS_REV_SUB_RES_REC Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;--L1
19:
20: -- Bug 2918350 // kamohan
21: -- Start Changes

Line 18: G_MISS_REV_SUB_RES_REC Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;--L1

14: G_MISS_SUB_COMP_REC BOM_BO_PUB.Sub_Component_Rec_Type;
15:
16: G_MISS_REV_OP_REC Bom_Rtg_Pub.Rev_Operation_Tbl_Type; --L1
17: G_MISS_REV_OP_RES_REC Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; --L1
18: G_MISS_REV_SUB_RES_REC Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;--L1
19:
20: -- Bug 2918350 // kamohan
21: -- Start Changes
22:

Line 67: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

63: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
64: , p_operation_seq_num IN NUMBER := NULL
65: , p_operation_type IN NUMBER := NULL
66: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
67: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
68: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
69: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70: , x_return_status OUT NOCOPY VARCHAR2
71: )

Line 68: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

64: , p_operation_seq_num IN NUMBER := NULL
65: , p_operation_type IN NUMBER := NULL
66: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
67: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
68: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
69: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70: , x_return_status OUT NOCOPY VARCHAR2
71: )
72:

Line 86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

82: --l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

Line 87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

83: --l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;

Line 88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;

84: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

Line 89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;

85: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
93:

Line 90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

86: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
93:
94: /* Error Handling Variables */

Line 91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;

87: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
93:
94: /* Error Handling Variables */
95: l_token_tbl Error_Handler.Token_Tbl_Type ;

Line 92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

88: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl;
89: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
90: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
91: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;
92: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;
93:
94: /* Error Handling Variables */
95: l_token_tbl Error_Handler.Token_Tbl_Type ;
96: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 910: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

906:
907: Bom_Default_Sub_Op_Res.Attribute_Defaulting
908: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
909: , p_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
910: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
911: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
912: , x_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
913: , x_mesg_token_tbl => l_mesg_token_tbl
914: , x_return_status => l_return_status

Line 982: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

978: THEN
979: Bom_Default_Sub_OP_Res.Entity_Defaulting
980: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
981: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
982: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
983: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
984: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
985: , x_mesg_token_tbl => l_mesg_token_tbl
986: , x_return_status => l_return_status

Line 1054: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1050: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
1051: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
1052: , p_old_rev_sub_resource_rec => l_old_rev_sub_resource_rec
1053: , p_old_rev_sub_res_unexp_rec => l_old_rev_sub_res_unexp_rec
1054: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1055: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
1056: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
1057: , x_mesg_token_tbl => l_mesg_token_tbl
1058: , x_return_status => l_return_status

Line 1116: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1112: --
1113: Bom_Sub_Op_Res_Util.Perform_Writes
1114: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
1115: , p_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
1116: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1117: , x_mesg_token_tbl => l_mesg_token_tbl
1118: , x_return_status => l_return_status
1119: ) ;
1120:

Line 1438: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

1434: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
1435: , p_operation_seq_num IN NUMBER := NULL
1436: , p_operation_type IN NUMBER := NULL
1437: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
1438: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1439: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1440: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1441: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1442: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1439: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

1435: , p_operation_seq_num IN NUMBER := NULL
1436: , p_operation_type IN NUMBER := NULL
1437: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
1438: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1439: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1440: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1441: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1442: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1443: , x_return_status OUT NOCOPY VARCHAR2

Line 1440: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

1436: , p_operation_type IN NUMBER := NULL
1437: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
1438: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1439: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1440: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1441: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1442: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1443: , x_return_status OUT NOCOPY VARCHAR2
1444: )

Line 1441: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

1437: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
1438: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1439: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1440: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1441: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1442: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1443: , x_return_status OUT NOCOPY VARCHAR2
1444: )
1445: IS

Line 1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

1444: )
1445: IS
1446:
1447: /* Exposed and Unexposed record */
1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

Line 1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

1445: IS
1446:
1447: /* Exposed and Unexposed record */
1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1453:

Line 1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;

1446:
1447: /* Exposed and Unexposed record */
1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1453:
1454:

Line 1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

1447: /* Exposed and Unexposed record */
1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1453:
1454:
1455:

Line 1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

1448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1450: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1451: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1452: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1453:
1454:
1455:
1456: /* Other Entities */

Line 1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;

1463: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1469: -- := p_rev_sub_resource_tbl ;
1470:
1471:

Line 1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;

1464: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1465: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1466: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1467: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1468: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1469: -- := p_rev_sub_resource_tbl ;
1470:
1471:
1472: /* Error Handling Variables */

Line 2294: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2290:
2291: Bom_Default_Op_res.Attribute_Defaulting
2292: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2293: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2294: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2295: , x_rev_op_resource_rec => l_rev_op_resource_rec
2296: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2297: , x_mesg_token_tbl => l_mesg_token_tbl
2298: , x_return_status => l_return_status

Line 2361: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2357: THEN
2358: Bom_Default_Op_res.Entity_Defaulting
2359: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2360: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2361: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2362: , x_rev_op_resource_rec => l_rev_op_resource_rec
2363: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2364: , x_mesg_token_tbl => l_mesg_token_tbl
2365: , x_return_status => l_return_status

Line 2426: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2422: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2423: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2424: , p_old_rev_op_resource_rec => l_old_rev_op_resource_rec
2425: , p_old_rev_op_res_unexp_rec => l_old_rev_op_res_unexp_rec
2426: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2427: , x_rev_op_resource_rec => l_rev_op_resource_rec
2428: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2429: , x_mesg_token_tbl => l_mesg_token_tbl
2430: , x_return_status => l_return_status

Line 2484: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2480: --
2481: Bom_Op_Res_Util.Perform_Writes
2482: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2483: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2484: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2485: , x_mesg_token_tbl => l_mesg_token_tbl
2486: , x_return_status => l_return_status
2487: ) ;
2488:

Line 2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type

2796: , p_item_revision IN VARCHAR2 := NULL
2797: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2798: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2799: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

Line 2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

2797: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2798: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2799: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

Line 2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

2798: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2799: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2806: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type

2799: , p_alternate_routing_code IN VARCHAR2 := NULL -- Added for bug 13440461
2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2806: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2807: , x_return_status OUT NOCOPY VARCHAR2

Line 2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

2800: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2806: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2807: , x_return_status OUT NOCOPY VARCHAR2
2808: )

Line 2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

2801: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2802: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2803: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2804: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2805: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2806: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2807: , x_return_status OUT NOCOPY VARCHAR2
2808: )
2809:

Line 2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

2809:
2810: IS
2811:
2812: /* Exposed and Unexposed record */
2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

Line 2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;

2810: IS
2811:
2812: /* Exposed and Unexposed record */
2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:

Line 2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

2811:
2812: /* Exposed and Unexposed record */
2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:
2819: /* Other Entities */

Line 2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

2812: /* Exposed and Unexposed record */
2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:
2819: /* Other Entities */
2820: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;

Line 2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

2813: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2814: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2815: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2816: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2817: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2818:
2819: /* Other Entities */
2820: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2821: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;

Line 2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;

2826: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2832:
2833: /* Others */
2834: l_return_status VARCHAR2(1) ;

Line 2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;

2827: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2828: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2829: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2830: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2831: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2832:
2833: /* Others */
2834: l_return_status VARCHAR2(1) ;
2835: l_bo_return_status VARCHAR2(1) ;

Line 3704: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3700:
3701: Bom_Default_Op_Seq.Attribute_Defaulting
3702: ( p_rev_operation_rec => l_rev_operation_rec
3703: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3704: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3705: , x_rev_operation_rec => l_rev_operation_rec
3706: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3707: , x_mesg_token_tbl => l_mesg_token_tbl
3708: , x_return_status => l_return_status

Line 3827: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3823: THEN
3824: Bom_Default_Op_Seq.Entity_Defaulting
3825: ( p_rev_operation_rec => l_rev_operation_rec
3826: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3827: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3828: , x_rev_operation_rec => l_rev_operation_rec
3829: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3830: , x_mesg_token_tbl => l_mesg_token_tbl
3831: , x_return_status => l_return_status

Line 3895: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3891: ( p_rev_operation_rec => l_rev_operation_rec
3892: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3893: , p_old_rev_operation_rec => l_old_rev_operation_rec
3894: , p_old_rev_op_unexp_rec => l_old_rev_op_unexp_rec
3895: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3896: , x_rev_operation_rec => l_rev_operation_rec
3897: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3898: , x_mesg_token_tbl => l_mesg_token_tbl
3899: , x_return_status => l_return_status

Line 4029: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

4025:
4026: Bom_Op_Seq_Util.Perform_Writes
4027: ( p_rev_operation_rec => l_rev_operation_rec
4028: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
4029: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
4030: , x_mesg_token_tbl => l_mesg_token_tbl
4031: , x_return_status => l_return_status
4032: ) ;
4033:

Line 4500: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

4496: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4497: l_return_value NUMBER;
4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4499:
4500: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4501: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4502: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4503:
4504:

Line 4501: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

4497: l_return_value NUMBER;
4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4499:
4500: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4501: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4502: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4503:
4504:
4505: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 4502: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

4498: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4499:
4500: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4501: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4502: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4503:
4504:
4505: EXC_SEV_QUIT_RECORD EXCEPTION;
4506: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 5409: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

5405: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5406: l_return_value NUMBER;
5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5408:
5409: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5410: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5411: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5412:
5413: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 5410: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

5406: l_return_value NUMBER;
5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5408:
5409: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5410: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5411: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5412:
5413: EXC_SEV_QUIT_RECORD EXCEPTION;
5414: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 5411: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

5407: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5408:
5409: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5410: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5411: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5412:
5413: EXC_SEV_QUIT_RECORD EXCEPTION;
5414: EXC_SEV_QUIT_BRANCH EXCEPTION;
5415: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 6237: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

6233: l_Token_Tbl Error_Handler.Token_Tbl_Type;
6234: l_structure_type_id NUMBER ;
6235: l_strc_cp_not_allowed NUMBER ;
6236:
6237: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6238: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6239: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6240:
6241: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 6238: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

6234: l_structure_type_id NUMBER ;
6235: l_strc_cp_not_allowed NUMBER ;
6236:
6237: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6238: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6239: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6240:
6241: EXC_SEV_QUIT_RECORD EXCEPTION;
6242: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 6239: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

6235: l_strc_cp_not_allowed NUMBER ;
6236:
6237: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6238: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6239: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6240:
6241: EXC_SEV_QUIT_RECORD EXCEPTION;
6242: EXC_SEV_QUIT_SIBLINGS EXCEPTION;
6243: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 7577: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

7573: l_Token_Tbl Error_Handler.Token_Tbl_Type;
7574: l_structure_type_id NUMBER ;
7575: l_strc_cp_not_allowed NUMBER ;
7576:
7577: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7578: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7579: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7580:
7581: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 7578: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

7574: l_structure_type_id NUMBER ;
7575: l_strc_cp_not_allowed NUMBER ;
7576:
7577: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7578: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7579: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7580:
7581: EXC_SEV_QUIT_RECORD EXCEPTION;
7582: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 7579: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

7575: l_strc_cp_not_allowed NUMBER ;
7576:
7577: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7578: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7579: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7580:
7581: EXC_SEV_QUIT_RECORD EXCEPTION;
7582: EXC_SEV_QUIT_SIBLINGS EXCEPTION;
7583: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

8888: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8889: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

8889: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

8890: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8891: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8892: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8893: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8894: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

8895: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8902: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8903: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

8896: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8902: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8903: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8904: , x_return_status OUT NOCOPY VARCHAR2

Line 8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

8897: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8898: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8899: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8900: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8901: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8902: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8903: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8904: , x_return_status OUT NOCOPY VARCHAR2
8905: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1

8925: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8926: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8932: l_return_value NUMBER;
8933: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1

8926: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8932: l_return_value NUMBER;
8933: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8934:

Line 8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1

8927: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8928: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8929: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8930: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8931: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8932: l_return_value NUMBER;
8933: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8934:
8935: l_process_children BOOLEAN := TRUE;

Line 10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

10315: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10316: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

10316: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

10317: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10318: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10319: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10320: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10321: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

Line 10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

10322: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10329: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10330: , x_return_status OUT NOCOPY VARCHAR2

Line 10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

10323: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10329: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10330: , x_return_status OUT NOCOPY VARCHAR2
10331: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

10324: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10325: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10326: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10327: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10328: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10329: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10330: , x_return_status OUT NOCOPY VARCHAR2
10331: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
10332: )

Line 10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1

10351: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10352: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10358: l_return_value NUMBER;
10359: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1

10352: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10358: l_return_value NUMBER;
10359: l_Token_Tbl Error_Handler.Token_Tbl_Type;
10360:

Line 10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1

10353: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10354: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10355: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10356: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10357: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10358: l_return_value NUMBER;
10359: l_Token_Tbl Error_Handler.Token_Tbl_Type;
10360:
10361: l_rev_comp_flag VARCHAR2(1);

Line 11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

11891: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11892: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

11892: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

11893: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11894: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11895: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11896: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11897: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11898: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

Line 11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--

11899: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11906: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11907: , x_return_status OUT NOCOPY VARCHAR2

Line 11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--

11900: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11906: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11907: , x_return_status OUT NOCOPY VARCHAR2
11908: )

Line 11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--

11901: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11902: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11903: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11904: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11905: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11906: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11907: , x_return_status OUT NOCOPY VARCHAR2
11908: )
11909: IS

Line 13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

13094: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13095: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

Line 13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

13095: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

13096: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13097: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13098: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13099: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13100: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

Line 13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

13103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13111: , x_return_status OUT NOCOPY VARCHAR2

Line 13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

13104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13111: , x_return_status OUT NOCOPY VARCHAR2
13112: )

Line 13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

13105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13111: , x_return_status OUT NOCOPY VARCHAR2
13112: )
13113: IS

Line 13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1

13130: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13131: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13137: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13138:

Line 13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1

13131: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13137: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13138:
13139:

Line 13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1

13132: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13133: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13134: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13135: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13136: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13137: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13138:
13139:
13140: l_return_value NUMBER;

Line 14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1

14167: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14168: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14174: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14175: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1

14168: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14174: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14175: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14176: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

Line 14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1

14169: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14170: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14171: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14172: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14173: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14174: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14175: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14176: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14177: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--

14177: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14178: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14185: , x_return_status OUT NOCOPY VARCHAR2

Line 14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--

14178: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14185: , x_return_status OUT NOCOPY VARCHAR2
14186: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--

14179: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14180: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14181: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14182: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14183: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14185: , x_return_status OUT NOCOPY VARCHAR2
14186: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
14187: )

Line 14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type

14203: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14204: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14205: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14206:
14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14208: := p_rev_operation_tbl; --L1
14209: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14210: :=p_rev_op_resource_tbl; --L1
14211: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

Line 14209: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

14205: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14206:
14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14208: := p_rev_operation_tbl; --L1
14209: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14210: :=p_rev_op_resource_tbl; --L1
14211: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14212: :=p_rev_sub_resource_tbl;--L1
14213:

Line 14211: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

14207: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14208: := p_rev_operation_tbl; --L1
14209: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14210: :=p_rev_op_resource_tbl; --L1
14211: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14212: :=p_rev_sub_resource_tbl;--L1
14213:
14214: l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14215: l_status_check_required BOOLEAN := TRUE; -- Added for enhancement 541

Line 15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1

15663: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

Line 15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL

15664: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

Line 15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1

15665: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15673: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

15666: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15673: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15674: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

Line 15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

15667: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15673: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15674: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15675: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

Line 15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

15668: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15669: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15670: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15671: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15672: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15673: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15674: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15675: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15676: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

Line 15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--

15676: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15677: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15683: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15684: )

Line 15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--

15677: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15683: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15684: )
15685: IS

Line 15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--

15678: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15679: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15680: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15681: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15682: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15683: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15684: )
15685: IS
15686: l_api_version_number CONSTANT NUMBER := 1.0;

Line 15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--

15706: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--

Line 15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--

15707: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--

Line 15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--

15708: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change

Line 15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--

15709: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15717: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change

Line 15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--

15710: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15717: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15718:

Line 15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--

15711: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15712: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15713: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15714: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15715: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15716: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15717: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15718:
15719: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;