[Home] [Help]
PACKAGE: APPS.ENG_ECO_REVISION_UTIL
Source
1 PACKAGE ENG_Eco_Revision_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGUREVS.pls 115.12 2002/12/12 18:11:40 akumar ship $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE11 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE12 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE13 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE14 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE15 CONSTANT NUMBER := 5;
11 G_PROGRAM_APPLICATION CONSTANT NUMBER := 6;
12 G_PROGRAM CONSTANT NUMBER := 7;
13 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 8;
14 G_REQUEST CONSTANT NUMBER := 9;
15 G_REVISION CONSTANT NUMBER := 10;
16 G_CHANGE_NOTICE CONSTANT NUMBER := 11;
17 G_ORGANIZATION CONSTANT NUMBER := 12;
18 G_REV CONSTANT NUMBER := 13;
19 G_LAST_UPDATE_DATE CONSTANT NUMBER := 14;
20 G_LAST_UPDATED_BY CONSTANT NUMBER := 15;
21 G_CREATION_DATE CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 18;
24 G_COMMENTS CONSTANT NUMBER := 19;
25 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 20;
26 G_ATTRIBUTE1 CONSTANT NUMBER := 21;
27 G_ATTRIBUTE2 CONSTANT NUMBER := 22;
28 G_ATTRIBUTE3 CONSTANT NUMBER := 23;
29 G_ATTRIBUTE4 CONSTANT NUMBER := 24;
30 G_ATTRIBUTE5 CONSTANT NUMBER := 25;
31 G_ATTRIBUTE6 CONSTANT NUMBER := 26;
32 G_ATTRIBUTE7 CONSTANT NUMBER := 27;
33 G_ATTRIBUTE8 CONSTANT NUMBER := 28;
34 G_ATTRIBUTE9 CONSTANT NUMBER := 29;
35 G_ATTRIBUTE10 CONSTANT NUMBER := 30;
36 G_MAX_ATTR_ID CONSTANT NUMBER := 31;
37
38 -- Procedure Clear_Dependent_Attr
39
40 PROCEDURE Clear_Dependent_Attr
41 ( p_attr_id IN NUMBER := NULL ---FND_API.G_MISS_NUM
42 , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
43 , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type :=
44 ENG_Eco_PUB.G_MISS_ECO_REVISION_REC
45 , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
46 );
47
48 -- Procedure Apply_Attribute_Changes
49
50 PROCEDURE Apply_Attribute_Changes
51 ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
52 , p_old_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type :=
53 ENG_Eco_PUB.G_MISS_ECO_REVISION_REC
54 , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
55 );
56
57 -- Function Convert_Miss_To_Null
58
59 FUNCTION Convert_Miss_To_Null
60 ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
61 ) RETURN ENG_Eco_PUB.Eco_Revision_Rec_Type;
62
63 -- Function Query_Row
64
65 PROCEDURE Query_Row
66 ( p_Change_Notice IN VARCHAR2
67 , p_Organization_Id IN NUMBER
68 , p_Revision IN VARCHAR2
69 , x_Eco_Revision_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Revision_Rec_Type
70 , x_Eco_Rev_Unexp_Rec OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
71 , x_Return_Status OUT NOCOPY VARCHAR2
72 );
73
74 -- Procedure lock_Row
75 --
76
77 PROCEDURE Lock_Row
78 ( x_return_status OUT NOCOPY VARCHAR2
79 , p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
80 , x_eco_revision_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Revision_Rec_Type
81 , x_err_text OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE Perform_Writes
85 ( p_eco_revision_rec IN Eng_Eco_Pub.Eco_Revision_Rec_Type
86 , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
87 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
88 := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
89 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90 , x_Return_Status OUT NOCOPY VARCHAR2
91 );
92
93
94 END ENG_Eco_Revision_Util;