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_001 dependencies on USER_TAB_COLUMNS

Line 4: p_column_name IN user_tab_columns.column_name%TYPE ,

1: PACKAGE BODY IGS_AU_GEN_001 AS
2: /* $Header: IGSAU01B.pls 115.7 2003/12/03 20:48:58 knag ship $ */
3: Function Audp_Get_Aah_Col(
4: p_column_name IN user_tab_columns.column_name%TYPE ,
5: p_person_id IN IGS_AD_APPL_HIST_ALL.person_id%TYPE ,
6: p_admission_appl_number IN NUMBER ,
7: p_hist_end_dt IN IGS_AD_APPL_HIST_ALL.hist_end_dt%TYPE )
8: RETURN VARCHAR2 AS

Line 74: p_column_name IN user_tab_columns.column_name%TYPE ,

70: END;
71: END audp_get_aah_col;
72:
73: Function Audp_Get_Acah_Col(
74: p_column_name IN user_tab_columns.column_name%TYPE ,
75: p_person_id IN IGS_AD_PS_APPL_HIST_ALL.person_id%TYPE ,
76: p_admission_appl_number IN NUMBER ,
77: p_nominated_course_cd IN VARCHAR2 ,
78: p_hist_end_dt IN IGS_AD_PS_APPL_HIST_ALL.hist_end_dt%TYPE )

Line 139: p_column_name IN user_tab_columns.column_name%TYPE ,

135: END;
136: END audp_get_acah_col;
137:
138: Function Audp_Get_Acaih_Col(
139: p_column_name IN user_tab_columns.column_name%TYPE ,
140: p_person_id IN NUMBER ,
141: p_admission_appl_number IN NUMBER ,
142: p_nominated_course_cd IN VARCHAR2 ,
143: p_sequence_number IN NUMBER ,

Line 335: p_column_name IN user_tab_columns.column_name%TYPE ,

331: END;
332: END audp_get_acaih_col;
333:
334: Function Audp_Get_Acaiuh_Col(
335: p_column_name IN user_tab_columns.column_name%TYPE ,
336: p_adm_ps_appl_inst_unit_id IN NUMBER ,
337: p_person_id IN NUMBER ,
338: p_admission_appl_number IN NUMBER ,
339: p_nominated_course_cd IN VARCHAR2 ,

Line 348: user_tab_columns.column_name%TYPE := 'UV_VERSION_NUMBER';

344:
345: BEGIN
346: DECLARE
347: cst_uv_version_number CONSTANT
348: user_tab_columns.column_name%TYPE := 'UV_VERSION_NUMBER';
349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';
350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';

Line 349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';

345: BEGIN
346: DECLARE
347: cst_uv_version_number CONSTANT
348: user_tab_columns.column_name%TYPE := 'UV_VERSION_NUMBER';
349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';
350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';

Line 351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';

347: cst_uv_version_number CONSTANT
348: user_tab_columns.column_name%TYPE := 'UV_VERSION_NUMBER';
349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';
350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';
354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT

Line 352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';

348: user_tab_columns.column_name%TYPE := 'UV_VERSION_NUMBER';
349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';
350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';
354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT
356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';

Line 353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';

349: cst_cal_type CONSTANT user_tab_columns.column_name%TYPE := 'CAL_TYPE';
350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';
354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT
356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';
357: cst_ass_tracking_id CONSTANT

Line 354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';

350: cst_ci_sequence_number CONSTANT
351: user_tab_columns.column_name%TYPE := 'CI_SEQUENCE_NUMBER';
352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';
354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT
356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';
357: cst_ass_tracking_id CONSTANT
358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';

Line 356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';

352: cst_location_cd CONSTANT user_tab_columns.column_name%TYPE := 'LOCATION_CD';
353: cst_unit_class CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_CLASS';
354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT
356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';
357: cst_ass_tracking_id CONSTANT
358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';
359: cst_rule_waived_dt CONSTANT
360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';

Line 358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';

354: cst_unit_mode CONSTANT user_tab_columns.column_name%TYPE := 'UNIT_MODE';
355: cst_adm_unit_outcome_status CONSTANT
356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';
357: cst_ass_tracking_id CONSTANT
358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';
359: cst_rule_waived_dt CONSTANT
360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';
361: cst_rule_waived_person_id CONSTANT
362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';

Line 360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';

356: user_tab_columns.column_name%TYPE := 'ADM_UNIT_OUTCOME_STATUS';
357: cst_ass_tracking_id CONSTANT
358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';
359: cst_rule_waived_dt CONSTANT
360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';
361: cst_rule_waived_person_id CONSTANT
362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';
363: cst_sup_unit_cd CONSTANT user_tab_columns.column_name%TYPE := 'SUP_UNIT_CD';
364: cst_sup_uv_version_number CONSTANT

Line 362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';

358: user_tab_columns.column_name%TYPE := 'ASS_TRACKING_ID';
359: cst_rule_waived_dt CONSTANT
360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';
361: cst_rule_waived_person_id CONSTANT
362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';
363: cst_sup_unit_cd CONSTANT user_tab_columns.column_name%TYPE := 'SUP_UNIT_CD';
364: cst_sup_uv_version_number CONSTANT
365: user_tab_columns.column_name%TYPE := 'SUP_UV_VERSION_NUMBER';
366: v_column_value VARCHAR2(2000) := NULL;

Line 363: cst_sup_unit_cd CONSTANT user_tab_columns.column_name%TYPE := 'SUP_UNIT_CD';

359: cst_rule_waived_dt CONSTANT
360: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_DT';
361: cst_rule_waived_person_id CONSTANT
362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';
363: cst_sup_unit_cd CONSTANT user_tab_columns.column_name%TYPE := 'SUP_UNIT_CD';
364: cst_sup_uv_version_number CONSTANT
365: user_tab_columns.column_name%TYPE := 'SUP_UV_VERSION_NUMBER';
366: v_column_value VARCHAR2(2000) := NULL;
367: CURSOR c_acaiuh IS

Line 365: user_tab_columns.column_name%TYPE := 'SUP_UV_VERSION_NUMBER';

361: cst_rule_waived_person_id CONSTANT
362: user_tab_columns.column_name%TYPE := 'RULE_WAIVED_PERSON_ID';
363: cst_sup_unit_cd CONSTANT user_tab_columns.column_name%TYPE := 'SUP_UNIT_CD';
364: cst_sup_uv_version_number CONSTANT
365: user_tab_columns.column_name%TYPE := 'SUP_UV_VERSION_NUMBER';
366: v_column_value VARCHAR2(2000) := NULL;
367: CURSOR c_acaiuh IS
368: SELECT DECODE(p_column_name,
369: cst_uv_version_number, TO_CHAR(acaiuh.uv_version_number),

Line 426: p_column_name user_tab_columns.column_name%TYPE ,

422: Function Audp_Get_Cfosh_Col(
423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
426: p_column_name user_tab_columns.column_name%TYPE ,
427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )
428: RETURN VARCHAR2 AS
429:
430: BEGIN -- audp_get_cfosh_col

Line 541: p_column_name user_tab_columns.column_name%TYPE ,

537: END;
538: END audp_get_crch_col;
539:
540: Function Audp_Get_Cth_Col(
541: p_column_name user_tab_columns.column_name%TYPE ,
542: p_course_type IGS_PS_TYPE_ALL.course_type%TYPE ,
543: p_hist_end_dt IGS_PS_TYPE_HIST_ALL.hist_end_dt%TYPE )
544: RETURN VARCHAR2 AS
545: -- HISTORY