eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ADD_TRAINING_SS dependencies on OTA_NOTRNG_HISTORIES

Line 583: l_title ota_notrng_histories.trng_title%TYPE;

579: PROCEDURE get_add_trg_data_from_tt (p_transaction_step_id IN NUMBER
580: ,p_add_trg_data OUT NOCOPY VARCHAR2
581: )IS
582: l_object_version_number per_phones.object_version_number%type;
583: l_title ota_notrng_histories.trng_title%TYPE;
584: l_supplier ota_notrng_histories.provider%TYPE;
585: l_eq_ota_activity VARCHAR2(80);
586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;

Line 584: l_supplier ota_notrng_histories.provider%TYPE;

580: ,p_add_trg_data OUT NOCOPY VARCHAR2
581: )IS
582: l_object_version_number per_phones.object_version_number%type;
583: l_title ota_notrng_histories.trng_title%TYPE;
584: l_supplier ota_notrng_histories.provider%TYPE;
585: l_eq_ota_activity VARCHAR2(80);
586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;
588: l_duration VARCHAR2(50);

Line 586: l_location ota_notrng_histories.centre%TYPE;

582: l_object_version_number per_phones.object_version_number%type;
583: l_title ota_notrng_histories.trng_title%TYPE;
584: l_supplier ota_notrng_histories.provider%TYPE;
585: l_eq_ota_activity VARCHAR2(80);
586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;
588: l_duration VARCHAR2(50);
589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;

Line 587: l_trntype ota_notrng_histories.type%TYPE;

583: l_title ota_notrng_histories.trng_title%TYPE;
584: l_supplier ota_notrng_histories.provider%TYPE;
585: l_eq_ota_activity VARCHAR2(80);
586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;
588: l_duration VARCHAR2(50);
589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;
591: l_completion_date DATE;

Line 589: l_duration_unit ota_notrng_histories.duration_units%TYPE;

585: l_eq_ota_activity VARCHAR2(80);
586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;
588: l_duration VARCHAR2(50);
589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;
591: l_completion_date DATE;
592: l_award ota_notrng_histories.award%TYPE;
593: l_score ota_notrng_histories.rating%TYPE;

Line 590: l_status ota_notrng_histories.status%TYPE;

586: l_location ota_notrng_histories.centre%TYPE;
587: l_trntype ota_notrng_histories.type%TYPE;
588: l_duration VARCHAR2(50);
589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;
591: l_completion_date DATE;
592: l_award ota_notrng_histories.award%TYPE;
593: l_score ota_notrng_histories.rating%TYPE;
594: l_internal_contact_person VARCHAR2(150);

Line 592: l_award ota_notrng_histories.award%TYPE;

588: l_duration VARCHAR2(50);
589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;
591: l_completion_date DATE;
592: l_award ota_notrng_histories.award%TYPE;
593: l_score ota_notrng_histories.rating%TYPE;
594: l_internal_contact_person VARCHAR2(150);
595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

Line 593: l_score ota_notrng_histories.rating%TYPE;

589: l_duration_unit ota_notrng_histories.duration_units%TYPE;
590: l_status ota_notrng_histories.status%TYPE;
591: l_completion_date DATE;
592: l_award ota_notrng_histories.award%TYPE;
593: l_score ota_notrng_histories.rating%TYPE;
594: l_internal_contact_person VARCHAR2(150);
595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

Line 596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

592: l_award ota_notrng_histories.award%TYPE;
593: l_score ota_notrng_histories.rating%TYPE;
594: l_internal_contact_person VARCHAR2(150);
595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

Line 597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

593: l_score ota_notrng_histories.rating%TYPE;
594: l_internal_contact_person VARCHAR2(150);
595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

Line 598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;

594: l_internal_contact_person VARCHAR2(150);
595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

Line 599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;

595: l_historyid VARCHAR2(50);
596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

Line 600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

596: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

Line 601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

597: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

Line 602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

598: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

Line 603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

599: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

Line 604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

600: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

Line 605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

601: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

Line 606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

602: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

Line 607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

603: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

Line 608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

604: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

Line 609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

605: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

Line 610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

606: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

Line 611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

607: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

Line 612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

608: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

Line 613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

609: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
617: l_contact_name VARCHAR2(80);

Line 614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

610: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
617: l_contact_name VARCHAR2(80);
618: l_activity_name ota_activity_versions.version_name%TYPE;

Line 615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

611: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
617: l_contact_name VARCHAR2(80);
618: l_activity_name ota_activity_versions.version_name%TYPE;
619: l_obj_ver_no VARCHAR2(80);

Line 616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

612: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
613: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
614: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
615: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
616: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
617: l_contact_name VARCHAR2(80);
618: l_activity_name ota_activity_versions.version_name%TYPE;
619: l_obj_ver_no VARCHAR2(80);
620: l_business_grp_id VARCHAR2(80);

Line 1033: l_title ota_notrng_histories.trng_title%TYPE;

1029:
1030: procedure create_add_training_tt
1031: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
1032: is
1033: l_title ota_notrng_histories.trng_title%TYPE;
1034: l_supplier ota_notrng_histories.provider%TYPE;
1035: l_eq_ota_activity VARCHAR2(800);
1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;

Line 1034: l_supplier ota_notrng_histories.provider%TYPE;

1030: procedure create_add_training_tt
1031: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
1032: is
1033: l_title ota_notrng_histories.trng_title%TYPE;
1034: l_supplier ota_notrng_histories.provider%TYPE;
1035: l_eq_ota_activity VARCHAR2(800);
1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;
1038: l_duration VARCHAR2(500);

Line 1036: l_location ota_notrng_histories.centre%TYPE;

1032: is
1033: l_title ota_notrng_histories.trng_title%TYPE;
1034: l_supplier ota_notrng_histories.provider%TYPE;
1035: l_eq_ota_activity VARCHAR2(800);
1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;
1038: l_duration VARCHAR2(500);
1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;

Line 1037: l_trntype ota_notrng_histories.type%TYPE;

1033: l_title ota_notrng_histories.trng_title%TYPE;
1034: l_supplier ota_notrng_histories.provider%TYPE;
1035: l_eq_ota_activity VARCHAR2(800);
1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;
1038: l_duration VARCHAR2(500);
1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;
1041: l_completion_date DATE;

Line 1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;

1035: l_eq_ota_activity VARCHAR2(800);
1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;
1038: l_duration VARCHAR2(500);
1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;
1041: l_completion_date DATE;
1042: l_award ota_notrng_histories.award%TYPE;
1043: l_score ota_notrng_histories.rating%TYPE;

Line 1040: l_status ota_notrng_histories.status%TYPE;

1036: l_location ota_notrng_histories.centre%TYPE;
1037: l_trntype ota_notrng_histories.type%TYPE;
1038: l_duration VARCHAR2(500);
1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;
1041: l_completion_date DATE;
1042: l_award ota_notrng_histories.award%TYPE;
1043: l_score ota_notrng_histories.rating%TYPE;
1044: l_internal_contact_person VARCHAR2(500);

Line 1042: l_award ota_notrng_histories.award%TYPE;

1038: l_duration VARCHAR2(500);
1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;
1041: l_completion_date DATE;
1042: l_award ota_notrng_histories.award%TYPE;
1043: l_score ota_notrng_histories.rating%TYPE;
1044: l_internal_contact_person VARCHAR2(500);
1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

Line 1043: l_score ota_notrng_histories.rating%TYPE;

1039: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1040: l_status ota_notrng_histories.status%TYPE;
1041: l_completion_date DATE;
1042: l_award ota_notrng_histories.award%TYPE;
1043: l_score ota_notrng_histories.rating%TYPE;
1044: l_internal_contact_person VARCHAR2(500);
1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

Line 1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

1042: l_award ota_notrng_histories.award%TYPE;
1043: l_score ota_notrng_histories.rating%TYPE;
1044: l_internal_contact_person VARCHAR2(500);
1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

Line 1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

1043: l_score ota_notrng_histories.rating%TYPE;
1044: l_internal_contact_person VARCHAR2(500);
1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

Line 1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;

1044: l_internal_contact_person VARCHAR2(500);
1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

Line 1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;

1045: l_historyid VARCHAR2(500);
1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

Line 1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

1046: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

Line 1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

1047: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

Line 1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

1048: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

Line 1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

1049: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

Line 1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

1050: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

Line 1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

1051: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

Line 1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

1052: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

Line 1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

1053: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

Line 1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

1054: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

Line 1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

1055: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

Line 1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

1056: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

Line 1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

1057: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

Line 1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

1058: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

Line 1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

1059: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1067: l_contact_name VARCHAR2(800);

Line 1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

1060: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1067: l_contact_name VARCHAR2(800);
1068: l_activity_name ota_activity_versions.version_name%TYPE;

Line 1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

1061: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1067: l_contact_name VARCHAR2(800);
1068: l_activity_name ota_activity_versions.version_name%TYPE;
1069: l_obj_ver_no VARCHAR2(800);

Line 1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

1062: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1063: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1064: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1065: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1066: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1067: l_contact_name VARCHAR2(800);
1068: l_activity_name ota_activity_versions.version_name%TYPE;
1069: l_obj_ver_no VARCHAR2(800);
1070: l_business_grp_id VARCHAR2(800);

Line 1278: l_title ota_notrng_histories.trng_title%TYPE;

1274: -- ---------------------------------------------------------------------------
1275: procedure update_add_training_tt
1276: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
1277: IS
1278: l_title ota_notrng_histories.trng_title%TYPE;
1279: l_supplier ota_notrng_histories.provider%TYPE;
1280: l_eq_ota_activity VARCHAR2(800);
1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;

Line 1279: l_supplier ota_notrng_histories.provider%TYPE;

1275: procedure update_add_training_tt
1276: (p_validate IN BOOLEAN, p_transaction_step_id IN NUMBER)
1277: IS
1278: l_title ota_notrng_histories.trng_title%TYPE;
1279: l_supplier ota_notrng_histories.provider%TYPE;
1280: l_eq_ota_activity VARCHAR2(800);
1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;
1283: l_duration VARCHAR2(500);

Line 1281: l_location ota_notrng_histories.centre%TYPE;

1277: IS
1278: l_title ota_notrng_histories.trng_title%TYPE;
1279: l_supplier ota_notrng_histories.provider%TYPE;
1280: l_eq_ota_activity VARCHAR2(800);
1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;
1283: l_duration VARCHAR2(500);
1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;

Line 1282: l_trntype ota_notrng_histories.type%TYPE;

1278: l_title ota_notrng_histories.trng_title%TYPE;
1279: l_supplier ota_notrng_histories.provider%TYPE;
1280: l_eq_ota_activity VARCHAR2(800);
1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;
1283: l_duration VARCHAR2(500);
1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;
1286: l_completion_date DATE;

Line 1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;

1280: l_eq_ota_activity VARCHAR2(800);
1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;
1283: l_duration VARCHAR2(500);
1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;
1286: l_completion_date DATE;
1287: l_award ota_notrng_histories.award%TYPE;
1288: l_score ota_notrng_histories.rating%TYPE;

Line 1285: l_status ota_notrng_histories.status%TYPE;

1281: l_location ota_notrng_histories.centre%TYPE;
1282: l_trntype ota_notrng_histories.type%TYPE;
1283: l_duration VARCHAR2(500);
1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;
1286: l_completion_date DATE;
1287: l_award ota_notrng_histories.award%TYPE;
1288: l_score ota_notrng_histories.rating%TYPE;
1289: l_internal_contact_person VARCHAR2(500);

Line 1287: l_award ota_notrng_histories.award%TYPE;

1283: l_duration VARCHAR2(500);
1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;
1286: l_completion_date DATE;
1287: l_award ota_notrng_histories.award%TYPE;
1288: l_score ota_notrng_histories.rating%TYPE;
1289: l_internal_contact_person VARCHAR2(500);
1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

Line 1288: l_score ota_notrng_histories.rating%TYPE;

1284: l_duration_unit ota_notrng_histories.duration_units%TYPE;
1285: l_status ota_notrng_histories.status%TYPE;
1286: l_completion_date DATE;
1287: l_award ota_notrng_histories.award%TYPE;
1288: l_score ota_notrng_histories.rating%TYPE;
1289: l_internal_contact_person VARCHAR2(500);
1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

Line 1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;

1287: l_award ota_notrng_histories.award%TYPE;
1288: l_score ota_notrng_histories.rating%TYPE;
1289: l_internal_contact_person VARCHAR2(500);
1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

Line 1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;

1288: l_score ota_notrng_histories.rating%TYPE;
1289: l_internal_contact_person VARCHAR2(500);
1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

Line 1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;

1289: l_internal_contact_person VARCHAR2(500);
1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

Line 1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;

1290: l_historyid VARCHAR2(500);
1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

Line 1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;

1291: l_nth_information_category ota_notrng_histories.NTH_INFORMATION_CATEGORY%TYPE;
1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

Line 1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;

1292: l_nth_information1 ota_notrng_histories.NTH_INFORMATION1%TYPE;
1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

Line 1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;

1293: l_nth_information2 ota_notrng_histories.NTH_INFORMATION2%TYPE;
1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

Line 1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;

1294: l_nth_information3 ota_notrng_histories.NTH_INFORMATION3%TYPE;
1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

Line 1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;

1295: l_nth_information4 ota_notrng_histories.NTH_INFORMATION4%TYPE;
1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

Line 1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;

1296: l_nth_information5 ota_notrng_histories.NTH_INFORMATION5%TYPE;
1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

Line 1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;

1297: l_nth_information6 ota_notrng_histories.NTH_INFORMATION6%TYPE;
1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

Line 1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;

1298: l_nth_information7 ota_notrng_histories.NTH_INFORMATION7%TYPE;
1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

Line 1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;

1299: l_nth_information8 ota_notrng_histories.NTH_INFORMATION8%TYPE;
1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

Line 1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;

1300: l_nth_information9 ota_notrng_histories.NTH_INFORMATION9%TYPE;
1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

Line 1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;

1301: l_nth_information10 ota_notrng_histories.NTH_INFORMATION10%TYPE;
1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

Line 1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;

1302: l_nth_information11 ota_notrng_histories.NTH_INFORMATION11%TYPE;
1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

Line 1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;

1303: l_nth_information12 ota_notrng_histories.NTH_INFORMATION12%TYPE;
1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

Line 1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;

1304: l_nth_information13 ota_notrng_histories.NTH_INFORMATION13%TYPE;
1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1312: l_contact_name VARCHAR2(800);

Line 1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;

1305: l_nth_information14 ota_notrng_histories.NTH_INFORMATION14%TYPE;
1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1312: l_contact_name VARCHAR2(800);
1313: l_activity_name ota_activity_versions.version_name%TYPE;

Line 1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;

1306: l_nth_information15 ota_notrng_histories.NTH_INFORMATION15%TYPE;
1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1312: l_contact_name VARCHAR2(800);
1313: l_activity_name ota_activity_versions.version_name%TYPE;
1314: l_old_obj_ver_no VARCHAR2(800);

Line 1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;

1307: l_nth_information16 ota_notrng_histories.NTH_INFORMATION16%TYPE;
1308: l_nth_information17 ota_notrng_histories.NTH_INFORMATION17%TYPE;
1309: l_nth_information18 ota_notrng_histories.NTH_INFORMATION18%TYPE;
1310: l_nth_information19 ota_notrng_histories.NTH_INFORMATION19%TYPE;
1311: l_nth_information20 ota_notrng_histories.NTH_INFORMATION20%TYPE;
1312: l_contact_name VARCHAR2(800);
1313: l_activity_name ota_activity_versions.version_name%TYPE;
1314: l_old_obj_ver_no VARCHAR2(800);
1315: l_new_obj_ver_no VARCHAR2(800) := NULL;

Line 1560: ( p_nota_history_id IN OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE

1556: --
1557: -- {End Of Comments}
1558: -- ----------------------------------------------------------------------------
1559: PROCEDURE delete_add_training
1560: ( p_nota_history_id IN OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE
1561: , p_trng_title IN VARCHAR2
1562: , p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
1563: , p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
1564: , p_message OUT NOCOPY VARCHAR2

Line 1569: FROM OTA_NOTRNG_HISTORIES

1565: ) IS
1566:
1567: CURSOR c_get_obj_ver_no IS
1568: SELECT OBJECT_VERSION_NUMBER
1569: FROM OTA_NOTRNG_HISTORIES
1570: WHERE NOTA_HISTORY_ID = p_nota_history_id;
1571:
1572: l_obj_ver_no OTA_NOTRNG_HISTORIES.OBJECT_VERSION_NUMBER%TYPE;
1573: l_proc VARCHAR2(72) := 'Delete_Add_Training';

Line 1572: l_obj_ver_no OTA_NOTRNG_HISTORIES.OBJECT_VERSION_NUMBER%TYPE;

1568: SELECT OBJECT_VERSION_NUMBER
1569: FROM OTA_NOTRNG_HISTORIES
1570: WHERE NOTA_HISTORY_ID = p_nota_history_id;
1571:
1572: l_obj_ver_no OTA_NOTRNG_HISTORIES.OBJECT_VERSION_NUMBER%TYPE;
1573: l_proc VARCHAR2(72) := 'Delete_Add_Training';
1574:
1575: BEGIN
1576:

Line 2162: ( Person_id IN ota_notrng_histories.contact_id%TYPE

2158: -- person_id belongs to a Customers' contact and ra_contacts is queried.
2159: -- {End Of Comments}
2160: -- ----------------------------------------------------------------------------
2161: Function get_learner_name
2162: ( Person_id IN ota_notrng_histories.contact_id%TYPE
2163: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2
2164: IS
2165:
2166: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS

Line 2163: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2

2159: -- {End Of Comments}
2160: -- ----------------------------------------------------------------------------
2161: Function get_learner_name
2162: ( Person_id IN ota_notrng_histories.contact_id%TYPE
2163: ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2
2164: IS
2165:
2166: CURSOR c_get_person_name(p_person_id per_all_people_f.person_id%TYPE) IS
2167: SELECT full_name

Line 2230: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,

2226: -- In Parameters:
2227: -- Customer_Id - customer_id of the Customer
2228: -- {End Of Comments}
2229: -- ----------------------------------------------------------------------------
2230: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,
2231: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)
2232: RETURN VARCHAR2 IS
2233:
2234: CURSOR c_get_customer_name IS

Line 2231: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)

2227: -- Customer_Id - customer_id of the Customer
2228: -- {End Of Comments}
2229: -- ----------------------------------------------------------------------------
2230: FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,
2231: p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)
2232: RETURN VARCHAR2 IS
2233:
2234: CURSOR c_get_customer_name IS
2235: SELECT

Line 2330: CURSOR c_get_training_data(p_history_id ota_notrng_histories.nota_history_id%TYPE) IS

2326: ,p_nth_information20 in VARCHAR2
2327: ,p_result out nocopy NUMBER
2328: ) Is
2329:
2330: CURSOR c_get_training_data(p_history_id ota_notrng_histories.nota_history_id%TYPE) IS
2331: Select
2332: ONH.Trng_Title,
2333: ONH.Provider,
2334: ONH.activity_version_id,

Line 2366: OTA_NOTRNG_HISTORIES ONH

2362: ONH.nth_information18,
2363: ONH.nth_information19,
2364: ONH.nth_information20
2365: From
2366: OTA_NOTRNG_HISTORIES ONH
2367: where
2368: ONH.nota_history_id = p_history_id;
2369:
2370: l_proc VARCHAR2(72) := 'check_changes';