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.

[Home] [Help]

APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_WAIVER_PGMS

Line 43: p_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) RETURN BOOLEAN AS

39:
40: FUNCTION validate_params(p_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
41: p_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
42: p_v_fee_type igs_fi_fee_type.fee_type%TYPE,
43: p_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) RETURN BOOLEAN AS
44:
45: /******************************************************************
46: Created By : Amit Gairola
47: Date Created By : 10-Aug-2005

Line 62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS

58:
59: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
63: SELECT waiver_name
64: FROM igs_fi_waiver_pgms
65: WHERE target_fee_type = cp_v_fee_type
66: AND fee_cal_type = cp_v_fee_cal_type

Line 64: FROM igs_fi_waiver_pgms

60: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
61: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
62: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
63: SELECT waiver_name
64: FROM igs_fi_waiver_pgms
65: WHERE target_fee_type = cp_v_fee_type
66: AND fee_cal_type = cp_v_fee_cal_type
67: AND fee_ci_sequence_number = cp_n_fee_ci_seq
68: AND ((waiver_name = cp_v_waiver_name) OR (cp_v_waiver_name IS NULL));

Line 73: l_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE;

69:
70: l_v_var VARCHAR2(1);
71: l_b_rec_found BOOLEAN;
72: l_b_ret_val BOOLEAN;
73: l_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE;
74:
75: BEGIN
76: l_b_rec_found := FALSE;
77: l_b_ret_val := TRUE;

Line 591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS

587:
588: CURSOR cur_wav_pgm(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
592: SELECT fwp.*
593: FROM igs_fi_waiver_pgms fwp
594: WHERE fwp.target_fee_type = cp_v_fee_type
595: AND fwp.fee_cal_type = cp_v_fee_cal_type

Line 593: FROM igs_fi_waiver_pgms fwp

589: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
590: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
591: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
592: SELECT fwp.*
593: FROM igs_fi_waiver_pgms fwp
594: WHERE fwp.target_fee_type = cp_v_fee_type
595: AND fwp.fee_cal_type = cp_v_fee_cal_type
596: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
597: AND ((fwp.waiver_name = cp_v_waiver_name) OR (cp_v_waiver_name IS NULL))

Line 603: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS

599:
600: CURSOR cur_wav_std_pgm(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
601: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
602: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
603: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE) IS
604: SELECT assignment_status_code
605: FROM igs_fi_wav_std_pgms
606: WHERE person_id = cp_n_person_id
607: AND fee_cal_type = cp_v_fee_cal_type

Line 1032: FROM igs_fi_waiver_pgms fwp

1028: fwp.credit_type_id,
1029: fwp.target_fee_type,
1030: fwp.waiver_mode_code,
1031: fwp.adjustment_fee_type
1032: FROM igs_fi_waiver_pgms fwp
1033: WHERE fwp.target_fee_type = cp_v_fee_type
1034: AND fwp.fee_cal_type = cp_v_fee_cal_type
1035: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
1036: AND fwp.waiver_method_code = 'MANUAL';

Line 1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,

1187:
1188: PROCEDURE validate_params( p_n_person_id IN hz_parties.party_id%TYPE,
1189: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1190: p_v_fee_cal IN VARCHAR2,
1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

Line 1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,

1188: PROCEDURE validate_params( p_n_person_id IN hz_parties.party_id%TYPE,
1189: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1190: p_v_fee_cal IN VARCHAR2,
1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,
1194: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1195: p_n_fee_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1196: p_v_ld_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

Line 1218: CURSOR cur_chk_waiver_name(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,

1214: SELECT 'X'
1215: FROM igs_pe_persid_group_v
1216: WHERE group_id = cp_n_person_grp_id;
1217:
1218: CURSOR cur_chk_waiver_name(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1219: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1220: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE)
1221: IS
1222: SELECT fwp.fee_cal_type,

Line 1219: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,

1215: FROM igs_pe_persid_group_v
1216: WHERE group_id = cp_n_person_grp_id;
1217:
1218: CURSOR cur_chk_waiver_name(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1219: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1220: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE)
1221: IS
1222: SELECT fwp.fee_cal_type,
1223: fwp.fee_ci_sequence_number,

Line 1220: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE)

1216: WHERE group_id = cp_n_person_grp_id;
1217:
1218: CURSOR cur_chk_waiver_name(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1219: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1220: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE)
1221: IS
1222: SELECT fwp.fee_cal_type,
1223: fwp.fee_ci_sequence_number,
1224: fwp.waiver_name,

Line 1227: FROM igs_fi_waiver_pgms fwp

1223: fwp.fee_ci_sequence_number,
1224: fwp.waiver_name,
1225: fwp.waiver_method_code,
1226: fwp.target_fee_type
1227: FROM igs_fi_waiver_pgms fwp
1228: WHERE fwp.fee_cal_type = cp_v_fee_cal_type
1229: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_nbr
1230: AND fwp.waiver_name = cp_v_waiver_name;
1231:

Line 1232: CURSOR cur_chk_fee_type(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,

1228: WHERE fwp.fee_cal_type = cp_v_fee_cal_type
1229: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_nbr
1230: AND fwp.waiver_name = cp_v_waiver_name;
1231:
1232: CURSOR cur_chk_fee_type(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1233: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1234: cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1235: IS
1236: SELECT 'X'

Line 1233: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,

1229: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_nbr
1230: AND fwp.waiver_name = cp_v_waiver_name;
1231:
1232: CURSOR cur_chk_fee_type(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1233: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1234: cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1235: IS
1236: SELECT 'X'
1237: FROM igs_fi_waiver_pgms fwp

Line 1234: cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)

1230: AND fwp.waiver_name = cp_v_waiver_name;
1231:
1232: CURSOR cur_chk_fee_type(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1233: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1234: cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1235: IS
1236: SELECT 'X'
1237: FROM igs_fi_waiver_pgms fwp
1238: WHERE fwp.fee_cal_type = cp_v_fee_cal_type

Line 1237: FROM igs_fi_waiver_pgms fwp

1233: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1234: cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1235: IS
1236: SELECT 'X'
1237: FROM igs_fi_waiver_pgms fwp
1238: WHERE fwp.fee_cal_type = cp_v_fee_cal_type
1239: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_seq_nbr
1240: AND fwp.target_fee_type = cp_v_target_fee_type;
1241:

Line 1400: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,

1396:
1397: END validate_params;
1398:
1399: PROCEDURE log_result(p_n_person_id IN hz_parties.party_id%TYPE,
1400: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1401: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1402: p_n_waiver_amount IN NUMBER,
1403: p_v_status IN VARCHAR2) IS
1404: ------------------------------------------------------------------

Line 1401: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,

1397: END validate_params;
1398:
1399: PROCEDURE log_result(p_n_person_id IN hz_parties.party_id%TYPE,
1400: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1401: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1402: p_n_waiver_amount IN NUMBER,
1403: p_v_status IN VARCHAR2) IS
1404: ------------------------------------------------------------------
1405: --Created by :Gurpreet Singh , Oracle India (in)

Line 1449: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,

1445:
1446: PROCEDURE log_in_parameters(p_n_person_id IN hz_parties.party_id%TYPE,
1447: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1448: p_v_fee_cal IN VARCHAR2,
1449: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1450: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1451: p_d_gl_date IN VARCHAR2) IS
1452: ------------------------------------------------------------------
1453: --Created by :Gurpreet Singh , Oracle India (in)

Line 1450: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,

1446: PROCEDURE log_in_parameters(p_n_person_id IN hz_parties.party_id%TYPE,
1447: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1448: p_v_fee_cal IN VARCHAR2,
1449: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1450: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1451: p_d_gl_date IN VARCHAR2) IS
1452: ------------------------------------------------------------------
1453: --Created by :Gurpreet Singh , Oracle India (in)
1454: --Date created: 08-Aug, 2005

Line 1533: p_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,

1529: retcode OUT NOCOPY NUMBER,
1530: p_person_id IN hz_parties.party_id%TYPE,
1531: p_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1532: p_fee_cal IN VARCHAR2,
1533: p_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1534: p_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1535: p_gl_date IN VARCHAR2 ) IS
1536: ------------------------------------------------------------------
1537: --Created by :Gurpreet Singh, Oracle India (in)

Line 1534: p_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,

1530: p_person_id IN hz_parties.party_id%TYPE,
1531: p_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1532: p_fee_cal IN VARCHAR2,
1533: p_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1534: p_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1535: p_gl_date IN VARCHAR2 ) IS
1536: ------------------------------------------------------------------
1537: --Created by :Gurpreet Singh, Oracle India (in)
1538: --Date created: 08-Aug-2005

Line 1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,

1601: SELECT currency_cd
1602: FROM IGS_FI_CONTROL;
1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;
1604:
1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1608: cp_n_person_id hz_parties.party_id%TYPE,
1609: cp_v_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)

Line 1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,

1602: FROM IGS_FI_CONTROL;
1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;
1604:
1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1608: cp_n_person_id hz_parties.party_id%TYPE,
1609: cp_v_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1610: IS

Line 1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,

1603: l_currency_cd IGS_FI_CONTROL.currency_cd%TYPE;
1604:
1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1608: cp_n_person_id hz_parties.party_id%TYPE,
1609: cp_v_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1610: IS
1611: SELECT FWSP.WAIVER_NAME,

Line 1609: cp_v_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)

1605: CURSOR cur_get_stdnt_wvr_assgn(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1606: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,
1607: cp_v_waiver_name IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1608: cp_n_person_id hz_parties.party_id%TYPE,
1609: cp_v_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1610: IS
1611: SELECT FWSP.WAIVER_NAME,
1612: FWSP.PERSON_ID,
1613: FWP.TARGET_FEE_TYPE

Line 1615: IGS_FI_WAIVER_PGMS FWP

1611: SELECT FWSP.WAIVER_NAME,
1612: FWSP.PERSON_ID,
1613: FWP.TARGET_FEE_TYPE
1614: FROM IGS_FI_WAV_STD_PGMS FWSP,
1615: IGS_FI_WAIVER_PGMS FWP
1616: WHERE FWSP.FEE_CAL_TYPE = cp_v_fee_cal_type
1617: AND FWSP.FEE_CI_SEQUENCE_NUMBER = cp_n_fee_ci_seq_nbr
1618: AND (cp_v_waiver_name IS NULL OR FWSP.WAIVER_NAME = cp_v_waiver_name)
1619: AND (FWSP.PERSON_ID = cp_n_person_id OR cp_n_person_id IS NULL)

Line 1627: CURSOR cur_get_sys_fee_type(cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)

1623: AND (cp_v_fee_type IS NULL OR FWP.TARGET_FEE_TYPE = cp_v_fee_type);
1624:
1625: l_rec_c_get_stdnt_wvr_assgn cur_get_stdnt_wvr_assgn%ROWTYPE;
1626:
1627: CURSOR cur_get_sys_fee_type(cp_v_target_fee_type IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE)
1628: IS
1629: SELECT FT.S_FEE_TYPE
1630: FROM IGS_FI_FEE_TYPE_ALL FT
1631: WHERE FT.FEE_TYPE = cp_v_target_fee_type;