APPS.IGS_PE_HZ_CONT_PREF_PKG dependencies on HZ_PARTIES

Line 9: p_person_id IN hz_parties.party_id%TYPE,

5:
6: PROCEDURE date_validate
7: (p_start_date IN hz_contact_preferences.PREFERENCE_START_DATE%TYPE,
8: p_end_date IN hz_contact_preferences.PREFERENCE_END_DATE%TYPE,
9: p_person_id IN hz_parties.party_id%TYPE,
10: x_msg_data OUT NOCOPY varchar2,
11: p_mode IN VARCHAR2)
12: AS
13: /*

Line 22: CURSOR c_person_db (cp_person_id HZ_PARTIES.PARTY_ID%TYPE)IS

18: || Change History :
19: || Who When What
20: || (reverse chronological order - newest change first)
21: */
22: CURSOR c_person_db (cp_person_id HZ_PARTIES.PARTY_ID%TYPE)IS
23: SELECT birth_date FROM igs_pe_person_base_v
24: WHERE person_id = cp_person_id;
25: l_date DATE := null;
26:

Line 150: l_cont_pref_rec_type.contact_level_table := NVL(X_CONTACT_LEVEL_TABLE,'HZ_PARTIES');

146: tmp_var1 VARCHAR2(2000);
147: BEGIN
148:
149:
150: l_cont_pref_rec_type.contact_level_table := NVL(X_CONTACT_LEVEL_TABLE,'HZ_PARTIES');
151: l_cont_pref_rec_type.contact_level_table_id := X_CONTACT_LEVEL_TABLE_ID;
152: l_cont_pref_rec_type.contact_type := X_CONTACT_TYPE;
153: l_cont_pref_rec_type.preference_code := X_PREFERENCE_CODE;
154: l_cont_pref_rec_type.preference_start_date := X_PREFERENCE_START_DATE;

Line 285: l_cont_pref_rec_type.contact_level_table := NVL(X_CONTACT_LEVEL_TABLE,'HZ_PARTIES');

281:
282: x_return_status := null;
283: x_msg_data := null;
284: l_cont_pref_rec_type.contact_preference_id := x_CONTACT_PREFERENCE_ID;
285: l_cont_pref_rec_type.contact_level_table := NVL(X_CONTACT_LEVEL_TABLE,'HZ_PARTIES');
286: l_cont_pref_rec_type.contact_level_table_id := X_CONTACT_LEVEL_TABLE_ID;
287: l_cont_pref_rec_type.contact_type := X_CONTACT_TYPE;
288: l_cont_pref_rec_type.preference_code := X_PREFERENCE_CODE;
289: l_cont_pref_rec_type.preference_start_date := X_PREFERENCE_START_DATE;