APPS.OTA_AME_ATTRIBUTES dependencies on OTA_CERTIFICATIONS_B

Line 593: c_certification_id ota_certifications_b.certification_id%type;

589: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
590: return varchar2 is
591:
592: c_certification_type varchar2(100);
593: c_certification_id ota_certifications_b.certification_id%type;
594: c_item_type varchar2(50);
595: c_item_key varchar2(100);
596:
597: cursor get_certification_type

Line 599: select renewable_flag from ota_certifications_b

595: c_item_key varchar2(100);
596:
597: cursor get_certification_type
598: is
599: select renewable_flag from ota_certifications_b
600: where certification_id = c_certification_id;
601:
602:
603: begin

Line 641: c_certification_id ota_certifications_b.certification_id%type;

637: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
638: return varchar2 is
639:
640: c_cert_dur varchar2(100);
641: c_certification_id ota_certifications_b.certification_id%type;
642: c_item_type varchar2(50);
643: c_item_key varchar2(100);
644:
645: cursor get_cert_dur

Line 647: select initial_completion_duration from ota_certifications_b

643: c_item_key varchar2(100);
644:
645: cursor get_cert_dur
646: is
647: select initial_completion_duration from ota_certifications_b
648: where certification_id = c_certification_id;
649:
650:
651: begin

Line 689: c_certification_id ota_certifications_b.certification_id%type;

685: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
686: return varchar2 is
687:
688: c_cert_dur varchar2(100);
689: c_certification_id ota_certifications_b.certification_id%type;
690: c_item_type varchar2(50);
691: c_item_key varchar2(100);
692:
693: cursor get_cert_renewal_duration

Line 695: select renewal_duration from ota_certifications_b

691: c_item_key varchar2(100);
692:
693: cursor get_cert_renewal_duration
694: is
695: select renewal_duration from ota_certifications_b
696: where certification_id = c_certification_id;
697:
698:
699: begin

Line 736: c_certification_id ota_certifications_b.certification_id%type;

732: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
733: return varchar2 is
734:
735: c_cert_dur varchar2(100);
736: c_certification_id ota_certifications_b.certification_id%type;
737: c_item_type varchar2(50);
738: c_item_key varchar2(100);
739:
740: cursor get_cert_validity_duration

Line 742: select validity_duration from ota_certifications_b

738: c_item_key varchar2(100);
739:
740: cursor get_cert_validity_duration
741: is
742: select validity_duration from ota_certifications_b
743: where certification_id = c_certification_id;
744:
745:
746: begin

Line 788: c_certification_id ota_certifications_b.certification_id%type;

784: return varchar2 is
785:
786: c_cert_date Date;
787: l_return_value varchar2(100);
788: c_certification_id ota_certifications_b.certification_id%type;
789: c_item_type varchar2(50);
790: c_item_key varchar2(100);
791: c_person_id number(15);
792:

Line 853: c_certification_id ota_certifications_b.certification_id%type;

849: return varchar2 is
850:
851: c_cert_date Date;
852: l_return_value varchar2(100);
853: c_certification_id ota_certifications_b.certification_id%type;
854: c_item_type varchar2(50);
855: c_item_key varchar2(100);
856: c_person_id number(15);
857:

Line 918: c_certification_id ota_certifications_b.certification_id%type;

914: return varchar2 is
915:
916: c_cert_date Date;
917: l_return_value varchar2(100);
918: c_certification_id ota_certifications_b.certification_id%type;
919: c_item_type varchar2(50);
920: c_item_key varchar2(100);
921: c_person_id number(15);
922:

Line 926: from ota_certifications_b

922:
923: cursor get_cert_comp_date
924: is
925: select INITIAL_COMPLETION_DATE
926: from ota_certifications_b
927: where
928: certification_id = c_certification_id;
929:
930: