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.PAY_EXA_UPD dependencies on HR_API

Line 76: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>

72: p_rec.object_version_number);
73: --
74: -- only do U if values have changed
75: --
76: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
77: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
78: or
79: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
80: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

Line 77: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )

73: --
74: -- only do U if values have changed
75: --
76: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
77: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
78: or
79: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
80: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
81: hr_utility.trace('| doing update on combination table');

Line 79: ( nvl(p_rec.prenote_date, hr_api.g_date) <>

75: --
76: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
77: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
78: or
79: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
80: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
81: hr_utility.trace('| doing update on combination table');
82: --
83: -- fresh combination record

Line 80: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

76: if ( nvl(p_rec.territory_code, hr_api.g_varchar2) <>
77: nvl(pay_exa_shd.g_old_rec.territory_code, hr_api.g_varchar2) )
78: or
79: ( nvl(p_rec.prenote_date, hr_api.g_date) <>
80: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
81: hr_utility.trace('| doing update on combination table');
82: --
83: -- fresh combination record
84: --

Line 99: if p_rec.prenote_date = hr_api.g_date then

95: ------------------------------------------------------------------------
96: --
97: -- Check for defaulted prenote_date.
98: --
99: if p_rec.prenote_date = hr_api.g_date then
100: hr_utility.trace('| not updating prenote_date (default passed in)');
101: --
102: -- No change to be made: existing combination's date is not updated,
103: -- and fresh combination must have date clear (for prenotification to

Line 107: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>

103: -- and fresh combination must have date clear (for prenotification to
104: -- take place).
105: --
106: null;
107: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>
108: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
109: hr_utility.trace('| updating prenote_date');
110: --
111: UPDATE PAY_EXTERNAL_ACCOUNTS

Line 108: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then

104: -- take place).
105: --
106: null;
107: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>
108: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
109: hr_utility.trace('| updating prenote_date');
110: --
111: UPDATE PAY_EXTERNAL_ACCOUNTS
112: SET prenote_date = p_rec.prenote_date

Line 130: When hr_api.check_integrity_violated Then

126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
133: pay_exa_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
133: pay_exa_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
138: pay_exa_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated Then

131: -- A check constraint has been violated
132: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
133: pay_exa_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
138: pay_exa_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
138: pay_exa_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
143: pay_exa_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated Then

136: -- Parent integrity has been violated
137: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
138: pay_exa_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
143: pay_exa_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
143: pay_exa_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: pay_exa_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: end update_dml;

Line 256: If (p_rec.territory_code = hr_api.g_varchar2) then

252: -- structure to see if a system default is being used,
253: -- if a system default is being used then we must set to the 'current'
254: -- argument value
255: --
256: If (p_rec.territory_code = hr_api.g_varchar2) then
257: p_rec.territory_code :=
258: pay_exa_shd.g_old_rec.territory_code;
259: End If;
260: --------------------------------------------------------------------------

Line 263: -- If p_prenote_date is defaulted (hr_api.g_varchar2) then no change if

259: End If;
260: --------------------------------------------------------------------------
261: -- bug2307154: do not convert prenote_date if it has been defaulted.
262: --
263: -- If p_prenote_date is defaulted (hr_api.g_varchar2) then no change if
264: -- the update results in an existing flex combination. If the update
265: -- results in a fresh combination the prenote date remains as NULL
266: -- (bug1776298) as prenotification must be done on fresh bank details.
267: --

Line 270: -- will look for hr_api.g_date when it handles the prenote_date.

266: -- (bug1776298) as prenotification must be done on fresh bank details.
267: --
268: -- Note: this is a deviation from the API strategy as convert_defs will
269: -- not convert a defaulted prenote date value, and the update logic
270: -- will look for hr_api.g_date when it handles the prenote_date.
271: --------------------------------------------------------------------------
272: If (p_rec.id_flex_num = hr_api.g_number) then
273: p_rec.id_flex_num :=
274: pay_exa_shd.g_old_rec.id_flex_num;

Line 272: If (p_rec.id_flex_num = hr_api.g_number) then

268: -- Note: this is a deviation from the API strategy as convert_defs will
269: -- not convert a defaulted prenote date value, and the update logic
270: -- will look for hr_api.g_date when it handles the prenote_date.
271: --------------------------------------------------------------------------
272: If (p_rec.id_flex_num = hr_api.g_number) then
273: p_rec.id_flex_num :=
274: pay_exa_shd.g_old_rec.id_flex_num;
275: End If;
276: If (p_rec.summary_flag = hr_api.g_varchar2) then

Line 276: If (p_rec.summary_flag = hr_api.g_varchar2) then

272: If (p_rec.id_flex_num = hr_api.g_number) then
273: p_rec.id_flex_num :=
274: pay_exa_shd.g_old_rec.id_flex_num;
275: End If;
276: If (p_rec.summary_flag = hr_api.g_varchar2) then
277: p_rec.summary_flag :=
278: pay_exa_shd.g_old_rec.summary_flag;
279: End If;
280: If (p_rec.enabled_flag = hr_api.g_varchar2) then

Line 280: If (p_rec.enabled_flag = hr_api.g_varchar2) then

276: If (p_rec.summary_flag = hr_api.g_varchar2) then
277: p_rec.summary_flag :=
278: pay_exa_shd.g_old_rec.summary_flag;
279: End If;
280: If (p_rec.enabled_flag = hr_api.g_varchar2) then
281: p_rec.enabled_flag :=
282: pay_exa_shd.g_old_rec.enabled_flag;
283: End If;
284: If (p_rec.start_date_active = hr_api.g_date) then

Line 284: If (p_rec.start_date_active = hr_api.g_date) then

280: If (p_rec.enabled_flag = hr_api.g_varchar2) then
281: p_rec.enabled_flag :=
282: pay_exa_shd.g_old_rec.enabled_flag;
283: End If;
284: If (p_rec.start_date_active = hr_api.g_date) then
285: p_rec.start_date_active :=
286: pay_exa_shd.g_old_rec.start_date_active;
287: End If;
288: If (p_rec.end_date_active = hr_api.g_date) then

Line 288: If (p_rec.end_date_active = hr_api.g_date) then

284: If (p_rec.start_date_active = hr_api.g_date) then
285: p_rec.start_date_active :=
286: pay_exa_shd.g_old_rec.start_date_active;
287: End If;
288: If (p_rec.end_date_active = hr_api.g_date) then
289: p_rec.end_date_active :=
290: pay_exa_shd.g_old_rec.end_date_active;
291: End If;
292: If (p_rec.segment1 = hr_api.g_varchar2) then

Line 292: If (p_rec.segment1 = hr_api.g_varchar2) then

288: If (p_rec.end_date_active = hr_api.g_date) then
289: p_rec.end_date_active :=
290: pay_exa_shd.g_old_rec.end_date_active;
291: End If;
292: If (p_rec.segment1 = hr_api.g_varchar2) then
293: p_rec.segment1 :=
294: pay_exa_shd.g_old_rec.segment1;
295: End If;
296: If (p_rec.segment2 = hr_api.g_varchar2) then

Line 296: If (p_rec.segment2 = hr_api.g_varchar2) then

292: If (p_rec.segment1 = hr_api.g_varchar2) then
293: p_rec.segment1 :=
294: pay_exa_shd.g_old_rec.segment1;
295: End If;
296: If (p_rec.segment2 = hr_api.g_varchar2) then
297: p_rec.segment2 :=
298: pay_exa_shd.g_old_rec.segment2;
299: End If;
300: If (p_rec.segment3 = hr_api.g_varchar2) then

Line 300: If (p_rec.segment3 = hr_api.g_varchar2) then

296: If (p_rec.segment2 = hr_api.g_varchar2) then
297: p_rec.segment2 :=
298: pay_exa_shd.g_old_rec.segment2;
299: End If;
300: If (p_rec.segment3 = hr_api.g_varchar2) then
301: p_rec.segment3 :=
302: pay_exa_shd.g_old_rec.segment3;
303: End If;
304: If (p_rec.segment4 = hr_api.g_varchar2) then

Line 304: If (p_rec.segment4 = hr_api.g_varchar2) then

300: If (p_rec.segment3 = hr_api.g_varchar2) then
301: p_rec.segment3 :=
302: pay_exa_shd.g_old_rec.segment3;
303: End If;
304: If (p_rec.segment4 = hr_api.g_varchar2) then
305: p_rec.segment4 :=
306: pay_exa_shd.g_old_rec.segment4;
307: End If;
308: If (p_rec.segment5 = hr_api.g_varchar2) then

Line 308: If (p_rec.segment5 = hr_api.g_varchar2) then

304: If (p_rec.segment4 = hr_api.g_varchar2) then
305: p_rec.segment4 :=
306: pay_exa_shd.g_old_rec.segment4;
307: End If;
308: If (p_rec.segment5 = hr_api.g_varchar2) then
309: p_rec.segment5 :=
310: pay_exa_shd.g_old_rec.segment5;
311: End If;
312: If (p_rec.segment6 = hr_api.g_varchar2) then

Line 312: If (p_rec.segment6 = hr_api.g_varchar2) then

308: If (p_rec.segment5 = hr_api.g_varchar2) then
309: p_rec.segment5 :=
310: pay_exa_shd.g_old_rec.segment5;
311: End If;
312: If (p_rec.segment6 = hr_api.g_varchar2) then
313: p_rec.segment6 :=
314: pay_exa_shd.g_old_rec.segment6;
315: End If;
316: If (p_rec.segment7 = hr_api.g_varchar2) then

Line 316: If (p_rec.segment7 = hr_api.g_varchar2) then

312: If (p_rec.segment6 = hr_api.g_varchar2) then
313: p_rec.segment6 :=
314: pay_exa_shd.g_old_rec.segment6;
315: End If;
316: If (p_rec.segment7 = hr_api.g_varchar2) then
317: p_rec.segment7 :=
318: pay_exa_shd.g_old_rec.segment7;
319: End If;
320: If (p_rec.segment8 = hr_api.g_varchar2) then

Line 320: If (p_rec.segment8 = hr_api.g_varchar2) then

316: If (p_rec.segment7 = hr_api.g_varchar2) then
317: p_rec.segment7 :=
318: pay_exa_shd.g_old_rec.segment7;
319: End If;
320: If (p_rec.segment8 = hr_api.g_varchar2) then
321: p_rec.segment8 :=
322: pay_exa_shd.g_old_rec.segment8;
323: End If;
324: If (p_rec.segment9 = hr_api.g_varchar2) then

Line 324: If (p_rec.segment9 = hr_api.g_varchar2) then

320: If (p_rec.segment8 = hr_api.g_varchar2) then
321: p_rec.segment8 :=
322: pay_exa_shd.g_old_rec.segment8;
323: End If;
324: If (p_rec.segment9 = hr_api.g_varchar2) then
325: p_rec.segment9 :=
326: pay_exa_shd.g_old_rec.segment9;
327: End If;
328: If (p_rec.segment10 = hr_api.g_varchar2) then

Line 328: If (p_rec.segment10 = hr_api.g_varchar2) then

324: If (p_rec.segment9 = hr_api.g_varchar2) then
325: p_rec.segment9 :=
326: pay_exa_shd.g_old_rec.segment9;
327: End If;
328: If (p_rec.segment10 = hr_api.g_varchar2) then
329: p_rec.segment10 :=
330: pay_exa_shd.g_old_rec.segment10;
331: End If;
332: If (p_rec.segment11 = hr_api.g_varchar2) then

Line 332: If (p_rec.segment11 = hr_api.g_varchar2) then

328: If (p_rec.segment10 = hr_api.g_varchar2) then
329: p_rec.segment10 :=
330: pay_exa_shd.g_old_rec.segment10;
331: End If;
332: If (p_rec.segment11 = hr_api.g_varchar2) then
333: p_rec.segment11 :=
334: pay_exa_shd.g_old_rec.segment11;
335: End If;
336: If (p_rec.segment12 = hr_api.g_varchar2) then

Line 336: If (p_rec.segment12 = hr_api.g_varchar2) then

332: If (p_rec.segment11 = hr_api.g_varchar2) then
333: p_rec.segment11 :=
334: pay_exa_shd.g_old_rec.segment11;
335: End If;
336: If (p_rec.segment12 = hr_api.g_varchar2) then
337: p_rec.segment12 :=
338: pay_exa_shd.g_old_rec.segment12;
339: End If;
340: If (p_rec.segment13 = hr_api.g_varchar2) then

Line 340: If (p_rec.segment13 = hr_api.g_varchar2) then

336: If (p_rec.segment12 = hr_api.g_varchar2) then
337: p_rec.segment12 :=
338: pay_exa_shd.g_old_rec.segment12;
339: End If;
340: If (p_rec.segment13 = hr_api.g_varchar2) then
341: p_rec.segment13 :=
342: pay_exa_shd.g_old_rec.segment13;
343: End If;
344: If (p_rec.segment14 = hr_api.g_varchar2) then

Line 344: If (p_rec.segment14 = hr_api.g_varchar2) then

340: If (p_rec.segment13 = hr_api.g_varchar2) then
341: p_rec.segment13 :=
342: pay_exa_shd.g_old_rec.segment13;
343: End If;
344: If (p_rec.segment14 = hr_api.g_varchar2) then
345: p_rec.segment14 :=
346: pay_exa_shd.g_old_rec.segment14;
347: End If;
348: If (p_rec.segment15 = hr_api.g_varchar2) then

Line 348: If (p_rec.segment15 = hr_api.g_varchar2) then

344: If (p_rec.segment14 = hr_api.g_varchar2) then
345: p_rec.segment14 :=
346: pay_exa_shd.g_old_rec.segment14;
347: End If;
348: If (p_rec.segment15 = hr_api.g_varchar2) then
349: p_rec.segment15 :=
350: pay_exa_shd.g_old_rec.segment15;
351: End If;
352: If (p_rec.segment16 = hr_api.g_varchar2) then

Line 352: If (p_rec.segment16 = hr_api.g_varchar2) then

348: If (p_rec.segment15 = hr_api.g_varchar2) then
349: p_rec.segment15 :=
350: pay_exa_shd.g_old_rec.segment15;
351: End If;
352: If (p_rec.segment16 = hr_api.g_varchar2) then
353: p_rec.segment16 :=
354: pay_exa_shd.g_old_rec.segment16;
355: End If;
356: If (p_rec.segment17 = hr_api.g_varchar2) then

Line 356: If (p_rec.segment17 = hr_api.g_varchar2) then

352: If (p_rec.segment16 = hr_api.g_varchar2) then
353: p_rec.segment16 :=
354: pay_exa_shd.g_old_rec.segment16;
355: End If;
356: If (p_rec.segment17 = hr_api.g_varchar2) then
357: p_rec.segment17 :=
358: pay_exa_shd.g_old_rec.segment17;
359: End If;
360: If (p_rec.segment18 = hr_api.g_varchar2) then

Line 360: If (p_rec.segment18 = hr_api.g_varchar2) then

356: If (p_rec.segment17 = hr_api.g_varchar2) then
357: p_rec.segment17 :=
358: pay_exa_shd.g_old_rec.segment17;
359: End If;
360: If (p_rec.segment18 = hr_api.g_varchar2) then
361: p_rec.segment18 :=
362: pay_exa_shd.g_old_rec.segment18;
363: End If;
364: If (p_rec.segment19 = hr_api.g_varchar2) then

Line 364: If (p_rec.segment19 = hr_api.g_varchar2) then

360: If (p_rec.segment18 = hr_api.g_varchar2) then
361: p_rec.segment18 :=
362: pay_exa_shd.g_old_rec.segment18;
363: End If;
364: If (p_rec.segment19 = hr_api.g_varchar2) then
365: p_rec.segment19 :=
366: pay_exa_shd.g_old_rec.segment19;
367: End If;
368: If (p_rec.segment20 = hr_api.g_varchar2) then

Line 368: If (p_rec.segment20 = hr_api.g_varchar2) then

364: If (p_rec.segment19 = hr_api.g_varchar2) then
365: p_rec.segment19 :=
366: pay_exa_shd.g_old_rec.segment19;
367: End If;
368: If (p_rec.segment20 = hr_api.g_varchar2) then
369: p_rec.segment20 :=
370: pay_exa_shd.g_old_rec.segment20;
371: End If;
372: If (p_rec.segment21 = hr_api.g_varchar2) then

Line 372: If (p_rec.segment21 = hr_api.g_varchar2) then

368: If (p_rec.segment20 = hr_api.g_varchar2) then
369: p_rec.segment20 :=
370: pay_exa_shd.g_old_rec.segment20;
371: End If;
372: If (p_rec.segment21 = hr_api.g_varchar2) then
373: p_rec.segment21 :=
374: pay_exa_shd.g_old_rec.segment21;
375: End If;
376: If (p_rec.segment22 = hr_api.g_varchar2) then

Line 376: If (p_rec.segment22 = hr_api.g_varchar2) then

372: If (p_rec.segment21 = hr_api.g_varchar2) then
373: p_rec.segment21 :=
374: pay_exa_shd.g_old_rec.segment21;
375: End If;
376: If (p_rec.segment22 = hr_api.g_varchar2) then
377: p_rec.segment22 :=
378: pay_exa_shd.g_old_rec.segment22;
379: End If;
380: If (p_rec.segment23 = hr_api.g_varchar2) then

Line 380: If (p_rec.segment23 = hr_api.g_varchar2) then

376: If (p_rec.segment22 = hr_api.g_varchar2) then
377: p_rec.segment22 :=
378: pay_exa_shd.g_old_rec.segment22;
379: End If;
380: If (p_rec.segment23 = hr_api.g_varchar2) then
381: p_rec.segment23 :=
382: pay_exa_shd.g_old_rec.segment23;
383: End If;
384: If (p_rec.segment24 = hr_api.g_varchar2) then

Line 384: If (p_rec.segment24 = hr_api.g_varchar2) then

380: If (p_rec.segment23 = hr_api.g_varchar2) then
381: p_rec.segment23 :=
382: pay_exa_shd.g_old_rec.segment23;
383: End If;
384: If (p_rec.segment24 = hr_api.g_varchar2) then
385: p_rec.segment24 :=
386: pay_exa_shd.g_old_rec.segment24;
387: End If;
388: If (p_rec.segment25 = hr_api.g_varchar2) then

Line 388: If (p_rec.segment25 = hr_api.g_varchar2) then

384: If (p_rec.segment24 = hr_api.g_varchar2) then
385: p_rec.segment24 :=
386: pay_exa_shd.g_old_rec.segment24;
387: End If;
388: If (p_rec.segment25 = hr_api.g_varchar2) then
389: p_rec.segment25 :=
390: pay_exa_shd.g_old_rec.segment25;
391: End If;
392: If (p_rec.segment26 = hr_api.g_varchar2) then

Line 392: If (p_rec.segment26 = hr_api.g_varchar2) then

388: If (p_rec.segment25 = hr_api.g_varchar2) then
389: p_rec.segment25 :=
390: pay_exa_shd.g_old_rec.segment25;
391: End If;
392: If (p_rec.segment26 = hr_api.g_varchar2) then
393: p_rec.segment26 :=
394: pay_exa_shd.g_old_rec.segment26;
395: End If;
396: If (p_rec.segment27 = hr_api.g_varchar2) then

Line 396: If (p_rec.segment27 = hr_api.g_varchar2) then

392: If (p_rec.segment26 = hr_api.g_varchar2) then
393: p_rec.segment26 :=
394: pay_exa_shd.g_old_rec.segment26;
395: End If;
396: If (p_rec.segment27 = hr_api.g_varchar2) then
397: p_rec.segment27 :=
398: pay_exa_shd.g_old_rec.segment27;
399: End If;
400: If (p_rec.segment28 = hr_api.g_varchar2) then

Line 400: If (p_rec.segment28 = hr_api.g_varchar2) then

396: If (p_rec.segment27 = hr_api.g_varchar2) then
397: p_rec.segment27 :=
398: pay_exa_shd.g_old_rec.segment27;
399: End If;
400: If (p_rec.segment28 = hr_api.g_varchar2) then
401: p_rec.segment28 :=
402: pay_exa_shd.g_old_rec.segment28;
403: End If;
404: If (p_rec.segment29 = hr_api.g_varchar2) then

Line 404: If (p_rec.segment29 = hr_api.g_varchar2) then

400: If (p_rec.segment28 = hr_api.g_varchar2) then
401: p_rec.segment28 :=
402: pay_exa_shd.g_old_rec.segment28;
403: End If;
404: If (p_rec.segment29 = hr_api.g_varchar2) then
405: p_rec.segment29 :=
406: pay_exa_shd.g_old_rec.segment29;
407: End If;
408: If (p_rec.segment30 = hr_api.g_varchar2) then

Line 408: If (p_rec.segment30 = hr_api.g_varchar2) then

404: If (p_rec.segment29 = hr_api.g_varchar2) then
405: p_rec.segment29 :=
406: pay_exa_shd.g_old_rec.segment29;
407: End If;
408: If (p_rec.segment30 = hr_api.g_varchar2) then
409: p_rec.segment30 :=
410: pay_exa_shd.g_old_rec.segment30;
411: End If;
412: --

Line 465: Raise HR_Api.Validate_Enabled;

461: --
462: -- if we are validating then raise the Validate_Enabled exception
463: --
464: If p_validate then
465: Raise HR_Api.Validate_Enabled;
466: End If;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception

Line 470: When HR_Api.Validate_Enabled Then

466: End If;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: Exception
470: When HR_Api.Validate_Enabled Then
471: --
472: -- As the Validate_Enabled exception has been raised
473: -- we must rollback to the savepoint
474: --

Line 484: ,p_prenote_date in date default hr_api.g_date

480: -- ----------------------------------------------------------------------------
481: procedure upd(
482: p_external_account_id in number
483: ,p_territory_code in varchar2
484: ,p_prenote_date in date default hr_api.g_date
485: ,p_object_version_number in out nocopy number
486: ,p_validate in boolean default false
487: ) is
488: --

Line 567: p_segment1 in varchar2 default hr_api.g_varchar2

563: -- ----------------------------------------------------------------------------
564: -- |-------------------------------< upd_or_sel >-----------------------------|
565: -- ----------------------------------------------------------------------------
566: procedure upd_or_sel(
567: p_segment1 in varchar2 default hr_api.g_varchar2
568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 568: ,p_segment2 in varchar2 default hr_api.g_varchar2

564: -- |-------------------------------< upd_or_sel >-----------------------------|
565: -- ----------------------------------------------------------------------------
566: procedure upd_or_sel(
567: p_segment1 in varchar2 default hr_api.g_varchar2
568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 569: ,p_segment3 in varchar2 default hr_api.g_varchar2

565: -- ----------------------------------------------------------------------------
566: procedure upd_or_sel(
567: p_segment1 in varchar2 default hr_api.g_varchar2
568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 570: ,p_segment4 in varchar2 default hr_api.g_varchar2

566: procedure upd_or_sel(
567: p_segment1 in varchar2 default hr_api.g_varchar2
568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 571: ,p_segment5 in varchar2 default hr_api.g_varchar2

567: p_segment1 in varchar2 default hr_api.g_varchar2
568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 572: ,p_segment6 in varchar2 default hr_api.g_varchar2

568: ,p_segment2 in varchar2 default hr_api.g_varchar2
569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 573: ,p_segment7 in varchar2 default hr_api.g_varchar2

569: ,p_segment3 in varchar2 default hr_api.g_varchar2
570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 574: ,p_segment8 in varchar2 default hr_api.g_varchar2

570: ,p_segment4 in varchar2 default hr_api.g_varchar2
571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 575: ,p_segment9 in varchar2 default hr_api.g_varchar2

571: ,p_segment5 in varchar2 default hr_api.g_varchar2
572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 576: ,p_segment10 in varchar2 default hr_api.g_varchar2

572: ,p_segment6 in varchar2 default hr_api.g_varchar2
573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 577: ,p_segment11 in varchar2 default hr_api.g_varchar2

573: ,p_segment7 in varchar2 default hr_api.g_varchar2
574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 578: ,p_segment12 in varchar2 default hr_api.g_varchar2

574: ,p_segment8 in varchar2 default hr_api.g_varchar2
575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 579: ,p_segment13 in varchar2 default hr_api.g_varchar2

575: ,p_segment9 in varchar2 default hr_api.g_varchar2
576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 580: ,p_segment14 in varchar2 default hr_api.g_varchar2

576: ,p_segment10 in varchar2 default hr_api.g_varchar2
577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 581: ,p_segment15 in varchar2 default hr_api.g_varchar2

577: ,p_segment11 in varchar2 default hr_api.g_varchar2
578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 582: ,p_segment16 in varchar2 default hr_api.g_varchar2

578: ,p_segment12 in varchar2 default hr_api.g_varchar2
579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 583: ,p_segment17 in varchar2 default hr_api.g_varchar2

579: ,p_segment13 in varchar2 default hr_api.g_varchar2
580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 584: ,p_segment18 in varchar2 default hr_api.g_varchar2

580: ,p_segment14 in varchar2 default hr_api.g_varchar2
581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 585: ,p_segment19 in varchar2 default hr_api.g_varchar2

581: ,p_segment15 in varchar2 default hr_api.g_varchar2
582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 586: ,p_segment20 in varchar2 default hr_api.g_varchar2

582: ,p_segment16 in varchar2 default hr_api.g_varchar2
583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 587: ,p_segment21 in varchar2 default hr_api.g_varchar2

583: ,p_segment17 in varchar2 default hr_api.g_varchar2
584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 588: ,p_segment22 in varchar2 default hr_api.g_varchar2

584: ,p_segment18 in varchar2 default hr_api.g_varchar2
585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 589: ,p_segment23 in varchar2 default hr_api.g_varchar2

585: ,p_segment19 in varchar2 default hr_api.g_varchar2
586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 590: ,p_segment24 in varchar2 default hr_api.g_varchar2

586: ,p_segment20 in varchar2 default hr_api.g_varchar2
587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 591: ,p_segment25 in varchar2 default hr_api.g_varchar2

587: ,p_segment21 in varchar2 default hr_api.g_varchar2
588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 592: ,p_segment26 in varchar2 default hr_api.g_varchar2

588: ,p_segment22 in varchar2 default hr_api.g_varchar2
589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2
596: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 593: ,p_segment27 in varchar2 default hr_api.g_varchar2

589: ,p_segment23 in varchar2 default hr_api.g_varchar2
590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2
596: ,p_segment30 in varchar2 default hr_api.g_varchar2
597: ,p_concat_segments in varchar2 default null

Line 594: ,p_segment28 in varchar2 default hr_api.g_varchar2

590: ,p_segment24 in varchar2 default hr_api.g_varchar2
591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2
596: ,p_segment30 in varchar2 default hr_api.g_varchar2
597: ,p_concat_segments in varchar2 default null
598: ,p_business_group_id in number

Line 595: ,p_segment29 in varchar2 default hr_api.g_varchar2

591: ,p_segment25 in varchar2 default hr_api.g_varchar2
592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2
596: ,p_segment30 in varchar2 default hr_api.g_varchar2
597: ,p_concat_segments in varchar2 default null
598: ,p_business_group_id in number
599: -- make territory_code code a mandatory parameter on U interface

Line 596: ,p_segment30 in varchar2 default hr_api.g_varchar2

592: ,p_segment26 in varchar2 default hr_api.g_varchar2
593: ,p_segment27 in varchar2 default hr_api.g_varchar2
594: ,p_segment28 in varchar2 default hr_api.g_varchar2
595: ,p_segment29 in varchar2 default hr_api.g_varchar2
596: ,p_segment30 in varchar2 default hr_api.g_varchar2
597: ,p_concat_segments in varchar2 default null
598: ,p_business_group_id in number
599: -- make territory_code code a mandatory parameter on U interface
600: ,p_territory_code in varchar2

Line 601: ,p_prenote_date in date default hr_api.g_date

597: ,p_concat_segments in varchar2 default null
598: ,p_business_group_id in number
599: -- make territory_code code a mandatory parameter on U interface
600: ,p_territory_code in varchar2
601: ,p_prenote_date in date default hr_api.g_date
602: ,p_external_account_id in out nocopy number
603: ,p_object_version_number in out nocopy number
604: ,p_validate in boolean default false
605: ) is

Line 632: hr_api.mandatory_arg_error(

628: --
629: -- may still need to set territory code incase fresh combination
630: -- record is being I'ed
631: --
632: hr_api.mandatory_arg_error(
633: p_api_name => l_proc,
634: p_argument => 'territory_code',
635: p_argument_value => p_territory_code
636: );

Line 650: hr_api.g_number, -- id_flex_num

646: --
647: -- use system defaults so that pay_exa_upd.convert_defs()
648: -- will convert the components to their current db values
649: --
650: hr_api.g_number, -- id_flex_num
651: hr_api.g_varchar2, -- summary_flag
652: hr_api.g_varchar2, -- enabled_flag
653: hr_api.g_date, -- start_date_active
654: hr_api.g_date, -- end_date_active

Line 651: hr_api.g_varchar2, -- summary_flag

647: -- use system defaults so that pay_exa_upd.convert_defs()
648: -- will convert the components to their current db values
649: --
650: hr_api.g_number, -- id_flex_num
651: hr_api.g_varchar2, -- summary_flag
652: hr_api.g_varchar2, -- enabled_flag
653: hr_api.g_date, -- start_date_active
654: hr_api.g_date, -- end_date_active
655: --

Line 652: hr_api.g_varchar2, -- enabled_flag

648: -- will convert the components to their current db values
649: --
650: hr_api.g_number, -- id_flex_num
651: hr_api.g_varchar2, -- summary_flag
652: hr_api.g_varchar2, -- enabled_flag
653: hr_api.g_date, -- start_date_active
654: hr_api.g_date, -- end_date_active
655: --
656: p_segment1,

Line 653: hr_api.g_date, -- start_date_active

649: --
650: hr_api.g_number, -- id_flex_num
651: hr_api.g_varchar2, -- summary_flag
652: hr_api.g_varchar2, -- enabled_flag
653: hr_api.g_date, -- start_date_active
654: hr_api.g_date, -- end_date_active
655: --
656: p_segment1,
657: p_segment2,

Line 654: hr_api.g_date, -- end_date_active

650: hr_api.g_number, -- id_flex_num
651: hr_api.g_varchar2, -- summary_flag
652: hr_api.g_varchar2, -- enabled_flag
653: hr_api.g_date, -- start_date_active
654: hr_api.g_date, -- end_date_active
655: --
656: p_segment1,
657: p_segment2,
658: p_segment3,