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_CURR_DETAILS_UTIL

Line 1: PACKAGE BODY QP_Curr_Details_Util AS

1: PACKAGE BODY QP_Curr_Details_Util AS
2: /* $Header: QPXUCDTB.pls 120.1.12010000.2 2008/10/19 08:40:54 hmohamme ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Curr_Details_Util';

2: /* $Header: QPXUCDTB.pls 120.1.12010000.2 2008/10/19 08:40:54 hmohamme ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Curr_Details_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;

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;
37:
38: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;

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;
43:
44: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;

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;
49:
50: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;

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;
55:
56: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;

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;
61:
62: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;

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;
67:
68: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;

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;
73:
74: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;

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;
79:
80: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;

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;
85:
86: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;

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;
91:
92: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;

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;
97:
98: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;

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;
103:
104: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;

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;
109:
110: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;

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;
115:
116: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;

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;
121:
122: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;

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;
127:
128: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;

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;
133:
134: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)
135: THEN

Line 137: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;

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;
139:
140: /*
141: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)

Line 144: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;

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;
146: */
147:
148: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)

Line 151: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;

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;
153:
154: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)
155: THEN

Line 157: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;

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;
159:
160: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)
161: THEN

Line 163: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;

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;
165:
166: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)
167: THEN

Line 169: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;

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;
171:
172: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)
173: THEN

Line 175: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;

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;
177:
178: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)
179: THEN

Line 181: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;

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;
183:
184: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)
185: THEN

Line 187: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;

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;
189:
190: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
191: THEN

Line 193: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;

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;
195:
196: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
197: THEN

Line 199: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;

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;
201:
202: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
203: THEN

Line 205: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;

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;
207:
208: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)
209: THEN

Line 211: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;

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;
213:
214: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)
215: THEN

Line 217: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;

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;
219:
220: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)
221: THEN

Line 223: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;

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;
225:
226: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)
227: THEN

Line 229: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;

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;
231:
232: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)
233: THEN

Line 235: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;

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;
237:
238: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)
239: THEN

Line 241: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;

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;
243:
244: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
245: THEN

Line 247: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;

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;
249:
250: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)
251: THEN

Line 253: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;

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;
255:
256: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)
257: THEN

Line 259: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;

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;
261:
262: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
263: p_old_CURR_DETAILS_rec.selling_rounding_factor)

Line 266: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;

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;
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

Line 272: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;

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;
274:
275: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)
276: THEN

Line 278: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;

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;
280:
281: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)
282: THEN

Line 284: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;

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;
286:
287: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)
288: THEN

Line 290: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;

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;
292:
293: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)
294: THEN

Line 296: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;

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;
298:
299: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)
300: THEN

Line 302: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;

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;
304:
305: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)
306: THEN

Line 308: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;

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;
310:
311: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
312: l_index := l_index + 1;

Line 313: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;

309: END IF;
310:
311: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;
314: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;
317: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 316: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;

312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;
314: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;
317: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;
320: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 319: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;

315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;
317: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;
320: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;
323: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 322: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;

318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;
320: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;
323: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;
326: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 325: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;

321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;
323: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;
326: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;
329: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 328: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;

324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;
326: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;
329: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;
332: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 331: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;

327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;
329: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;
332: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;
335: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 334: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;

330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;
332: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;
335: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;
338: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 337: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;

333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;
335: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;
338: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;
341: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 340: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;

336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;
338: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;
341: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;
344: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 343: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;

339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;
341: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;
344: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;
347: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 346: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;

342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;
344: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;
347: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;
350: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 349: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;

345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;
347: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;
350: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;
353: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 352: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;

348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;
350: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;
353: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
356: ELSIF p_attr_id = G_CONTEXT THEN

Line 355: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;

351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;
353: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
356: ELSIF p_attr_id = G_CONTEXT THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
359: ELSIF p_attr_id = G_CONVERSION_DATE THEN

Line 358: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;

354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
356: ELSIF p_attr_id = G_CONTEXT THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
359: ELSIF p_attr_id = G_CONVERSION_DATE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
362: ELSIF p_attr_id = G_CONVERSION_DATE_TYPE THEN

Line 361: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;

357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
359: ELSIF p_attr_id = G_CONVERSION_DATE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
362: ELSIF p_attr_id = G_CONVERSION_DATE_TYPE THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
365: -- ELSIF p_attr_id = G_CONVERSION_METHOD THEN

Line 364: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;

360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
362: ELSIF p_attr_id = G_CONVERSION_DATE_TYPE THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
365: -- ELSIF p_attr_id = G_CONVERSION_METHOD THEN
366: -- l_index := l_index + 1;
367: -- l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
368: ELSIF p_attr_id = G_CONVERSION_TYPE THEN

Line 367: -- l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;

363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
365: -- ELSIF p_attr_id = G_CONVERSION_METHOD THEN
366: -- l_index := l_index + 1;
367: -- l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
368: ELSIF p_attr_id = G_CONVERSION_TYPE THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
371: ELSIF p_attr_id = G_CREATED_BY THEN

Line 370: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;

366: -- l_index := l_index + 1;
367: -- l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
368: ELSIF p_attr_id = G_CONVERSION_TYPE THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
371: ELSIF p_attr_id = G_CREATED_BY THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
374: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 373: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;

369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
371: ELSIF p_attr_id = G_CREATED_BY THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
374: ELSIF p_attr_id = G_CREATION_DATE THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
377: ELSIF p_attr_id = G_CURRENCY_DETAIL THEN

Line 376: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
374: ELSIF p_attr_id = G_CREATION_DATE THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
377: ELSIF p_attr_id = G_CURRENCY_DETAIL THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
380: ELSIF p_attr_id = G_CURRENCY_HEADER THEN

Line 379: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
377: ELSIF p_attr_id = G_CURRENCY_DETAIL THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
380: ELSIF p_attr_id = G_CURRENCY_HEADER THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
383: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 382: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
380: ELSIF p_attr_id = G_CURRENCY_HEADER THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
383: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
386: ELSIF p_attr_id = G_FIXED_VALUE THEN

Line 385: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
383: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
386: ELSIF p_attr_id = G_FIXED_VALUE THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
389: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 388: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
386: ELSIF p_attr_id = G_FIXED_VALUE THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
389: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
392: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 391: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
389: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
392: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
395: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 394: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
392: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
395: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
398: ELSIF p_attr_id = G_MARKUP_FORMULA THEN

Line 397: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
395: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
398: ELSIF p_attr_id = G_MARKUP_FORMULA THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
401: ELSIF p_attr_id = G_MARKUP_OPERATOR THEN

Line 400: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
398: ELSIF p_attr_id = G_MARKUP_FORMULA THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
401: ELSIF p_attr_id = G_MARKUP_OPERATOR THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
404: ELSIF p_attr_id = G_MARKUP_VALUE THEN

Line 403: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
401: ELSIF p_attr_id = G_MARKUP_OPERATOR THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
404: ELSIF p_attr_id = G_MARKUP_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
407: ELSIF p_attr_id = G_PRICE_FORMULA THEN

Line 406: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
404: ELSIF p_attr_id = G_MARKUP_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
407: ELSIF p_attr_id = G_PRICE_FORMULA THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
410: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 409: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
407: ELSIF p_attr_id = G_PRICE_FORMULA THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
410: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
413: ELSIF p_attr_id = G_PROGRAM THEN

Line 412: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
410: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
413: ELSIF p_attr_id = G_PROGRAM THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
416: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 415: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
413: ELSIF p_attr_id = G_PROGRAM THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
416: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
419: ELSIF p_attr_id = G_REQUEST THEN

Line 418: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
416: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
419: ELSIF p_attr_id = G_REQUEST THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
422: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN

Line 421: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;

417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
419: ELSIF p_attr_id = G_REQUEST THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
422: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
425: ELSIF p_attr_id = G_SELLING_ROUNDING_FACTOR THEN

Line 424: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;

420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
422: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
425: ELSIF p_attr_id = G_SELLING_ROUNDING_FACTOR THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
428: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 427: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;

423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
425: ELSIF p_attr_id = G_SELLING_ROUNDING_FACTOR THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
428: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
431: ELSIF p_attr_id = G_TO_CURRENCY THEN

Line 430: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;

426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
428: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
431: ELSIF p_attr_id = G_TO_CURRENCY THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
434: ELSIF p_attr_id = G_CURR_ATTRIBUTE_TYPE THEN

Line 433: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;

429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
431: ELSIF p_attr_id = G_TO_CURRENCY THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
434: ELSIF p_attr_id = G_CURR_ATTRIBUTE_TYPE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
437: ELSIF p_attr_id = G_CURR_ATTRIBUTE_CONTEXT THEN

Line 436: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;

432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
434: ELSIF p_attr_id = G_CURR_ATTRIBUTE_TYPE THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
437: ELSIF p_attr_id = G_CURR_ATTRIBUTE_CONTEXT THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
440: ELSIF p_attr_id = G_CURR_ATTRIBUTE THEN

Line 439: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;

435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
437: ELSIF p_attr_id = G_CURR_ATTRIBUTE_CONTEXT THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
440: ELSIF p_attr_id = G_CURR_ATTRIBUTE THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
443: ELSIF p_attr_id = G_CURR_ATTRIBUTE_VALUE THEN

Line 442: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;

438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
440: ELSIF p_attr_id = G_CURR_ATTRIBUTE THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
443: ELSIF p_attr_id = G_CURR_ATTRIBUTE_VALUE THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
446: ELSIF p_attr_id = G_PRECEDENCE THEN

Line 445: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;

441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
443: ELSIF p_attr_id = G_CURR_ATTRIBUTE_VALUE THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
446: ELSIF p_attr_id = G_PRECEDENCE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;
449: END IF;

Line 448: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;

444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
446: ELSIF p_attr_id = G_PRECEDENCE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;
449: END IF;
450:
451: END Clear_Dependent_Attr;
452:

Line 2067: END QP_Curr_Details_Util;

2063: RETURN l_CURR_DETAILS_rec;
2064:
2065: END Get_Ids;
2066:
2067: END QP_Curr_Details_Util;