[Home] [Help]
PACKAGE: APPS.QP_RQT_UTIL
Source
1 PACKAGE QP_Rqt_Util AS
2 /* $Header: QPXURQTS.pls 120.1 2005/06/13 23:18:38 appldev $ */
3
4 -- Attributes global constants
5
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_CONTEXT CONSTANT NUMBER := 16;
22 G_CREATED_BY CONSTANT NUMBER := 17;
23 G_CREATION_DATE CONSTANT NUMBER := 18;
24 G_ENABLED CONSTANT NUMBER := 19;
25 G_LAST_UPDATED_BY CONSTANT NUMBER := 20;
26 G_LAST_UPDATE_DATE CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 22;
28 G_LINE_LEVEL_GLOBAL_STRUCT CONSTANT NUMBER := 23;
29 G_LINE_LEVEL_VIEW_NAME CONSTANT NUMBER := 24;
30 G_ORDER_LEVEL_GLOBAL_STRUCT CONSTANT NUMBER := 25;
31 G_ORDER_LEVEL_VIEW_NAME CONSTANT NUMBER := 26;
32 G_PROGRAM_APPLICATION CONSTANT NUMBER := 27;
33 G_PROGRAM CONSTANT NUMBER := 28;
34 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 29;
35 G_PTE CONSTANT NUMBER := 30;
36 G_REQUEST_TYPE CONSTANT NUMBER := 31;
37 G_REQUEST_TYPE_DESC CONSTANT NUMBER := 32;
38 G_ROW CONSTANT NUMBER := 33;
39 G_MAX_ATTR_ID CONSTANT NUMBER := 34;
40
41 -- Procedure Clear_Dependent_Attr
42
43 PROCEDURE Clear_Dependent_Attr
44 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
45 , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
46 , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
47 QP_Attr_Map_PUB.G_MISS_RQT_REC
48 , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
49 );
50
51 -- Procedure Apply_Attribute_Changes
52
53 PROCEDURE Apply_Attribute_Changes
54 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
55 , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
56 QP_Attr_Map_PUB.G_MISS_RQT_REC
57 , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
58 );
59
60 -- Function Complete_Record
61
62 FUNCTION Complete_Record
63 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
64 , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
65 ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;
66
67 -- Function Convert_Miss_To_Null
68
69 FUNCTION Convert_Miss_To_Null
70 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
71 ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;
72
73 -- Procedure Update_Row
74
75 PROCEDURE Update_Row
76 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
77 );
78
79 -- Procedure Insert_Row
80
81 PROCEDURE Insert_Row
82 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
83 );
84
85 -- Procedure Delete_Row
86
87 PROCEDURE Delete_Row
88 ( p_request_type_code IN VARCHAR2
89 );
90
91 -- Function Query_Row
92
93 FUNCTION Query_Row
94 ( p_request_type_code IN VARCHAR2
95 ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;
96
97 -- Function Query_Rows
98
99 --
100
101 FUNCTION Query_Rows
102 ( p_request_type_code IN VARCHAR2 :=
103 FND_API.G_MISS_CHAR
104 , p_lookup_code IN VARCHAR2 :=
105 FND_API.G_MISS_CHAR
106 ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type;
107
108 -- Procedure lock_Row
109 --
110
111 PROCEDURE Lock_Row
112 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
114 , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
115 );
116
117 -- Function Get_Values
118
119 FUNCTION Get_Values
120 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
121 , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
122 QP_Attr_Map_PUB.G_MISS_RQT_REC
123 ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
124
125 -- Function Get_Ids
126
127 FUNCTION Get_Ids
128 ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
129 , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
130 ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;
131
132 END QP_Rqt_Util;