APPS.IGS_PE_HZ_CONT_PREF_PKG dependencies on HZ_CONTACT_PREFERENCES

Line 7: (p_start_date IN hz_contact_preferences.PREFERENCE_START_DATE%TYPE,

3:
4: g_error_msg VARCHAR2(2000);
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)

Line 8: p_end_date IN hz_contact_preferences.PREFERENCE_END_DATE%TYPE,

4: g_error_msg VARCHAR2(2000);
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

Line 65: p_person_id hz_contact_preferences.CONTACT_LEVEL_TABLE_ID%TYPE,

61: --Local procedure to check for duplicate records
62:
63:
64: PROCEDURE val_overlap_api(
65: p_person_id hz_contact_preferences.CONTACT_LEVEL_TABLE_ID%TYPE,
66: p_start_date DATE,
67: p_end_date DATE,
68: p_cpid NUMBER,
69: x_msg_data OUT NOCOPY varchar2,

Line 84: CURSOR c_validate_overlap_dates ( cp_person_id hz_contact_preferences.CONTACT_LEVEL_TABLE_ID%TYPE,

80: || (reverse chronological order - newest change first) */
81:
82: --l_nvl_end DATE := NVL(p_END_DATE,TO_DATE('4712/12/31','YYYY/MM/DD'));
83:
84: CURSOR c_validate_overlap_dates ( cp_person_id hz_contact_preferences.CONTACT_LEVEL_TABLE_ID%TYPE,
85: cp_start_date DATE,
86: cp_end_date DATE,
87: cp_cpid NUMBER)
88: IS

Line 90: FROM hz_contact_preferences

86: cp_end_date DATE,
87: cp_cpid NUMBER)
88: IS
89: SELECT 1
90: FROM hz_contact_preferences
91: WHERE contact_level_table_id = cp_person_id
92: AND contact_type = 'VISIT'
93: AND ( cp_cpid IS NULL OR contact_preference_id <> cp_cpid)
94: AND (NVL(preference_END_DATE,TO_DATE('4712/12/31','YYYY/MM/DD')) >= cp_start_date OR