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_FI_GEN_APINT dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 97: CURSOR cur_uoo_details(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

93: --Who When What
94: ------------------------------------------------------------------
95:
96: --Cursor to fetch the unit section details.
97: CURSOR cur_uoo_details(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
98: SELECT unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class
99: FROM igs_ps_unit_ofr_opt_all
100: WHERE uoo_id = cp_n_uoo_id;
101:

Line 99: FROM igs_ps_unit_ofr_opt_all

95:
96: --Cursor to fetch the unit section details.
97: CURSOR cur_uoo_details(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
98: SELECT unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class
99: FROM igs_ps_unit_ofr_opt_all
100: WHERE uoo_id = cp_n_uoo_id;
101:
102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;

Line 102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;

98: SELECT unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class
99: FROM igs_ps_unit_ofr_opt_all
100: WHERE uoo_id = cp_n_uoo_id;
101:
102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;

Line 103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;

99: FROM igs_ps_unit_ofr_opt_all
100: WHERE uoo_id = cp_n_uoo_id;
101:
102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;

Line 104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;

100: WHERE uoo_id = cp_n_uoo_id;
101:
102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:

Line 105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;

101:
102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:
109: --Cursor to get the Teaching Calendar for the Calendar Type and Calendar Instance Sequence Number.

Line 106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;

102: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE := p_v_unit_cd;
103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:
109: --Cursor to get the Teaching Calendar for the Calendar Type and Calendar Instance Sequence Number.
110: CURSOR cur_cal_type (cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;

103: l_n_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE := p_n_version_number;
104: l_v_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE := p_v_cal_type;
105: l_n_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE := p_n_ci_sequence_number;
106: l_v_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE := p_v_location_cd;
107: l_v_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE := p_v_unit_class;
108:
109: --Cursor to get the Teaching Calendar for the Calendar Type and Calendar Instance Sequence Number.
110: CURSOR cur_cal_type (cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
111: cp_n_seq_number igs_ca_inst_all.sequence_number%TYPE