APPS.PAY_ASSG_COST_SS dependencies on HR_TRANSACTION_API

Line 370: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');

366: SAVEPOINT create_date;
367:
368: if p_validate = false then
369: --
370: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
371: if l_effective_date is null then
372: l_effective_date := sysdate;
373: end if;
374: if g_debug then

Line 378: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value

374: if g_debug then
375: hr_utility.set_location('Get P_COST_ALLOCATION_KEYFLEX_ID and P_OBJECT_VERSION_NUMBER', 20);
376: end if;
377: /*Get the parameters to be used in the API call*/
378: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value
379: (p_transaction_step_id => p_transaction_step_id
380: ,p_name => 'P_COST_ALLOCATION_KEYFLEX_ID');
381: l_object_version_number := hr_transaction_api.get_number_value
382: (p_transaction_step_id => p_transaction_step_id

Line 381: l_object_version_number := hr_transaction_api.get_number_value

377: /*Get the parameters to be used in the API call*/
378: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value
379: (p_transaction_step_id => p_transaction_step_id
380: ,p_name => 'P_COST_ALLOCATION_KEYFLEX_ID');
381: l_object_version_number := hr_transaction_api.get_number_value
382: (p_transaction_step_id => p_transaction_step_id
383: ,p_name => 'P_OBJECT_VERSION_NUMBER');
384: if g_debug then
385: hr_utility.set_location('P_COST_ALLOCATION_KEYFLEX_ID => '||NVL(l_cost_allocation_keyflex_id,-1), 30);

Line 396: ,p_assignment_id => hr_transaction_api.get_number_value

392: /*Now call the API to create cost allocations*/
393: PAY_COST_ALLOCATION_API.CREATE_COST_ALLOCATION
394: (p_validate => p_validate
395: ,p_effective_date => l_effective_date
396: ,p_assignment_id => hr_transaction_api.get_number_value
397: (p_transaction_step_id => p_transaction_step_id
398: ,p_name => 'P_ASSIGNMENT_ID')
399: ,p_proportion => hr_transaction_api.get_number_value
400: (p_transaction_step_id => p_transaction_step_id

Line 399: ,p_proportion => hr_transaction_api.get_number_value

395: ,p_effective_date => l_effective_date
396: ,p_assignment_id => hr_transaction_api.get_number_value
397: (p_transaction_step_id => p_transaction_step_id
398: ,p_name => 'P_ASSIGNMENT_ID')
399: ,p_proportion => hr_transaction_api.get_number_value
400: (p_transaction_step_id => p_transaction_step_id
401: ,p_name => 'P_PROPORTION')/100
402: ,p_business_group_id => hr_transaction_api.get_number_value
403: (p_transaction_step_id => p_transaction_step_id

Line 402: ,p_business_group_id => hr_transaction_api.get_number_value

398: ,p_name => 'P_ASSIGNMENT_ID')
399: ,p_proportion => hr_transaction_api.get_number_value
400: (p_transaction_step_id => p_transaction_step_id
401: ,p_name => 'P_PROPORTION')/100
402: ,p_business_group_id => hr_transaction_api.get_number_value
403: (p_transaction_step_id => p_transaction_step_id
404: ,p_name => 'P_BUSINESS_GROUP_ID')
405: ,p_segment1 => hr_transaction_api.get_varchar2_value
406: (p_transaction_step_id => p_transaction_step_id

Line 405: ,p_segment1 => hr_transaction_api.get_varchar2_value

401: ,p_name => 'P_PROPORTION')/100
402: ,p_business_group_id => hr_transaction_api.get_number_value
403: (p_transaction_step_id => p_transaction_step_id
404: ,p_name => 'P_BUSINESS_GROUP_ID')
405: ,p_segment1 => hr_transaction_api.get_varchar2_value
406: (p_transaction_step_id => p_transaction_step_id
407: ,p_name => 'P_SEGMENT1')
408: ,p_segment2 => hr_transaction_api.get_varchar2_value
409: (p_transaction_step_id => p_transaction_step_id

Line 408: ,p_segment2 => hr_transaction_api.get_varchar2_value

404: ,p_name => 'P_BUSINESS_GROUP_ID')
405: ,p_segment1 => hr_transaction_api.get_varchar2_value
406: (p_transaction_step_id => p_transaction_step_id
407: ,p_name => 'P_SEGMENT1')
408: ,p_segment2 => hr_transaction_api.get_varchar2_value
409: (p_transaction_step_id => p_transaction_step_id
410: ,p_name => 'P_SEGMENT2')
411: ,p_segment3 => hr_transaction_api.get_varchar2_value
412: (p_transaction_step_id => p_transaction_step_id

Line 411: ,p_segment3 => hr_transaction_api.get_varchar2_value

407: ,p_name => 'P_SEGMENT1')
408: ,p_segment2 => hr_transaction_api.get_varchar2_value
409: (p_transaction_step_id => p_transaction_step_id
410: ,p_name => 'P_SEGMENT2')
411: ,p_segment3 => hr_transaction_api.get_varchar2_value
412: (p_transaction_step_id => p_transaction_step_id
413: ,p_name => 'P_SEGMENT3')
414: ,p_segment4 => hr_transaction_api.get_varchar2_value
415: (p_transaction_step_id => p_transaction_step_id

Line 414: ,p_segment4 => hr_transaction_api.get_varchar2_value

410: ,p_name => 'P_SEGMENT2')
411: ,p_segment3 => hr_transaction_api.get_varchar2_value
412: (p_transaction_step_id => p_transaction_step_id
413: ,p_name => 'P_SEGMENT3')
414: ,p_segment4 => hr_transaction_api.get_varchar2_value
415: (p_transaction_step_id => p_transaction_step_id
416: ,p_name => 'P_SEGMENT4')
417: ,p_segment5 => hr_transaction_api.get_varchar2_value
418: (p_transaction_step_id => p_transaction_step_id

Line 417: ,p_segment5 => hr_transaction_api.get_varchar2_value

413: ,p_name => 'P_SEGMENT3')
414: ,p_segment4 => hr_transaction_api.get_varchar2_value
415: (p_transaction_step_id => p_transaction_step_id
416: ,p_name => 'P_SEGMENT4')
417: ,p_segment5 => hr_transaction_api.get_varchar2_value
418: (p_transaction_step_id => p_transaction_step_id
419: ,p_name => 'P_SEGMENT5')
420: ,p_segment6 => hr_transaction_api.get_varchar2_value
421: (p_transaction_step_id => p_transaction_step_id

Line 420: ,p_segment6 => hr_transaction_api.get_varchar2_value

416: ,p_name => 'P_SEGMENT4')
417: ,p_segment5 => hr_transaction_api.get_varchar2_value
418: (p_transaction_step_id => p_transaction_step_id
419: ,p_name => 'P_SEGMENT5')
420: ,p_segment6 => hr_transaction_api.get_varchar2_value
421: (p_transaction_step_id => p_transaction_step_id
422: ,p_name => 'P_SEGMENT6')
423: ,p_segment7 => hr_transaction_api.get_varchar2_value
424: (p_transaction_step_id => p_transaction_step_id

Line 423: ,p_segment7 => hr_transaction_api.get_varchar2_value

419: ,p_name => 'P_SEGMENT5')
420: ,p_segment6 => hr_transaction_api.get_varchar2_value
421: (p_transaction_step_id => p_transaction_step_id
422: ,p_name => 'P_SEGMENT6')
423: ,p_segment7 => hr_transaction_api.get_varchar2_value
424: (p_transaction_step_id => p_transaction_step_id
425: ,p_name => 'P_SEGMENT7')
426: ,p_segment8 => hr_transaction_api.get_varchar2_value
427: (p_transaction_step_id => p_transaction_step_id

Line 426: ,p_segment8 => hr_transaction_api.get_varchar2_value

422: ,p_name => 'P_SEGMENT6')
423: ,p_segment7 => hr_transaction_api.get_varchar2_value
424: (p_transaction_step_id => p_transaction_step_id
425: ,p_name => 'P_SEGMENT7')
426: ,p_segment8 => hr_transaction_api.get_varchar2_value
427: (p_transaction_step_id => p_transaction_step_id
428: ,p_name => 'P_SEGMENT8')
429: ,p_segment9 => hr_transaction_api.get_varchar2_value
430: (p_transaction_step_id => p_transaction_step_id

Line 429: ,p_segment9 => hr_transaction_api.get_varchar2_value

425: ,p_name => 'P_SEGMENT7')
426: ,p_segment8 => hr_transaction_api.get_varchar2_value
427: (p_transaction_step_id => p_transaction_step_id
428: ,p_name => 'P_SEGMENT8')
429: ,p_segment9 => hr_transaction_api.get_varchar2_value
430: (p_transaction_step_id => p_transaction_step_id
431: ,p_name => 'P_SEGMENT9')
432: ,p_segment10 => hr_transaction_api.get_varchar2_value
433: (p_transaction_step_id => p_transaction_step_id

Line 432: ,p_segment10 => hr_transaction_api.get_varchar2_value

428: ,p_name => 'P_SEGMENT8')
429: ,p_segment9 => hr_transaction_api.get_varchar2_value
430: (p_transaction_step_id => p_transaction_step_id
431: ,p_name => 'P_SEGMENT9')
432: ,p_segment10 => hr_transaction_api.get_varchar2_value
433: (p_transaction_step_id => p_transaction_step_id
434: ,p_name => 'P_SEGMENT10')
435: ,p_segment11 => hr_transaction_api.get_varchar2_value
436: (p_transaction_step_id => p_transaction_step_id

Line 435: ,p_segment11 => hr_transaction_api.get_varchar2_value

431: ,p_name => 'P_SEGMENT9')
432: ,p_segment10 => hr_transaction_api.get_varchar2_value
433: (p_transaction_step_id => p_transaction_step_id
434: ,p_name => 'P_SEGMENT10')
435: ,p_segment11 => hr_transaction_api.get_varchar2_value
436: (p_transaction_step_id => p_transaction_step_id
437: ,p_name => 'P_SEGMENT11')
438: ,p_segment12 => hr_transaction_api.get_varchar2_value
439: (p_transaction_step_id => p_transaction_step_id

Line 438: ,p_segment12 => hr_transaction_api.get_varchar2_value

434: ,p_name => 'P_SEGMENT10')
435: ,p_segment11 => hr_transaction_api.get_varchar2_value
436: (p_transaction_step_id => p_transaction_step_id
437: ,p_name => 'P_SEGMENT11')
438: ,p_segment12 => hr_transaction_api.get_varchar2_value
439: (p_transaction_step_id => p_transaction_step_id
440: ,p_name => 'P_SEGMENT12')
441: ,p_segment13 => hr_transaction_api.get_varchar2_value
442: (p_transaction_step_id => p_transaction_step_id

Line 441: ,p_segment13 => hr_transaction_api.get_varchar2_value

437: ,p_name => 'P_SEGMENT11')
438: ,p_segment12 => hr_transaction_api.get_varchar2_value
439: (p_transaction_step_id => p_transaction_step_id
440: ,p_name => 'P_SEGMENT12')
441: ,p_segment13 => hr_transaction_api.get_varchar2_value
442: (p_transaction_step_id => p_transaction_step_id
443: ,p_name => 'P_SEGMENT13')
444: ,p_segment14 => hr_transaction_api.get_varchar2_value
445: (p_transaction_step_id => p_transaction_step_id

Line 444: ,p_segment14 => hr_transaction_api.get_varchar2_value

440: ,p_name => 'P_SEGMENT12')
441: ,p_segment13 => hr_transaction_api.get_varchar2_value
442: (p_transaction_step_id => p_transaction_step_id
443: ,p_name => 'P_SEGMENT13')
444: ,p_segment14 => hr_transaction_api.get_varchar2_value
445: (p_transaction_step_id => p_transaction_step_id
446: ,p_name => 'P_SEGMENT14')
447: ,p_segment15 => hr_transaction_api.get_varchar2_value
448: (p_transaction_step_id => p_transaction_step_id

Line 447: ,p_segment15 => hr_transaction_api.get_varchar2_value

443: ,p_name => 'P_SEGMENT13')
444: ,p_segment14 => hr_transaction_api.get_varchar2_value
445: (p_transaction_step_id => p_transaction_step_id
446: ,p_name => 'P_SEGMENT14')
447: ,p_segment15 => hr_transaction_api.get_varchar2_value
448: (p_transaction_step_id => p_transaction_step_id
449: ,p_name => 'P_SEGMENT15')
450: ,p_segment16 => hr_transaction_api.get_varchar2_value
451: (p_transaction_step_id => p_transaction_step_id

Line 450: ,p_segment16 => hr_transaction_api.get_varchar2_value

446: ,p_name => 'P_SEGMENT14')
447: ,p_segment15 => hr_transaction_api.get_varchar2_value
448: (p_transaction_step_id => p_transaction_step_id
449: ,p_name => 'P_SEGMENT15')
450: ,p_segment16 => hr_transaction_api.get_varchar2_value
451: (p_transaction_step_id => p_transaction_step_id
452: ,p_name => 'P_SEGMENT16')
453: ,p_segment17 => hr_transaction_api.get_varchar2_value
454: (p_transaction_step_id => p_transaction_step_id

Line 453: ,p_segment17 => hr_transaction_api.get_varchar2_value

449: ,p_name => 'P_SEGMENT15')
450: ,p_segment16 => hr_transaction_api.get_varchar2_value
451: (p_transaction_step_id => p_transaction_step_id
452: ,p_name => 'P_SEGMENT16')
453: ,p_segment17 => hr_transaction_api.get_varchar2_value
454: (p_transaction_step_id => p_transaction_step_id
455: ,p_name => 'P_SEGMENT17')
456: ,p_segment18 => hr_transaction_api.get_varchar2_value
457: (p_transaction_step_id => p_transaction_step_id

Line 456: ,p_segment18 => hr_transaction_api.get_varchar2_value

452: ,p_name => 'P_SEGMENT16')
453: ,p_segment17 => hr_transaction_api.get_varchar2_value
454: (p_transaction_step_id => p_transaction_step_id
455: ,p_name => 'P_SEGMENT17')
456: ,p_segment18 => hr_transaction_api.get_varchar2_value
457: (p_transaction_step_id => p_transaction_step_id
458: ,p_name => 'P_SEGMENT18')
459: ,p_segment19 => hr_transaction_api.get_varchar2_value
460: (p_transaction_step_id => p_transaction_step_id

Line 459: ,p_segment19 => hr_transaction_api.get_varchar2_value

455: ,p_name => 'P_SEGMENT17')
456: ,p_segment18 => hr_transaction_api.get_varchar2_value
457: (p_transaction_step_id => p_transaction_step_id
458: ,p_name => 'P_SEGMENT18')
459: ,p_segment19 => hr_transaction_api.get_varchar2_value
460: (p_transaction_step_id => p_transaction_step_id
461: ,p_name => 'P_SEGMENT19')
462: ,p_segment20 => hr_transaction_api.get_varchar2_value
463: (p_transaction_step_id => p_transaction_step_id

Line 462: ,p_segment20 => hr_transaction_api.get_varchar2_value

458: ,p_name => 'P_SEGMENT18')
459: ,p_segment19 => hr_transaction_api.get_varchar2_value
460: (p_transaction_step_id => p_transaction_step_id
461: ,p_name => 'P_SEGMENT19')
462: ,p_segment20 => hr_transaction_api.get_varchar2_value
463: (p_transaction_step_id => p_transaction_step_id
464: ,p_name => 'P_SEGMENT20')
465: ,p_segment21 => hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id => p_transaction_step_id

Line 465: ,p_segment21 => hr_transaction_api.get_varchar2_value

461: ,p_name => 'P_SEGMENT19')
462: ,p_segment20 => hr_transaction_api.get_varchar2_value
463: (p_transaction_step_id => p_transaction_step_id
464: ,p_name => 'P_SEGMENT20')
465: ,p_segment21 => hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id => p_transaction_step_id
467: ,p_name => 'P_SEGMENT21')
468: ,p_segment22 => hr_transaction_api.get_varchar2_value
469: (p_transaction_step_id => p_transaction_step_id

Line 468: ,p_segment22 => hr_transaction_api.get_varchar2_value

464: ,p_name => 'P_SEGMENT20')
465: ,p_segment21 => hr_transaction_api.get_varchar2_value
466: (p_transaction_step_id => p_transaction_step_id
467: ,p_name => 'P_SEGMENT21')
468: ,p_segment22 => hr_transaction_api.get_varchar2_value
469: (p_transaction_step_id => p_transaction_step_id
470: ,p_name => 'P_SEGMENT22')
471: ,p_segment23 => hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id => p_transaction_step_id

Line 471: ,p_segment23 => hr_transaction_api.get_varchar2_value

467: ,p_name => 'P_SEGMENT21')
468: ,p_segment22 => hr_transaction_api.get_varchar2_value
469: (p_transaction_step_id => p_transaction_step_id
470: ,p_name => 'P_SEGMENT22')
471: ,p_segment23 => hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id => p_transaction_step_id
473: ,p_name => 'P_SEGMENT23')
474: ,p_segment24 => hr_transaction_api.get_varchar2_value
475: (p_transaction_step_id => p_transaction_step_id

Line 474: ,p_segment24 => hr_transaction_api.get_varchar2_value

470: ,p_name => 'P_SEGMENT22')
471: ,p_segment23 => hr_transaction_api.get_varchar2_value
472: (p_transaction_step_id => p_transaction_step_id
473: ,p_name => 'P_SEGMENT23')
474: ,p_segment24 => hr_transaction_api.get_varchar2_value
475: (p_transaction_step_id => p_transaction_step_id
476: ,p_name => 'P_SEGMENT24')
477: ,p_segment25 => hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id => p_transaction_step_id

Line 477: ,p_segment25 => hr_transaction_api.get_varchar2_value

473: ,p_name => 'P_SEGMENT23')
474: ,p_segment24 => hr_transaction_api.get_varchar2_value
475: (p_transaction_step_id => p_transaction_step_id
476: ,p_name => 'P_SEGMENT24')
477: ,p_segment25 => hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id => p_transaction_step_id
479: ,p_name => 'P_SEGMENT25')
480: ,p_segment26 => hr_transaction_api.get_varchar2_value
481: (p_transaction_step_id => p_transaction_step_id

Line 480: ,p_segment26 => hr_transaction_api.get_varchar2_value

476: ,p_name => 'P_SEGMENT24')
477: ,p_segment25 => hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id => p_transaction_step_id
479: ,p_name => 'P_SEGMENT25')
480: ,p_segment26 => hr_transaction_api.get_varchar2_value
481: (p_transaction_step_id => p_transaction_step_id
482: ,p_name => 'P_SEGMENT26')
483: ,p_segment27 => hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id => p_transaction_step_id

Line 483: ,p_segment27 => hr_transaction_api.get_varchar2_value

479: ,p_name => 'P_SEGMENT25')
480: ,p_segment26 => hr_transaction_api.get_varchar2_value
481: (p_transaction_step_id => p_transaction_step_id
482: ,p_name => 'P_SEGMENT26')
483: ,p_segment27 => hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id => p_transaction_step_id
485: ,p_name => 'P_SEGMENT27')
486: ,p_segment28 => hr_transaction_api.get_varchar2_value
487: (p_transaction_step_id => p_transaction_step_id

Line 486: ,p_segment28 => hr_transaction_api.get_varchar2_value

482: ,p_name => 'P_SEGMENT26')
483: ,p_segment27 => hr_transaction_api.get_varchar2_value
484: (p_transaction_step_id => p_transaction_step_id
485: ,p_name => 'P_SEGMENT27')
486: ,p_segment28 => hr_transaction_api.get_varchar2_value
487: (p_transaction_step_id => p_transaction_step_id
488: ,p_name => 'P_SEGMENT28')
489: ,p_segment29 => hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id => p_transaction_step_id

Line 489: ,p_segment29 => hr_transaction_api.get_varchar2_value

485: ,p_name => 'P_SEGMENT27')
486: ,p_segment28 => hr_transaction_api.get_varchar2_value
487: (p_transaction_step_id => p_transaction_step_id
488: ,p_name => 'P_SEGMENT28')
489: ,p_segment29 => hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id => p_transaction_step_id
491: ,p_name => 'P_SEGMENT29')
492: ,p_segment30 => hr_transaction_api.get_varchar2_value
493: (p_transaction_step_id => p_transaction_step_id

Line 492: ,p_segment30 => hr_transaction_api.get_varchar2_value

488: ,p_name => 'P_SEGMENT28')
489: ,p_segment29 => hr_transaction_api.get_varchar2_value
490: (p_transaction_step_id => p_transaction_step_id
491: ,p_name => 'P_SEGMENT29')
492: ,p_segment30 => hr_transaction_api.get_varchar2_value
493: (p_transaction_step_id => p_transaction_step_id
494: ,p_name => 'P_SEGMENT30')
495: ,p_combination_name => l_combination_name
496: ,p_cost_allocation_id => l_cost_allocation_id

Line 897: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');

893: end if;
894:
895: SAVEPOINT UPDATE_DATA;
896: if p_validate = false then
897: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
898: if l_effective_date is null then
899: l_effective_date := sysdate;
900: end if;
901: if g_debug then

Line 904: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value

900: end if;
901: if g_debug then
902: hr_utility.set_location('Get P_COST_ALLOCATION_KEYFLEX_ID and P_OBJECT_VERSION_NUMBER', 20);
903: end if;
904: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value
905: (p_transaction_step_id => p_transaction_step_id
906: ,p_name => 'P_COST_ALLOCATION_KEYFLEX_ID');
907: l_object_version_number := hr_transaction_api.get_number_value
908: (p_transaction_step_id => p_transaction_step_id

Line 907: l_object_version_number := hr_transaction_api.get_number_value

903: end if;
904: l_cost_allocation_keyflex_id := hr_transaction_api.get_number_value
905: (p_transaction_step_id => p_transaction_step_id
906: ,p_name => 'P_COST_ALLOCATION_KEYFLEX_ID');
907: l_object_version_number := hr_transaction_api.get_number_value
908: (p_transaction_step_id => p_transaction_step_id
909: ,p_name => 'P_OBJECT_VERSION_NUMBER');
910: l_update_datetrack_mode := hr_transaction_api.get_varchar2_value(
911: p_transaction_step_id => p_transaction_step_id,

Line 910: l_update_datetrack_mode := hr_transaction_api.get_varchar2_value(

906: ,p_name => 'P_COST_ALLOCATION_KEYFLEX_ID');
907: l_object_version_number := hr_transaction_api.get_number_value
908: (p_transaction_step_id => p_transaction_step_id
909: ,p_name => 'P_OBJECT_VERSION_NUMBER');
910: l_update_datetrack_mode := hr_transaction_api.get_varchar2_value(
911: p_transaction_step_id => p_transaction_step_id,
912: p_name => 'P_UPDATE_MODE');
913: if g_debug then
914: hr_utility.set_location('P_COST_ALLOCATION_KEYFLEX_ID => '||NVL(l_cost_allocation_keyflex_id,-1), 30);

Line 928: ,p_cost_allocation_id => hr_transaction_api.get_number_value

924: PAY_COST_ALLOCATION_API.UPDATE_COST_ALLOCATION
925: (p_validate => p_validate
926: ,p_effective_date => l_effective_date
927: ,p_datetrack_update_mode => nvl(l_update_datetrack_mode,'UPDATE')
928: ,p_cost_allocation_id => hr_transaction_api.get_number_value
929: (p_transaction_step_id => p_transaction_step_id
930: ,p_name => 'P_COST_ALLOCATION_ID')
931: ,p_object_version_number => l_object_version_number
932: ,p_proportion => hr_transaction_api.get_number_value

Line 932: ,p_proportion => hr_transaction_api.get_number_value

928: ,p_cost_allocation_id => hr_transaction_api.get_number_value
929: (p_transaction_step_id => p_transaction_step_id
930: ,p_name => 'P_COST_ALLOCATION_ID')
931: ,p_object_version_number => l_object_version_number
932: ,p_proportion => hr_transaction_api.get_number_value
933: (p_transaction_step_id => p_transaction_step_id
934: ,p_name => 'P_PROPORTION')/100
935: ,p_segment1 => hr_transaction_api.get_varchar2_value
936: (p_transaction_step_id => p_transaction_step_id

Line 935: ,p_segment1 => hr_transaction_api.get_varchar2_value

931: ,p_object_version_number => l_object_version_number
932: ,p_proportion => hr_transaction_api.get_number_value
933: (p_transaction_step_id => p_transaction_step_id
934: ,p_name => 'P_PROPORTION')/100
935: ,p_segment1 => hr_transaction_api.get_varchar2_value
936: (p_transaction_step_id => p_transaction_step_id
937: ,p_name => 'P_SEGMENT1')
938: ,p_segment2 => hr_transaction_api.get_varchar2_value
939: (p_transaction_step_id => p_transaction_step_id

Line 938: ,p_segment2 => hr_transaction_api.get_varchar2_value

934: ,p_name => 'P_PROPORTION')/100
935: ,p_segment1 => hr_transaction_api.get_varchar2_value
936: (p_transaction_step_id => p_transaction_step_id
937: ,p_name => 'P_SEGMENT1')
938: ,p_segment2 => hr_transaction_api.get_varchar2_value
939: (p_transaction_step_id => p_transaction_step_id
940: ,p_name => 'P_SEGMENT2')
941: ,p_segment3 => hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id

Line 941: ,p_segment3 => hr_transaction_api.get_varchar2_value

937: ,p_name => 'P_SEGMENT1')
938: ,p_segment2 => hr_transaction_api.get_varchar2_value
939: (p_transaction_step_id => p_transaction_step_id
940: ,p_name => 'P_SEGMENT2')
941: ,p_segment3 => hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_SEGMENT3')
944: ,p_segment4 => hr_transaction_api.get_varchar2_value
945: (p_transaction_step_id => p_transaction_step_id

Line 944: ,p_segment4 => hr_transaction_api.get_varchar2_value

940: ,p_name => 'P_SEGMENT2')
941: ,p_segment3 => hr_transaction_api.get_varchar2_value
942: (p_transaction_step_id => p_transaction_step_id
943: ,p_name => 'P_SEGMENT3')
944: ,p_segment4 => hr_transaction_api.get_varchar2_value
945: (p_transaction_step_id => p_transaction_step_id
946: ,p_name => 'P_SEGMENT4')
947: ,p_segment5 => hr_transaction_api.get_varchar2_value
948: (p_transaction_step_id => p_transaction_step_id

Line 947: ,p_segment5 => hr_transaction_api.get_varchar2_value

943: ,p_name => 'P_SEGMENT3')
944: ,p_segment4 => hr_transaction_api.get_varchar2_value
945: (p_transaction_step_id => p_transaction_step_id
946: ,p_name => 'P_SEGMENT4')
947: ,p_segment5 => hr_transaction_api.get_varchar2_value
948: (p_transaction_step_id => p_transaction_step_id
949: ,p_name => 'P_SEGMENT5')
950: ,p_segment6 => hr_transaction_api.get_varchar2_value
951: (p_transaction_step_id => p_transaction_step_id

Line 950: ,p_segment6 => hr_transaction_api.get_varchar2_value

946: ,p_name => 'P_SEGMENT4')
947: ,p_segment5 => hr_transaction_api.get_varchar2_value
948: (p_transaction_step_id => p_transaction_step_id
949: ,p_name => 'P_SEGMENT5')
950: ,p_segment6 => hr_transaction_api.get_varchar2_value
951: (p_transaction_step_id => p_transaction_step_id
952: ,p_name => 'P_SEGMENT6')
953: ,p_segment7 => hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id

Line 953: ,p_segment7 => hr_transaction_api.get_varchar2_value

949: ,p_name => 'P_SEGMENT5')
950: ,p_segment6 => hr_transaction_api.get_varchar2_value
951: (p_transaction_step_id => p_transaction_step_id
952: ,p_name => 'P_SEGMENT6')
953: ,p_segment7 => hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_SEGMENT7')
956: ,p_segment8 => hr_transaction_api.get_varchar2_value
957: (p_transaction_step_id => p_transaction_step_id

Line 956: ,p_segment8 => hr_transaction_api.get_varchar2_value

952: ,p_name => 'P_SEGMENT6')
953: ,p_segment7 => hr_transaction_api.get_varchar2_value
954: (p_transaction_step_id => p_transaction_step_id
955: ,p_name => 'P_SEGMENT7')
956: ,p_segment8 => hr_transaction_api.get_varchar2_value
957: (p_transaction_step_id => p_transaction_step_id
958: ,p_name => 'P_SEGMENT8')
959: ,p_segment9 => hr_transaction_api.get_varchar2_value
960: (p_transaction_step_id => p_transaction_step_id

Line 959: ,p_segment9 => hr_transaction_api.get_varchar2_value

955: ,p_name => 'P_SEGMENT7')
956: ,p_segment8 => hr_transaction_api.get_varchar2_value
957: (p_transaction_step_id => p_transaction_step_id
958: ,p_name => 'P_SEGMENT8')
959: ,p_segment9 => hr_transaction_api.get_varchar2_value
960: (p_transaction_step_id => p_transaction_step_id
961: ,p_name => 'P_SEGMENT9')
962: ,p_segment10 => hr_transaction_api.get_varchar2_value
963: (p_transaction_step_id => p_transaction_step_id

Line 962: ,p_segment10 => hr_transaction_api.get_varchar2_value

958: ,p_name => 'P_SEGMENT8')
959: ,p_segment9 => hr_transaction_api.get_varchar2_value
960: (p_transaction_step_id => p_transaction_step_id
961: ,p_name => 'P_SEGMENT9')
962: ,p_segment10 => hr_transaction_api.get_varchar2_value
963: (p_transaction_step_id => p_transaction_step_id
964: ,p_name => 'P_SEGMENT10')
965: ,p_segment11 => hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id

Line 965: ,p_segment11 => hr_transaction_api.get_varchar2_value

961: ,p_name => 'P_SEGMENT9')
962: ,p_segment10 => hr_transaction_api.get_varchar2_value
963: (p_transaction_step_id => p_transaction_step_id
964: ,p_name => 'P_SEGMENT10')
965: ,p_segment11 => hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_SEGMENT11')
968: ,p_segment12 => hr_transaction_api.get_varchar2_value
969: (p_transaction_step_id => p_transaction_step_id

Line 968: ,p_segment12 => hr_transaction_api.get_varchar2_value

964: ,p_name => 'P_SEGMENT10')
965: ,p_segment11 => hr_transaction_api.get_varchar2_value
966: (p_transaction_step_id => p_transaction_step_id
967: ,p_name => 'P_SEGMENT11')
968: ,p_segment12 => hr_transaction_api.get_varchar2_value
969: (p_transaction_step_id => p_transaction_step_id
970: ,p_name => 'P_SEGMENT12')
971: ,p_segment13 => hr_transaction_api.get_varchar2_value
972: (p_transaction_step_id => p_transaction_step_id

Line 971: ,p_segment13 => hr_transaction_api.get_varchar2_value

967: ,p_name => 'P_SEGMENT11')
968: ,p_segment12 => hr_transaction_api.get_varchar2_value
969: (p_transaction_step_id => p_transaction_step_id
970: ,p_name => 'P_SEGMENT12')
971: ,p_segment13 => hr_transaction_api.get_varchar2_value
972: (p_transaction_step_id => p_transaction_step_id
973: ,p_name => 'P_SEGMENT13')
974: ,p_segment14 => hr_transaction_api.get_varchar2_value
975: (p_transaction_step_id => p_transaction_step_id

Line 974: ,p_segment14 => hr_transaction_api.get_varchar2_value

970: ,p_name => 'P_SEGMENT12')
971: ,p_segment13 => hr_transaction_api.get_varchar2_value
972: (p_transaction_step_id => p_transaction_step_id
973: ,p_name => 'P_SEGMENT13')
974: ,p_segment14 => hr_transaction_api.get_varchar2_value
975: (p_transaction_step_id => p_transaction_step_id
976: ,p_name => 'P_SEGMENT14')
977: ,p_segment15 => hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id

Line 977: ,p_segment15 => hr_transaction_api.get_varchar2_value

973: ,p_name => 'P_SEGMENT13')
974: ,p_segment14 => hr_transaction_api.get_varchar2_value
975: (p_transaction_step_id => p_transaction_step_id
976: ,p_name => 'P_SEGMENT14')
977: ,p_segment15 => hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_SEGMENT15')
980: ,p_segment16 => hr_transaction_api.get_varchar2_value
981: (p_transaction_step_id => p_transaction_step_id

Line 980: ,p_segment16 => hr_transaction_api.get_varchar2_value

976: ,p_name => 'P_SEGMENT14')
977: ,p_segment15 => hr_transaction_api.get_varchar2_value
978: (p_transaction_step_id => p_transaction_step_id
979: ,p_name => 'P_SEGMENT15')
980: ,p_segment16 => hr_transaction_api.get_varchar2_value
981: (p_transaction_step_id => p_transaction_step_id
982: ,p_name => 'P_SEGMENT16')
983: ,p_segment17 => hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => p_transaction_step_id

Line 983: ,p_segment17 => hr_transaction_api.get_varchar2_value

979: ,p_name => 'P_SEGMENT15')
980: ,p_segment16 => hr_transaction_api.get_varchar2_value
981: (p_transaction_step_id => p_transaction_step_id
982: ,p_name => 'P_SEGMENT16')
983: ,p_segment17 => hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => p_transaction_step_id
985: ,p_name => 'P_SEGMENT17')
986: ,p_segment18 => hr_transaction_api.get_varchar2_value
987: (p_transaction_step_id => p_transaction_step_id

Line 986: ,p_segment18 => hr_transaction_api.get_varchar2_value

982: ,p_name => 'P_SEGMENT16')
983: ,p_segment17 => hr_transaction_api.get_varchar2_value
984: (p_transaction_step_id => p_transaction_step_id
985: ,p_name => 'P_SEGMENT17')
986: ,p_segment18 => hr_transaction_api.get_varchar2_value
987: (p_transaction_step_id => p_transaction_step_id
988: ,p_name => 'P_SEGMENT18')
989: ,p_segment19 => hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id

Line 989: ,p_segment19 => hr_transaction_api.get_varchar2_value

985: ,p_name => 'P_SEGMENT17')
986: ,p_segment18 => hr_transaction_api.get_varchar2_value
987: (p_transaction_step_id => p_transaction_step_id
988: ,p_name => 'P_SEGMENT18')
989: ,p_segment19 => hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_SEGMENT19')
992: ,p_segment20 => hr_transaction_api.get_varchar2_value
993: (p_transaction_step_id => p_transaction_step_id

Line 992: ,p_segment20 => hr_transaction_api.get_varchar2_value

988: ,p_name => 'P_SEGMENT18')
989: ,p_segment19 => hr_transaction_api.get_varchar2_value
990: (p_transaction_step_id => p_transaction_step_id
991: ,p_name => 'P_SEGMENT19')
992: ,p_segment20 => hr_transaction_api.get_varchar2_value
993: (p_transaction_step_id => p_transaction_step_id
994: ,p_name => 'P_SEGMENT20')
995: ,p_segment21 => hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id

Line 995: ,p_segment21 => hr_transaction_api.get_varchar2_value

991: ,p_name => 'P_SEGMENT19')
992: ,p_segment20 => hr_transaction_api.get_varchar2_value
993: (p_transaction_step_id => p_transaction_step_id
994: ,p_name => 'P_SEGMENT20')
995: ,p_segment21 => hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_SEGMENT21')
998: ,p_segment22 => hr_transaction_api.get_varchar2_value
999: (p_transaction_step_id => p_transaction_step_id

Line 998: ,p_segment22 => hr_transaction_api.get_varchar2_value

994: ,p_name => 'P_SEGMENT20')
995: ,p_segment21 => hr_transaction_api.get_varchar2_value
996: (p_transaction_step_id => p_transaction_step_id
997: ,p_name => 'P_SEGMENT21')
998: ,p_segment22 => hr_transaction_api.get_varchar2_value
999: (p_transaction_step_id => p_transaction_step_id
1000: ,p_name => 'P_SEGMENT22')
1001: ,p_segment23 => hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id

Line 1001: ,p_segment23 => hr_transaction_api.get_varchar2_value

997: ,p_name => 'P_SEGMENT21')
998: ,p_segment22 => hr_transaction_api.get_varchar2_value
999: (p_transaction_step_id => p_transaction_step_id
1000: ,p_name => 'P_SEGMENT22')
1001: ,p_segment23 => hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_SEGMENT23')
1004: ,p_segment24 => hr_transaction_api.get_varchar2_value
1005: (p_transaction_step_id => p_transaction_step_id

Line 1004: ,p_segment24 => hr_transaction_api.get_varchar2_value

1000: ,p_name => 'P_SEGMENT22')
1001: ,p_segment23 => hr_transaction_api.get_varchar2_value
1002: (p_transaction_step_id => p_transaction_step_id
1003: ,p_name => 'P_SEGMENT23')
1004: ,p_segment24 => hr_transaction_api.get_varchar2_value
1005: (p_transaction_step_id => p_transaction_step_id
1006: ,p_name => 'P_SEGMENT24')
1007: ,p_segment25 => hr_transaction_api.get_varchar2_value
1008: (p_transaction_step_id => p_transaction_step_id

Line 1007: ,p_segment25 => hr_transaction_api.get_varchar2_value

1003: ,p_name => 'P_SEGMENT23')
1004: ,p_segment24 => hr_transaction_api.get_varchar2_value
1005: (p_transaction_step_id => p_transaction_step_id
1006: ,p_name => 'P_SEGMENT24')
1007: ,p_segment25 => hr_transaction_api.get_varchar2_value
1008: (p_transaction_step_id => p_transaction_step_id
1009: ,p_name => 'P_SEGMENT25')
1010: ,p_segment26 => hr_transaction_api.get_varchar2_value
1011: (p_transaction_step_id => p_transaction_step_id

Line 1010: ,p_segment26 => hr_transaction_api.get_varchar2_value

1006: ,p_name => 'P_SEGMENT24')
1007: ,p_segment25 => hr_transaction_api.get_varchar2_value
1008: (p_transaction_step_id => p_transaction_step_id
1009: ,p_name => 'P_SEGMENT25')
1010: ,p_segment26 => hr_transaction_api.get_varchar2_value
1011: (p_transaction_step_id => p_transaction_step_id
1012: ,p_name => 'P_SEGMENT26')
1013: ,p_segment27 => hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id

Line 1013: ,p_segment27 => hr_transaction_api.get_varchar2_value

1009: ,p_name => 'P_SEGMENT25')
1010: ,p_segment26 => hr_transaction_api.get_varchar2_value
1011: (p_transaction_step_id => p_transaction_step_id
1012: ,p_name => 'P_SEGMENT26')
1013: ,p_segment27 => hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_SEGMENT27')
1016: ,p_segment28 => hr_transaction_api.get_varchar2_value
1017: (p_transaction_step_id => p_transaction_step_id

Line 1016: ,p_segment28 => hr_transaction_api.get_varchar2_value

1012: ,p_name => 'P_SEGMENT26')
1013: ,p_segment27 => hr_transaction_api.get_varchar2_value
1014: (p_transaction_step_id => p_transaction_step_id
1015: ,p_name => 'P_SEGMENT27')
1016: ,p_segment28 => hr_transaction_api.get_varchar2_value
1017: (p_transaction_step_id => p_transaction_step_id
1018: ,p_name => 'P_SEGMENT28')
1019: ,p_segment29 => hr_transaction_api.get_varchar2_value
1020: (p_transaction_step_id => p_transaction_step_id

Line 1019: ,p_segment29 => hr_transaction_api.get_varchar2_value

1015: ,p_name => 'P_SEGMENT27')
1016: ,p_segment28 => hr_transaction_api.get_varchar2_value
1017: (p_transaction_step_id => p_transaction_step_id
1018: ,p_name => 'P_SEGMENT28')
1019: ,p_segment29 => hr_transaction_api.get_varchar2_value
1020: (p_transaction_step_id => p_transaction_step_id
1021: ,p_name => 'P_SEGMENT29')
1022: ,p_segment30 => hr_transaction_api.get_varchar2_value
1023: (p_transaction_step_id => p_transaction_step_id

Line 1022: ,p_segment30 => hr_transaction_api.get_varchar2_value

1018: ,p_name => 'P_SEGMENT28')
1019: ,p_segment29 => hr_transaction_api.get_varchar2_value
1020: (p_transaction_step_id => p_transaction_step_id
1021: ,p_name => 'P_SEGMENT29')
1022: ,p_segment30 => hr_transaction_api.get_varchar2_value
1023: (p_transaction_step_id => p_transaction_step_id
1024: ,p_name => 'P_SEGMENT30')
1025: ,p_combination_name => l_combination_name
1026: ,p_cost_allocation_keyflex_id => l_cost_allocation_keyflex_id

Line 1226: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');

1222: /*Create save point before starting database operation*/
1223: SAVEPOINT create_date;
1224: if p_validate = false then
1225: --
1226: l_effective_date := hr_transaction_api.get_date_value(p_transaction_step_id,'P_EFFECTIVE_DATE');
1227: if l_effective_date is null then
1228: l_effective_date := sysdate;
1229: end if;
1230:

Line 1236: l_cost_allocation_id := hr_transaction_api.get_number_value

1232: hr_utility.set_location('Get P_COST_ALLOCATION_KEYFLEX_ID and P_OBJECT_VERSION_NUMBER', 20);
1233: end if;
1234:
1235: /*Get the values used to call the API*/
1236: l_cost_allocation_id := hr_transaction_api.get_number_value
1237: (p_transaction_step_id => p_transaction_step_id
1238: ,p_name => 'P_COST_ALLOCATION_ID');
1239: l_object_version_number := hr_transaction_api.get_number_value
1240: (p_transaction_step_id => p_transaction_step_id

Line 1239: l_object_version_number := hr_transaction_api.get_number_value

1235: /*Get the values used to call the API*/
1236: l_cost_allocation_id := hr_transaction_api.get_number_value
1237: (p_transaction_step_id => p_transaction_step_id
1238: ,p_name => 'P_COST_ALLOCATION_ID');
1239: l_object_version_number := hr_transaction_api.get_number_value
1240: (p_transaction_step_id => p_transaction_step_id
1241: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1242: l_datetrack_delete_mode := hr_transaction_api.get_varchar2_value
1243: (p_transaction_step_id => p_transaction_step_id

Line 1242: l_datetrack_delete_mode := hr_transaction_api.get_varchar2_value

1238: ,p_name => 'P_COST_ALLOCATION_ID');
1239: l_object_version_number := hr_transaction_api.get_number_value
1240: (p_transaction_step_id => p_transaction_step_id
1241: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1242: l_datetrack_delete_mode := hr_transaction_api.get_varchar2_value
1243: (p_transaction_step_id => p_transaction_step_id
1244: ,p_name => 'P_DELETE_MODE');
1245:
1246: /*Now Call the API to delete the cost allocations.*/

Line 1251: ,p_cost_allocation_id => hr_transaction_api.get_number_value

1247: PAY_COST_ALLOCATION_API.DELETE_COST_ALLOCATION
1248: (p_validate => P_VALIDATE
1249: ,p_effective_date => l_effective_date
1250: ,p_datetrack_delete_mode => nvl(l_datetrack_delete_mode,'DELETE')
1251: ,p_cost_allocation_id => hr_transaction_api.get_number_value
1252: (p_transaction_step_id => p_transaction_step_id
1253: ,p_name => 'P_COST_ALLOCATION_ID')
1254: ,p_object_version_number => l_object_version_number
1255: ,p_effective_start_date => l_effective_start_date