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_004 dependencies on IGS_FI_FEE_TYPE

Line 126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;

122: cst_active
123: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='ACTIVE';
124: cst_planned
125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';
126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,

Line 129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,

125: CONSTANT IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE :='PLANNED';
126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,

Line 130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,

126: v_previous_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE;
127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,

Line 131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,

127:
128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,
135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,

Line 132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,

128: CURSOR c_scafcflrv( cp_v_s_fee_structure_status igs_fi_fee_str_stat.s_fee_structure_status%TYPE,
129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,
135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,
136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_type%TYPE

Line 133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,

129: cp_v_closed_ind igs_fi_fee_type.closed_ind%TYPE,
130: cp_v_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE,
131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,
135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,
136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_type%TYPE
137: ) IS

Line 153: igs_fi_fee_type ft,

149: FROM igs_en_stdnt_ps_att spa,
150: igs_fi_f_cat_fee_lbl_v fcflv,
151: igs_fi_fee_str_stat fsst,
152: igs_fi_fee_as_rate far,
153: igs_fi_fee_type ft,
154: igs_fi_fee_as_rt cfar
155: WHERE spa.person_id = p_person_id
156: AND spa.course_cd = p_course_cd
157: AND spa.fee_cat = fcflv.fee_cat

Line 216: igs_fi_fee_type ft,

212: igs_en_stdnt_ps_att spa,
213: igs_fi_f_cat_fee_lbl_v fcflv,
214: igs_fi_fee_str_stat fsst,
215: igs_fi_fee_as_rate far,
216: igs_fi_fee_type ft,
217: igs_fi_fee_as_rt cfar
218: WHERE spt.person_id = p_person_id
219: AND spt.program_cd = p_course_cd
220: AND spt.person_id = spa.person_id

Line 330: p_fee_type IN IGS_FI_FEE_TYPE_all.fee_type%TYPE ,

326: errbuf out NOCOPY varchar2,
327: retcode out NOCOPY NUMBER,
328: p_fin_period IN VARCHAR2 ,
329: p_fee_period IN VARCHAR2,
330: p_fee_type IN IGS_FI_FEE_TYPE_all.fee_type%TYPE ,
331: p_snapshot_create_dt_C IN DATE,
332: p_income_type IN VARCHAR2 ,
333: p_ignore_prior_journals IN CHAR ,
334: p_percent_disbursement IN NUMBER,

Line 359: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE,

355: errbuf out NOCOPY varchar2,
356: retcode out NOCOPY NUMBER,
357: p_fin_period IN VARCHAR2,
358: p_fee_period IN VARCHAR2,
359: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE,
360: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE,
361: p_org_id NUMBER
362: ) AS
363: BEGIN

Line 844: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE,

840: p_person_grp_id IN VARCHAR2,
841: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
842: p_fee_cal IN VARCHAR2,
843: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE,
844: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE,
845: p_trace_on IN VARCHAR2,
846: p_test_run IN VARCHAR2,
847: p_org_id NUMBER,
848: p_process_mode IN VARCHAR2,

Line 1326: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

1322: retcode out NOCOPY number,
1323: p_effective_dt_C IN VARCHAR2,
1324: P_fee_assessment_period IN VARCHAR2,
1325: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1326: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
1327: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1328: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1329: p_pending_fee_encmb_status IN VARCHAR2,
1330: p_n_authorising_person_id IN NUMBER,