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_EN_STDNT_PS_ATT

Line 149: FROM igs_en_stdnt_ps_att spa,

145: ) start_dt,
146: far.location_cd chg_rate_location_cd,
147: far.attendance_type chg_rate_attendance_type,
148: far.attendance_mode chg_rate_attendance_mode
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,

Line 212: igs_en_stdnt_ps_att spa,

208: far.location_cd chg_rate_location_cd,
209: far.attendance_type chg_rate_attendance_type,
210: far.attendance_mode chg_rate_attendance_mode
211: FROM igs_en_spa_terms spt,
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,

Line 360: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE,

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
364: retcode:=0;

Line 843: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE,

839: p_person_id IN VARCHAR2,
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,

Line 1291: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

1287: errbuf out NOCOPY varchar2,
1288: retcode out NOCOPY NUMBER,
1289: p_effective_dt_C IN OUT NOCOPY VARCHAR2 ,
1290: P_fee_assessment_period IN VARCHAR2,
1291: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1292: p_fee_cat IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1293: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1294: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1295: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,

Line 1292: p_fee_cat IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

1288: retcode out NOCOPY NUMBER,
1289: p_effective_dt_C IN OUT NOCOPY VARCHAR2 ,
1290: P_fee_assessment_period IN VARCHAR2,
1291: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1292: p_fee_cat IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1293: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1294: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1295: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1296: p_org_id NUMBER

Line 1293: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

1289: p_effective_dt_C IN OUT NOCOPY VARCHAR2 ,
1290: P_fee_assessment_period IN VARCHAR2,
1291: p_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
1292: p_fee_cat IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,
1293: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
1294: p_deferred_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1295: p_upfront_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE,
1296: p_org_id NUMBER
1297: ) AS

Line 1325: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

1321: errbuf out NOCOPY varchar2,
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,

Line 1327: p_fee_cat IN IGS_EN_STDNT_PS_ATT_ALL.fee_cat%TYPE ,

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,
1331: p_org_id NUMBER

Line 1328: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

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,
1331: p_org_id NUMBER
1332: ) AS

Line 1501: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1497: App_Exception.Raise_Exception;
1498: END finpl_prc_end_fee_contract;
1499:
1500: PROCEDURE finpl_prc_reverse_fee_assess (
1501: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1502: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1503: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1504: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
1505: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,

Line 1502: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1498: END finpl_prc_end_fee_contract;
1499:
1500: PROCEDURE finpl_prc_reverse_fee_assess (
1501: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1502: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1503: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1504: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
1505: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
1506: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE)

Line 1506: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE)

1502: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1503: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1504: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
1505: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
1506: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE)
1507: AS
1508:
1509: CURSOR cur_fee_calc_mthd
1510: IS

Line 1596: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1592: App_Exception.Raise_Exception;
1593: END finpl_prc_reverse_fee_assess;
1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1595: FUNCTION finpl_prc_this_crs_liable (
1596: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1597: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1598: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE,
1599: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
1600: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,

Line 1597: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1593: END finpl_prc_reverse_fee_assess;
1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1595: FUNCTION finpl_prc_this_crs_liable (
1596: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1597: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1598: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE,
1599: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
1600: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1601: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE)

Line 1598: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE,

1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1595: FUNCTION finpl_prc_this_crs_liable (
1596: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1597: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1598: p_fee_cat IGS_EN_STDNT_PS_ATT.FEE_CAT%TYPE,
1599: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
1600: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1601: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE)
1602: RETURN VARCHAR2 AS

Line 1648: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1644: App_Exception.Raise_Exception;
1645: END finpl_prc_this_crs_liable;
1646: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1647: FUNCTION finpl_prc_another_crs_liable (
1648: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1649: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1650: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1651: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
1652: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE)

Line 1649: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

1645: END finpl_prc_this_crs_liable;
1646: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.
1647: FUNCTION finpl_prc_another_crs_liable (
1648: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1649: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1650: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
1651: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
1652: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE)
1653: RETURN VARCHAR2 AS