APPS.IGS_FI_PRC_WAIVERS dependencies on HZ_PARTIES

Line 1188: PROCEDURE validate_params( p_n_person_id IN hz_parties.party_id%TYPE,

1184: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_fi_prc_waivers.'||p_v_module, p_v_string);
1185: END IF;
1186: END log_to_fnd;
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,

Line 1399: PROCEDURE log_result(p_n_person_id IN hz_parties.party_id%TYPE,

1395: p_val_status := l_b_parameter_val_status;
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

Line 1446: PROCEDURE log_in_parameters(p_n_person_id IN hz_parties.party_id%TYPE,

1442: fnd_file.put_line(fnd_file.log,fnd_message.get);
1443:
1444: END log_result;
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,

Line 1530: p_person_id IN hz_parties.party_id%TYPE,

1526:
1527:
1528: PROCEDURE process_waivers( errbuf OUT NOCOPY VARCHAR2,
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,

Line 1552: l_n_person_id hz_parties.party_id%TYPE;

1548: -------------------------------------------------------------------
1549: TYPE person_grp_ref_cur_type IS REF CURSOR;
1550: c_ref_person_grp person_grp_ref_cur_type;
1551:
1552: l_n_person_id hz_parties.party_id%TYPE;
1553: l_dynamic_sql VARCHAR2(32767);
1554: l_v_status VARCHAR2(1);
1555: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE;
1556: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1608: cp_n_person_id hz_parties.party_id%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,
1612: FWSP.PERSON_ID,