APPS.ENG_ECO_REVISION_UTIL dependencies on ENG_ECO_PUB

Line 80: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

76: -- Procedure Clear_Dependent_Attr
77:
78: PROCEDURE Clear_Dependent_Attr
79: ( p_attr_id IN NUMBER := NULL --FND_API.G_MISS_NUM
80: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
81: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
82: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
83: )
84: IS

Line 81: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

77:
78: PROCEDURE Clear_Dependent_Attr
79: ( p_attr_id IN NUMBER := NULL --FND_API.G_MISS_NUM
80: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
81: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
82: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
83: )
84: IS
85: BEGIN

Line 82: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type

78: PROCEDURE Clear_Dependent_Attr
79: ( p_attr_id IN NUMBER := NULL --FND_API.G_MISS_NUM
80: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
81: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
82: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
83: )
84: IS
85: BEGIN
86:

Line 96: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

92:
93: -- Procedure Apply_Attribute_Changes
94:
95: PROCEDURE Apply_Attribute_Changes
96: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
97: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
98: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
99: )
100: IS

Line 97: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

93: -- Procedure Apply_Attribute_Changes
94:
95: PROCEDURE Apply_Attribute_Changes
96: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
97: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
98: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
99: )
100: IS
101: BEGIN

Line 98: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type

94:
95: PROCEDURE Apply_Attribute_Changes
96: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
97: , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
98: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
99: )
100: IS
101: BEGIN
102: -- Load out record

Line 112: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

108:
109: -- Function Convert_Miss_To_Null
110:
111: FUNCTION Convert_Miss_To_Null
112: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
113: ) RETURN ENG_Eco_PUB.Eco_Revision_Rec_Type
114: IS
115: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type :=
116: p_eco_revision_rec;

Line 113: ) RETURN ENG_Eco_PUB.Eco_Revision_Rec_Type

109: -- Function Convert_Miss_To_Null
110:
111: FUNCTION Convert_Miss_To_Null
112: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
113: ) RETURN ENG_Eco_PUB.Eco_Revision_Rec_Type
114: IS
115: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type :=
116: p_eco_revision_rec;
117: BEGIN

Line 115: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type :=

111: FUNCTION Convert_Miss_To_Null
112: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
113: ) RETURN ENG_Eco_PUB.Eco_Revision_Rec_Type
114: IS
115: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type :=
116: p_eco_revision_rec;
117: BEGIN
118:
119: RETURN l_eco_revision_rec;

Line 134: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

130: * record. If it fails then an unexpected error will be returned
131: * with message text in Mesg_Token_Tbl and return_status of U.
132: ****************************************************************************/
133: PROCEDURE Update_Row
134: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
135: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: , x_Return_Status OUT NOCOPY VARCHAR2
138: )

Line 135: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

131: * with message text in Mesg_Token_Tbl and return_status of U.
132: ****************************************************************************/
133: PROCEDURE Update_Row
134: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
135: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: , x_Return_Status OUT NOCOPY VARCHAR2
138: )
139: IS

Line 235: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type

231: * an unexpected error with message text in the Mesg token
232: * Table and a return status of U
233: ***************************************************************************/
234: PROCEDURE Insert_Row
235: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
236: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
237: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
238: , x_Return_Status OUT NOCOPY VARCHAR2
239: )

Line 236: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

232: * Table and a return status of U
233: ***************************************************************************/
234: PROCEDURE Insert_Row
235: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
236: , p_Eco_Rev_Unexp_Rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
237: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
238: , x_Return_Status OUT NOCOPY VARCHAR2
239: )
240: IS

Line 477: , x_Eco_Revision_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Revision_Rec_Type

473: PROCEDURE Query_Row
474: ( p_Change_Notice IN VARCHAR2
475: , p_Organization_Id IN NUMBER
476: , p_Revision IN VARCHAR2
477: , x_Eco_Revision_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Revision_Rec_Type
478: , x_Eco_Rev_Unexp_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
479: , x_Return_Status OUT NOCOPY Varchar2
480: )
481: IS

Line 478: , x_Eco_Rev_Unexp_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

474: ( p_Change_Notice IN VARCHAR2
475: , p_Organization_Id IN NUMBER
476: , p_Revision IN VARCHAR2
477: , x_Eco_Revision_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Revision_Rec_Type
478: , x_Eco_Rev_Unexp_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
479: , x_Return_Status OUT NOCOPY Varchar2
480: )
481: IS
482: l_err_text VARCHAR2(2000);

Line 556: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type

552: * insert, update or delete procedures. When it comes to writing
553: * data to the entity tables, this is the only exposed procedure.
554: ******************************************************************************/
555: PROCEDURE Perform_Writes
556: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
557: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
558: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
559: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
560: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 557: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type

553: * data to the entity tables, this is the only exposed procedure.
554: ******************************************************************************/
555: PROCEDURE Perform_Writes
556: ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
557: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
558: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
559: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
560: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
561: , x_return_status OUT NOCOPY VARCHAR2

Line 606: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type

602: -- Procedure lock_Row
603: -- NOT USED CURRENTLY
604: PROCEDURE Lock_Row
605: ( x_return_status OUT NOCOPY VARCHAR2
606: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
607: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
608: , x_err_text OUT NOCOPY VARCHAR2
609: )
610: IS

Line 607: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type

603: -- NOT USED CURRENTLY
604: PROCEDURE Lock_Row
605: ( x_return_status OUT NOCOPY VARCHAR2
606: , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
607: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
608: , x_err_text OUT NOCOPY VARCHAR2
609: )
610: IS
611: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;

Line 611: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;

607: , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
608: , x_err_text OUT NOCOPY VARCHAR2
609: )
610: IS
611: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
612: l_err_text VARCHAR2(255);
613: BEGIN
614: NULL;
615: /*

Line 849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

845: -- Row has changed by another user.
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
850: , p_msg_name => 'OE_LOCK_ROW_CHANGED'
851: , x_err_text => x_err_text );
852: END IF;
853:

Line 860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

856: WHEN NO_DATA_FOUND THEN
857:
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
861: , p_msg_name => 'OE_LOCK_ROW_DELETED'
862: , x_err_text => x_err_text );
863:
864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
869: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
870: , x_err_text => x_err_text );
871: WHEN OTHERS THEN
872: