APPS.OTA_CERT_APPROVAL_SS dependencies on HR_TRANSACTION_API

Line 168: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type

164: --
165: -- Delete transaction step if exist
166: --
167:
168: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
169: ,p_item_key => p_item_key
170: ,p_activity_id => p_activity_id) ) then
171:
172: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

Line 172: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type

168: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
169: ,p_item_key => p_item_key
170: ,p_activity_id => p_activity_id) ) then
171:
172: hr_transaction_api.get_transaction_step_info(p_item_type => p_item_type
173: ,p_item_key => p_item_key
174: ,p_activity_id => p_activity_id
175: ,p_transaction_step_id => l_old_transaction_step_id
176: ,p_object_version_number => l_old_object_version_number);

Line 179: hr_transaction_api.delete_transaction_step(p_validate => false

175: ,p_transaction_step_id => l_old_transaction_step_id
176: ,p_object_version_number => l_old_object_version_number);
177:
178:
179: hr_transaction_api.delete_transaction_step(p_validate => false
180: ,p_transaction_step_id => l_old_transaction_step_id
181: ,p_person_id => p_login_person_id
182: ,p_object_version_number => l_old_object_version_number);
183:

Line 189: hr_transaction_api.create_transaction_step

185:
186: --
187: -- Create a transaction step
188: --
189: hr_transaction_api.create_transaction_step
190: (p_validate => false
191: ,p_creator_person_id => p_login_person_id
192: ,p_transaction_id => l_transaction_id
193: ,p_api_name => g_package || '.PROCESS_API'

Line 516: l_certification_id := hr_transaction_api.get_varchar2_value

512:
513: begin
514:
515:
516: l_certification_id := hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id => p_transaction_step_id
518: ,p_name => 'P_CERTIFICATIONID');
519:
520: l_attribute_category := hr_transaction_api.get_varchar2_value

Line 520: l_attribute_category := hr_transaction_api.get_varchar2_value

516: l_certification_id := hr_transaction_api.get_varchar2_value
517: (p_transaction_step_id => p_transaction_step_id
518: ,p_name => 'P_CERTIFICATIONID');
519:
520: l_attribute_category := hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id => p_transaction_step_id
522: ,p_name => 'P_ATTRIBUTECATEGORY');
523: l_attribute1 := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id

Line 523: l_attribute1 := hr_transaction_api.get_varchar2_value

519:
520: l_attribute_category := hr_transaction_api.get_varchar2_value
521: (p_transaction_step_id => p_transaction_step_id
522: ,p_name => 'P_ATTRIBUTECATEGORY');
523: l_attribute1 := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_ATTRIBUTE1');
526: l_attribute2 := hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id => p_transaction_step_id

Line 526: l_attribute2 := hr_transaction_api.get_varchar2_value

522: ,p_name => 'P_ATTRIBUTECATEGORY');
523: l_attribute1 := hr_transaction_api.get_varchar2_value
524: (p_transaction_step_id => p_transaction_step_id
525: ,p_name => 'P_ATTRIBUTE1');
526: l_attribute2 := hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id => p_transaction_step_id
528: ,p_name => 'P_ATTRIBUTE2');
529: l_attribute3 := hr_transaction_api.get_varchar2_value
530: (p_transaction_step_id => p_transaction_step_id

Line 529: l_attribute3 := hr_transaction_api.get_varchar2_value

525: ,p_name => 'P_ATTRIBUTE1');
526: l_attribute2 := hr_transaction_api.get_varchar2_value
527: (p_transaction_step_id => p_transaction_step_id
528: ,p_name => 'P_ATTRIBUTE2');
529: l_attribute3 := hr_transaction_api.get_varchar2_value
530: (p_transaction_step_id => p_transaction_step_id
531: ,p_name => 'P_ATTRIBUTE3');
532: l_attribute4 := hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id => p_transaction_step_id

Line 532: l_attribute4 := hr_transaction_api.get_varchar2_value

528: ,p_name => 'P_ATTRIBUTE2');
529: l_attribute3 := hr_transaction_api.get_varchar2_value
530: (p_transaction_step_id => p_transaction_step_id
531: ,p_name => 'P_ATTRIBUTE3');
532: l_attribute4 := hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id => p_transaction_step_id
534: ,p_name => 'P_ATTRIBUTE4');
535: l_attribute5 := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id

Line 535: l_attribute5 := hr_transaction_api.get_varchar2_value

531: ,p_name => 'P_ATTRIBUTE3');
532: l_attribute4 := hr_transaction_api.get_varchar2_value
533: (p_transaction_step_id => p_transaction_step_id
534: ,p_name => 'P_ATTRIBUTE4');
535: l_attribute5 := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_ATTRIBUTE5');
538: l_attribute6 := hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id => p_transaction_step_id

Line 538: l_attribute6 := hr_transaction_api.get_varchar2_value

534: ,p_name => 'P_ATTRIBUTE4');
535: l_attribute5 := hr_transaction_api.get_varchar2_value
536: (p_transaction_step_id => p_transaction_step_id
537: ,p_name => 'P_ATTRIBUTE5');
538: l_attribute6 := hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id => p_transaction_step_id
540: ,p_name => 'P_ATTRIBUTE6');
541: l_attribute7 := hr_transaction_api.get_varchar2_value
542: (p_transaction_step_id => p_transaction_step_id

Line 541: l_attribute7 := hr_transaction_api.get_varchar2_value

537: ,p_name => 'P_ATTRIBUTE5');
538: l_attribute6 := hr_transaction_api.get_varchar2_value
539: (p_transaction_step_id => p_transaction_step_id
540: ,p_name => 'P_ATTRIBUTE6');
541: l_attribute7 := hr_transaction_api.get_varchar2_value
542: (p_transaction_step_id => p_transaction_step_id
543: ,p_name => 'P_ATTRIBUTE7');
544: l_attribute8 := hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id => p_transaction_step_id

Line 544: l_attribute8 := hr_transaction_api.get_varchar2_value

540: ,p_name => 'P_ATTRIBUTE6');
541: l_attribute7 := hr_transaction_api.get_varchar2_value
542: (p_transaction_step_id => p_transaction_step_id
543: ,p_name => 'P_ATTRIBUTE7');
544: l_attribute8 := hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id => p_transaction_step_id
546: ,p_name => 'P_ATTRIBUTE8');
547: l_attribute9 := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id

Line 547: l_attribute9 := hr_transaction_api.get_varchar2_value

543: ,p_name => 'P_ATTRIBUTE7');
544: l_attribute8 := hr_transaction_api.get_varchar2_value
545: (p_transaction_step_id => p_transaction_step_id
546: ,p_name => 'P_ATTRIBUTE8');
547: l_attribute9 := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_ATTRIBUTE9');
550: l_attribute10 := hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id => p_transaction_step_id

Line 550: l_attribute10 := hr_transaction_api.get_varchar2_value

546: ,p_name => 'P_ATTRIBUTE8');
547: l_attribute9 := hr_transaction_api.get_varchar2_value
548: (p_transaction_step_id => p_transaction_step_id
549: ,p_name => 'P_ATTRIBUTE9');
550: l_attribute10 := hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id => p_transaction_step_id
552: ,p_name => 'P_ATTRIBUTE10');
553: l_attribute11 := hr_transaction_api.get_varchar2_value
554: (p_transaction_step_id => p_transaction_step_id

Line 553: l_attribute11 := hr_transaction_api.get_varchar2_value

549: ,p_name => 'P_ATTRIBUTE9');
550: l_attribute10 := hr_transaction_api.get_varchar2_value
551: (p_transaction_step_id => p_transaction_step_id
552: ,p_name => 'P_ATTRIBUTE10');
553: l_attribute11 := hr_transaction_api.get_varchar2_value
554: (p_transaction_step_id => p_transaction_step_id
555: ,p_name => 'P_ATTRIBUTE11');
556: l_attribute12 := hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id => p_transaction_step_id

Line 556: l_attribute12 := hr_transaction_api.get_varchar2_value

552: ,p_name => 'P_ATTRIBUTE10');
553: l_attribute11 := hr_transaction_api.get_varchar2_value
554: (p_transaction_step_id => p_transaction_step_id
555: ,p_name => 'P_ATTRIBUTE11');
556: l_attribute12 := hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id => p_transaction_step_id
558: ,p_name => 'P_ATTRIBUTE12');
559: l_attribute13 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id

Line 559: l_attribute13 := hr_transaction_api.get_varchar2_value

555: ,p_name => 'P_ATTRIBUTE11');
556: l_attribute12 := hr_transaction_api.get_varchar2_value
557: (p_transaction_step_id => p_transaction_step_id
558: ,p_name => 'P_ATTRIBUTE12');
559: l_attribute13 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_ATTRIBUTE13');
562: l_attribute14 := hr_transaction_api.get_varchar2_value
563: (p_transaction_step_id => p_transaction_step_id

Line 562: l_attribute14 := hr_transaction_api.get_varchar2_value

558: ,p_name => 'P_ATTRIBUTE12');
559: l_attribute13 := hr_transaction_api.get_varchar2_value
560: (p_transaction_step_id => p_transaction_step_id
561: ,p_name => 'P_ATTRIBUTE13');
562: l_attribute14 := hr_transaction_api.get_varchar2_value
563: (p_transaction_step_id => p_transaction_step_id
564: ,p_name => 'P_ATTRIBUTE14');
565: l_attribute15 := hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id => p_transaction_step_id

Line 565: l_attribute15 := hr_transaction_api.get_varchar2_value

561: ,p_name => 'P_ATTRIBUTE13');
562: l_attribute14 := hr_transaction_api.get_varchar2_value
563: (p_transaction_step_id => p_transaction_step_id
564: ,p_name => 'P_ATTRIBUTE14');
565: l_attribute15 := hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id => p_transaction_step_id
567: ,p_name => 'P_ATTRIBUTE15');
568: l_attribute16 := hr_transaction_api.get_varchar2_value
569: (p_transaction_step_id => p_transaction_step_id

Line 568: l_attribute16 := hr_transaction_api.get_varchar2_value

564: ,p_name => 'P_ATTRIBUTE14');
565: l_attribute15 := hr_transaction_api.get_varchar2_value
566: (p_transaction_step_id => p_transaction_step_id
567: ,p_name => 'P_ATTRIBUTE15');
568: l_attribute16 := hr_transaction_api.get_varchar2_value
569: (p_transaction_step_id => p_transaction_step_id
570: ,p_name => 'P_ATTRIBUTE16');
571: l_attribute17 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id

Line 571: l_attribute17 := hr_transaction_api.get_varchar2_value

567: ,p_name => 'P_ATTRIBUTE15');
568: l_attribute16 := hr_transaction_api.get_varchar2_value
569: (p_transaction_step_id => p_transaction_step_id
570: ,p_name => 'P_ATTRIBUTE16');
571: l_attribute17 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_ATTRIBUTE17');
574: l_attribute18 := hr_transaction_api.get_varchar2_value
575: (p_transaction_step_id => p_transaction_step_id

Line 574: l_attribute18 := hr_transaction_api.get_varchar2_value

570: ,p_name => 'P_ATTRIBUTE16');
571: l_attribute17 := hr_transaction_api.get_varchar2_value
572: (p_transaction_step_id => p_transaction_step_id
573: ,p_name => 'P_ATTRIBUTE17');
574: l_attribute18 := hr_transaction_api.get_varchar2_value
575: (p_transaction_step_id => p_transaction_step_id
576: ,p_name => 'P_ATTRIBUTE18');
577: l_attribute19 := hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id => p_transaction_step_id

Line 577: l_attribute19 := hr_transaction_api.get_varchar2_value

573: ,p_name => 'P_ATTRIBUTE17');
574: l_attribute18 := hr_transaction_api.get_varchar2_value
575: (p_transaction_step_id => p_transaction_step_id
576: ,p_name => 'P_ATTRIBUTE18');
577: l_attribute19 := hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id => p_transaction_step_id
579: ,p_name => 'P_ATTRIBUTE19');
580: l_attribute20 := hr_transaction_api.get_varchar2_value
581: (p_transaction_step_id => p_transaction_step_id

Line 580: l_attribute20 := hr_transaction_api.get_varchar2_value

576: ,p_name => 'P_ATTRIBUTE18');
577: l_attribute19 := hr_transaction_api.get_varchar2_value
578: (p_transaction_step_id => p_transaction_step_id
579: ,p_name => 'P_ATTRIBUTE19');
580: l_attribute20 := hr_transaction_api.get_varchar2_value
581: (p_transaction_step_id => p_transaction_step_id
582: ,p_name => 'P_ATTRIBUTE20');
583:
584: --

Line 690: l_certification_id := hr_transaction_api.get_varchar2_value

686:
687: begin
688:
689:
690: l_certification_id := hr_transaction_api.get_varchar2_value
691: (p_transaction_step_id => p_transaction_step_id
692: ,p_name => 'P_CERTIFICATIONID');
693:
694: /*

Line 784: l_certification_id := hr_transaction_api.get_varchar2_value

780: l_approval_req_flag :='A';
781:
782: end if;
783:
784: l_certification_id := hr_transaction_api.get_varchar2_value
785: (p_transaction_step_id => p_transaction_step_id
786: ,p_name => 'P_CERTIFICATIONID');
787: /*l_certification_status_code := hr_transaction_api.get_varchar2_value
788: (p_transaction_step_id => p_transaction_step_id

Line 787: /*l_certification_status_code := hr_transaction_api.get_varchar2_value

783:
784: l_certification_id := hr_transaction_api.get_varchar2_value
785: (p_transaction_step_id => p_transaction_step_id
786: ,p_name => 'P_CERTIFICATIONID');
787: /*l_certification_status_code := hr_transaction_api.get_varchar2_value
788: (p_transaction_step_id => p_transaction_step_id
789: ,p_name => 'P_CERTIFICATIONCODE');*/
790: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value
791: (p_transaction_step_id => p_transaction_step_id

Line 790: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value

786: ,p_name => 'P_CERTIFICATIONID');
787: /*l_certification_status_code := hr_transaction_api.get_varchar2_value
788: (p_transaction_step_id => p_transaction_step_id
789: ,p_name => 'P_CERTIFICATIONCODE');*/
790: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_HISTORYFLAG');
793: l_person_id := hr_transaction_api.get_Number_value
794: (p_transaction_step_id => p_transaction_step_id

Line 793: l_person_id := hr_transaction_api.get_Number_value

789: ,p_name => 'P_CERTIFICATIONCODE');*/
790: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value
791: (p_transaction_step_id => p_transaction_step_id
792: ,p_name => 'P_HISTORYFLAG');
793: l_person_id := hr_transaction_api.get_Number_value
794: (p_transaction_step_id => p_transaction_step_id
795: ,p_name => 'P_PERSONID');
796: l_business_group_id := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id

Line 796: l_business_group_id := hr_transaction_api.get_varchar2_value

792: ,p_name => 'P_HISTORYFLAG');
793: l_person_id := hr_transaction_api.get_Number_value
794: (p_transaction_step_id => p_transaction_step_id
795: ,p_name => 'P_PERSONID');
796: l_business_group_id := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_BUSINESSGROUPID');
799: l_attribute_category := hr_transaction_api.get_varchar2_value
800: (p_transaction_step_id => p_transaction_step_id

Line 799: l_attribute_category := hr_transaction_api.get_varchar2_value

795: ,p_name => 'P_PERSONID');
796: l_business_group_id := hr_transaction_api.get_varchar2_value
797: (p_transaction_step_id => p_transaction_step_id
798: ,p_name => 'P_BUSINESSGROUPID');
799: l_attribute_category := hr_transaction_api.get_varchar2_value
800: (p_transaction_step_id => p_transaction_step_id
801: ,p_name => 'P_ATTRIBUTECATEGORY');
802: l_attribute1 := hr_transaction_api.get_varchar2_value
803: (p_transaction_step_id => p_transaction_step_id

Line 802: l_attribute1 := hr_transaction_api.get_varchar2_value

798: ,p_name => 'P_BUSINESSGROUPID');
799: l_attribute_category := hr_transaction_api.get_varchar2_value
800: (p_transaction_step_id => p_transaction_step_id
801: ,p_name => 'P_ATTRIBUTECATEGORY');
802: l_attribute1 := hr_transaction_api.get_varchar2_value
803: (p_transaction_step_id => p_transaction_step_id
804: ,p_name => 'P_ATTRIBUTE1');
805: l_attribute2 := hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id

Line 805: l_attribute2 := hr_transaction_api.get_varchar2_value

801: ,p_name => 'P_ATTRIBUTECATEGORY');
802: l_attribute1 := hr_transaction_api.get_varchar2_value
803: (p_transaction_step_id => p_transaction_step_id
804: ,p_name => 'P_ATTRIBUTE1');
805: l_attribute2 := hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_ATTRIBUTE2');
808: l_attribute3 := hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => p_transaction_step_id

Line 808: l_attribute3 := hr_transaction_api.get_varchar2_value

804: ,p_name => 'P_ATTRIBUTE1');
805: l_attribute2 := hr_transaction_api.get_varchar2_value
806: (p_transaction_step_id => p_transaction_step_id
807: ,p_name => 'P_ATTRIBUTE2');
808: l_attribute3 := hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => p_transaction_step_id
810: ,p_name => 'P_ATTRIBUTE3');
811: l_attribute4 := hr_transaction_api.get_varchar2_value
812: (p_transaction_step_id => p_transaction_step_id

Line 811: l_attribute4 := hr_transaction_api.get_varchar2_value

807: ,p_name => 'P_ATTRIBUTE2');
808: l_attribute3 := hr_transaction_api.get_varchar2_value
809: (p_transaction_step_id => p_transaction_step_id
810: ,p_name => 'P_ATTRIBUTE3');
811: l_attribute4 := hr_transaction_api.get_varchar2_value
812: (p_transaction_step_id => p_transaction_step_id
813: ,p_name => 'P_ATTRIBUTE4');
814: l_attribute5 := hr_transaction_api.get_varchar2_value
815: (p_transaction_step_id => p_transaction_step_id

Line 814: l_attribute5 := hr_transaction_api.get_varchar2_value

810: ,p_name => 'P_ATTRIBUTE3');
811: l_attribute4 := hr_transaction_api.get_varchar2_value
812: (p_transaction_step_id => p_transaction_step_id
813: ,p_name => 'P_ATTRIBUTE4');
814: l_attribute5 := hr_transaction_api.get_varchar2_value
815: (p_transaction_step_id => p_transaction_step_id
816: ,p_name => 'P_ATTRIBUTE5');
817: l_attribute6 := hr_transaction_api.get_varchar2_value
818: (p_transaction_step_id => p_transaction_step_id

Line 817: l_attribute6 := hr_transaction_api.get_varchar2_value

813: ,p_name => 'P_ATTRIBUTE4');
814: l_attribute5 := hr_transaction_api.get_varchar2_value
815: (p_transaction_step_id => p_transaction_step_id
816: ,p_name => 'P_ATTRIBUTE5');
817: l_attribute6 := hr_transaction_api.get_varchar2_value
818: (p_transaction_step_id => p_transaction_step_id
819: ,p_name => 'P_ATTRIBUTE6');
820: l_attribute7 := hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id

Line 820: l_attribute7 := hr_transaction_api.get_varchar2_value

816: ,p_name => 'P_ATTRIBUTE5');
817: l_attribute6 := hr_transaction_api.get_varchar2_value
818: (p_transaction_step_id => p_transaction_step_id
819: ,p_name => 'P_ATTRIBUTE6');
820: l_attribute7 := hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_ATTRIBUTE7');
823: l_attribute8 := hr_transaction_api.get_varchar2_value
824: (p_transaction_step_id => p_transaction_step_id

Line 823: l_attribute8 := hr_transaction_api.get_varchar2_value

819: ,p_name => 'P_ATTRIBUTE6');
820: l_attribute7 := hr_transaction_api.get_varchar2_value
821: (p_transaction_step_id => p_transaction_step_id
822: ,p_name => 'P_ATTRIBUTE7');
823: l_attribute8 := hr_transaction_api.get_varchar2_value
824: (p_transaction_step_id => p_transaction_step_id
825: ,p_name => 'P_ATTRIBUTE8');
826: l_attribute9 := hr_transaction_api.get_varchar2_value
827: (p_transaction_step_id => p_transaction_step_id

Line 826: l_attribute9 := hr_transaction_api.get_varchar2_value

822: ,p_name => 'P_ATTRIBUTE7');
823: l_attribute8 := hr_transaction_api.get_varchar2_value
824: (p_transaction_step_id => p_transaction_step_id
825: ,p_name => 'P_ATTRIBUTE8');
826: l_attribute9 := hr_transaction_api.get_varchar2_value
827: (p_transaction_step_id => p_transaction_step_id
828: ,p_name => 'P_ATTRIBUTE9');
829: l_attribute10 := hr_transaction_api.get_varchar2_value
830: (p_transaction_step_id => p_transaction_step_id

Line 829: l_attribute10 := hr_transaction_api.get_varchar2_value

825: ,p_name => 'P_ATTRIBUTE8');
826: l_attribute9 := hr_transaction_api.get_varchar2_value
827: (p_transaction_step_id => p_transaction_step_id
828: ,p_name => 'P_ATTRIBUTE9');
829: l_attribute10 := hr_transaction_api.get_varchar2_value
830: (p_transaction_step_id => p_transaction_step_id
831: ,p_name => 'P_ATTRIBUTE10');
832: l_attribute11 := hr_transaction_api.get_varchar2_value
833: (p_transaction_step_id => p_transaction_step_id

Line 832: l_attribute11 := hr_transaction_api.get_varchar2_value

828: ,p_name => 'P_ATTRIBUTE9');
829: l_attribute10 := hr_transaction_api.get_varchar2_value
830: (p_transaction_step_id => p_transaction_step_id
831: ,p_name => 'P_ATTRIBUTE10');
832: l_attribute11 := hr_transaction_api.get_varchar2_value
833: (p_transaction_step_id => p_transaction_step_id
834: ,p_name => 'P_ATTRIBUTE11');
835: l_attribute12 := hr_transaction_api.get_varchar2_value
836: (p_transaction_step_id => p_transaction_step_id

Line 835: l_attribute12 := hr_transaction_api.get_varchar2_value

831: ,p_name => 'P_ATTRIBUTE10');
832: l_attribute11 := hr_transaction_api.get_varchar2_value
833: (p_transaction_step_id => p_transaction_step_id
834: ,p_name => 'P_ATTRIBUTE11');
835: l_attribute12 := hr_transaction_api.get_varchar2_value
836: (p_transaction_step_id => p_transaction_step_id
837: ,p_name => 'P_ATTRIBUTE12');
838: l_attribute13 := hr_transaction_api.get_varchar2_value
839: (p_transaction_step_id => p_transaction_step_id

Line 838: l_attribute13 := hr_transaction_api.get_varchar2_value

834: ,p_name => 'P_ATTRIBUTE11');
835: l_attribute12 := hr_transaction_api.get_varchar2_value
836: (p_transaction_step_id => p_transaction_step_id
837: ,p_name => 'P_ATTRIBUTE12');
838: l_attribute13 := hr_transaction_api.get_varchar2_value
839: (p_transaction_step_id => p_transaction_step_id
840: ,p_name => 'P_ATTRIBUTE13');
841: l_attribute14 := hr_transaction_api.get_varchar2_value
842: (p_transaction_step_id => p_transaction_step_id

Line 841: l_attribute14 := hr_transaction_api.get_varchar2_value

837: ,p_name => 'P_ATTRIBUTE12');
838: l_attribute13 := hr_transaction_api.get_varchar2_value
839: (p_transaction_step_id => p_transaction_step_id
840: ,p_name => 'P_ATTRIBUTE13');
841: l_attribute14 := hr_transaction_api.get_varchar2_value
842: (p_transaction_step_id => p_transaction_step_id
843: ,p_name => 'P_ATTRIBUTE14');
844: l_attribute15 := hr_transaction_api.get_varchar2_value
845: (p_transaction_step_id => p_transaction_step_id

Line 844: l_attribute15 := hr_transaction_api.get_varchar2_value

840: ,p_name => 'P_ATTRIBUTE13');
841: l_attribute14 := hr_transaction_api.get_varchar2_value
842: (p_transaction_step_id => p_transaction_step_id
843: ,p_name => 'P_ATTRIBUTE14');
844: l_attribute15 := hr_transaction_api.get_varchar2_value
845: (p_transaction_step_id => p_transaction_step_id
846: ,p_name => 'P_ATTRIBUTE15');
847: l_attribute16 := hr_transaction_api.get_varchar2_value
848: (p_transaction_step_id => p_transaction_step_id

Line 847: l_attribute16 := hr_transaction_api.get_varchar2_value

843: ,p_name => 'P_ATTRIBUTE14');
844: l_attribute15 := hr_transaction_api.get_varchar2_value
845: (p_transaction_step_id => p_transaction_step_id
846: ,p_name => 'P_ATTRIBUTE15');
847: l_attribute16 := hr_transaction_api.get_varchar2_value
848: (p_transaction_step_id => p_transaction_step_id
849: ,p_name => 'P_ATTRIBUTE16');
850: l_attribute17 := hr_transaction_api.get_varchar2_value
851: (p_transaction_step_id => p_transaction_step_id

Line 850: l_attribute17 := hr_transaction_api.get_varchar2_value

846: ,p_name => 'P_ATTRIBUTE15');
847: l_attribute16 := hr_transaction_api.get_varchar2_value
848: (p_transaction_step_id => p_transaction_step_id
849: ,p_name => 'P_ATTRIBUTE16');
850: l_attribute17 := hr_transaction_api.get_varchar2_value
851: (p_transaction_step_id => p_transaction_step_id
852: ,p_name => 'P_ATTRIBUTE17');
853: l_attribute18 := hr_transaction_api.get_varchar2_value
854: (p_transaction_step_id => p_transaction_step_id

Line 853: l_attribute18 := hr_transaction_api.get_varchar2_value

849: ,p_name => 'P_ATTRIBUTE16');
850: l_attribute17 := hr_transaction_api.get_varchar2_value
851: (p_transaction_step_id => p_transaction_step_id
852: ,p_name => 'P_ATTRIBUTE17');
853: l_attribute18 := hr_transaction_api.get_varchar2_value
854: (p_transaction_step_id => p_transaction_step_id
855: ,p_name => 'P_ATTRIBUTE18');
856: l_attribute19 := hr_transaction_api.get_varchar2_value
857: (p_transaction_step_id => p_transaction_step_id

Line 856: l_attribute19 := hr_transaction_api.get_varchar2_value

852: ,p_name => 'P_ATTRIBUTE17');
853: l_attribute18 := hr_transaction_api.get_varchar2_value
854: (p_transaction_step_id => p_transaction_step_id
855: ,p_name => 'P_ATTRIBUTE18');
856: l_attribute19 := hr_transaction_api.get_varchar2_value
857: (p_transaction_step_id => p_transaction_step_id
858: ,p_name => 'P_ATTRIBUTE19');
859: l_attribute20 := hr_transaction_api.get_varchar2_value
860: (p_transaction_step_id => p_transaction_step_id

Line 859: l_attribute20 := hr_transaction_api.get_varchar2_value

855: ,p_name => 'P_ATTRIBUTE18');
856: l_attribute19 := hr_transaction_api.get_varchar2_value
857: (p_transaction_step_id => p_transaction_step_id
858: ,p_name => 'P_ATTRIBUTE19');
859: l_attribute20 := hr_transaction_api.get_varchar2_value
860: (p_transaction_step_id => p_transaction_step_id
861: ,p_name => 'P_ATTRIBUTE20');
862: l_completion_date := hr_transaction_api.get_varchar2_value
863: (p_transaction_step_id => p_transaction_step_id

Line 862: l_completion_date := hr_transaction_api.get_varchar2_value

858: ,p_name => 'P_ATTRIBUTE19');
859: l_attribute20 := hr_transaction_api.get_varchar2_value
860: (p_transaction_step_id => p_transaction_step_id
861: ,p_name => 'P_ATTRIBUTE20');
862: l_completion_date := hr_transaction_api.get_varchar2_value
863: (p_transaction_step_id => p_transaction_step_id
864: ,p_name => 'P_COMPLETIONDATE');
865: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
866: (p_transaction_step_id => p_transaction_step_id

Line 865: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value

861: ,p_name => 'P_ATTRIBUTE20');
862: l_completion_date := hr_transaction_api.get_varchar2_value
863: (p_transaction_step_id => p_transaction_step_id
864: ,p_name => 'P_COMPLETIONDATE');
865: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
866: (p_transaction_step_id => p_transaction_step_id
867: ,p_name => 'P_UNENROLLMENTDATE');
868:
869: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value

Line 869: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value

865: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
866: (p_transaction_step_id => p_transaction_step_id
867: ,p_name => 'P_UNENROLLMENTDATE');
868:
869: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value
870: (p_transaction_step_id => p_transaction_step_id
871: ,p_name => 'P_EXPIRATIONDATE');
872: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id

Line 872: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value

868:
869: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value
870: (p_transaction_step_id => p_transaction_step_id
871: ,p_name => 'P_EXPIRATIONDATE');
872: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value
873: (p_transaction_step_id => p_transaction_step_id
874: ,p_name => 'P_EARLIESTENROLLDATE');
875:
876: hr_utility.trace ('Before create ' ||'10');

Line 919: hr_transaction_api.get_transaction_step_info

915:
916: hr_utility.trace ('AFTER create ' ||'10');
917: --Put certification enrollment id in wf attributes
918: --req during update
919: hr_transaction_api.get_transaction_step_info
920: (p_transaction_step_id => p_transaction_step_id
921: ,p_item_type => l_item_type
922: ,p_item_key => l_item_key
923: ,p_activity_id => l_activity_id);

Line 1003: hr_transaction_api.get_transaction_step_info

999:
1000: begin
1001:
1002: if l_item_key is null then
1003: hr_transaction_api.get_transaction_step_info
1004: (p_transaction_step_id => p_transaction_step_id
1005: ,p_item_type => l_item_type
1006: ,p_item_key => l_item_key
1007: ,p_activity_id => l_activity_id);

Line 1051: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value

1047: -- call subscribe to create child objects as well
1048:
1049: --really req or not ??
1050:
1051: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value
1052: (p_transaction_step_id => p_transaction_step_id
1053: ,p_name => 'P_HISTORYFLAG');
1054: l_person_id := hr_transaction_api.get_Number_value
1055: (p_transaction_step_id => p_transaction_step_id

Line 1054: l_person_id := hr_transaction_api.get_Number_value

1050:
1051: l_IS_HISTORY_FLAG := hr_transaction_api.get_varchar2_value
1052: (p_transaction_step_id => p_transaction_step_id
1053: ,p_name => 'P_HISTORYFLAG');
1054: l_person_id := hr_transaction_api.get_Number_value
1055: (p_transaction_step_id => p_transaction_step_id
1056: ,p_name => 'P_PERSONID');
1057: l_business_group_id := hr_transaction_api.get_varchar2_value
1058: (p_transaction_step_id => p_transaction_step_id

Line 1057: l_business_group_id := hr_transaction_api.get_varchar2_value

1053: ,p_name => 'P_HISTORYFLAG');
1054: l_person_id := hr_transaction_api.get_Number_value
1055: (p_transaction_step_id => p_transaction_step_id
1056: ,p_name => 'P_PERSONID');
1057: l_business_group_id := hr_transaction_api.get_varchar2_value
1058: (p_transaction_step_id => p_transaction_step_id
1059: ,p_name => 'P_BUSINESSGROUPID');
1060: l_attribute_category := hr_transaction_api.get_varchar2_value
1061: (p_transaction_step_id => p_transaction_step_id

Line 1060: l_attribute_category := hr_transaction_api.get_varchar2_value

1056: ,p_name => 'P_PERSONID');
1057: l_business_group_id := hr_transaction_api.get_varchar2_value
1058: (p_transaction_step_id => p_transaction_step_id
1059: ,p_name => 'P_BUSINESSGROUPID');
1060: l_attribute_category := hr_transaction_api.get_varchar2_value
1061: (p_transaction_step_id => p_transaction_step_id
1062: ,p_name => 'P_ATTRIBUTECATEGORY');
1063: l_attribute1 := hr_transaction_api.get_varchar2_value
1064: (p_transaction_step_id => p_transaction_step_id

Line 1063: l_attribute1 := hr_transaction_api.get_varchar2_value

1059: ,p_name => 'P_BUSINESSGROUPID');
1060: l_attribute_category := hr_transaction_api.get_varchar2_value
1061: (p_transaction_step_id => p_transaction_step_id
1062: ,p_name => 'P_ATTRIBUTECATEGORY');
1063: l_attribute1 := hr_transaction_api.get_varchar2_value
1064: (p_transaction_step_id => p_transaction_step_id
1065: ,p_name => 'P_ATTRIBUTE1');
1066: l_attribute2 := hr_transaction_api.get_varchar2_value
1067: (p_transaction_step_id => p_transaction_step_id

Line 1066: l_attribute2 := hr_transaction_api.get_varchar2_value

1062: ,p_name => 'P_ATTRIBUTECATEGORY');
1063: l_attribute1 := hr_transaction_api.get_varchar2_value
1064: (p_transaction_step_id => p_transaction_step_id
1065: ,p_name => 'P_ATTRIBUTE1');
1066: l_attribute2 := hr_transaction_api.get_varchar2_value
1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_ATTRIBUTE2');
1069: l_attribute3 := hr_transaction_api.get_varchar2_value
1070: (p_transaction_step_id => p_transaction_step_id

Line 1069: l_attribute3 := hr_transaction_api.get_varchar2_value

1065: ,p_name => 'P_ATTRIBUTE1');
1066: l_attribute2 := hr_transaction_api.get_varchar2_value
1067: (p_transaction_step_id => p_transaction_step_id
1068: ,p_name => 'P_ATTRIBUTE2');
1069: l_attribute3 := hr_transaction_api.get_varchar2_value
1070: (p_transaction_step_id => p_transaction_step_id
1071: ,p_name => 'P_ATTRIBUTE3');
1072: l_attribute4 := hr_transaction_api.get_varchar2_value
1073: (p_transaction_step_id => p_transaction_step_id

Line 1072: l_attribute4 := hr_transaction_api.get_varchar2_value

1068: ,p_name => 'P_ATTRIBUTE2');
1069: l_attribute3 := hr_transaction_api.get_varchar2_value
1070: (p_transaction_step_id => p_transaction_step_id
1071: ,p_name => 'P_ATTRIBUTE3');
1072: l_attribute4 := hr_transaction_api.get_varchar2_value
1073: (p_transaction_step_id => p_transaction_step_id
1074: ,p_name => 'P_ATTRIBUTE4');
1075: l_attribute5 := hr_transaction_api.get_varchar2_value
1076: (p_transaction_step_id => p_transaction_step_id

Line 1075: l_attribute5 := hr_transaction_api.get_varchar2_value

1071: ,p_name => 'P_ATTRIBUTE3');
1072: l_attribute4 := hr_transaction_api.get_varchar2_value
1073: (p_transaction_step_id => p_transaction_step_id
1074: ,p_name => 'P_ATTRIBUTE4');
1075: l_attribute5 := hr_transaction_api.get_varchar2_value
1076: (p_transaction_step_id => p_transaction_step_id
1077: ,p_name => 'P_ATTRIBUTE5');
1078: l_attribute6 := hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id

Line 1078: l_attribute6 := hr_transaction_api.get_varchar2_value

1074: ,p_name => 'P_ATTRIBUTE4');
1075: l_attribute5 := hr_transaction_api.get_varchar2_value
1076: (p_transaction_step_id => p_transaction_step_id
1077: ,p_name => 'P_ATTRIBUTE5');
1078: l_attribute6 := hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id
1080: ,p_name => 'P_ATTRIBUTE6');
1081: l_attribute7 := hr_transaction_api.get_varchar2_value
1082: (p_transaction_step_id => p_transaction_step_id

Line 1081: l_attribute7 := hr_transaction_api.get_varchar2_value

1077: ,p_name => 'P_ATTRIBUTE5');
1078: l_attribute6 := hr_transaction_api.get_varchar2_value
1079: (p_transaction_step_id => p_transaction_step_id
1080: ,p_name => 'P_ATTRIBUTE6');
1081: l_attribute7 := hr_transaction_api.get_varchar2_value
1082: (p_transaction_step_id => p_transaction_step_id
1083: ,p_name => 'P_ATTRIBUTE7');
1084: l_attribute8 := hr_transaction_api.get_varchar2_value
1085: (p_transaction_step_id => p_transaction_step_id

Line 1084: l_attribute8 := hr_transaction_api.get_varchar2_value

1080: ,p_name => 'P_ATTRIBUTE6');
1081: l_attribute7 := hr_transaction_api.get_varchar2_value
1082: (p_transaction_step_id => p_transaction_step_id
1083: ,p_name => 'P_ATTRIBUTE7');
1084: l_attribute8 := hr_transaction_api.get_varchar2_value
1085: (p_transaction_step_id => p_transaction_step_id
1086: ,p_name => 'P_ATTRIBUTE8');
1087: l_attribute9 := hr_transaction_api.get_varchar2_value
1088: (p_transaction_step_id => p_transaction_step_id

Line 1087: l_attribute9 := hr_transaction_api.get_varchar2_value

1083: ,p_name => 'P_ATTRIBUTE7');
1084: l_attribute8 := hr_transaction_api.get_varchar2_value
1085: (p_transaction_step_id => p_transaction_step_id
1086: ,p_name => 'P_ATTRIBUTE8');
1087: l_attribute9 := hr_transaction_api.get_varchar2_value
1088: (p_transaction_step_id => p_transaction_step_id
1089: ,p_name => 'P_ATTRIBUTE9');
1090: l_attribute10 := hr_transaction_api.get_varchar2_value
1091: (p_transaction_step_id => p_transaction_step_id

Line 1090: l_attribute10 := hr_transaction_api.get_varchar2_value

1086: ,p_name => 'P_ATTRIBUTE8');
1087: l_attribute9 := hr_transaction_api.get_varchar2_value
1088: (p_transaction_step_id => p_transaction_step_id
1089: ,p_name => 'P_ATTRIBUTE9');
1090: l_attribute10 := hr_transaction_api.get_varchar2_value
1091: (p_transaction_step_id => p_transaction_step_id
1092: ,p_name => 'P_ATTRIBUTE10');
1093: l_attribute11 := hr_transaction_api.get_varchar2_value
1094: (p_transaction_step_id => p_transaction_step_id

Line 1093: l_attribute11 := hr_transaction_api.get_varchar2_value

1089: ,p_name => 'P_ATTRIBUTE9');
1090: l_attribute10 := hr_transaction_api.get_varchar2_value
1091: (p_transaction_step_id => p_transaction_step_id
1092: ,p_name => 'P_ATTRIBUTE10');
1093: l_attribute11 := hr_transaction_api.get_varchar2_value
1094: (p_transaction_step_id => p_transaction_step_id
1095: ,p_name => 'P_ATTRIBUTE11');
1096: l_attribute12 := hr_transaction_api.get_varchar2_value
1097: (p_transaction_step_id => p_transaction_step_id

Line 1096: l_attribute12 := hr_transaction_api.get_varchar2_value

1092: ,p_name => 'P_ATTRIBUTE10');
1093: l_attribute11 := hr_transaction_api.get_varchar2_value
1094: (p_transaction_step_id => p_transaction_step_id
1095: ,p_name => 'P_ATTRIBUTE11');
1096: l_attribute12 := hr_transaction_api.get_varchar2_value
1097: (p_transaction_step_id => p_transaction_step_id
1098: ,p_name => 'P_ATTRIBUTE12');
1099: l_attribute13 := hr_transaction_api.get_varchar2_value
1100: (p_transaction_step_id => p_transaction_step_id

Line 1099: l_attribute13 := hr_transaction_api.get_varchar2_value

1095: ,p_name => 'P_ATTRIBUTE11');
1096: l_attribute12 := hr_transaction_api.get_varchar2_value
1097: (p_transaction_step_id => p_transaction_step_id
1098: ,p_name => 'P_ATTRIBUTE12');
1099: l_attribute13 := hr_transaction_api.get_varchar2_value
1100: (p_transaction_step_id => p_transaction_step_id
1101: ,p_name => 'P_ATTRIBUTE13');
1102: l_attribute14 := hr_transaction_api.get_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id

Line 1102: l_attribute14 := hr_transaction_api.get_varchar2_value

1098: ,p_name => 'P_ATTRIBUTE12');
1099: l_attribute13 := hr_transaction_api.get_varchar2_value
1100: (p_transaction_step_id => p_transaction_step_id
1101: ,p_name => 'P_ATTRIBUTE13');
1102: l_attribute14 := hr_transaction_api.get_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id
1104: ,p_name => 'P_ATTRIBUTE14');
1105: l_attribute15 := hr_transaction_api.get_varchar2_value
1106: (p_transaction_step_id => p_transaction_step_id

Line 1105: l_attribute15 := hr_transaction_api.get_varchar2_value

1101: ,p_name => 'P_ATTRIBUTE13');
1102: l_attribute14 := hr_transaction_api.get_varchar2_value
1103: (p_transaction_step_id => p_transaction_step_id
1104: ,p_name => 'P_ATTRIBUTE14');
1105: l_attribute15 := hr_transaction_api.get_varchar2_value
1106: (p_transaction_step_id => p_transaction_step_id
1107: ,p_name => 'P_ATTRIBUTE15');
1108: l_attribute16 := hr_transaction_api.get_varchar2_value
1109: (p_transaction_step_id => p_transaction_step_id

Line 1108: l_attribute16 := hr_transaction_api.get_varchar2_value

1104: ,p_name => 'P_ATTRIBUTE14');
1105: l_attribute15 := hr_transaction_api.get_varchar2_value
1106: (p_transaction_step_id => p_transaction_step_id
1107: ,p_name => 'P_ATTRIBUTE15');
1108: l_attribute16 := hr_transaction_api.get_varchar2_value
1109: (p_transaction_step_id => p_transaction_step_id
1110: ,p_name => 'P_ATTRIBUTE16');
1111: l_attribute17 := hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => p_transaction_step_id

Line 1111: l_attribute17 := hr_transaction_api.get_varchar2_value

1107: ,p_name => 'P_ATTRIBUTE15');
1108: l_attribute16 := hr_transaction_api.get_varchar2_value
1109: (p_transaction_step_id => p_transaction_step_id
1110: ,p_name => 'P_ATTRIBUTE16');
1111: l_attribute17 := hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => p_transaction_step_id
1113: ,p_name => 'P_ATTRIBUTE17');
1114: l_attribute18 := hr_transaction_api.get_varchar2_value
1115: (p_transaction_step_id => p_transaction_step_id

Line 1114: l_attribute18 := hr_transaction_api.get_varchar2_value

1110: ,p_name => 'P_ATTRIBUTE16');
1111: l_attribute17 := hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => p_transaction_step_id
1113: ,p_name => 'P_ATTRIBUTE17');
1114: l_attribute18 := hr_transaction_api.get_varchar2_value
1115: (p_transaction_step_id => p_transaction_step_id
1116: ,p_name => 'P_ATTRIBUTE18');
1117: l_attribute19 := hr_transaction_api.get_varchar2_value
1118: (p_transaction_step_id => p_transaction_step_id

Line 1117: l_attribute19 := hr_transaction_api.get_varchar2_value

1113: ,p_name => 'P_ATTRIBUTE17');
1114: l_attribute18 := hr_transaction_api.get_varchar2_value
1115: (p_transaction_step_id => p_transaction_step_id
1116: ,p_name => 'P_ATTRIBUTE18');
1117: l_attribute19 := hr_transaction_api.get_varchar2_value
1118: (p_transaction_step_id => p_transaction_step_id
1119: ,p_name => 'P_ATTRIBUTE19');
1120: l_attribute20 := hr_transaction_api.get_varchar2_value
1121: (p_transaction_step_id => p_transaction_step_id

Line 1120: l_attribute20 := hr_transaction_api.get_varchar2_value

1116: ,p_name => 'P_ATTRIBUTE18');
1117: l_attribute19 := hr_transaction_api.get_varchar2_value
1118: (p_transaction_step_id => p_transaction_step_id
1119: ,p_name => 'P_ATTRIBUTE19');
1120: l_attribute20 := hr_transaction_api.get_varchar2_value
1121: (p_transaction_step_id => p_transaction_step_id
1122: ,p_name => 'P_ATTRIBUTE20');
1123: l_completion_date := hr_transaction_api.get_varchar2_value
1124: (p_transaction_step_id => p_transaction_step_id

Line 1123: l_completion_date := hr_transaction_api.get_varchar2_value

1119: ,p_name => 'P_ATTRIBUTE19');
1120: l_attribute20 := hr_transaction_api.get_varchar2_value
1121: (p_transaction_step_id => p_transaction_step_id
1122: ,p_name => 'P_ATTRIBUTE20');
1123: l_completion_date := hr_transaction_api.get_varchar2_value
1124: (p_transaction_step_id => p_transaction_step_id
1125: ,p_name => 'P_COMPLETIONDATE');
1126: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
1127: (p_transaction_step_id => p_transaction_step_id

Line 1126: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value

1122: ,p_name => 'P_ATTRIBUTE20');
1123: l_completion_date := hr_transaction_api.get_varchar2_value
1124: (p_transaction_step_id => p_transaction_step_id
1125: ,p_name => 'P_COMPLETIONDATE');
1126: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
1127: (p_transaction_step_id => p_transaction_step_id
1128: ,p_name => 'P_UNENROLLMENTDATE');
1129:
1130: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value

Line 1130: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value

1126: l_UNENROLLMENT_DATE := hr_transaction_api.get_varchar2_value
1127: (p_transaction_step_id => p_transaction_step_id
1128: ,p_name => 'P_UNENROLLMENTDATE');
1129:
1130: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_EXPIRATIONDATE');
1133: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => p_transaction_step_id

Line 1133: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value

1129:
1130: l_EXPIRATION_DATE := hr_transaction_api.get_varchar2_value
1131: (p_transaction_step_id => p_transaction_step_id
1132: ,p_name => 'P_EXPIRATIONDATE');
1133: l_EARLIEST_ENROLL_DATE := hr_transaction_api.get_varchar2_value
1134: (p_transaction_step_id => p_transaction_step_id
1135: ,p_name => 'P_EARLIESTENROLLDATE');
1136:
1137:

Line 1204: l_from := hr_transaction_api.get_varchar2_value

1200: and business_group_id = ota_general.get_business_group_id();*/
1201:
1202: begin
1203:
1204: l_from := hr_transaction_api.get_varchar2_value
1205: (p_transaction_step_id => p_transaction_step_id
1206: ,p_name => 'P_FROM');
1207:
1208:

Line 1209: /*l_certification_id := hr_transaction_api.get_varchar2_value

1205: (p_transaction_step_id => p_transaction_step_id
1206: ,p_name => 'P_FROM');
1207:
1208:
1209: /*l_certification_id := hr_transaction_api.get_varchar2_value
1210: (p_transaction_step_id => p_transaction_step_id
1211: ,p_name => 'P_CERTIFICATIONID');
1212:
1213: l_person_id := hr_transaction_api.get_Number_value

Line 1213: l_person_id := hr_transaction_api.get_Number_value

1209: /*l_certification_id := hr_transaction_api.get_varchar2_value
1210: (p_transaction_step_id => p_transaction_step_id
1211: ,p_name => 'P_CERTIFICATIONID');
1212:
1213: l_person_id := hr_transaction_api.get_Number_value
1214: (p_transaction_step_id => p_transaction_step_id
1215: ,p_name => 'P_PERSONID'); */
1216:
1217: If (l_from = 'REVIEW') Then