eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_CURR_LISTS_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,p_old_CURR_LISTS_rec.attribute1)

28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,p_old_CURR_LISTS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,p_old_CURR_LISTS_rec.attribute10)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,p_old_CURR_LISTS_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,p_old_CURR_LISTS_rec.attribute11)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,p_old_CURR_LISTS_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,p_old_CURR_LISTS_rec.attribute12)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,p_old_CURR_LISTS_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,p_old_CURR_LISTS_rec.attribute13)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,p_old_CURR_LISTS_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,p_old_CURR_LISTS_rec.attribute14)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,p_old_CURR_LISTS_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,p_old_CURR_LISTS_rec.attribute15)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,p_old_CURR_LISTS_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,p_old_CURR_LISTS_rec.attribute2)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,p_old_CURR_LISTS_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,p_old_CURR_LISTS_rec.attribute3)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,p_old_CURR_LISTS_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,p_old_CURR_LISTS_rec.attribute4)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,p_old_CURR_LISTS_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,p_old_CURR_LISTS_rec.attribute5)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,p_old_CURR_LISTS_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,p_old_CURR_LISTS_rec.attribute6)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,p_old_CURR_LISTS_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,p_old_CURR_LISTS_rec.attribute7)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,p_old_CURR_LISTS_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,p_old_CURR_LISTS_rec.attribute8)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,p_old_CURR_LISTS_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,p_old_CURR_LISTS_rec.attribute9)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,p_old_CURR_LISTS_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,p_old_CURR_LISTS_rec.base_currency_code)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,p_old_CURR_LISTS_rec.base_currency_code)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_CURRENCY;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,p_old_CURR_LISTS_rec.context)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_CURRENCY;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,p_old_CURR_LISTS_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CONTEXT;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,p_old_CURR_LISTS_rec.created_by)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,p_old_CURR_LISTS_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CREATED_BY;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,p_old_CURR_LISTS_rec.creation_date)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,p_old_CURR_LISTS_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CREATION_DATE;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,p_old_CURR_LISTS_rec.currency_header_id)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,p_old_CURR_LISTS_rec.currency_header_id)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CURRENCY_HEADER;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,p_old_CURR_LISTS_rec.description)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_CURRENCY_HEADER;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,p_old_CURR_LISTS_rec.description)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_DESCRIPTION;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,p_old_CURR_LISTS_rec.last_updated_by)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_DESCRIPTION;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,p_old_CURR_LISTS_rec.last_updated_by)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATED_BY;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,p_old_CURR_LISTS_rec.last_update_date)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATED_BY;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,p_old_CURR_LISTS_rec.last_update_date)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_DATE;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,p_old_CURR_LISTS_rec.last_update_login)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_DATE;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,p_old_CURR_LISTS_rec.last_update_login)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_LOGIN;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,p_old_CURR_LISTS_rec.name)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_LAST_UPDATE_LOGIN;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,p_old_CURR_LISTS_rec.name)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_NAME;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,p_old_CURR_LISTS_rec.program_application_id)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_NAME;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,p_old_CURR_LISTS_rec.program_application_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_APPLICATION;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,p_old_CURR_LISTS_rec.program_id)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,p_old_CURR_LISTS_rec.program_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,p_old_CURR_LISTS_rec.program_update_date)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,p_old_CURR_LISTS_rec.program_update_date)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,p_old_CURR_LISTS_rec.request_id)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,p_old_CURR_LISTS_rec.request_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_REQUEST;
204: END IF;

Line 207: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,p_old_CURR_LISTS_rec.base_markup_formula_id)

203: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_REQUEST;
204: END IF;
205:
206: -- Added by Sunil Pandey 10/01/01
207: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,p_old_CURR_LISTS_rec.base_markup_formula_id)
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_FORMULA;
211: END IF;

Line 213: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,p_old_CURR_LISTS_rec.base_markup_operator)

209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_FORMULA;
211: END IF;
212:
213: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,p_old_CURR_LISTS_rec.base_markup_operator)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_OPERATOR;
217: END IF;

Line 219: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,p_old_CURR_LISTS_rec.base_markup_value)

215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_OPERATOR;
217: END IF;
218:
219: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,p_old_CURR_LISTS_rec.base_markup_value)
220: THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_VALUE;
223: END IF;

Line 225: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,p_old_CURR_LISTS_rec.base_rounding_factor)

221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_MARKUP_VALUE;
223: END IF;
224:
225: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,p_old_CURR_LISTS_rec.base_rounding_factor)
226: THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_BASE_ROUNDING_FACTOR;
229: END IF;

Line 234: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,p_old_CURR_LISTS_rec.row_id)

230: -- Added by Sunil Pandey 10/01/01
231:
232:
233: /* Commented by Sunil
234: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,p_old_CURR_LISTS_rec.row_id)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := QP_CURR_LISTS_UTIL.G_ROW;
238: END IF;

Line 367: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,p_old_CURR_LISTS_rec.attribute1)

363: -- Load out record
364:
365: x_CURR_LISTS_rec := p_CURR_LISTS_rec;
366:
367: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,p_old_CURR_LISTS_rec.attribute1)
368: THEN
369: NULL;
370: END IF;
371:

Line 372: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,p_old_CURR_LISTS_rec.attribute10)

368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,p_old_CURR_LISTS_rec.attribute10)
373: THEN
374: NULL;
375: END IF;
376:

Line 377: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,p_old_CURR_LISTS_rec.attribute11)

373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,p_old_CURR_LISTS_rec.attribute11)
378: THEN
379: NULL;
380: END IF;
381:

Line 382: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,p_old_CURR_LISTS_rec.attribute12)

378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,p_old_CURR_LISTS_rec.attribute12)
383: THEN
384: NULL;
385: END IF;
386:

Line 387: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,p_old_CURR_LISTS_rec.attribute13)

383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,p_old_CURR_LISTS_rec.attribute13)
388: THEN
389: NULL;
390: END IF;
391:

Line 392: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,p_old_CURR_LISTS_rec.attribute14)

388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,p_old_CURR_LISTS_rec.attribute14)
393: THEN
394: NULL;
395: END IF;
396:

Line 397: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,p_old_CURR_LISTS_rec.attribute15)

393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,p_old_CURR_LISTS_rec.attribute15)
398: THEN
399: NULL;
400: END IF;
401:

Line 402: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,p_old_CURR_LISTS_rec.attribute2)

398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,p_old_CURR_LISTS_rec.attribute2)
403: THEN
404: NULL;
405: END IF;
406:

Line 407: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,p_old_CURR_LISTS_rec.attribute3)

403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,p_old_CURR_LISTS_rec.attribute3)
408: THEN
409: NULL;
410: END IF;
411:

Line 412: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,p_old_CURR_LISTS_rec.attribute4)

408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,p_old_CURR_LISTS_rec.attribute4)
413: THEN
414: NULL;
415: END IF;
416:

Line 417: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,p_old_CURR_LISTS_rec.attribute5)

413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,p_old_CURR_LISTS_rec.attribute5)
418: THEN
419: NULL;
420: END IF;
421:

Line 422: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,p_old_CURR_LISTS_rec.attribute6)

418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,p_old_CURR_LISTS_rec.attribute6)
423: THEN
424: NULL;
425: END IF;
426:

Line 427: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,p_old_CURR_LISTS_rec.attribute7)

423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,p_old_CURR_LISTS_rec.attribute7)
428: THEN
429: NULL;
430: END IF;
431:

Line 432: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,p_old_CURR_LISTS_rec.attribute8)

428: THEN
429: NULL;
430: END IF;
431:
432: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,p_old_CURR_LISTS_rec.attribute8)
433: THEN
434: NULL;
435: END IF;
436:

Line 437: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,p_old_CURR_LISTS_rec.attribute9)

433: THEN
434: NULL;
435: END IF;
436:
437: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,p_old_CURR_LISTS_rec.attribute9)
438: THEN
439: NULL;
440: END IF;
441:

Line 442: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,p_old_CURR_LISTS_rec.base_currency_code)

438: THEN
439: NULL;
440: END IF;
441:
442: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,p_old_CURR_LISTS_rec.base_currency_code)
443: THEN
444: -- Added by Sunil Pandey 10/01/01
445: -- Allow modification of Base_Currency_code only if the currency_list is not attached to
446: -- any Price List

Line 496: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,p_old_CURR_LISTS_rec.context)

492:
493: End;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,p_old_CURR_LISTS_rec.context)
497: THEN
498: NULL;
499: END IF;
500:

Line 501: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,p_old_CURR_LISTS_rec.created_by)

497: THEN
498: NULL;
499: END IF;
500:
501: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,p_old_CURR_LISTS_rec.created_by)
502: THEN
503: NULL;
504: END IF;
505:

Line 506: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,p_old_CURR_LISTS_rec.creation_date)

502: THEN
503: NULL;
504: END IF;
505:
506: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,p_old_CURR_LISTS_rec.creation_date)
507: THEN
508: NULL;
509: END IF;
510:

Line 511: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,p_old_CURR_LISTS_rec.currency_header_id)

507: THEN
508: NULL;
509: END IF;
510:
511: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,p_old_CURR_LISTS_rec.currency_header_id)
512: THEN
513: NULL;
514: END IF;
515:

Line 516: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,p_old_CURR_LISTS_rec.description)

512: THEN
513: NULL;
514: END IF;
515:
516: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,p_old_CURR_LISTS_rec.description)
517: THEN
518: NULL;
519: END IF;
520:

Line 522: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,p_old_CURR_LISTS_rec.base_rounding_factor)

518: NULL;
519: END IF;
520:
521: -- Added by Sunil Pandey 10/01/01
522: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,p_old_CURR_LISTS_rec.base_rounding_factor)
523: THEN
524: NULL;
525: update qp_list_headers_b
526: set rounding_factor = p_CURR_LISTS_rec.base_rounding_factor

Line 530: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,p_old_CURR_LISTS_rec.base_markup_operator)

526: set rounding_factor = p_CURR_LISTS_rec.base_rounding_factor
527: where currency_header_id = p_CURR_LISTS_rec.currency_header_id;
528: END IF;
529:
530: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,p_old_CURR_LISTS_rec.base_markup_operator)
531: THEN
532: NULL;
533: END IF;
534:

Line 535: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,p_old_CURR_LISTS_rec.base_markup_value)

531: THEN
532: NULL;
533: END IF;
534:
535: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,p_old_CURR_LISTS_rec.base_markup_value)
536: THEN
537: NULL;
538: END IF;
539:

Line 540: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,p_old_CURR_LISTS_rec.base_markup_formula_id)

536: THEN
537: NULL;
538: END IF;
539:
540: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,p_old_CURR_LISTS_rec.base_markup_formula_id)
541: THEN
542: NULL;
543: END IF;
544: -- Added by Sunil Pandey 10/01/01

Line 546: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,p_old_CURR_LISTS_rec.last_updated_by)

542: NULL;
543: END IF;
544: -- Added by Sunil Pandey 10/01/01
545:
546: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,p_old_CURR_LISTS_rec.last_updated_by)
547: THEN
548: NULL;
549: END IF;
550:

Line 551: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,p_old_CURR_LISTS_rec.last_update_date)

547: THEN
548: NULL;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,p_old_CURR_LISTS_rec.last_update_date)
552: THEN
553: NULL;
554: END IF;
555:

Line 556: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,p_old_CURR_LISTS_rec.last_update_login)

552: THEN
553: NULL;
554: END IF;
555:
556: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,p_old_CURR_LISTS_rec.last_update_login)
557: THEN
558: NULL;
559: END IF;
560:

Line 561: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,p_old_CURR_LISTS_rec.name)

557: THEN
558: NULL;
559: END IF;
560:
561: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,p_old_CURR_LISTS_rec.name)
562: THEN
563: NULL;
564: END IF;
565:

Line 566: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,p_old_CURR_LISTS_rec.program_application_id)

562: THEN
563: NULL;
564: END IF;
565:
566: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,p_old_CURR_LISTS_rec.program_application_id)
567: THEN
568: NULL;
569: END IF;
570:

Line 571: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,p_old_CURR_LISTS_rec.program_id)

567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,p_old_CURR_LISTS_rec.program_id)
572: THEN
573: NULL;
574: END IF;
575:

Line 576: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,p_old_CURR_LISTS_rec.program_update_date)

572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,p_old_CURR_LISTS_rec.program_update_date)
577: THEN
578: NULL;
579: END IF;
580:

Line 581: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,p_old_CURR_LISTS_rec.request_id)

577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,p_old_CURR_LISTS_rec.request_id)
582: THEN
583: NULL;
584: END IF;
585:

Line 587: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,p_old_CURR_LISTS_rec.row_id)

583: NULL;
584: END IF;
585:
586: /* Commented by Sunil
587: IF NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,p_old_CURR_LISTS_rec.row_id)
588: THEN
589: NULL;
590: END IF;
591: Commented by Sunil */

Line 1512: IF QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,

1508: -- FOR UPDATE NOWAIT;
1509:
1510: -- Row locked. Compare IN attributes to DB attributes.
1511:
1512: IF QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,
1513: l_CURR_LISTS_rec.attribute1)
1514: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,
1515: l_CURR_LISTS_rec.attribute10)
1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,

Line 1514: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,

1510: -- Row locked. Compare IN attributes to DB attributes.
1511:
1512: IF QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,
1513: l_CURR_LISTS_rec.attribute1)
1514: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,
1515: l_CURR_LISTS_rec.attribute10)
1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,
1517: l_CURR_LISTS_rec.attribute11)
1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,

Line 1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,

1512: IF QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute1,
1513: l_CURR_LISTS_rec.attribute1)
1514: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,
1515: l_CURR_LISTS_rec.attribute10)
1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,
1517: l_CURR_LISTS_rec.attribute11)
1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,
1519: l_CURR_LISTS_rec.attribute12)
1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,

Line 1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,

1514: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute10,
1515: l_CURR_LISTS_rec.attribute10)
1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,
1517: l_CURR_LISTS_rec.attribute11)
1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,
1519: l_CURR_LISTS_rec.attribute12)
1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,
1521: l_CURR_LISTS_rec.attribute13)
1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,

Line 1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,

1516: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute11,
1517: l_CURR_LISTS_rec.attribute11)
1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,
1519: l_CURR_LISTS_rec.attribute12)
1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,
1521: l_CURR_LISTS_rec.attribute13)
1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,
1523: l_CURR_LISTS_rec.attribute14)
1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,

Line 1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,

1518: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute12,
1519: l_CURR_LISTS_rec.attribute12)
1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,
1521: l_CURR_LISTS_rec.attribute13)
1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,
1523: l_CURR_LISTS_rec.attribute14)
1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,
1525: l_CURR_LISTS_rec.attribute15)
1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,

Line 1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,

1520: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute13,
1521: l_CURR_LISTS_rec.attribute13)
1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,
1523: l_CURR_LISTS_rec.attribute14)
1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,
1525: l_CURR_LISTS_rec.attribute15)
1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,
1527: l_CURR_LISTS_rec.attribute2)
1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,

Line 1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,

1522: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute14,
1523: l_CURR_LISTS_rec.attribute14)
1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,
1525: l_CURR_LISTS_rec.attribute15)
1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,
1527: l_CURR_LISTS_rec.attribute2)
1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,
1529: l_CURR_LISTS_rec.attribute3)
1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,

Line 1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,

1524: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute15,
1525: l_CURR_LISTS_rec.attribute15)
1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,
1527: l_CURR_LISTS_rec.attribute2)
1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,
1529: l_CURR_LISTS_rec.attribute3)
1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,
1531: l_CURR_LISTS_rec.attribute4)
1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,

Line 1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,

1526: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute2,
1527: l_CURR_LISTS_rec.attribute2)
1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,
1529: l_CURR_LISTS_rec.attribute3)
1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,
1531: l_CURR_LISTS_rec.attribute4)
1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,
1533: l_CURR_LISTS_rec.attribute5)
1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,

Line 1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,

1528: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute3,
1529: l_CURR_LISTS_rec.attribute3)
1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,
1531: l_CURR_LISTS_rec.attribute4)
1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,
1533: l_CURR_LISTS_rec.attribute5)
1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,
1535: l_CURR_LISTS_rec.attribute6)
1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,

Line 1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,

1530: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute4,
1531: l_CURR_LISTS_rec.attribute4)
1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,
1533: l_CURR_LISTS_rec.attribute5)
1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,
1535: l_CURR_LISTS_rec.attribute6)
1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,
1537: l_CURR_LISTS_rec.attribute7)
1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,

Line 1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,

1532: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute5,
1533: l_CURR_LISTS_rec.attribute5)
1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,
1535: l_CURR_LISTS_rec.attribute6)
1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,
1537: l_CURR_LISTS_rec.attribute7)
1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,
1539: l_CURR_LISTS_rec.attribute8)
1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,

Line 1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,

1534: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute6,
1535: l_CURR_LISTS_rec.attribute6)
1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,
1537: l_CURR_LISTS_rec.attribute7)
1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,
1539: l_CURR_LISTS_rec.attribute8)
1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,
1541: l_CURR_LISTS_rec.attribute9)
1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,

Line 1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,

1536: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute7,
1537: l_CURR_LISTS_rec.attribute7)
1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,
1539: l_CURR_LISTS_rec.attribute8)
1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,
1541: l_CURR_LISTS_rec.attribute9)
1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1543: l_CURR_LISTS_rec.base_currency_code)
1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,

Line 1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,

1538: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute8,
1539: l_CURR_LISTS_rec.attribute8)
1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,
1541: l_CURR_LISTS_rec.attribute9)
1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1543: l_CURR_LISTS_rec.base_currency_code)
1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,
1545: l_CURR_LISTS_rec.context)
1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,

Line 1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,

1540: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.attribute9,
1541: l_CURR_LISTS_rec.attribute9)
1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1543: l_CURR_LISTS_rec.base_currency_code)
1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,
1545: l_CURR_LISTS_rec.context)
1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,
1547: l_CURR_LISTS_rec.created_by)
1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,

Line 1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,

1542: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1543: l_CURR_LISTS_rec.base_currency_code)
1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,
1545: l_CURR_LISTS_rec.context)
1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,
1547: l_CURR_LISTS_rec.created_by)
1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,
1549: l_CURR_LISTS_rec.creation_date)
1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,

Line 1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,

1544: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.context,
1545: l_CURR_LISTS_rec.context)
1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,
1547: l_CURR_LISTS_rec.created_by)
1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,
1549: l_CURR_LISTS_rec.creation_date)
1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1551: l_CURR_LISTS_rec.currency_header_id)
1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,

Line 1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,

1546: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.created_by,
1547: l_CURR_LISTS_rec.created_by)
1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,
1549: l_CURR_LISTS_rec.creation_date)
1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1551: l_CURR_LISTS_rec.currency_header_id)
1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,
1553: l_CURR_LISTS_rec.description)
1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,

Line 1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,

1548: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.creation_date,
1549: l_CURR_LISTS_rec.creation_date)
1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1551: l_CURR_LISTS_rec.currency_header_id)
1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,
1553: l_CURR_LISTS_rec.description)
1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,
1555: l_CURR_LISTS_rec.last_updated_by)
1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,

Line 1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,

1550: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1551: l_CURR_LISTS_rec.currency_header_id)
1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,
1553: l_CURR_LISTS_rec.description)
1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,
1555: l_CURR_LISTS_rec.last_updated_by)
1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,
1557: l_CURR_LISTS_rec.last_update_date)
1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,

Line 1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,

1552: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.description,
1553: l_CURR_LISTS_rec.description)
1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,
1555: l_CURR_LISTS_rec.last_updated_by)
1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,
1557: l_CURR_LISTS_rec.last_update_date)
1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,
1559: l_CURR_LISTS_rec.last_update_login)
1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,

Line 1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,

1554: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_updated_by,
1555: l_CURR_LISTS_rec.last_updated_by)
1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,
1557: l_CURR_LISTS_rec.last_update_date)
1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,
1559: l_CURR_LISTS_rec.last_update_login)
1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,
1561: l_CURR_LISTS_rec.name)
1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,

Line 1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,

1556: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_date,
1557: l_CURR_LISTS_rec.last_update_date)
1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,
1559: l_CURR_LISTS_rec.last_update_login)
1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,
1561: l_CURR_LISTS_rec.name)
1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,
1563: l_CURR_LISTS_rec.program_application_id)
1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,

Line 1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,

1558: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.last_update_login,
1559: l_CURR_LISTS_rec.last_update_login)
1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,
1561: l_CURR_LISTS_rec.name)
1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,
1563: l_CURR_LISTS_rec.program_application_id)
1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,
1565: l_CURR_LISTS_rec.program_id)
1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,

Line 1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,

1560: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.name,
1561: l_CURR_LISTS_rec.name)
1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,
1563: l_CURR_LISTS_rec.program_application_id)
1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,
1565: l_CURR_LISTS_rec.program_id)
1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,
1567: l_CURR_LISTS_rec.program_update_date)
1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,

Line 1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,

1562: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_application_id,
1563: l_CURR_LISTS_rec.program_application_id)
1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,
1565: l_CURR_LISTS_rec.program_id)
1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,
1567: l_CURR_LISTS_rec.program_update_date)
1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,
1569: l_CURR_LISTS_rec.request_id)
1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,

Line 1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,

1564: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_id,
1565: l_CURR_LISTS_rec.program_id)
1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,
1567: l_CURR_LISTS_rec.program_update_date)
1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,
1569: l_CURR_LISTS_rec.request_id)
1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,
1571: l_CURR_LISTS_rec.base_rounding_factor)
1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,

Line 1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,

1566: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.program_update_date,
1567: l_CURR_LISTS_rec.program_update_date)
1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,
1569: l_CURR_LISTS_rec.request_id)
1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,
1571: l_CURR_LISTS_rec.base_rounding_factor)
1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,
1573: l_CURR_LISTS_rec.base_markup_value)
1574: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,

Line 1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,

1568: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.request_id,
1569: l_CURR_LISTS_rec.request_id)
1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,
1571: l_CURR_LISTS_rec.base_rounding_factor)
1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,
1573: l_CURR_LISTS_rec.base_markup_value)
1574: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,
1575: l_CURR_LISTS_rec.base_markup_operator)
1576: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,

Line 1574: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,

1570: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_rounding_factor,
1571: l_CURR_LISTS_rec.base_rounding_factor)
1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,
1573: l_CURR_LISTS_rec.base_markup_value)
1574: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,
1575: l_CURR_LISTS_rec.base_markup_operator)
1576: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
1577: l_CURR_LISTS_rec.base_markup_formula_id)
1578: /* Commented by Sunil

Line 1576: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,

1572: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_value,
1573: l_CURR_LISTS_rec.base_markup_value)
1574: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_operator,
1575: l_CURR_LISTS_rec.base_markup_operator)
1576: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
1577: l_CURR_LISTS_rec.base_markup_formula_id)
1578: /* Commented by Sunil
1579: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,
1580: l_CURR_LISTS_rec.row_id)

Line 1579: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,

1575: l_CURR_LISTS_rec.base_markup_operator)
1576: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
1577: l_CURR_LISTS_rec.base_markup_formula_id)
1578: /* Commented by Sunil
1579: AND QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,
1580: l_CURR_LISTS_rec.row_id)
1581: Commented by Sunil */
1582: THEN
1583:

Line 1665: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,

1661:
1662: -- oe_debug_pub.add('. ENTERED QP_Curr_Lists_Util.Get_Values');
1663: IF p_CURR_LISTS_rec.base_currency_code IS NOT NULL AND
1664: p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR AND
1665: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1666: p_old_CURR_LISTS_rec.base_currency_code)
1667: THEN
1668: l_CURR_LISTS_val_rec.base_currency := QP_Id_To_Value.Base_Currency
1669: ( p_base_currency_code => p_CURR_LISTS_rec.base_currency_code

Line 1675: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,

1671: END IF;
1672:
1673: IF p_CURR_LISTS_rec.currency_header_id IS NOT NULL AND
1674: p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM AND
1675: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1676: p_old_CURR_LISTS_rec.currency_header_id)
1677: THEN
1678: l_CURR_LISTS_val_rec.currency_header := QP_Id_To_Value.Currency_Header
1679: ( p_currency_header_id => p_CURR_LISTS_rec.currency_header_id

Line 1687: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,

1683: /*
1684: -- Added by Sunil Pandey 10/01/01
1685: IF p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL AND
1686: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_CHAR AND
1687: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
1688: p_old_CURR_LISTS_rec.base_markup_formula_id)
1689: THEN
1690: l_CURR_LISTS_val_rec.base_markup_formula := QP_Id_To_Value.Base_Markup_Formula
1691: ( p_base_markup_formula_id => p_CURR_LISTS_rec.base_markup_formula_id

Line 1700: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,

1696:
1697: /* Commented by Sunil
1698: IF p_CURR_LISTS_rec.row_id IS NOT NULL AND
1699: p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_NUM AND
1700: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,
1701: p_old_CURR_LISTS_rec.row_id)
1702: THEN
1703: l_CURR_LISTS_val_rec.row := QP_Id_To_Value.Row
1704: ( p_row_id => p_CURR_LISTS_rec.row_id