APPS.IGS_PT_GEN_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 74: SELECT course_cd FROM igs_en_stdnt_ps_att

70: igs_ca_load_to_teach_v where load_cal_type = p_load_cal_type
71: AND load_ci_sequence_number = p_load_sequence_number
72: )
73: AND course_cd IN (
74: SELECT course_cd FROM igs_en_stdnt_ps_att
75: WHERE primary_program_type = 'PRIMARY'
76: AND person_id = p_person_id
77: AND course_attempt_status IN ('INACTIVE','ENROLLED')
78: )

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