APPS.ENG_DEFAULT_REVISED_ITEM dependencies on ENG_ECO_PUB

Line 10: g_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Default_Revised_Item';
7:
8: -- Package global used within the package.
9:
10: g_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
11: g_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
12:
13: -- Local Function used for defualting.
14:

Line 11: g_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

7:
8: -- Package global used within the package.
9:
10: g_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
11: g_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
12:
13: -- Local Function used for defualting.
14:
15: /***************************************************************************

Line 383: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

379: * Purpose : Attribute Defaulting will default the necessary null attribute
380: * with appropriate values.
381: *******************************************************************************/
382: PROCEDURE Attribute_Defaulting
383: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
384: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
385: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
386: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_rec_type
387: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 384: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

380: * with appropriate values.
381: *******************************************************************************/
382: PROCEDURE Attribute_Defaulting
383: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
384: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
385: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
386: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_rec_type
387: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
388: , x_return_status OUT NOCOPY VARCHAR2

Line 385: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type

381: *******************************************************************************/
382: PROCEDURE Attribute_Defaulting
383: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
384: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
385: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
386: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_rec_type
387: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
388: , x_return_status OUT NOCOPY VARCHAR2
389: )

Line 386: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_rec_type

382: PROCEDURE Attribute_Defaulting
383: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
384: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
385: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
386: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_rec_type
387: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
388: , x_return_status OUT NOCOPY VARCHAR2
389: )
390: IS

Line 741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type

737: * given are having a missing or any other then those columns
738: * are not copied.
739: ********************************************************************************/
740: PROCEDURE Populate_Null_Columns
741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type
742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

Line 742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type

738: * are not copied.
739: ********************************************************************************/
740: PROCEDURE Populate_Null_Columns
741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type
742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

Line 743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type

739: ********************************************************************************/
740: PROCEDURE Populate_Null_Columns
741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type
742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
747: )

Line 744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type

740: PROCEDURE Populate_Null_Columns
741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type
742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
747: )
748: IS

Line 745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

741: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_item_Rec_Type
742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
747: )
748: IS
749: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=

Line 746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

742: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_item_Rec_Type
743: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
744: , p_old_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type
745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
747: )
748: IS
749: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=
750: p_revised_item_rec;

Line 749: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=

745: , x_revised_item_Rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
746: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
747: )
748: IS
749: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=
750: p_revised_item_rec;
751: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type :=
752: p_rev_item_unexp_rec;
753: BEGIN

Line 751: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type :=

747: )
748: IS
749: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=
750: p_revised_item_rec;
751: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_item_Unexposed_Rec_Type :=
752: p_rev_item_unexp_rec;
753: BEGIN
754:
755: IF l_revised_item_rec.disposition_type IS NULL THEN

Line 1336: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1332: * need conditional defaulting i.e defaulting which is based on
1333: * one or more columns from the entity column values.
1334: ******************************************************************************/
1335: PROCEDURE Entity_Defaulting
1336: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1337: , p_rev_item_unexp_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type

Line 1337: , p_rev_item_unexp_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type

1333: * one or more columns from the entity column values.
1334: ******************************************************************************/
1335: PROCEDURE Entity_Defaulting
1336: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1337: , p_rev_item_unexp_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1341: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

Line 1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

1334: ******************************************************************************/
1335: PROCEDURE Entity_Defaulting
1336: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1337: , p_rev_item_unexp_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1341: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1342: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type

Line 1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1335: PROCEDURE Entity_Defaulting
1336: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1337: , p_rev_item_unexp_rec IN ENG_Eco_PUB.Rev_Item_Unexposed_Rec_Type
1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1341: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1342: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
1343: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

Line 1342: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type

1338: , p_old_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1341: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1342: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
1343: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1344: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1345: , x_return_status OUT NOCOPY VARCHAR2
1346: )

Line 1343: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

1339: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1340: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
1341: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
1342: , x_revised_item_rec IN OUT NOCOPY ENG_Eco_PUB.Revised_Item_Rec_Type
1343: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1344: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1345: , x_return_status OUT NOCOPY VARCHAR2
1346: )
1347: IS

Line 1349: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=

1345: , x_return_status OUT NOCOPY VARCHAR2
1346: )
1347: IS
1348: l_schedule_id NUMBER := NULL;
1349: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=
1350: p_revised_item_rec;
1351: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type :=
1352: p_rev_item_unexp_rec;
1353: l_processed BOOLEAN := FALSE;

Line 1351: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type :=

1347: IS
1348: l_schedule_id NUMBER := NULL;
1349: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type :=
1350: p_revised_item_rec;
1351: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type :=
1352: p_rev_item_unexp_rec;
1353: l_processed BOOLEAN := FALSE;
1354: l_current_revision VARCHAR2(3) := 999;
1355: l_err_text VARCHAR2(2000);