APPS.IGS_EN_SPA_LGCY_PUB dependencies on IGS_PS_TYPE

Line 885: CURSOR cur_re_prg(p_prg_type igs_ps_type.course_type%TYPE) IS

881: l_api_name CONSTANT VARCHAR2(30) := 'create_spa';
882: l_api_version CONSTANT NUMBER := 1.0;
883:
884: --Cursor to get the research details for a program type
885: CURSOR cur_re_prg(p_prg_type igs_ps_type.course_type%TYPE) IS
886: SELECT research_type_ind FROM igs_ps_type
887: WHERE course_type = p_prg_type;
888: --Cursor is to get the sequence number for the candidature.
889: CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;

Line 886: SELECT research_type_ind FROM igs_ps_type

882: l_api_version CONSTANT NUMBER := 1.0;
883:
884: --Cursor to get the research details for a program type
885: CURSOR cur_re_prg(p_prg_type igs_ps_type.course_type%TYPE) IS
886: SELECT research_type_ind FROM igs_ps_type
887: WHERE course_type = p_prg_type;
888: --Cursor is to get the sequence number for the candidature.
889: CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;
890:

Line 916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;

912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;
914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;
915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;
917:
918: BEGIN --Begin of create_spa
919:
920: --Save point for whole procedure.