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_AS

Line 19: finpl_prc_another_crs_liable to use IGS_FI_FEE_AS instead of IGS_FI_FEE_ASS_DEBT_V.

15: vvutukur 03-Feb-2004 Enh#3167098.FICR112 Build. Modified finp_prc_cfar.
16: shtatiko 24-DEC-2003 Enh# 3167098, Modified finp_prc_sca_unconf, finp_prc_enr_fee_ass, finpl_prc_reverse_fee_assess
17: uudayapr 15-DEC-2003 Bug#3080983 Modified the Procedure finp_prc_enr_fee_ass,finp_prc_sca_unconf
18: and the input parameter of procedure finpl_prc_reverse_fee_assess, finpl_prc_this_crs_liable,
19: finpl_prc_another_crs_liable to use IGS_FI_FEE_AS instead of IGS_FI_FEE_ASS_DEBT_V.
20: shtatiko 25-NOV-2003 Bug# 3230754, Modified finp_prc_enr_fa_todo.
21: pathipat 04-Nov-2003 Bug: 3151102 - Modified finp_prc_enr_fee_ass() Removed conditions before
22: setting p_create_dt to v_create_dt
23: pathipat 17-Oct-2003 Bug: 3151102 - Modified finp_prc_enr_fee_ass() - Added begin-end block for exception handling

Line 95: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,

91: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
92: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
93:
94: FUNCTION finp_prc_cfar(
95: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
96: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
97: p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
98: p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
99: p_message_name OUT NOCOPY VARCHAR2 )

Line 96: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,

92: g_v_ind_no CONSTANT VARCHAR2(1) := 'N';
93:
94: FUNCTION finp_prc_cfar(
95: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
96: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
97: p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
98: p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
99: p_message_name OUT NOCOPY VARCHAR2 )
100: RETURN BOOLEAN AS

Line 97: p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,

93:
94: FUNCTION finp_prc_cfar(
95: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
96: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
97: p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
98: p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
99: p_message_name OUT NOCOPY VARCHAR2 )
100: RETURN BOOLEAN AS
101: ------------------------------------------------------------------

Line 98: p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,

94: FUNCTION finp_prc_cfar(
95: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
96: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
97: p_commencement_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
98: p_completion_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
99: p_message_name OUT NOCOPY VARCHAR2 )
100: RETURN BOOLEAN AS
101: ------------------------------------------------------------------
102: --Created by :

Line 135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%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
138: SELECT fcflv.fee_type fee_type,
139: far.chg_rate chg_rate,

Line 136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_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
138: SELECT fcflv.fee_type fee_type,
139: far.chg_rate chg_rate,
140: fcflv.fee_cal_type fee_cal_type,

Line 152: igs_fi_fee_as_rate far,

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,
154: igs_fi_fee_as_rt cfar
155: WHERE spa.person_id = p_person_id
156: AND spa.course_cd = p_course_cd

Line 154: igs_fi_fee_as_rt cfar

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
158: AND fcflv.fee_liability_status = fsst.fee_structure_status

Line 215: igs_fi_fee_as_rate far,

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,
217: igs_fi_fee_as_rt cfar
218: WHERE spt.person_id = p_person_id
219: AND spt.program_cd = p_course_cd

Line 217: igs_fi_fee_as_rt cfar

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
221: AND spt.program_cd = spa.course_cd

Line 863: uudayapr 15-dec-2003 Bug#3080983 Modified the Cursor c_fee_ass_debt to select data from IGS_FI_FEE_AS instead of

859: abshriva 05-DEC-2005 Bug:4701695 Made the code modification so that 'Fee calculation method' and 'term'message
860: is displayed only once in log file on execution of 'Process Fee Assessment'
861: shtatiko 03-JAN-2004 Enh# 3167098, Providing Persin Id or Person Group is made mandatory. Initial and Combined Processing
862: modes are made functionally obsolete.
863: uudayapr 15-dec-2003 Bug#3080983 Modified the Cursor c_fee_ass_debt to select data from IGS_FI_FEE_AS instead of
864: IGS_FI_FEE_ASS_DEBT_V .
865: shtatiko 18-NOV-2003 Enh# 3117341, Added check for profile 'IGS: Charge tuition for Audited Student Attempt'
866: pathipat 04-Nov-2003 Bug: 3151102 - Removed conditions before setting p_create_dt to v_create_dt
867: pathipat 17-Oct-2003 Bug: 3151102 - Added begin-end block for exception handling

Line 864: IGS_FI_FEE_ASS_DEBT_V .

860: is displayed only once in log file on execution of 'Process Fee Assessment'
861: shtatiko 03-JAN-2004 Enh# 3167098, Providing Persin Id or Person Group is made mandatory. Initial and Combined Processing
862: modes are made functionally obsolete.
863: uudayapr 15-dec-2003 Bug#3080983 Modified the Cursor c_fee_ass_debt to select data from IGS_FI_FEE_AS instead of
864: IGS_FI_FEE_ASS_DEBT_V .
865: shtatiko 18-NOV-2003 Enh# 3117341, Added check for profile 'IGS: Charge tuition for Audited Student Attempt'
866: pathipat 04-Nov-2003 Bug: 3151102 - Removed conditions before setting p_create_dt to v_create_dt
867: pathipat 17-Oct-2003 Bug: 3151102 - Added begin-end block for exception handling
868: pathipat 07-Oct-2003 Bug 3122652 - Logged messg IGF_AP_INVALID_QUERY if any error occurs

Line 1371: uudayapr 15-dec-2003 Bug#3080983 Modified the cursor c_fasdv to fetch Data from IGS_FI_FEE_AS instead of IGS_FI_FEE_ASS_DEBT_V.

1367: Know limitations, enhancements or remarks
1368: Change History
1369: Who When What
1370: shtatiko 24-DEC-2003 Enh# 3167098, Modified finpl_prc_this_crs_liable and finpl_prc_another_crs_liable
1371: uudayapr 15-dec-2003 Bug#3080983 Modified the cursor c_fasdv to fetch Data from IGS_FI_FEE_AS instead of IGS_FI_FEE_ASS_DEBT_V.
1372: vchappid 24-May-2002 Bug#2228743, in the local procedure finpl_prc_reverse_fee_assess of finp_prc_sca_unconf
1373: fee assessment call has been changed to pass course cd in case of program approach, course type
1374: incase of the career approach and will pass null in the case of primary_career approach
1375: SCHODAVA 28-NOV-2001 Enh # 2122257

Line 1396: FROM IGS_FI_FEE_AS fas

1392: v_delete_sca_ind VARCHAR2(1) := 'Y';
1393: v_log_entry_ind VARCHAR2(1) := 'N';
1394: CURSOR c_fas IS
1395: SELECT DISTINCT fas.course_cd
1396: FROM IGS_FI_FEE_AS fas
1397: WHERE fas.person_id = p_person_id;
1398: --Modifed to fetch data from IGS_FI_FEE_AS insted of IGS_FI_FEE_ASS_DEBT_V.
1399: CURSOR c_fasdv (cp_fee_ass_course_cd IGS_FI_FEE_AS.course_cd%TYPE) IS
1400: SELECT fasdv.course_cd,

Line 1398: --Modifed to fetch data from IGS_FI_FEE_AS insted of IGS_FI_FEE_ASS_DEBT_V.

1394: CURSOR c_fas IS
1395: SELECT DISTINCT fas.course_cd
1396: FROM IGS_FI_FEE_AS fas
1397: WHERE fas.person_id = p_person_id;
1398: --Modifed to fetch data from IGS_FI_FEE_AS insted of IGS_FI_FEE_ASS_DEBT_V.
1399: CURSOR c_fasdv (cp_fee_ass_course_cd IGS_FI_FEE_AS.course_cd%TYPE) IS
1400: SELECT fasdv.course_cd,
1401: fasdv.fee_cal_type,
1402: fasdv.fee_ci_sequence_number,

Line 1399: CURSOR c_fasdv (cp_fee_ass_course_cd IGS_FI_FEE_AS.course_cd%TYPE) IS

1395: SELECT DISTINCT fas.course_cd
1396: FROM IGS_FI_FEE_AS fas
1397: WHERE fas.person_id = p_person_id;
1398: --Modifed to fetch data from IGS_FI_FEE_AS insted of IGS_FI_FEE_ASS_DEBT_V.
1399: CURSOR c_fasdv (cp_fee_ass_course_cd IGS_FI_FEE_AS.course_cd%TYPE) IS
1400: SELECT fasdv.course_cd,
1401: fasdv.fee_cal_type,
1402: fasdv.fee_ci_sequence_number,
1403: fasdv.FEE_TYPE,

Line 1406: FROM IGS_FI_FEE_AS fasdv

1402: fasdv.fee_ci_sequence_number,
1403: fasdv.FEE_TYPE,
1404: fasdv.FEE_CAT,
1405: SUM(fasdv.transaction_amount) assessment_amount
1406: FROM IGS_FI_FEE_AS fasdv
1407: WHERE fasdv.person_id = p_person_id
1408: AND (fasdv.course_cd = cp_fee_ass_course_cd
1409: OR
1410: (fasdv.course_cd IS NULL AND cp_fee_ass_course_cd IS NULL)

Line 1444: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,

1440: IGS_GE_MSG_STACK.ADD;
1441: App_Exception.Raise_Exception;
1442: END finpl_prc_ins_log_entry;
1443: PROCEDURE finpl_prc_end_fee_contract(
1444: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,
1445: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)
1446: AS
1447: BEGIN -- finpl_prc_end_fee_contract
1448: -- End the fee contract

Line 1445: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)

1441: App_Exception.Raise_Exception;
1442: END finpl_prc_ins_log_entry;
1443: PROCEDURE finpl_prc_end_fee_contract(
1444: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,
1445: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)
1446: AS
1447: BEGIN -- finpl_prc_end_fee_contract
1448: -- End the fee contract
1449: DECLARE

Line 1463: FROM IGS_FI_FEE_AS_RT cfar

1459: cfar.ATTENDANCE_TYPE,
1460: cfar.ATTENDANCE_MODE,
1461: cfar.CHG_RATE,
1462: cfar.LOWER_NRML_RATE_OVRD_IND
1463: FROM IGS_FI_FEE_AS_RT cfar
1464: WHERE cfar.person_id = p_person_id AND
1465: cfar.course_cd = p_course_cd
1466: FOR UPDATE OF cfar.end_dt NOWAIT;
1467: BEGIN

Line 1469: IGS_FI_FEE_AS_RT_PKG.UPDATE_ROW(

1465: cfar.course_cd = p_course_cd
1466: FOR UPDATE OF cfar.end_dt NOWAIT;
1467: BEGIN
1468: FOR v_cfar_rec IN c_cfar LOOP
1469: IGS_FI_FEE_AS_RT_PKG.UPDATE_ROW(
1470: X_ROWID => v_cfar_rec.ROWID ,
1471: X_PERSON_ID => v_cfar_rec.PERSON_ID ,
1472: X_COURSE_CD => v_cfar_rec.COURSE_CD,
1473: X_FEE_TYPE => v_cfar_rec.FEE_TYPE ,

Line 1503: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,

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)
1507: AS

Line 1504: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,

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)
1507: AS
1508:

Line 1505: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,

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)
1507: AS
1508:
1509: CURSOR cur_fee_calc_mthd

Line 1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.

1590: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_REVERSE_FEE_ASSESS');
1591: IGS_GE_MSG_STACK.ADD;
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,

Line 1599: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,

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
1603: BEGIN -- finpl_prc_this_crs_liable

Line 1600: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,

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
1603: BEGIN -- finpl_prc_this_crs_liable
1604: -- Check if this IGS_PS_COURSE is liable for the fees

Line 1601: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%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
1603: BEGIN -- finpl_prc_this_crs_liable
1604: -- Check if this IGS_PS_COURSE is liable for the fees
1605: DECLARE

Line 1646: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.

1642: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_THIS_CRS_LIABLE');
1643: IGS_GE_MSG_STACK.ADD;
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,

Line 1650: p_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,

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
1654: BEGIN -- finpl_prc_another_crs_liable

Line 1651: p_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,

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
1654: BEGIN -- finpl_prc_another_crs_liable
1655: -- Check if another IGS_PS_COURSE is liable for the fees

Line 1652: p_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE)

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
1654: BEGIN -- finpl_prc_another_crs_liable
1655: -- Check if another IGS_PS_COURSE is liable for the fees
1656: DECLARE

Line 1700: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,

1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END finpl_prc_another_crs_liable;
1699: PROCEDURE finpl_prc_delete_fee_contract (
1700: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,
1701: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)
1702: AS
1703: BEGIN -- finpl_prc_delete_fee_contract
1704: -- Delete the fee contract

Line 1701: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)

1697: App_Exception.Raise_Exception;
1698: END finpl_prc_another_crs_liable;
1699: PROCEDURE finpl_prc_delete_fee_contract (
1700: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE,
1701: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE)
1702: AS
1703: BEGIN -- finpl_prc_delete_fee_contract
1704: -- Delete the fee contract
1705: DECLARE

Line 1708: FROM IGS_FI_FEE_AS_RT cfar

1704: -- Delete the fee contract
1705: DECLARE
1706: CURSOR c_cfar IS
1707: SELECT cfar.person_id , cfar.ROWID
1708: FROM IGS_FI_FEE_AS_RT cfar
1709: WHERE cfar.person_id = p_person_id AND
1710: cfar.course_cd = p_course_cd
1711: FOR UPDATE OF cfar.person_id NOWAIT;
1712: BEGIN

Line 1714: IGS_FI_FEE_AS_RT_PKG.DELETE_ROW(X_ROWID =>v_cfar_rec.ROWID);

1710: cfar.course_cd = p_course_cd
1711: FOR UPDATE OF cfar.person_id NOWAIT;
1712: BEGIN
1713: FOR v_cfar_rec IN c_cfar LOOP
1714: IGS_FI_FEE_AS_RT_PKG.DELETE_ROW(X_ROWID =>v_cfar_rec.ROWID);
1715: END LOOP;
1716: EXCEPTION
1717: WHEN e_resource_busy THEN
1718: finpl_prc_ins_log_entry(