APPS.IGS_PT_GEN_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 96: l_key_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

92: WHERE course_cd = p_prog_cd
93: AND version_number = p_ver_num ;
94:
95:
96: l_key_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
97: l_key_prog_ind igs_en_stdnt_ps_att_all.key_program%TYPE DEFAULT 'N';
98: l_single_prog_exists BOOLEAN DEFAULT TRUE;
99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
100:

Line 97: l_key_prog_ind igs_en_stdnt_ps_att_all.key_program%TYPE DEFAULT 'N';

93: AND version_number = p_ver_num ;
94:
95:
96: l_key_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
97: l_key_prog_ind igs_en_stdnt_ps_att_all.key_program%TYPE DEFAULT 'N';
98: l_single_prog_exists BOOLEAN DEFAULT TRUE;
99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
100:
101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;

Line 99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

95:
96: l_key_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
97: l_key_prog_ind igs_en_stdnt_ps_att_all.key_program%TYPE DEFAULT 'N';
98: l_single_prog_exists BOOLEAN DEFAULT TRUE;
99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
100:
101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;
102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
103: l_programlist VARCHAR2(2000);

Line 101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;

97: l_key_prog_ind igs_en_stdnt_ps_att_all.key_program%TYPE DEFAULT 'N';
98: l_single_prog_exists BOOLEAN DEFAULT TRUE;
99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
100:
101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;
102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
103: l_programlist VARCHAR2(2000);
104:
105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

Line 102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;

98: l_single_prog_exists BOOLEAN DEFAULT TRUE;
99: l_curr_prog_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
100:
101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;
102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
103: l_programlist VARCHAR2(2000);
104:
105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;

Line 105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

101: l_primary_program igs_en_stdnt_ps_att_all.course_cd%TYPE;
102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
103: l_programlist VARCHAR2(2000);
104:
105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;
107: p_career igs_ps_ver.course_type%TYPE;
108: p_program_list VARCHAR2(2000);
109: p_program_title VARCHAR2(200);

Line 106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;

102: l_primary_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
103: l_programlist VARCHAR2(2000);
104:
105: p_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;
107: p_career igs_ps_ver.course_type%TYPE;
108: p_program_list VARCHAR2(2000);
109: p_program_title VARCHAR2(200);
110: l_curr_prog_cd_tmp igs_en_stdnt_ps_att_all.course_cd%TYPE;

Line 110: l_curr_prog_cd_tmp igs_en_stdnt_ps_att_all.course_cd%TYPE;

106: p_program_ver igs_en_stdnt_ps_att_all.version_number%TYPE;
107: p_career igs_ps_ver.course_type%TYPE;
108: p_program_list VARCHAR2(2000);
109: p_program_title VARCHAR2(200);
110: l_curr_prog_cd_tmp igs_en_stdnt_ps_att_all.course_cd%TYPE;
111:
112: BEGIN
113:
114: IF fnd_profile.value('CAREER_MODEL_ENABLED') = 'Y' THEN