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_DETAILS_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_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_DETAILS_rec.attribute1,p_old_CURR_DETAILS_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_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)

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

Line 44: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)

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

Line 50: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)

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

Line 56: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)

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

Line 62: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)

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

Line 68: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)

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

Line 74: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)

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

Line 80: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)

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

Line 86: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)

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

Line 92: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)

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

Line 98: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)

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

Line 104: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)

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

Line 110: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)

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

Line 116: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)

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

Line 122: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
138: END IF;

Line 141: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)

137: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
138: END IF;
139:
140: /*
141: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
145: END IF;

Line 148: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)

144: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
145: END IF;
146: */
147:
148: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
152: END IF;

Line 154: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)

150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
152: END IF;
153:
154: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
158: END IF;

Line 160: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)

156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
164: END IF;

Line 166: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)

162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
170: END IF;

Line 172: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)

168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
176: END IF;

Line 178: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)

174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
182: END IF;

Line 184: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)

180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
188: END IF;

Line 190: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)

186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
194: END IF;

Line 196: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)

192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
200: END IF;

Line 202: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)

198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
206: END IF;

Line 208: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)

204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
212: END IF;

Line 214: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)

210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
218: END IF;

Line 220: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)

216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
224: END IF;

Line 226: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)

222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
230: END IF;

Line 232: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)

228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
236: END IF;

Line 238: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)

234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
242: END IF;

Line 244: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)

240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
248: END IF;

Line 250: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)

246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
254: END IF;

Line 256: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)

252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
260: END IF;

Line 262: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,

258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
263: p_old_CURR_DETAILS_rec.selling_rounding_factor)
264: THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;

Line 269: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)

265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
267: END IF;
268:
269: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)
270: THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
273: END IF;

Line 275: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)

271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
273: END IF;
274:
275: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
279: END IF;

Line 281: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)

277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
285: END IF;

Line 287: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)

283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
291: END IF;

Line 293: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)

289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
297: END IF;

Line 299: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)

295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
303: END IF;

Line 305: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)

301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;
309: END IF;

Line 469: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)

465: -- Load out NOCOPY record
466:
467: x_CURR_DETAILS_rec := p_CURR_DETAILS_rec;
468:
469: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)
470: THEN
471: NULL;
472: END IF;
473:

Line 474: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)

470: THEN
471: NULL;
472: END IF;
473:
474: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)
475: THEN
476: NULL;
477: END IF;
478:

Line 479: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)

475: THEN
476: NULL;
477: END IF;
478:
479: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)
480: THEN
481: NULL;
482: END IF;
483:

Line 484: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)

480: THEN
481: NULL;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)
485: THEN
486: NULL;
487: END IF;
488:

Line 489: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)

485: THEN
486: NULL;
487: END IF;
488:
489: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)
490: THEN
491: NULL;
492: END IF;
493:

Line 494: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)

490: THEN
491: NULL;
492: END IF;
493:
494: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)
495: THEN
496: NULL;
497: END IF;
498:

Line 499: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)

495: THEN
496: NULL;
497: END IF;
498:
499: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)
500: THEN
501: NULL;
502: END IF;
503:

Line 504: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)

500: THEN
501: NULL;
502: END IF;
503:
504: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)
505: THEN
506: NULL;
507: END IF;
508:

Line 509: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)

505: THEN
506: NULL;
507: END IF;
508:
509: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)
510: THEN
511: NULL;
512: END IF;
513:

Line 514: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)

510: THEN
511: NULL;
512: END IF;
513:
514: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)
515: THEN
516: NULL;
517: END IF;
518:

Line 519: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)

515: THEN
516: NULL;
517: END IF;
518:
519: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)
520: THEN
521: NULL;
522: END IF;
523:

Line 524: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)

520: THEN
521: NULL;
522: END IF;
523:
524: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)
525: THEN
526: NULL;
527: END IF;
528:

Line 529: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)

525: THEN
526: NULL;
527: END IF;
528:
529: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)
530: THEN
531: NULL;
532: END IF;
533:

Line 534: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)

530: THEN
531: NULL;
532: END IF;
533:
534: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)
535: THEN
536: NULL;
537: END IF;
538:

Line 539: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)

535: THEN
536: NULL;
537: END IF;
538:
539: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)
540: THEN
541: NULL;
542: END IF;
543:

Line 544: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)

540: THEN
541: NULL;
542: END IF;
543:
544: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)
545: THEN
546: NULL;
547: END IF;
548:

Line 549: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)

545: THEN
546: NULL;
547: END IF;
548:
549: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)
550: THEN
551: NULL;
552: END IF;
553:

Line 554: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)

550: THEN
551: NULL;
552: END IF;
553:
554: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)
555: THEN
556: NULL;
557: END IF;
558:

Line 560: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)

556: NULL;
557: END IF;
558:
559: /*
560: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)
561: THEN
562: NULL;
563: END IF;
564: */

Line 566: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)

562: NULL;
563: END IF;
564: */
565:
566: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)
567: THEN
568: NULL;
569: END IF;
570:

Line 571: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)

567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)
572: THEN
573: NULL;
574: END IF;
575:

Line 576: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)

572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)
577: THEN
578: NULL;
579: END IF;
580:

Line 581: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)

577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)
582: THEN
583: NULL;
584: END IF;
585:

Line 586: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)

582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)
587: THEN
588: NULL;
589: END IF;
590:

Line 591: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)

587: THEN
588: NULL;
589: END IF;
590:
591: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)
592: THEN
593: NULL;
594: END IF;
595:

Line 596: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)

592: THEN
593: NULL;
594: END IF;
595:
596: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)
597: THEN
598: NULL;
599: END IF;
600:

Line 601: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)

597: THEN
598: NULL;
599: END IF;
600:
601: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
602: THEN
603: NULL;
604: END IF;
605:

Line 606: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)

602: THEN
603: NULL;
604: END IF;
605:
606: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
607: THEN
608: NULL;
609: END IF;
610:

Line 611: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)

607: THEN
608: NULL;
609: END IF;
610:
611: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
612: THEN
613: NULL;
614: END IF;
615:

Line 616: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)

612: THEN
613: NULL;
614: END IF;
615:
616: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)
617: THEN
618: NULL;
619: END IF;
620:

Line 621: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)

617: THEN
618: NULL;
619: END IF;
620:
621: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)
622: THEN
623: NULL;
624: END IF;
625:

Line 626: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)

622: THEN
623: NULL;
624: END IF;
625:
626: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)
627: THEN
628: NULL;
629: END IF;
630:

Line 631: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)

627: THEN
628: NULL;
629: END IF;
630:
631: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)
632: THEN
633: NULL;
634: END IF;
635:

Line 636: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)

632: THEN
633: NULL;
634: END IF;
635:
636: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)
637: THEN
638: NULL;
639: END IF;
640:

Line 641: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)

637: THEN
638: NULL;
639: END IF;
640:
641: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)
642: THEN
643: NULL;
644: END IF;
645:

Line 646: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)

642: THEN
643: NULL;
644: END IF;
645:
646: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
647: THEN
648: NULL;
649: END IF;
650:

Line 651: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)

647: THEN
648: NULL;
649: END IF;
650:
651: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)
652: THEN
653: NULL;
654: END IF;
655:

Line 656: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)

652: THEN
653: NULL;
654: END IF;
655:
656: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)
657: THEN
658: NULL;
659: END IF;
660:

Line 661: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,

657: THEN
658: NULL;
659: END IF;
660:
661: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
662: p_old_CURR_DETAILS_rec.selling_rounding_factor)
663: THEN
664: oe_debug_pub.add('Logging a request to validate unique selling rounding factor');
665:

Line 667: p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS,

663: THEN
664: oe_debug_pub.add('Logging a request to validate unique selling rounding factor');
665:
666: qp_delayed_requests_PVT.log_request(
667: p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS,
668: p_entity_id => p_CURR_DETAILS_rec.currency_header_id,
669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,

Line 671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,

667: p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS,
668: p_entity_id => p_CURR_DETAILS_rec.currency_header_id,
669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,
672: p_requesting_entity_id => p_CURR_DETAILS_rec.currency_header_id,
673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;

Line 673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,

669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,
672: p_requesting_entity_id => p_CURR_DETAILS_rec.currency_header_id,
673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;
676:
677: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)

Line 677: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)

673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;
676:
677: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)
678: THEN
679: NULL;
680: END IF;
681:

Line 682: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)

678: THEN
679: NULL;
680: END IF;
681:
682: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)
683: THEN
684: NULL;
685: END IF;
686:

Line 687: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)

683: THEN
684: NULL;
685: END IF;
686:
687: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)
688: THEN
689: NULL;
690: END IF;
691:

Line 692: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)

688: THEN
689: NULL;
690: END IF;
691:
692: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)
693: THEN
694: NULL;
695: END IF;
696:

Line 697: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)

693: THEN
694: NULL;
695: END IF;
696:
697: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)
698: THEN
699: NULL;
700: END IF;
701:

Line 702: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)

698: THEN
699: NULL;
700: END IF;
701:
702: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)
703: THEN
704: NULL;
705: END IF;
706:

Line 707: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)

703: THEN
704: NULL;
705: END IF;
706:
707: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)
708: THEN
709: NULL;
710: END IF;
711:

Line 1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,

1664: FOR UPDATE NOWAIT;
1665:
1666: -- Row locked. Compare IN attributes to DB attributes.
1667:
1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,

Line 1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,

1666: -- Row locked. Compare IN attributes to DB attributes.
1667:
1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,

Line 1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,

1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,

Line 1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,

1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,

Line 1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,

1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,

Line 1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,

1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,

Line 1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,

1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,

Line 1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,

1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,

Line 1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,

1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,

Line 1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,

1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,

Line 1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,

1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,

Line 1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,

1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,

Line 1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,

1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,

Line 1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,

1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,

Line 1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,

1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,

Line 1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,

1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,

Line 1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,

1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,

Line 1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,

1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,

Line 1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,

1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,

Line 1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,

1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,

Line 1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,

1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,

Line 1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,

1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,

Line 1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,

1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,

Line 1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,

1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,

Line 1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,

1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,

Line 1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,

1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,

Line 1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,

1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,

Line 1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,

1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,

Line 1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,

1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,

Line 1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,

1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,

Line 1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,

1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,

Line 1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,

1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,

Line 1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,

1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,

Line 1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,

1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,

Line 1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,

1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,

Line 1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,

1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,

Line 1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,

1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,

Line 1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,

1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,

Line 1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,

1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,

Line 1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,

1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,

Line 1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,

1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,

Line 1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,

1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,

Line 1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,

1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,

Line 1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,

1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,

Line 1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,

1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
1759: l_CURR_DETAILS_rec.precedence)
1760: THEN

Line 1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,

1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
1759: l_CURR_DETAILS_rec.precedence)
1760: THEN
1761:
1762: -- Row has not changed. Set out parameter.

Line 1842: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,

1838: BEGIN
1839:
1840: IF p_CURR_DETAILS_rec.currency_detail_id IS NOT NULL AND
1841: p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM AND
1842: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1843: p_old_CURR_DETAILS_rec.currency_detail_id)
1844: THEN
1845: l_CURR_DETAILS_val_rec.currency_detail := QP_Id_To_Value.Currency_Detail
1846: ( p_currency_detail_id => p_CURR_DETAILS_rec.currency_detail_id

Line 1852: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,

1848: END IF;
1849:
1850: IF p_CURR_DETAILS_rec.currency_header_id IS NOT NULL AND
1851: p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM AND
1852: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1853: p_old_CURR_DETAILS_rec.currency_header_id)
1854: THEN
1855: l_CURR_DETAILS_val_rec.currency_header := QP_Id_To_Value.Currency_Header
1856: ( p_currency_header_id => p_CURR_DETAILS_rec.currency_header_id

Line 1862: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,

1858: END IF;
1859:
1860: IF p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL AND
1861: p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM AND
1862: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1863: p_old_CURR_DETAILS_rec.markup_formula_id)
1864: THEN
1865: l_CURR_DETAILS_val_rec.markup_formula := QP_Id_To_Value.Markup_Formula
1866: ( p_markup_formula_id => p_CURR_DETAILS_rec.markup_formula_id

Line 1872: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,

1868: END IF;
1869:
1870: IF p_CURR_DETAILS_rec.price_formula_id IS NOT NULL AND
1871: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1872: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1873: p_old_CURR_DETAILS_rec.price_formula_id)
1874: THEN
1875: l_CURR_DETAILS_val_rec.price_formula := QP_Id_To_Value.Price_Formula
1876: ( p_price_formula_id => p_CURR_DETAILS_rec.price_formula_id

Line 1882: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,

1878: END IF;
1879:
1880: IF p_CURR_DETAILS_rec.to_currency_code IS NOT NULL AND
1881: p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR AND
1882: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1883: p_old_CURR_DETAILS_rec.to_currency_code)
1884: THEN
1885: l_CURR_DETAILS_val_rec.to_currency := QP_Id_To_Value.To_Currency
1886: ( p_to_currency_code => p_CURR_DETAILS_rec.to_currency_code