[Home] [Help]
PACKAGE: APPS.QP_QUALIFIERS_UTIL
Source
1 PACKAGE QP_Qualifiers_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUQPQS.pls 120.3.12020000.1 2012/06/27 21:13:13 appldev ship $ */
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_COMPARISON_OPERATOR CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATED_FROM_RULE CONSTANT NUMBER := 19;
25 G_CREATION_DATE CONSTANT NUMBER := 20;
26 G_END_DATE_ACTIVE CONSTANT NUMBER := 21;
27 G_EXCLUDER CONSTANT NUMBER := 22;
28 G_LAST_UPDATED_BY CONSTANT NUMBER := 23;
29 G_LAST_UPDATE_DATE CONSTANT NUMBER := 24;
30 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 25;
31 G_LIST_HEADER CONSTANT NUMBER := 26;
32 G_LIST_LINE CONSTANT NUMBER := 27;
33 G_PROGRAM_APPLICATION CONSTANT NUMBER := 28;
34 G_PROGRAM CONSTANT NUMBER := 29;
35 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 30;
36 G_QUALIFIER_ATTRIBUTE CONSTANT NUMBER := 31;
37 G_QUALIFIER_ATTR_VALUE CONSTANT NUMBER := 32;
38 G_QUALIFIER_ATTR_VALUE_TO CONSTANT NUMBER := 33;
39 G_QUALIFIER_CONTEXT CONSTANT NUMBER := 34;
40 G_QUALIFIER_DATATYPE CONSTANT NUMBER := 35;
41 --G_QUALIFIER_DATE_FORMAT CONSTANT NUMBER := 36;
42 G_QUALIFIER_GROUPING_NO CONSTANT NUMBER := 36;
43 G_QUALIFIER CONSTANT NUMBER := 37;
44 --G_QUALIFIER_NUMBER_FORMAT CONSTANT NUMBER := 38;
45 G_QUALIFIER_PRECEDENCE CONSTANT NUMBER := 38;
46 G_QUALIFIER_RULE CONSTANT NUMBER := 39;
47 G_REQUEST CONSTANT NUMBER := 40;
48 G_START_DATE_ACTIVE CONSTANT NUMBER := 41;
49 G_MAX_ATTR_ID CONSTANT NUMBER := 42;
50 G_QUALIFY_HIER_DESCENDENT_FLAG CONSTANT NUMBER := 43; -- Added for TCA
51
52 -- Procedure Clear_Dependent_Attr
53
54 PROCEDURE Clear_Dependent_Attr
55 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56 , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
57 , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
58 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
59 , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
60 );
61
62 -- Procedure Apply_Attribute_Changes
63
64 PROCEDURE Apply_Attribute_Changes
65 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
66 , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
67 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
68 , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
69 );
70
71 -- Function Complete_Record
72
73 FUNCTION Complete_Record
74 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
75 , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
76 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
77
78 -- Function Convert_Miss_To_Null
79
80 FUNCTION Convert_Miss_To_Null
81 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
82 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
83
84 -- Procedure Update_Row
85
86 PROCEDURE Update_Row
87 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
88 );
89
90 -- Procedure Update_coupon_Row Added for bug 7315016
91
92 PROCEDURE Update_coupon_Row
93 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
94 );
95
96
97 -- Procedure Insert_Row
98
99 PROCEDURE Insert_Row
100 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
101 );
102
103 --This procedure will be used by HTML Qualifier UI
104 --to insert qualifiers into dummy table for updates
105 PROCEDURE Insert_Row(p_qual_grp_no IN NUMBER,
106 p_list_header_id IN NUMBER,
107 p_list_line_id IN NUMBER,
108 p_transaction_id IN NUMBER);
109
110 --This procedure will be used by HTML Qualifier UI
111 --to delete rows from dummy table
112 Procedure Delete_Dummy_Rows(p_transaction_id IN NUMBER);
113
114 --This procedure will mark given qualifier as DELETED
115 Procedure Mark_Delete_Dummy_Qual(p_qual_id IN NUMBER
116 ,p_mode IN VARCHAR2
117 ,p_transaction_id IN NUMBER);
118
119 --This procedure will mark given qualifiergroup as DELETED
120 Procedure Mark_Delete_Dummy_Qual(p_qual_grp_no IN NUMBER,
121 p_list_header_id IN NUMBER,
122 p_list_line_id IN NUMBER,
123 p_transaction_id IN NUMBER);
124
125 --This procedure will delete the dummy qualifiers inserted for updates
126 Procedure Remove_Dummy_Quals(p_action_type IN VARCHAR2,
127 p_list_header_id IN NUMBER,
128 p_list_line_id IN NUMBER,
129 p_transaction_id IN NUMBER);
130
131 -- Procedure Delete_Row
132
133 -- added qualifier_rule-id parameter for cascade delete
134
135 PROCEDURE Delete_Row
136 ( p_qualifier_id IN NUMBER := FND_API.G_MISS_NUM,
137 p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
138 );
139
140 PROCEDURE Delete_Row(p_qual_grp_no IN NUMBER,
141 p_list_header_id IN NUMBER,
142 p_list_line_id IN NUMBER,
143 p_transaction_id IN NUMBER);
144
145 -- Function Query_Row
146
147 FUNCTION Query_Row
148 ( p_qualifier_id IN NUMBER
149 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
150
151 -- Function Query_Rows
152
153 --
154
155 FUNCTION Query_Rows
156 ( p_qualifier_id IN NUMBER :=
157 FND_API.G_MISS_NUM
158 , p_qualifier_rule_id IN NUMBER :=
159 FND_API.G_MISS_NUM
160 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
161
162 -- Procedure lock_Row
163 --
164
165 PROCEDURE Lock_Row
166 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
168 , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
169 );
170
171 -- Function Get_Values
172
173 FUNCTION Get_Values
174 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
175 , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
176 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
177 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
178
179 -- Function Get_Ids
180
181 FUNCTION Get_Ids
182 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
183 , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
184 ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185
186 Procedure Pre_Write_Process
187 ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188 , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
189 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
190 , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
191 );
192
193 END QP_Qualifiers_Util;