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.

[Home] [Help]

APPS.IGS_EN_GEN_004 dependencies on IGS_AS_SC_ATTEMPT_H

Line 341: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,

337: END enrp_get_rule_cutoff;
338:
339: FUNCTION Enrp_Get_Scah_Col(
340: p_column_name IN VARCHAR2 ,
341: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
342: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
343: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
344: RETURN VARCHAR2 AS
345: gv_other_detail VARCHAR2(255);

Line 342: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,

338:
339: FUNCTION Enrp_Get_Scah_Col(
340: p_column_name IN VARCHAR2 ,
341: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
342: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
343: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
344: RETURN VARCHAR2 AS
345: gv_other_detail VARCHAR2(255);
346: BEGIN

Line 343: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )

339: FUNCTION Enrp_Get_Scah_Col(
340: p_column_name IN VARCHAR2 ,
341: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
342: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
343: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
344: RETURN VARCHAR2 AS
345: gv_other_detail VARCHAR2(255);
346: BEGIN
347: DECLARE

Line 349: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,

345: gv_other_detail VARCHAR2(255);
346: BEGIN
347: DECLARE
348: CURSOR c_sca_hist (cp_column_name user_tab_columns.column_name%TYPE,
349: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
350: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE,
351: cp_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE) IS
352: SELECT DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(scah.version_number),
353: 'cal_type', scah.cal_type,

Line 350: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE,

346: BEGIN
347: DECLARE
348: CURSOR c_sca_hist (cp_column_name user_tab_columns.column_name%TYPE,
349: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
350: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE,
351: cp_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE) IS
352: SELECT DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(scah.version_number),
353: 'cal_type', scah.cal_type,
354: 'LOCATION_CD', scah.location_cd,

Line 351: cp_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE) IS

347: DECLARE
348: CURSOR c_sca_hist (cp_column_name user_tab_columns.column_name%TYPE,
349: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
350: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE,
351: cp_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE) IS
352: SELECT DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(scah.version_number),
353: 'cal_type', scah.cal_type,
354: 'LOCATION_CD', scah.location_cd,
355: 'attendance_mode', scah.attendance_mode,

Line 383: FROM IGS_AS_SC_ATTEMPT_H scah

379: 'IGS_CO_CAT', scah.CORRESPONDENCE_CAT,
380: 'SELF_HELP_GROUP_IND', scah.self_help_group_ind,
381: 'PRIMARY_PROGRAM_TYPE', primary_program_type, --Bug 2162747 by vvutukur
382: 'KEY_PROGRAM', key_program) --Bug 2162747 by vvutukur
383: FROM IGS_AS_SC_ATTEMPT_H scah
384: WHERE scah.person_id = cp_person_id AND
385: scah.course_cd = cp_course_cd AND
386: scah.hist_start_dt >= cp_hist_end_dt
387: ORDER BY