[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_icx_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_icx_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_icx_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_icx_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update
167: (p_rec in hr_icx_shd.g_rec_type
168: ) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update
211: (p_effective_date in date
212: ,p_rec in hr_icx_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --
294: => p_rec.segment29
295: ,p_segment30
296: => p_rec.segment30
297: ,p_object_version_number_o
298: => hr_icx_shd.g_old_rec.object_version_number
299: ,p_id_flex_num_o
300: => hr_icx_shd.g_old_rec.id_flex_num
301: ,p_summary_flag_o
302: => hr_icx_shd.g_old_rec.summary_flag
296: => p_rec.segment30
297: ,p_object_version_number_o
298: => hr_icx_shd.g_old_rec.object_version_number
299: ,p_id_flex_num_o
300: => hr_icx_shd.g_old_rec.id_flex_num
301: ,p_summary_flag_o
302: => hr_icx_shd.g_old_rec.summary_flag
303: ,p_enabled_flag_o
304: => hr_icx_shd.g_old_rec.enabled_flag
298: => hr_icx_shd.g_old_rec.object_version_number
299: ,p_id_flex_num_o
300: => hr_icx_shd.g_old_rec.id_flex_num
301: ,p_summary_flag_o
302: => hr_icx_shd.g_old_rec.summary_flag
303: ,p_enabled_flag_o
304: => hr_icx_shd.g_old_rec.enabled_flag
305: ,p_start_date_active_o
306: => hr_icx_shd.g_old_rec.start_date_active
300: => hr_icx_shd.g_old_rec.id_flex_num
301: ,p_summary_flag_o
302: => hr_icx_shd.g_old_rec.summary_flag
303: ,p_enabled_flag_o
304: => hr_icx_shd.g_old_rec.enabled_flag
305: ,p_start_date_active_o
306: => hr_icx_shd.g_old_rec.start_date_active
307: ,p_end_date_active_o
308: => hr_icx_shd.g_old_rec.end_date_active
302: => hr_icx_shd.g_old_rec.summary_flag
303: ,p_enabled_flag_o
304: => hr_icx_shd.g_old_rec.enabled_flag
305: ,p_start_date_active_o
306: => hr_icx_shd.g_old_rec.start_date_active
307: ,p_end_date_active_o
308: => hr_icx_shd.g_old_rec.end_date_active
309: ,p_segment1_o
310: => hr_icx_shd.g_old_rec.segment1
304: => hr_icx_shd.g_old_rec.enabled_flag
305: ,p_start_date_active_o
306: => hr_icx_shd.g_old_rec.start_date_active
307: ,p_end_date_active_o
308: => hr_icx_shd.g_old_rec.end_date_active
309: ,p_segment1_o
310: => hr_icx_shd.g_old_rec.segment1
311: ,p_segment2_o
312: => hr_icx_shd.g_old_rec.segment2
306: => hr_icx_shd.g_old_rec.start_date_active
307: ,p_end_date_active_o
308: => hr_icx_shd.g_old_rec.end_date_active
309: ,p_segment1_o
310: => hr_icx_shd.g_old_rec.segment1
311: ,p_segment2_o
312: => hr_icx_shd.g_old_rec.segment2
313: ,p_segment3_o
314: => hr_icx_shd.g_old_rec.segment3
308: => hr_icx_shd.g_old_rec.end_date_active
309: ,p_segment1_o
310: => hr_icx_shd.g_old_rec.segment1
311: ,p_segment2_o
312: => hr_icx_shd.g_old_rec.segment2
313: ,p_segment3_o
314: => hr_icx_shd.g_old_rec.segment3
315: ,p_segment4_o
316: => hr_icx_shd.g_old_rec.segment4
310: => hr_icx_shd.g_old_rec.segment1
311: ,p_segment2_o
312: => hr_icx_shd.g_old_rec.segment2
313: ,p_segment3_o
314: => hr_icx_shd.g_old_rec.segment3
315: ,p_segment4_o
316: => hr_icx_shd.g_old_rec.segment4
317: ,p_segment5_o
318: => hr_icx_shd.g_old_rec.segment5
312: => hr_icx_shd.g_old_rec.segment2
313: ,p_segment3_o
314: => hr_icx_shd.g_old_rec.segment3
315: ,p_segment4_o
316: => hr_icx_shd.g_old_rec.segment4
317: ,p_segment5_o
318: => hr_icx_shd.g_old_rec.segment5
319: ,p_segment6_o
320: => hr_icx_shd.g_old_rec.segment6
314: => hr_icx_shd.g_old_rec.segment3
315: ,p_segment4_o
316: => hr_icx_shd.g_old_rec.segment4
317: ,p_segment5_o
318: => hr_icx_shd.g_old_rec.segment5
319: ,p_segment6_o
320: => hr_icx_shd.g_old_rec.segment6
321: ,p_segment7_o
322: => hr_icx_shd.g_old_rec.segment7
316: => hr_icx_shd.g_old_rec.segment4
317: ,p_segment5_o
318: => hr_icx_shd.g_old_rec.segment5
319: ,p_segment6_o
320: => hr_icx_shd.g_old_rec.segment6
321: ,p_segment7_o
322: => hr_icx_shd.g_old_rec.segment7
323: ,p_segment8_o
324: => hr_icx_shd.g_old_rec.segment8
318: => hr_icx_shd.g_old_rec.segment5
319: ,p_segment6_o
320: => hr_icx_shd.g_old_rec.segment6
321: ,p_segment7_o
322: => hr_icx_shd.g_old_rec.segment7
323: ,p_segment8_o
324: => hr_icx_shd.g_old_rec.segment8
325: ,p_segment9_o
326: => hr_icx_shd.g_old_rec.segment9
320: => hr_icx_shd.g_old_rec.segment6
321: ,p_segment7_o
322: => hr_icx_shd.g_old_rec.segment7
323: ,p_segment8_o
324: => hr_icx_shd.g_old_rec.segment8
325: ,p_segment9_o
326: => hr_icx_shd.g_old_rec.segment9
327: ,p_segment10_o
328: => hr_icx_shd.g_old_rec.segment10
322: => hr_icx_shd.g_old_rec.segment7
323: ,p_segment8_o
324: => hr_icx_shd.g_old_rec.segment8
325: ,p_segment9_o
326: => hr_icx_shd.g_old_rec.segment9
327: ,p_segment10_o
328: => hr_icx_shd.g_old_rec.segment10
329: ,p_segment11_o
330: => hr_icx_shd.g_old_rec.segment11
324: => hr_icx_shd.g_old_rec.segment8
325: ,p_segment9_o
326: => hr_icx_shd.g_old_rec.segment9
327: ,p_segment10_o
328: => hr_icx_shd.g_old_rec.segment10
329: ,p_segment11_o
330: => hr_icx_shd.g_old_rec.segment11
331: ,p_segment12_o
332: => hr_icx_shd.g_old_rec.segment12
326: => hr_icx_shd.g_old_rec.segment9
327: ,p_segment10_o
328: => hr_icx_shd.g_old_rec.segment10
329: ,p_segment11_o
330: => hr_icx_shd.g_old_rec.segment11
331: ,p_segment12_o
332: => hr_icx_shd.g_old_rec.segment12
333: ,p_segment13_o
334: => hr_icx_shd.g_old_rec.segment13
328: => hr_icx_shd.g_old_rec.segment10
329: ,p_segment11_o
330: => hr_icx_shd.g_old_rec.segment11
331: ,p_segment12_o
332: => hr_icx_shd.g_old_rec.segment12
333: ,p_segment13_o
334: => hr_icx_shd.g_old_rec.segment13
335: ,p_segment14_o
336: => hr_icx_shd.g_old_rec.segment14
330: => hr_icx_shd.g_old_rec.segment11
331: ,p_segment12_o
332: => hr_icx_shd.g_old_rec.segment12
333: ,p_segment13_o
334: => hr_icx_shd.g_old_rec.segment13
335: ,p_segment14_o
336: => hr_icx_shd.g_old_rec.segment14
337: ,p_segment15_o
338: => hr_icx_shd.g_old_rec.segment15
332: => hr_icx_shd.g_old_rec.segment12
333: ,p_segment13_o
334: => hr_icx_shd.g_old_rec.segment13
335: ,p_segment14_o
336: => hr_icx_shd.g_old_rec.segment14
337: ,p_segment15_o
338: => hr_icx_shd.g_old_rec.segment15
339: ,p_segment16_o
340: => hr_icx_shd.g_old_rec.segment16
334: => hr_icx_shd.g_old_rec.segment13
335: ,p_segment14_o
336: => hr_icx_shd.g_old_rec.segment14
337: ,p_segment15_o
338: => hr_icx_shd.g_old_rec.segment15
339: ,p_segment16_o
340: => hr_icx_shd.g_old_rec.segment16
341: ,p_segment17_o
342: => hr_icx_shd.g_old_rec.segment17
336: => hr_icx_shd.g_old_rec.segment14
337: ,p_segment15_o
338: => hr_icx_shd.g_old_rec.segment15
339: ,p_segment16_o
340: => hr_icx_shd.g_old_rec.segment16
341: ,p_segment17_o
342: => hr_icx_shd.g_old_rec.segment17
343: ,p_segment18_o
344: => hr_icx_shd.g_old_rec.segment18
338: => hr_icx_shd.g_old_rec.segment15
339: ,p_segment16_o
340: => hr_icx_shd.g_old_rec.segment16
341: ,p_segment17_o
342: => hr_icx_shd.g_old_rec.segment17
343: ,p_segment18_o
344: => hr_icx_shd.g_old_rec.segment18
345: ,p_segment19_o
346: => hr_icx_shd.g_old_rec.segment19
340: => hr_icx_shd.g_old_rec.segment16
341: ,p_segment17_o
342: => hr_icx_shd.g_old_rec.segment17
343: ,p_segment18_o
344: => hr_icx_shd.g_old_rec.segment18
345: ,p_segment19_o
346: => hr_icx_shd.g_old_rec.segment19
347: ,p_segment20_o
348: => hr_icx_shd.g_old_rec.segment20
342: => hr_icx_shd.g_old_rec.segment17
343: ,p_segment18_o
344: => hr_icx_shd.g_old_rec.segment18
345: ,p_segment19_o
346: => hr_icx_shd.g_old_rec.segment19
347: ,p_segment20_o
348: => hr_icx_shd.g_old_rec.segment20
349: ,p_segment21_o
350: => hr_icx_shd.g_old_rec.segment21
344: => hr_icx_shd.g_old_rec.segment18
345: ,p_segment19_o
346: => hr_icx_shd.g_old_rec.segment19
347: ,p_segment20_o
348: => hr_icx_shd.g_old_rec.segment20
349: ,p_segment21_o
350: => hr_icx_shd.g_old_rec.segment21
351: ,p_segment22_o
352: => hr_icx_shd.g_old_rec.segment22
346: => hr_icx_shd.g_old_rec.segment19
347: ,p_segment20_o
348: => hr_icx_shd.g_old_rec.segment20
349: ,p_segment21_o
350: => hr_icx_shd.g_old_rec.segment21
351: ,p_segment22_o
352: => hr_icx_shd.g_old_rec.segment22
353: ,p_segment23_o
354: => hr_icx_shd.g_old_rec.segment23
348: => hr_icx_shd.g_old_rec.segment20
349: ,p_segment21_o
350: => hr_icx_shd.g_old_rec.segment21
351: ,p_segment22_o
352: => hr_icx_shd.g_old_rec.segment22
353: ,p_segment23_o
354: => hr_icx_shd.g_old_rec.segment23
355: ,p_segment24_o
356: => hr_icx_shd.g_old_rec.segment24
350: => hr_icx_shd.g_old_rec.segment21
351: ,p_segment22_o
352: => hr_icx_shd.g_old_rec.segment22
353: ,p_segment23_o
354: => hr_icx_shd.g_old_rec.segment23
355: ,p_segment24_o
356: => hr_icx_shd.g_old_rec.segment24
357: ,p_segment25_o
358: => hr_icx_shd.g_old_rec.segment25
352: => hr_icx_shd.g_old_rec.segment22
353: ,p_segment23_o
354: => hr_icx_shd.g_old_rec.segment23
355: ,p_segment24_o
356: => hr_icx_shd.g_old_rec.segment24
357: ,p_segment25_o
358: => hr_icx_shd.g_old_rec.segment25
359: ,p_segment26_o
360: => hr_icx_shd.g_old_rec.segment26
354: => hr_icx_shd.g_old_rec.segment23
355: ,p_segment24_o
356: => hr_icx_shd.g_old_rec.segment24
357: ,p_segment25_o
358: => hr_icx_shd.g_old_rec.segment25
359: ,p_segment26_o
360: => hr_icx_shd.g_old_rec.segment26
361: ,p_segment27_o
362: => hr_icx_shd.g_old_rec.segment27
356: => hr_icx_shd.g_old_rec.segment24
357: ,p_segment25_o
358: => hr_icx_shd.g_old_rec.segment25
359: ,p_segment26_o
360: => hr_icx_shd.g_old_rec.segment26
361: ,p_segment27_o
362: => hr_icx_shd.g_old_rec.segment27
363: ,p_segment28_o
364: => hr_icx_shd.g_old_rec.segment28
358: => hr_icx_shd.g_old_rec.segment25
359: ,p_segment26_o
360: => hr_icx_shd.g_old_rec.segment26
361: ,p_segment27_o
362: => hr_icx_shd.g_old_rec.segment27
363: ,p_segment28_o
364: => hr_icx_shd.g_old_rec.segment28
365: ,p_segment29_o
366: => hr_icx_shd.g_old_rec.segment29
360: => hr_icx_shd.g_old_rec.segment26
361: ,p_segment27_o
362: => hr_icx_shd.g_old_rec.segment27
363: ,p_segment28_o
364: => hr_icx_shd.g_old_rec.segment28
365: ,p_segment29_o
366: => hr_icx_shd.g_old_rec.segment29
367: ,p_segment30_o
368: => hr_icx_shd.g_old_rec.segment30
362: => hr_icx_shd.g_old_rec.segment27
363: ,p_segment28_o
364: => hr_icx_shd.g_old_rec.segment28
365: ,p_segment29_o
366: => hr_icx_shd.g_old_rec.segment29
367: ,p_segment30_o
368: => hr_icx_shd.g_old_rec.segment30
369: );
370: --
364: => hr_icx_shd.g_old_rec.segment28
365: ,p_segment29_o
366: => hr_icx_shd.g_old_rec.segment29
367: ,p_segment30_o
368: => hr_icx_shd.g_old_rec.segment30
369: );
370: --
371: exception
372: --
424: --
425: -- {End Of Comments}
426: -- ----------------------------------------------------------------------------
427: Procedure convert_defs
428: (p_rec in out nocopy hr_icx_shd.g_rec_type
429: ) is
430: --
431: Begin
432: --
436: -- is being used then we must set to the 'current' argument value.
437: --
438: If (p_rec.id_flex_num = hr_api.g_number) then
439: p_rec.id_flex_num :=
440: hr_icx_shd.g_old_rec.id_flex_num;
441: End If;
442: If (p_rec.summary_flag = hr_api.g_varchar2) then
443: p_rec.summary_flag :=
444: hr_icx_shd.g_old_rec.summary_flag;
440: hr_icx_shd.g_old_rec.id_flex_num;
441: End If;
442: If (p_rec.summary_flag = hr_api.g_varchar2) then
443: p_rec.summary_flag :=
444: hr_icx_shd.g_old_rec.summary_flag;
445: End If;
446: If (p_rec.enabled_flag = hr_api.g_varchar2) then
447: p_rec.enabled_flag :=
448: hr_icx_shd.g_old_rec.enabled_flag;
444: hr_icx_shd.g_old_rec.summary_flag;
445: End If;
446: If (p_rec.enabled_flag = hr_api.g_varchar2) then
447: p_rec.enabled_flag :=
448: hr_icx_shd.g_old_rec.enabled_flag;
449: End If;
450: If (p_rec.start_date_active = hr_api.g_date) then
451: p_rec.start_date_active :=
452: hr_icx_shd.g_old_rec.start_date_active;
448: hr_icx_shd.g_old_rec.enabled_flag;
449: End If;
450: If (p_rec.start_date_active = hr_api.g_date) then
451: p_rec.start_date_active :=
452: hr_icx_shd.g_old_rec.start_date_active;
453: End If;
454: If (p_rec.end_date_active = hr_api.g_date) then
455: p_rec.end_date_active :=
456: hr_icx_shd.g_old_rec.end_date_active;
452: hr_icx_shd.g_old_rec.start_date_active;
453: End If;
454: If (p_rec.end_date_active = hr_api.g_date) then
455: p_rec.end_date_active :=
456: hr_icx_shd.g_old_rec.end_date_active;
457: End If;
458: If (p_rec.segment1 = hr_api.g_varchar2) then
459: p_rec.segment1 :=
460: hr_icx_shd.g_old_rec.segment1;
456: hr_icx_shd.g_old_rec.end_date_active;
457: End If;
458: If (p_rec.segment1 = hr_api.g_varchar2) then
459: p_rec.segment1 :=
460: hr_icx_shd.g_old_rec.segment1;
461: End If;
462: If (p_rec.segment2 = hr_api.g_varchar2) then
463: p_rec.segment2 :=
464: hr_icx_shd.g_old_rec.segment2;
460: hr_icx_shd.g_old_rec.segment1;
461: End If;
462: If (p_rec.segment2 = hr_api.g_varchar2) then
463: p_rec.segment2 :=
464: hr_icx_shd.g_old_rec.segment2;
465: End If;
466: If (p_rec.segment3 = hr_api.g_varchar2) then
467: p_rec.segment3 :=
468: hr_icx_shd.g_old_rec.segment3;
464: hr_icx_shd.g_old_rec.segment2;
465: End If;
466: If (p_rec.segment3 = hr_api.g_varchar2) then
467: p_rec.segment3 :=
468: hr_icx_shd.g_old_rec.segment3;
469: End If;
470: If (p_rec.segment4 = hr_api.g_varchar2) then
471: p_rec.segment4 :=
472: hr_icx_shd.g_old_rec.segment4;
468: hr_icx_shd.g_old_rec.segment3;
469: End If;
470: If (p_rec.segment4 = hr_api.g_varchar2) then
471: p_rec.segment4 :=
472: hr_icx_shd.g_old_rec.segment4;
473: End If;
474: If (p_rec.segment5 = hr_api.g_varchar2) then
475: p_rec.segment5 :=
476: hr_icx_shd.g_old_rec.segment5;
472: hr_icx_shd.g_old_rec.segment4;
473: End If;
474: If (p_rec.segment5 = hr_api.g_varchar2) then
475: p_rec.segment5 :=
476: hr_icx_shd.g_old_rec.segment5;
477: End If;
478: If (p_rec.segment6 = hr_api.g_varchar2) then
479: p_rec.segment6 :=
480: hr_icx_shd.g_old_rec.segment6;
476: hr_icx_shd.g_old_rec.segment5;
477: End If;
478: If (p_rec.segment6 = hr_api.g_varchar2) then
479: p_rec.segment6 :=
480: hr_icx_shd.g_old_rec.segment6;
481: End If;
482: If (p_rec.segment7 = hr_api.g_varchar2) then
483: p_rec.segment7 :=
484: hr_icx_shd.g_old_rec.segment7;
480: hr_icx_shd.g_old_rec.segment6;
481: End If;
482: If (p_rec.segment7 = hr_api.g_varchar2) then
483: p_rec.segment7 :=
484: hr_icx_shd.g_old_rec.segment7;
485: End If;
486: If (p_rec.segment8 = hr_api.g_varchar2) then
487: p_rec.segment8 :=
488: hr_icx_shd.g_old_rec.segment8;
484: hr_icx_shd.g_old_rec.segment7;
485: End If;
486: If (p_rec.segment8 = hr_api.g_varchar2) then
487: p_rec.segment8 :=
488: hr_icx_shd.g_old_rec.segment8;
489: End If;
490: If (p_rec.segment9 = hr_api.g_varchar2) then
491: p_rec.segment9 :=
492: hr_icx_shd.g_old_rec.segment9;
488: hr_icx_shd.g_old_rec.segment8;
489: End If;
490: If (p_rec.segment9 = hr_api.g_varchar2) then
491: p_rec.segment9 :=
492: hr_icx_shd.g_old_rec.segment9;
493: End If;
494: If (p_rec.segment10 = hr_api.g_varchar2) then
495: p_rec.segment10 :=
496: hr_icx_shd.g_old_rec.segment10;
492: hr_icx_shd.g_old_rec.segment9;
493: End If;
494: If (p_rec.segment10 = hr_api.g_varchar2) then
495: p_rec.segment10 :=
496: hr_icx_shd.g_old_rec.segment10;
497: End If;
498: If (p_rec.segment11 = hr_api.g_varchar2) then
499: p_rec.segment11 :=
500: hr_icx_shd.g_old_rec.segment11;
496: hr_icx_shd.g_old_rec.segment10;
497: End If;
498: If (p_rec.segment11 = hr_api.g_varchar2) then
499: p_rec.segment11 :=
500: hr_icx_shd.g_old_rec.segment11;
501: End If;
502: If (p_rec.segment12 = hr_api.g_varchar2) then
503: p_rec.segment12 :=
504: hr_icx_shd.g_old_rec.segment12;
500: hr_icx_shd.g_old_rec.segment11;
501: End If;
502: If (p_rec.segment12 = hr_api.g_varchar2) then
503: p_rec.segment12 :=
504: hr_icx_shd.g_old_rec.segment12;
505: End If;
506: If (p_rec.segment13 = hr_api.g_varchar2) then
507: p_rec.segment13 :=
508: hr_icx_shd.g_old_rec.segment13;
504: hr_icx_shd.g_old_rec.segment12;
505: End If;
506: If (p_rec.segment13 = hr_api.g_varchar2) then
507: p_rec.segment13 :=
508: hr_icx_shd.g_old_rec.segment13;
509: End If;
510: If (p_rec.segment14 = hr_api.g_varchar2) then
511: p_rec.segment14 :=
512: hr_icx_shd.g_old_rec.segment14;
508: hr_icx_shd.g_old_rec.segment13;
509: End If;
510: If (p_rec.segment14 = hr_api.g_varchar2) then
511: p_rec.segment14 :=
512: hr_icx_shd.g_old_rec.segment14;
513: End If;
514: If (p_rec.segment15 = hr_api.g_varchar2) then
515: p_rec.segment15 :=
516: hr_icx_shd.g_old_rec.segment15;
512: hr_icx_shd.g_old_rec.segment14;
513: End If;
514: If (p_rec.segment15 = hr_api.g_varchar2) then
515: p_rec.segment15 :=
516: hr_icx_shd.g_old_rec.segment15;
517: End If;
518: If (p_rec.segment16 = hr_api.g_varchar2) then
519: p_rec.segment16 :=
520: hr_icx_shd.g_old_rec.segment16;
516: hr_icx_shd.g_old_rec.segment15;
517: End If;
518: If (p_rec.segment16 = hr_api.g_varchar2) then
519: p_rec.segment16 :=
520: hr_icx_shd.g_old_rec.segment16;
521: End If;
522: If (p_rec.segment17 = hr_api.g_varchar2) then
523: p_rec.segment17 :=
524: hr_icx_shd.g_old_rec.segment17;
520: hr_icx_shd.g_old_rec.segment16;
521: End If;
522: If (p_rec.segment17 = hr_api.g_varchar2) then
523: p_rec.segment17 :=
524: hr_icx_shd.g_old_rec.segment17;
525: End If;
526: If (p_rec.segment18 = hr_api.g_varchar2) then
527: p_rec.segment18 :=
528: hr_icx_shd.g_old_rec.segment18;
524: hr_icx_shd.g_old_rec.segment17;
525: End If;
526: If (p_rec.segment18 = hr_api.g_varchar2) then
527: p_rec.segment18 :=
528: hr_icx_shd.g_old_rec.segment18;
529: End If;
530: If (p_rec.segment19 = hr_api.g_varchar2) then
531: p_rec.segment19 :=
532: hr_icx_shd.g_old_rec.segment19;
528: hr_icx_shd.g_old_rec.segment18;
529: End If;
530: If (p_rec.segment19 = hr_api.g_varchar2) then
531: p_rec.segment19 :=
532: hr_icx_shd.g_old_rec.segment19;
533: End If;
534: If (p_rec.segment20 = hr_api.g_varchar2) then
535: p_rec.segment20 :=
536: hr_icx_shd.g_old_rec.segment20;
532: hr_icx_shd.g_old_rec.segment19;
533: End If;
534: If (p_rec.segment20 = hr_api.g_varchar2) then
535: p_rec.segment20 :=
536: hr_icx_shd.g_old_rec.segment20;
537: End If;
538: If (p_rec.segment21 = hr_api.g_varchar2) then
539: p_rec.segment21 :=
540: hr_icx_shd.g_old_rec.segment21;
536: hr_icx_shd.g_old_rec.segment20;
537: End If;
538: If (p_rec.segment21 = hr_api.g_varchar2) then
539: p_rec.segment21 :=
540: hr_icx_shd.g_old_rec.segment21;
541: End If;
542: If (p_rec.segment22 = hr_api.g_varchar2) then
543: p_rec.segment22 :=
544: hr_icx_shd.g_old_rec.segment22;
540: hr_icx_shd.g_old_rec.segment21;
541: End If;
542: If (p_rec.segment22 = hr_api.g_varchar2) then
543: p_rec.segment22 :=
544: hr_icx_shd.g_old_rec.segment22;
545: End If;
546: If (p_rec.segment23 = hr_api.g_varchar2) then
547: p_rec.segment23 :=
548: hr_icx_shd.g_old_rec.segment23;
544: hr_icx_shd.g_old_rec.segment22;
545: End If;
546: If (p_rec.segment23 = hr_api.g_varchar2) then
547: p_rec.segment23 :=
548: hr_icx_shd.g_old_rec.segment23;
549: End If;
550: If (p_rec.segment24 = hr_api.g_varchar2) then
551: p_rec.segment24 :=
552: hr_icx_shd.g_old_rec.segment24;
548: hr_icx_shd.g_old_rec.segment23;
549: End If;
550: If (p_rec.segment24 = hr_api.g_varchar2) then
551: p_rec.segment24 :=
552: hr_icx_shd.g_old_rec.segment24;
553: End If;
554: If (p_rec.segment25 = hr_api.g_varchar2) then
555: p_rec.segment25 :=
556: hr_icx_shd.g_old_rec.segment25;
552: hr_icx_shd.g_old_rec.segment24;
553: End If;
554: If (p_rec.segment25 = hr_api.g_varchar2) then
555: p_rec.segment25 :=
556: hr_icx_shd.g_old_rec.segment25;
557: End If;
558: If (p_rec.segment26 = hr_api.g_varchar2) then
559: p_rec.segment26 :=
560: hr_icx_shd.g_old_rec.segment26;
556: hr_icx_shd.g_old_rec.segment25;
557: End If;
558: If (p_rec.segment26 = hr_api.g_varchar2) then
559: p_rec.segment26 :=
560: hr_icx_shd.g_old_rec.segment26;
561: End If;
562: If (p_rec.segment27 = hr_api.g_varchar2) then
563: p_rec.segment27 :=
564: hr_icx_shd.g_old_rec.segment27;
560: hr_icx_shd.g_old_rec.segment26;
561: End If;
562: If (p_rec.segment27 = hr_api.g_varchar2) then
563: p_rec.segment27 :=
564: hr_icx_shd.g_old_rec.segment27;
565: End If;
566: If (p_rec.segment28 = hr_api.g_varchar2) then
567: p_rec.segment28 :=
568: hr_icx_shd.g_old_rec.segment28;
564: hr_icx_shd.g_old_rec.segment27;
565: End If;
566: If (p_rec.segment28 = hr_api.g_varchar2) then
567: p_rec.segment28 :=
568: hr_icx_shd.g_old_rec.segment28;
569: End If;
570: If (p_rec.segment29 = hr_api.g_varchar2) then
571: p_rec.segment29 :=
572: hr_icx_shd.g_old_rec.segment29;
568: hr_icx_shd.g_old_rec.segment28;
569: End If;
570: If (p_rec.segment29 = hr_api.g_varchar2) then
571: p_rec.segment29 :=
572: hr_icx_shd.g_old_rec.segment29;
573: End If;
574: If (p_rec.segment30 = hr_api.g_varchar2) then
575: p_rec.segment30 :=
576: hr_icx_shd.g_old_rec.segment30;
572: hr_icx_shd.g_old_rec.segment29;
573: End If;
574: If (p_rec.segment30 = hr_api.g_varchar2) then
575: p_rec.segment30 :=
576: hr_icx_shd.g_old_rec.segment30;
577: End If;
578: --
579: End convert_defs;
580: --
628: AND application_id = 800
629: AND id_flex_code = 'ICX';
630:
631: l_proc varchar2(72) := g_package||'upd_or_sel';
632: l_rec hr_icx_shd.g_rec_type;
633: l_concatenated_segments varchar2(2000);
634: l_segs_changed boolean;
635: l_id_flex_num number ;
636: l_context_type varchar2(30);
689: ELSE
690: --
691: -- convert args into record format
692: l_rec :=
693: hr_icx_shd.convert_args (
694: p_item_context_id => p_item_context_id,
695: p_object_version_number => p_object_version_number,
696: p_id_flex_num => l_id_flex_num,
697: p_summary_flag => null,
731: );
732: --
733: -- check to see if we are updating a row
734: --
735: if hr_icx_shd.api_updating
736: (p_item_context_id => l_rec.item_context_id
737: ,p_object_version_number => l_rec.object_version_number
738: ) then
739: --
902: -- |---------------------------------< upd >----------------------------------|
903: -- ----------------------------------------------------------------------------
904: Procedure upd
905: (p_effective_date in date
906: ,p_rec in out nocopy hr_icx_shd.g_rec_type
907: ) is
908: --
909: l_proc varchar2(72) := g_package||'upd';
910: --
912: hr_utility.set_location('Entering:'||l_proc, 5);
913: --
914: -- We must lock the row which we need to update.
915: --
916: hr_icx_shd.lck
917: (p_rec.item_context_id,
918: p_rec.object_version_number
919: );
920: --
989: ,p_segment29 in varchar2 default hr_api.g_varchar2
990: ,p_segment30 in varchar2 default hr_api.g_varchar2
991: ) is
992: --
993: l_rec hr_icx_shd.g_rec_type;
994: l_proc varchar2(72) := g_package||'upd';
995: --
996: Begin
997: hr_utility.set_location('Entering:'||l_proc, 5);
999: -- Call conversion function to turn arguments into the
1000: -- l_rec structure.
1001: --
1002: l_rec :=
1003: hr_icx_shd.convert_args
1004: (p_item_context_id
1005: ,p_object_version_number
1006: ,p_id_flex_num
1007: ,p_summary_flag