97: END IF;
98: --
99: -- Create a transaction step
100: --
101: hr_transaction_api.create_transaction_step
102: (p_validate => false
103: ,p_creator_person_id => p_login_person_id
104: ,p_transaction_id => l_transaction_id
105: ,p_api_name => g_package || '.PROCESS_API'
376:
377: BEGIN
378: --
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: p_person_id := hr_transaction_api.get_number_value
381: (p_transaction_step_id => p_transaction_step_id
382: ,p_name => 'P_PERSON_ID');
383:
384: -- start registration
400: -- end registration
401: --
402:
403: --
404: p_login_person_id := hr_transaction_api.get_number_value
405: (p_transaction_step_id => p_transaction_step_id
406: ,p_name => 'P_LOGIN_PERSON_ID');
407: --
408: p_person_analysis_id := hr_transaction_api.get_number_value
404: p_login_person_id := hr_transaction_api.get_number_value
405: (p_transaction_step_id => p_transaction_step_id
406: ,p_name => 'P_LOGIN_PERSON_ID');
407: --
408: p_person_analysis_id := hr_transaction_api.get_number_value
409: (p_transaction_step_id => p_transaction_step_id
410: ,p_name => 'P_PERSON_ANALYSIS_ID');
411: --
412: p_pea_object_version_number := hr_transaction_api.get_number_value
408: p_person_analysis_id := hr_transaction_api.get_number_value
409: (p_transaction_step_id => p_transaction_step_id
410: ,p_name => 'P_PERSON_ANALYSIS_ID');
411: --
412: p_pea_object_version_number := hr_transaction_api.get_number_value
413: (p_transaction_step_id => p_transaction_step_id
414: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER');
415: --
416: p_effective_date:= hr_transaction_api.get_date_value
412: p_pea_object_version_number := hr_transaction_api.get_number_value
413: (p_transaction_step_id => p_transaction_step_id
414: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER');
415: --
416: p_effective_date:= hr_transaction_api.get_date_value
417: (p_transaction_step_id => p_transaction_step_id
418: ,p_name => 'P_EFFECTIVE_DATE');
419: --
420: p_date_from:= hr_transaction_api.get_date_value
416: p_effective_date:= hr_transaction_api.get_date_value
417: (p_transaction_step_id => p_transaction_step_id
418: ,p_name => 'P_EFFECTIVE_DATE');
419: --
420: p_date_from:= hr_transaction_api.get_date_value
421: (p_transaction_step_id => p_transaction_step_id
422: ,p_name => 'P_DATE_FROM');
423: --
424: p_date_to:= hr_transaction_api.get_date_value
420: p_date_from:= hr_transaction_api.get_date_value
421: (p_transaction_step_id => p_transaction_step_id
422: ,p_name => 'P_DATE_FROM');
423: --
424: p_date_to:= hr_transaction_api.get_date_value
425: (p_transaction_step_id => p_transaction_step_id
426: ,p_name => 'P_DATE_TO');
427: --
428: p_analysis_criteria_id:= hr_transaction_api.get_number_value
424: p_date_to:= hr_transaction_api.get_date_value
425: (p_transaction_step_id => p_transaction_step_id
426: ,p_name => 'P_DATE_TO');
427: --
428: p_analysis_criteria_id:= hr_transaction_api.get_number_value
429: (p_transaction_step_id => p_transaction_step_id
430: ,p_name => 'P_ANALYSIS_CRITERIA_ID');
431: --
432: p_old_analysis_criteria_id:= hr_transaction_api.get_number_value
428: p_analysis_criteria_id:= hr_transaction_api.get_number_value
429: (p_transaction_step_id => p_transaction_step_id
430: ,p_name => 'P_ANALYSIS_CRITERIA_ID');
431: --
432: p_old_analysis_criteria_id:= hr_transaction_api.get_number_value
433: (p_transaction_step_id => p_transaction_step_id
434: ,p_name => 'P_OLD_ANALYSIS_CRITERIA_ID');
435: --
436: p_business_group_id:= hr_transaction_api.get_number_value
432: p_old_analysis_criteria_id:= hr_transaction_api.get_number_value
433: (p_transaction_step_id => p_transaction_step_id
434: ,p_name => 'P_OLD_ANALYSIS_CRITERIA_ID');
435: --
436: p_business_group_id:= hr_transaction_api.get_number_value
437: (p_transaction_step_id => p_transaction_step_id
438: ,p_name => 'P_BUSINESS_GROUP_ID');
439: --
440: p_id_flex_num:= hr_transaction_api.get_number_value
436: p_business_group_id:= hr_transaction_api.get_number_value
437: (p_transaction_step_id => p_transaction_step_id
438: ,p_name => 'P_BUSINESS_GROUP_ID');
439: --
440: p_id_flex_num:= hr_transaction_api.get_number_value
441: (p_transaction_step_id => p_transaction_step_id
442: ,p_name => 'P_ID_FLEX_NUM');
443: --
444: p_structure_code:= hr_transaction_api.get_varchar2_value
440: p_id_flex_num:= hr_transaction_api.get_number_value
441: (p_transaction_step_id => p_transaction_step_id
442: ,p_name => 'P_ID_FLEX_NUM');
443: --
444: p_structure_code:= hr_transaction_api.get_varchar2_value
445: (p_transaction_step_id => p_transaction_step_id
446: ,p_name => 'P_STRUCTURE_CODE');
447: --
448: p_structure_name:= hr_transaction_api.get_varchar2_value
444: p_structure_code:= hr_transaction_api.get_varchar2_value
445: (p_transaction_step_id => p_transaction_step_id
446: ,p_name => 'P_STRUCTURE_CODE');
447: --
448: p_structure_name:= hr_transaction_api.get_varchar2_value
449: (p_transaction_step_id => p_transaction_step_id
450: ,p_name => 'P_STRUCTURE_NAME');
451: --
452: p_action:= hr_transaction_api.get_varchar2_value
448: p_structure_name:= hr_transaction_api.get_varchar2_value
449: (p_transaction_step_id => p_transaction_step_id
450: ,p_name => 'P_STRUCTURE_NAME');
451: --
452: p_action:= hr_transaction_api.get_varchar2_value
453: (p_transaction_step_id => p_transaction_step_id
454: ,p_name => 'P_ACTION');
455:
456: --
453: (p_transaction_step_id => p_transaction_step_id
454: ,p_name => 'P_ACTION');
455:
456: --
457: p_attribute_category:= hr_transaction_api.get_varchar2_value
458: (p_transaction_step_id => p_transaction_step_id
459: ,p_name => 'P_ATTRIBUTE_CATEGORY');
460:
461: --
458: (p_transaction_step_id => p_transaction_step_id
459: ,p_name => 'P_ATTRIBUTE_CATEGORY');
460:
461: --
462: p_attribute1:= hr_transaction_api.get_varchar2_value
463: (p_transaction_step_id => p_transaction_step_id
464: ,p_name => 'P_ATTRIBUTE1');
465:
466: --
463: (p_transaction_step_id => p_transaction_step_id
464: ,p_name => 'P_ATTRIBUTE1');
465:
466: --
467: p_attribute2:= hr_transaction_api.get_varchar2_value
468: (p_transaction_step_id => p_transaction_step_id
469: ,p_name => 'P_ATTRIBUTE2');
470:
471: --
468: (p_transaction_step_id => p_transaction_step_id
469: ,p_name => 'P_ATTRIBUTE2');
470:
471: --
472: p_attribute3:= hr_transaction_api.get_varchar2_value
473: (p_transaction_step_id => p_transaction_step_id
474: ,p_name => 'P_ATTRIBUTE3');
475:
476: --
473: (p_transaction_step_id => p_transaction_step_id
474: ,p_name => 'P_ATTRIBUTE3');
475:
476: --
477: p_attribute4:= hr_transaction_api.get_varchar2_value
478: (p_transaction_step_id => p_transaction_step_id
479: ,p_name => 'P_ATTRIBUTE4');
480:
481: --
478: (p_transaction_step_id => p_transaction_step_id
479: ,p_name => 'P_ATTRIBUTE4');
480:
481: --
482: p_attribute5:= hr_transaction_api.get_varchar2_value
483: (p_transaction_step_id => p_transaction_step_id
484: ,p_name => 'P_ATTRIBUTE5');
485:
486: --
483: (p_transaction_step_id => p_transaction_step_id
484: ,p_name => 'P_ATTRIBUTE5');
485:
486: --
487: p_attribute6:= hr_transaction_api.get_varchar2_value
488: (p_transaction_step_id => p_transaction_step_id
489: ,p_name => 'P_ATTRIBUTE6');
490:
491: --
488: (p_transaction_step_id => p_transaction_step_id
489: ,p_name => 'P_ATTRIBUTE6');
490:
491: --
492: p_attribute7:= hr_transaction_api.get_varchar2_value
493: (p_transaction_step_id => p_transaction_step_id
494: ,p_name => 'P_ATTRIBUTE7');
495:
496: --
493: (p_transaction_step_id => p_transaction_step_id
494: ,p_name => 'P_ATTRIBUTE7');
495:
496: --
497: p_attribute8:= hr_transaction_api.get_varchar2_value
498: (p_transaction_step_id => p_transaction_step_id
499: ,p_name => 'P_ATTRIBUTE8');
500:
501: --
498: (p_transaction_step_id => p_transaction_step_id
499: ,p_name => 'P_ATTRIBUTE8');
500:
501: --
502: p_attribute9:= hr_transaction_api.get_varchar2_value
503: (p_transaction_step_id => p_transaction_step_id
504: ,p_name => 'P_ATTRIBUTE9');
505:
506: --
503: (p_transaction_step_id => p_transaction_step_id
504: ,p_name => 'P_ATTRIBUTE9');
505:
506: --
507: p_attribute10:= hr_transaction_api.get_varchar2_value
508: (p_transaction_step_id => p_transaction_step_id
509: ,p_name => 'P_ATTRIBUTE10');
510:
511: --
508: (p_transaction_step_id => p_transaction_step_id
509: ,p_name => 'P_ATTRIBUTE10');
510:
511: --
512: p_attribute11:= hr_transaction_api.get_varchar2_value
513: (p_transaction_step_id => p_transaction_step_id
514: ,p_name => 'P_ATTRIBUTE11');
515:
516: --
513: (p_transaction_step_id => p_transaction_step_id
514: ,p_name => 'P_ATTRIBUTE11');
515:
516: --
517: p_attribute12:= hr_transaction_api.get_varchar2_value
518: (p_transaction_step_id => p_transaction_step_id
519: ,p_name => 'P_ATTRIBUTE12');
520:
521: --
518: (p_transaction_step_id => p_transaction_step_id
519: ,p_name => 'P_ATTRIBUTE12');
520:
521: --
522: p_attribute13:= hr_transaction_api.get_varchar2_value
523: (p_transaction_step_id => p_transaction_step_id
524: ,p_name => 'P_ATTRIBUTE13');
525:
526: --
523: (p_transaction_step_id => p_transaction_step_id
524: ,p_name => 'P_ATTRIBUTE13');
525:
526: --
527: p_attribute14:= hr_transaction_api.get_varchar2_value
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_ATTRIBUTE14');
530:
531: --
528: (p_transaction_step_id => p_transaction_step_id
529: ,p_name => 'P_ATTRIBUTE14');
530:
531: --
532: p_attribute15:= hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id => p_transaction_step_id
534: ,p_name => 'P_ATTRIBUTE15');
535:
536: --
533: (p_transaction_step_id => p_transaction_step_id
534: ,p_name => 'P_ATTRIBUTE15');
535:
536: --
537: p_attribute16:= hr_transaction_api.get_varchar2_value
538: (p_transaction_step_id => p_transaction_step_id
539: ,p_name => 'P_ATTRIBUTE16');
540:
541: --
538: (p_transaction_step_id => p_transaction_step_id
539: ,p_name => 'P_ATTRIBUTE16');
540:
541: --
542: p_attribute17:= hr_transaction_api.get_varchar2_value
543: (p_transaction_step_id => p_transaction_step_id
544: ,p_name => 'P_ATTRIBUTE17');
545:
546: --
543: (p_transaction_step_id => p_transaction_step_id
544: ,p_name => 'P_ATTRIBUTE17');
545:
546: --
547: p_attribute18:= hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_ATTRIBUTE18');
550:
551: --
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_ATTRIBUTE18');
550:
551: --
552: p_attribute19:= hr_transaction_api.get_varchar2_value
553: (p_transaction_step_id => p_transaction_step_id
554: ,p_name => 'P_ATTRIBUTE19');
555:
556: --
553: (p_transaction_step_id => p_transaction_step_id
554: ,p_name => 'P_ATTRIBUTE19');
555:
556: --
557: p_attribute20:= hr_transaction_api.get_varchar2_value
558: (p_transaction_step_id => p_transaction_step_id
559: ,p_name => 'P_ATTRIBUTE20');
560:
561: