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.IGS_AU_GEN_002 dependencies on IGS_GE_DATE

Line 131: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),

127: l_c_annual_instruction_time VARCHAR2(30) := 'ANNUAL_INSTRUCTION_TIME';
128: v_column_value VARCHAR2(2000) := NULL;
129: CURSOR c_cvh IS
130: SELECT decode (p_column_name,
131: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
132: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
133: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
134: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
135: cst_course_status, cvh.course_status,

Line 132: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),

128: v_column_value VARCHAR2(2000) := NULL;
129: CURSOR c_cvh IS
130: SELECT decode (p_column_name,
131: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
132: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
133: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
134: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
135: cst_course_status, cvh.course_status,
136: cst_title, cvh.title,

Line 133: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),

129: CURSOR c_cvh IS
130: SELECT decode (p_column_name,
131: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
132: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
133: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
134: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
135: cst_course_status, cvh.course_status,
136: cst_title, cvh.title,
137: cst_short_title, cvh.short_title,

Line 134: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),

130: SELECT decode (p_column_name,
131: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
132: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
133: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
134: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
135: cst_course_status, cvh.course_status,
136: cst_title, cvh.title,
137: cst_short_title, cvh.short_title,
138: cst_abbreviation, cvh.abbreviation,

Line 147: cst_responsible_ou_start_dt, igs_ge_date.igschardt(cvh.responsible_ou_start_dt),

143: cst_intrmsn_allowed_ind, cvh.intrmsn_allowed_ind,
144: cst_course_type, cvh.course_type,
145: cst_ct_description, cvh.ct_description,
146: cst_responsible_org_unit_cd, cvh.responsible_org_unit_cd,
147: cst_responsible_ou_start_dt, igs_ge_date.igschardt(cvh.responsible_ou_start_dt),
148: cst_ou_description, cvh.ou_description,
149: cst_govt_special_course_type, cvh.govt_special_course_type,
150: cst_gsct_description, cvh.gsct_description,
151: cst_qualification_recency, TO_CHAR(cvh.qualification_recency),

Line 163: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),

159: cst_max_intrmsn_duration, TO_CHAR(cvh.max_intrmsn_duration),
160: cst_num_of_unts_bfr_intrmsn, TO_CHAR(cvh.num_of_units_before_intrmsn),
161: cst_min_sbmsn_percentage, TO_CHAR(cvh.min_sbmsn_percentage),
162: cst_min_cp_per_calendar, TO_CHAR(cvh.min_cp_per_calendar),
163: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),
164: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),
165: cst_federal_financial_aid, cvh.federal_financial_aid,
166: c_institutional_financial_aid, cvh.institutional_financial_aid,
167: cst_max_cp_per_teaching_period, TO_CHAR(cvh.max_cp_per_teaching_period),

Line 164: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),

160: cst_num_of_unts_bfr_intrmsn, TO_CHAR(cvh.num_of_units_before_intrmsn),
161: cst_min_sbmsn_percentage, TO_CHAR(cvh.min_sbmsn_percentage),
162: cst_min_cp_per_calendar, TO_CHAR(cvh.min_cp_per_calendar),
163: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),
164: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),
165: cst_federal_financial_aid, cvh.federal_financial_aid,
166: c_institutional_financial_aid, cvh.institutional_financial_aid,
167: cst_max_cp_per_teaching_period, TO_CHAR(cvh.max_cp_per_teaching_period),
168: cst_residency_cp_required, TO_CHAR(residency_cp_required),

Line 178: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),

174: WHERE cvh.course_cd = p_course_cd AND
175: cvh.version_number = p_version_number AND
176: cvh.hist_start_dt >= p_hist_date AND
177: decode (p_column_name,
178: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
179: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
180: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
181: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
182: cst_course_status, cvh.course_status,

Line 179: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),

175: cvh.version_number = p_version_number AND
176: cvh.hist_start_dt >= p_hist_date AND
177: decode (p_column_name,
178: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
179: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
180: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
181: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
182: cst_course_status, cvh.course_status,
183: cst_title, cvh.title,

Line 180: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),

176: cvh.hist_start_dt >= p_hist_date AND
177: decode (p_column_name,
178: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
179: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
180: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
181: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
182: cst_course_status, cvh.course_status,
183: cst_title, cvh.title,
184: cst_short_title, cvh.short_title,

Line 181: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),

177: decode (p_column_name,
178: cst_start_dt, igs_ge_date.igschardt(cvh.start_dt),
179: cst_review_dt, igs_ge_date.igschardt(cvh.review_dt),
180: cst_expiry_dt, igs_ge_date.igschardt(cvh.expiry_dt),
181: cst_end_dt, igs_ge_date.igschardt(cvh.end_dt),
182: cst_course_status, cvh.course_status,
183: cst_title, cvh.title,
184: cst_short_title, cvh.short_title,
185: cst_abbreviation, cvh.abbreviation,

Line 194: cst_responsible_ou_start_dt, igs_ge_date.igschardt(cvh.responsible_ou_start_dt),

190: cst_intrmsn_allowed_ind, cvh.intrmsn_allowed_ind,
191: cst_course_type, cvh.course_type,
192: cst_ct_description, cvh.ct_description,
193: cst_responsible_org_unit_cd, cvh.responsible_org_unit_cd,
194: cst_responsible_ou_start_dt, igs_ge_date.igschardt(cvh.responsible_ou_start_dt),
195: cst_ou_description, cvh.ou_description,
196: cst_govt_special_course_type, cvh.govt_special_course_type,
197: cst_gsct_description, cvh.gsct_description,
198: cst_qualification_recency, TO_CHAR(cvh.qualification_recency),

Line 210: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),

206: cst_max_intrmsn_duration, TO_CHAR(cvh.max_intrmsn_duration),
207: cst_num_of_unts_bfr_intrmsn, TO_CHAR(cvh.num_of_units_before_intrmsn),
208: cst_min_sbmsn_percentage, TO_CHAR(cvh.min_sbmsn_percentage),
209: cst_min_cp_per_calendar, TO_CHAR(cvh.min_cp_per_calendar),
210: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),
211: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),
212: cst_federal_financial_aid, cvh.federal_financial_aid,
213: c_institutional_financial_aid, cvh.institutional_financial_aid,
214: cst_max_cp_per_teaching_period, TO_CHAR(cvh.max_cp_per_teaching_period),

Line 211: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),

207: cst_num_of_unts_bfr_intrmsn, TO_CHAR(cvh.num_of_units_before_intrmsn),
208: cst_min_sbmsn_percentage, TO_CHAR(cvh.min_sbmsn_percentage),
209: cst_min_cp_per_calendar, TO_CHAR(cvh.min_cp_per_calendar),
210: cst_approval_date, igs_ge_date.igschardt(cvh.approval_date),
211: cst_external_approval_date, igs_ge_date.igschardt(cvh.external_approval_date),
212: cst_federal_financial_aid, cvh.federal_financial_aid,
213: c_institutional_financial_aid, cvh.institutional_financial_aid,
214: cst_max_cp_per_teaching_period, TO_CHAR(cvh.max_cp_per_teaching_period),
215: cst_residency_cp_required, TO_CHAR(residency_cp_required),