APPS.IGS_EN_PRC_LOAD dependencies on HZ_PARTIES

Line 1666: FUNCTION enrp_clc_key_prog(p_person_id IN hz_parties.party_id%TYPE,

1662:
1663: END;
1664: END ENRP_GET_LOAD_APPLY;
1665:
1666: FUNCTION enrp_clc_key_prog(p_person_id IN hz_parties.party_id%TYPE,
1667: p_version_number OUT NOCOPY igs_en_su_attempt.version_number%TYPE,
1668: p_term_cal_type IN VARCHAR2,
1669: p_term_sequence_number IN NUMBER
1670: )

Line 1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,

1749:
1750:
1751: END enrp_clc_key_prog;
1752:
1753: PROCEDURE enrp_get_inst_latt(p_person_id IN hz_parties.party_id%TYPE,
1754: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1755: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1756: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1757: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

Line 1807: FROM hz_parties

1803: --## CURSOR to get the Person number for the person id for message tokens
1804:
1805: CURSOR c_person IS
1806: SELECT party_number
1807: FROM hz_parties
1808: WHERE party_id=p_person_id;
1809:
1810: l_person hz_parties.party_number%TYPE;
1811:

Line 1810: l_person hz_parties.party_number%TYPE;

1806: SELECT party_number
1807: FROM hz_parties
1808: WHERE party_id=p_person_id;
1809:
1810: l_person hz_parties.party_number%TYPE;
1811:
1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,
1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,
1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS

Line 1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,

1929: END enrp_get_inst_latt;
1930:
1931:
1932:
1933: PROCEDURE enrp_get_inst_latt_fte(p_person_id IN hz_parties.party_id%TYPE,
1934: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1935: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE,
1936: p_attendance OUT NOCOPY igs_en_atd_type_load.attendance_type%TYPE,
1937: p_credit_points OUT NOCOPY igs_en_su_attempt.override_achievable_cp%TYPE,

Line 2542: p_person_id IN hz_parties.party_id%TYPE,

2538:
2539: -- Function to calculate the Institutional Level Attendance Type
2540:
2541: FUNCTION enrp_get_inst_attendance(
2542: p_person_id IN hz_parties.party_id%TYPE,
2543: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2544: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2545: ) RETURN VARCHAR2 AS
2546:

Line 2572: p_person_id IN hz_parties.party_id%TYPE,

2568: END enrp_get_inst_attendance;
2569:
2570: -- Function to calculate the Institutional Level Attendance Type
2571: FUNCTION enrp_get_inst_cp(
2572: p_person_id IN hz_parties.party_id%TYPE,
2573: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2574: p_load_seq_number IN igs_ca_inst.sequence_number%TYPE
2575: ) RETURN VARCHAR2 AS
2576: