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_RT

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 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 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 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 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(