DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_ECO_PUB

Line 749: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

745: * updated the use up plan name or the item, then a new schedule
746: * must be fetched and updated in all the corresponding entities.
747: ******************************************************************************/
748: PROCEDURE Update_Row
749: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
750: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
751: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
752: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
753: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 750: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

746: * must be fetched and updated in all the corresponding entities.
747: ******************************************************************************/
748: PROCEDURE Update_Row
749: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
750: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
751: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
752: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
753: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
754: , x_Return_Status OUT NOCOPY VARCHAR2

Line 1574: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1570: * does not exist. Also an entry into the table eng_current_
1571: * effective dates is also made for the new item.
1572: *****************************************************************************/
1573: PROCEDURE Insert_Row
1574: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1575: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1576: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1577: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1578: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1575: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1571: * effective dates is also made for the new item.
1572: *****************************************************************************/
1573: PROCEDURE Insert_Row
1574: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1575: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1576: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1577: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1578: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1579: , x_Return_Status OUT NOCOPY VARCHAR2

Line 2197: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

2193: , p_new_item_revision IN VARCHAR2
2194: , p_new_routing_revision IN VARCHAR2 -- Added by MK
2195: , p_from_end_item_number IN VARCHAR2 := NULL
2196: , p_alternate_designator IN VARCHAR2 := NULL -- To Fix 2869146
2197: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
2198: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2199: , x_Return_status OUT NOCOPY VARCHAR2
2200: )
2201: IS

Line 2198: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2194: , p_new_routing_revision IN VARCHAR2 -- Added by MK
2195: , p_from_end_item_number IN VARCHAR2 := NULL
2196: , p_alternate_designator IN VARCHAR2 := NULL -- To Fix 2869146
2197: , x_revised_item_rec OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
2198: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2199: , x_Return_status OUT NOCOPY VARCHAR2
2200: )
2201: IS
2202: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

Line 2202: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

2198: , x_rev_item_unexp_rec OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2199: , x_Return_status OUT NOCOPY VARCHAR2
2200: )
2201: IS
2202: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
2203: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2204: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2205: l_err_text VARCHAR2(2000);
2206: BEGIN

Line 2203: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

2199: , x_Return_status OUT NOCOPY VARCHAR2
2200: )
2201: IS
2202: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
2203: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2204: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2205: l_err_text VARCHAR2(2000);
2206: BEGIN
2207:

Line 2377: Eng_Eco_Pub.Revised_Item_Rec_Type

2373: * So based on the transaction type this procedure will call
2374: * the internal insert, update and delete procedures.
2375: ******************************************************************************/
2376: PROCEDURE Perform_Writes( p_revised_item_rec IN
2377: Eng_Eco_Pub.Revised_Item_Rec_Type
2378: , p_rev_item_unexp_rec IN
2379: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2380: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2381: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

Line 2379: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2375: ******************************************************************************/
2376: PROCEDURE Perform_Writes( p_revised_item_rec IN
2377: Eng_Eco_Pub.Revised_Item_Rec_Type
2378: , p_rev_item_unexp_rec IN
2379: Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2380: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2381: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2382: , x_Mesg_Token_Tbl OUT NOCOPY
2383: Error_Handler.Mesg_Token_Tbl_Type

Line 2686: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;

2682: FROM eng_revised_items
2683: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2684:
2685: l_old_revised_item_rec c_revised_item%ROWTYPE;
2686: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2687: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2688: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2689: BEGIN
2690: --

Line 2687: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

2683: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2684:
2685: l_old_revised_item_rec c_revised_item%ROWTYPE;
2686: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;
2687: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
2688: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2689: BEGIN
2690: --
2691: -- Initialize OUT variables