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 66: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

62: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
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_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
67: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
68: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_return_status OUT NOCOPY VARCHAR2
70: )

Line 67: , x_rev_sub_resource_tbl IN OUT NOCOPY 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_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
67: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
68: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
69: , x_return_status OUT NOCOPY VARCHAR2
70: )
71:

Line 85: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

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

Line 86: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

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

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

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

Line 88: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;

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

Line 89: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

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

Line 90: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_rec_Type;

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

Line 91: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type;

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

Line 904: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

900:
901: Bom_Default_Sub_Op_Res.Attribute_Defaulting
902: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
903: , p_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
904: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
905: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
906: , x_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
907: , x_mesg_token_tbl => l_mesg_token_tbl
908: , x_return_status => l_return_status

Line 976: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

972: THEN
973: Bom_Default_Sub_OP_Res.Entity_Defaulting
974: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
975: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
976: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
977: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
978: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
979: , x_mesg_token_tbl => l_mesg_token_tbl
980: , x_return_status => l_return_status

Line 1048: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1044: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
1045: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
1046: , p_old_rev_sub_resource_rec => l_old_rev_sub_resource_rec
1047: , p_old_rev_sub_res_unexp_rec => l_old_rev_sub_res_unexp_rec
1048: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1049: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
1050: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
1051: , x_mesg_token_tbl => l_mesg_token_tbl
1052: , x_return_status => l_return_status

Line 1110: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

1106: --
1107: Bom_Sub_Op_Res_Util.Perform_Writes
1108: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
1109: , p_rev_sub_res_unexp_rec=> l_rev_sub_res_unexp_rec
1110: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
1111: , x_mesg_token_tbl => l_mesg_token_tbl
1112: , x_return_status => l_return_status
1113: ) ;
1114:

Line 1431: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

1427: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
1428: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
1429: , p_operation_seq_num IN NUMBER := NULL
1430: , p_operation_type IN NUMBER := NULL
1431: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1432: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1433: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1434: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1435: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1432: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

1428: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
1429: , p_operation_seq_num IN NUMBER := NULL
1430: , p_operation_type IN NUMBER := NULL
1431: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1432: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1433: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1434: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1435: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1436: , x_return_status OUT NOCOPY VARCHAR2

Line 1433: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

1429: , p_operation_seq_num IN NUMBER := NULL
1430: , p_operation_type IN NUMBER := NULL
1431: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1432: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1433: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1434: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1435: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1436: , x_return_status OUT NOCOPY VARCHAR2
1437: )

Line 1434: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

1430: , p_operation_type IN NUMBER := NULL
1431: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1432: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1433: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1434: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1435: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1436: , x_return_status OUT NOCOPY VARCHAR2
1437: )
1438: IS

Line 1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

1437: )
1438: IS
1439:
1440: /* Exposed and Unexposed record */
1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

Line 1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

1438: IS
1439:
1440: /* Exposed and Unexposed record */
1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1446:

Line 1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;

1439:
1440: /* Exposed and Unexposed record */
1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1446:
1447:

Line 1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

1440: /* Exposed and Unexposed record */
1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1446:
1447:
1448:

Line 1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

1441: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1442: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1443: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type ;
1444: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1445: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1446:
1447:
1448:
1449: /* Other Entities */

Line 1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;

1456: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1462: -- := p_rev_sub_resource_tbl ;
1463:
1464:

Line 1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;

1457: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
1458: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1459: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1460: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
1461: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type ;
1462: -- := p_rev_sub_resource_tbl ;
1463:
1464:
1465: /* Error Handling Variables */

Line 2282: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2278:
2279: Bom_Default_Op_res.Attribute_Defaulting
2280: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2281: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2282: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2283: , x_rev_op_resource_rec => l_rev_op_resource_rec
2284: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2285: , x_mesg_token_tbl => l_mesg_token_tbl
2286: , x_return_status => l_return_status

Line 2349: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2345: THEN
2346: Bom_Default_Op_res.Entity_Defaulting
2347: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2348: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2349: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2350: , x_rev_op_resource_rec => l_rev_op_resource_rec
2351: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2352: , x_mesg_token_tbl => l_mesg_token_tbl
2353: , x_return_status => l_return_status

Line 2414: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2410: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2411: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2412: , p_old_rev_op_resource_rec => l_old_rev_op_resource_rec
2413: , p_old_rev_op_res_unexp_rec => l_old_rev_op_res_unexp_rec
2414: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2415: , x_rev_op_resource_rec => l_rev_op_resource_rec
2416: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2417: , x_mesg_token_tbl => l_mesg_token_tbl
2418: , x_return_status => l_return_status

Line 2472: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

2468: --
2469: Bom_Op_Res_Util.Perform_Writes
2470: ( p_rev_op_resource_rec => l_rev_op_resource_rec
2471: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
2472: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
2473: , x_mesg_token_tbl => l_mesg_token_tbl
2474: , x_return_status => l_return_status
2475: ) ;
2476:

Line 2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type

2783: , p_effectivity_date IN DATE := NULL
2784: , p_item_revision IN VARCHAR2 := NULL
2785: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2786: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

Line 2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

2784: , p_item_revision IN VARCHAR2 := NULL
2785: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2786: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

Line 2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

2785: , p_routing_revision IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2786: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2793: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type

2786: , p_from_end_item_number IN VARCHAR2 := NULL -- Added by MK on 11/02/00
2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2793: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2794: , x_return_status OUT NOCOPY VARCHAR2

Line 2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

2787: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2793: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2794: , x_return_status OUT NOCOPY VARCHAR2
2795: )

Line 2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

2788: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2789: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2790: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
2791: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
2792: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
2793: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2794: , x_return_status OUT NOCOPY VARCHAR2
2795: )
2796:

Line 2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

2796:
2797: IS
2798:
2799: /* Exposed and Unexposed record */
2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

Line 2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;

2797: IS
2798:
2799: /* Exposed and Unexposed record */
2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:

Line 2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

2798:
2799: /* Exposed and Unexposed record */
2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:
2806: /* Other Entities */

Line 2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;

2799: /* Exposed and Unexposed record */
2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:
2806: /* Other Entities */
2807: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;

Line 2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

2800: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2801: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type ;
2802: l_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2803: l_old_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type ;
2804: l_old_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
2805:
2806: /* Other Entities */
2807: l_eco_rec ENG_Eco_PUB.Eco_Rec_Type;
2808: l_eco_revision_tbl ENG_Eco_PUB.ECO_Revision_Tbl_Type;

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

2813: l_old_rev_component_rec BOM_BO_PUB.Rev_Component_Rec_Type;
2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2818: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2819:
2820: /* Others */
2821: l_return_status VARCHAR2(1) ;

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

2814: l_old_rev_comp_unexp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
2815: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
2816: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
2817: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := p_rev_op_resource_tbl ;
2818: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type := p_rev_sub_resource_tbl ;
2819:
2820: /* Others */
2821: l_return_status VARCHAR2(1) ;
2822: l_bo_return_status VARCHAR2(1) ;

Line 3687: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3683:
3684: Bom_Default_Op_Seq.Attribute_Defaulting
3685: ( p_rev_operation_rec => l_rev_operation_rec
3686: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3687: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3688: , x_rev_operation_rec => l_rev_operation_rec
3689: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3690: , x_mesg_token_tbl => l_mesg_token_tbl
3691: , x_return_status => l_return_status

Line 3810: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3806: THEN
3807: Bom_Default_Op_Seq.Entity_Defaulting
3808: ( p_rev_operation_rec => l_rev_operation_rec
3809: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3810: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3811: , x_rev_operation_rec => l_rev_operation_rec
3812: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3813: , x_mesg_token_tbl => l_mesg_token_tbl
3814: , x_return_status => l_return_status

Line 3878: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3874: ( p_rev_operation_rec => l_rev_operation_rec
3875: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3876: , p_old_rev_operation_rec => l_old_rev_operation_rec
3877: , p_old_rev_op_unexp_rec => l_old_rev_op_unexp_rec
3878: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3879: , x_rev_operation_rec => l_rev_operation_rec
3880: , x_rev_op_unexp_rec => l_rev_op_unexp_rec
3881: , x_mesg_token_tbl => l_mesg_token_tbl
3882: , x_return_status => l_return_status

Line 3998: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec

3994:
3995: Bom_Op_Seq_Util.Perform_Writes
3996: ( p_rev_operation_rec => l_rev_operation_rec
3997: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3998: , p_control_rec => Bom_Rtg_Pub.G_Default_Control_Rec
3999: , x_mesg_token_tbl => l_mesg_token_tbl
4000: , x_return_status => l_return_status
4001: ) ;
4002:

Line 4457: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

4453: l_old_sub_comp_unexp_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
4454: l_return_value NUMBER;
4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4456:
4457: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4458: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4459: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4460:
4461:

Line 4458: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

4454: l_return_value NUMBER;
4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4456:
4457: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4458: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4459: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4460:
4461:
4462: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 4459: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

4455: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4456:
4457: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
4458: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
4459: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
4460:
4461:
4462: EXC_SEV_QUIT_RECORD EXCEPTION;
4463: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 5366: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

5362: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
5363: l_return_value NUMBER;
5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5365:
5366: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5367: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5368: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5369:
5370: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 5367: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

5363: l_return_value NUMBER;
5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5365:
5366: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5367: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5368: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5369:
5370: EXC_SEV_QUIT_RECORD EXCEPTION;
5371: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 5368: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

5364: l_Token_Tbl Error_Handler.Token_Tbl_Type;
5365:
5366: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
5367: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
5368: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
5369:
5370: EXC_SEV_QUIT_RECORD EXCEPTION;
5371: EXC_SEV_QUIT_BRANCH EXCEPTION;
5372: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 6194: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

6190: l_Token_Tbl Error_Handler.Token_Tbl_Type;
6191: l_structure_type_id NUMBER ;
6192: l_strc_cp_not_allowed NUMBER ;
6193:
6194: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6195: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6196: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6197:
6198: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 6195: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

6191: l_structure_type_id NUMBER ;
6192: l_strc_cp_not_allowed NUMBER ;
6193:
6194: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6195: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6196: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6197:
6198: EXC_SEV_QUIT_RECORD EXCEPTION;
6199: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 6196: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

6192: l_strc_cp_not_allowed NUMBER ;
6193:
6194: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
6195: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
6196: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
6197:
6198: EXC_SEV_QUIT_RECORD EXCEPTION;
6199: EXC_SEV_QUIT_SIBLINGS EXCEPTION;
6200: EXC_SEV_QUIT_BRANCH EXCEPTION;

Line 7533: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;

7529: l_Token_Tbl Error_Handler.Token_Tbl_Type;
7530: l_structure_type_id NUMBER ;
7531: l_strc_cp_not_allowed NUMBER ;
7532:
7533: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7534: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7535: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7536:
7537: EXC_SEV_QUIT_RECORD EXCEPTION;

Line 7534: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;

7530: l_structure_type_id NUMBER ;
7531: l_strc_cp_not_allowed NUMBER ;
7532:
7533: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7534: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7535: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7536:
7537: EXC_SEV_QUIT_RECORD EXCEPTION;
7538: EXC_SEV_QUIT_SIBLINGS EXCEPTION;

Line 7535: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;

7531: l_strc_cp_not_allowed NUMBER ;
7532:
7533: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type;
7534: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type;
7535: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type;
7536:
7537: EXC_SEV_QUIT_RECORD EXCEPTION;
7538: EXC_SEV_QUIT_SIBLINGS EXCEPTION;
7539: EXC_SEV_QUIT_BRANCH EXCEPTION;

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

8843: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
8844: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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

8844: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

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

8845: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
8846: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
8847: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8848: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8849: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

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

8850: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8856: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8857: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8858: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

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

8851: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8856: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8857: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8858: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8859: , x_return_status OUT NOCOPY VARCHAR2

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

8852: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
8853: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
8854: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
8855: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
8856: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
8857: , x_revised_item_unexp_rec OUT NOCOPY ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
8858: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
8859: , x_return_status OUT NOCOPY VARCHAR2
8860: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

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

8880: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
8881: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8886: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8887: l_return_value NUMBER;
8888: l_Token_Tbl Error_Handler.Token_Tbl_Type;

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

8881: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8886: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8887: l_return_value NUMBER;
8888: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8889:

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

8882: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
8883: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
8884: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
8885: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
8886: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
8887: l_return_value NUMBER;
8888: l_Token_Tbl Error_Handler.Token_Tbl_Type;
8889:
8890: l_process_children BOOLEAN := TRUE;

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

10267: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
10268: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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

10268: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

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

10269: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
10270: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
10271: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10272: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10273: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type

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

10274: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10280: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10281: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10282: , x_return_status OUT NOCOPY VARCHAR2

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

10275: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10280: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10281: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10282: , x_return_status OUT NOCOPY VARCHAR2
10283: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

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

10276: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
10277: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
10278: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
10279: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
10280: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
10281: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
10282: , x_return_status OUT NOCOPY VARCHAR2
10283: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
10284: )

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

10303: l_old_rev_item_unexp_rec ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type;
10304: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10309: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10310: l_return_value NUMBER;
10311: l_Token_Tbl Error_Handler.Token_Tbl_Type;

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

10304: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10309: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10310: l_return_value NUMBER;
10311: l_Token_Tbl Error_Handler.Token_Tbl_Type;
10312:

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

10305: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
10306: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
10307: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
10308: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
10309: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
10310: l_return_value NUMBER;
10311: l_Token_Tbl Error_Handler.Token_Tbl_Type;
10312:
10313: l_process_children BOOLEAN := TRUE;

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

11817: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
11818: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

11818: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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

11819: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
11820: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
11821: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
11822: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
11823: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
11824: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type

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

11825: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11831: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11832: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11833: , x_return_status OUT NOCOPY VARCHAR2

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

11826: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11831: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11832: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11833: , x_return_status OUT NOCOPY VARCHAR2
11834: )

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

11827: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
11828: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
11829: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
11830: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
11831: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
11832: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
11833: , x_return_status OUT NOCOPY VARCHAR2
11834: )
11835: IS

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

13020: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
13021: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

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

13021: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

13022: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
13023: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
13024: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13025: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13026: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13027: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
13028: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type

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

13029: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13035: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13037: , x_return_status OUT NOCOPY VARCHAR2

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

13030: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13035: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13037: , x_return_status OUT NOCOPY VARCHAR2
13038: )

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

13031: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
13032: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
13033: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
13034: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
13035: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
13036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
13037: , x_return_status OUT NOCOPY VARCHAR2
13038: )
13039: IS

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

13056: --l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type := p_revised_item_tbl;
13057: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13062: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13063: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13064:

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

13057: --l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13062: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13063: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13064:
13065:

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

13058: --l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
13059: --l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
13060: --l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type := p_rev_operation_tbl; --L1
13061: --l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type :=p_rev_op_resource_tbl; --L1
13062: --l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type :=p_rev_sub_resource_tbl; --L1
13063: --l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
13064:
13065:
13066: l_return_value NUMBER;

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

14093: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type
14094: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14099: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14100: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

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

14094: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14099: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14100: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

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

14095: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
14096: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
14097: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1
14098: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1
14099: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type--L1
14100: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
14101: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
14102: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
14103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

14103: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
14104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14111: , x_return_status OUT NOCOPY VARCHAR2

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

14104: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14111: , x_return_status OUT NOCOPY VARCHAR2
14112: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

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

14105: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
14106: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
14107: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
14108: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
14109: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
14110: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
14111: , x_return_status OUT NOCOPY VARCHAR2
14112: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
14113: )

Line 14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type

14129: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type := p_rev_component_tbl;
14130: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type := p_ref_designator_tbl;
14131: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14132:
14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14134: := p_rev_operation_tbl; --L1
14135: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14136: :=p_rev_op_resource_tbl; --L1
14137: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

Line 14135: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

14131: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type := p_sub_component_tbl;
14132:
14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14134: := p_rev_operation_tbl; --L1
14135: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14136: :=p_rev_op_resource_tbl; --L1
14137: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14138: :=p_rev_sub_resource_tbl;--L1
14139:

Line 14137: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

14133: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type
14134: := p_rev_operation_tbl; --L1
14135: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
14136: :=p_rev_op_resource_tbl; --L1
14137: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
14138: :=p_rev_sub_resource_tbl;--L1
14139:
14140: l_change_line_tbl Eng_Eco_Pub.Change_Line_Tbl_Type := p_change_line_tbl; -- Eng Change
14141: l_status_check_required BOOLEAN := TRUE; -- Added for enhancement 541

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

15586: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type :=
15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

Line 15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL

15587: BOM_BO_PUB.G_MISS_REF_DESIGNATOR_TBL
15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

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

15588: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type :=
15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15596: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

Line 15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

15589: BOM_BO_PUB.G_MISS_SUB_COMPONENT_TBL
15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15596: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15597: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type

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

15590: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15596: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15597: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15598: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change

Line 15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

15591: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
15592: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type := --L1
15593: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
15594: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
15595: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
15596: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
15597: , x_eco_revision_tbl IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Tbl_Type
15598: , x_change_line_tbl IN OUT NOCOPY ENG_Eco_PUB.Change_Line_Tbl_Type -- Eng Change
15599: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type

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

15599: , x_revised_item_tbl IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Tbl_Type
15600: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15605: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15606: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15607: )

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

15600: , x_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15605: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15606: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15607: )
15608: IS

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

15601: , x_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
15602: , x_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
15603: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
15604: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
15605: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
15606: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
15607: )
15608: IS
15609: l_api_version_number CONSTANT NUMBER := 1.0;

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

15627: l_ref_designator_rec BOM_BO_PUB.Ref_Designator_Rec_Type;
15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--

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

15628: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--

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

15629: l_sub_component_rec BOM_BO_PUB.Sub_Component_Rec_Type;
15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change

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

15630: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15638: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change

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

15631: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15638: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15639:

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

15632: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
15633: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
15634: l_rev_operation_rec Bom_Rtg_Pub.Rev_Operation_Rec_Type; -- L1--
15635: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type; -- L1--
15636: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type; -- L1--
15637: l_change_line_rec ENG_Eco_PUB.Change_Line_Rec_Type ; -- Eng Change
15638: l_change_line_tbl ENG_Eco_PUB.Change_Line_Tbl_Type ; -- Eng Change
15639:
15640: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;