DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_ECO_PUB

Line 732: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

728: * updated the use up plan name or the item, then a new schedule
729: * must be fetched and updated in all the corresponding entities.
730: ******************************************************************************/
731: PROCEDURE Update_Row
732: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
733: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
734: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
735: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
736: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 733: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

729: * must be fetched and updated in all the corresponding entities.
730: ******************************************************************************/
731: PROCEDURE Update_Row
732: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
733: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
734: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
735: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
736: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
737: , x_Return_Status OUT NOCOPY VARCHAR2

Line 1556: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1552: * does not exist. Also an entry into the table eng_current_
1553: * effective dates is also made for the new item.
1554: *****************************************************************************/
1555: PROCEDURE Insert_Row
1556: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1557: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1558: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1559: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1560: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1557: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1553: * effective dates is also made for the new item.
1554: *****************************************************************************/
1555: PROCEDURE Insert_Row
1556: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1557: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1558: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1559: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1560: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1561: , x_Return_Status OUT NOCOPY VARCHAR2

Line 2173: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

2169: , p_new_item_revision IN VARCHAR2
2170: , p_new_routing_revision IN VARCHAR2 -- Added by MK
2171: , p_from_end_item_number IN VARCHAR2 := NULL
2172: , p_alternate_designator IN VARCHAR2 := NULL -- To Fix 2869146
2173: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
2174: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2175: , x_Return_status OUT NOCOPY VARCHAR2
2176: )
2177: IS

Line 2174: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2170: , p_new_routing_revision IN VARCHAR2 -- Added by MK
2171: , p_from_end_item_number IN VARCHAR2 := NULL
2172: , p_alternate_designator IN VARCHAR2 := NULL -- To Fix 2869146
2173: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
2174: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2175: , x_Return_status OUT NOCOPY VARCHAR2
2176: )
2177: IS
2178: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

Line 2178: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

2174: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2175: , x_Return_status OUT NOCOPY VARCHAR2
2176: )
2177: IS
2178: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
2179: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2180: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2181: l_err_text VARCHAR2(2000);
2182: BEGIN

Line 2179: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

2175: , x_Return_status OUT NOCOPY VARCHAR2
2176: )
2177: IS
2178: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
2179: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2180: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2181: l_err_text VARCHAR2(2000);
2182: BEGIN
2183:

Line 2353: Eng_Eco_Pub.Revised_Item_Rec_Type

2349: * So based on the transaction type this procedure will call
2350: * the internal insert, update and delete procedures.
2351: ******************************************************************************/
2352: PROCEDURE Perform_Writes( p_revised_item_rec IN
2353: Eng_Eco_Pub.Revised_Item_Rec_Type
2354: , p_rev_item_unexp_rec IN
2355: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2356: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2357: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

Line 2355: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2351: ******************************************************************************/
2352: PROCEDURE Perform_Writes( p_revised_item_rec IN
2353: Eng_Eco_Pub.Revised_Item_Rec_Type
2354: , p_rev_item_unexp_rec IN
2355: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2356: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2357: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2358: , x_Mesg_Token_Tbl OUT NOCOPY
2359: Error_Handler.Mesg_Token_Tbl_Type

Line 2662: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;

2658: FROM eng_revised_items
2659: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2660:
2661: l_old_revised_item_rec c_revised_item%ROWTYPE;
2662: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2663: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2664: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2665: BEGIN
2666: --

Line 2663: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

2659: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2660:
2661: l_old_revised_item_rec c_revised_item%ROWTYPE;
2662: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2663: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2664: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2665: BEGIN
2666: --
2667: -- Initialize OUT variables