DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 100: p_update_field_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,

96: END preference_date_nonupdateable;
97:
98: PROCEDURE get_updated_record (
99: p_contact_preference_id IN NUMBER,
100: p_update_field_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,
101: x_updated_cp_rec OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
102: )
103: IS
104: BEGIN

Line 101: x_updated_cp_rec OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE

97:
98: PROCEDURE get_updated_record (
99: p_contact_preference_id IN NUMBER,
100: p_update_field_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,
101: x_updated_cp_rec OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
102: )
103: IS
104: BEGIN
105:

Line 158: p_contact_preference_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,

154: --------------------------------------
155:
156: PROCEDURE validate_contact_preference (
157: p_create_update_flag IN VARCHAR2,
158: p_contact_preference_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE,
159: p_rowid IN ROWID,
160: x_return_status IN OUT NOCOPY VARCHAR2
161:
162: ) IS

Line 184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

180: l_dummy VARCHAR2(1);
181: l_tag FND_LOOKUP_VALUES.tag%TYPE;
182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;
183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;
186: l_preference_topic_type_code HZ_CONTACT_PREFERENCES.preference_topic_type_code%TYPE;
187: l_max_no_of_interact_uom_code HZ_CONTACT_PREFERENCES.max_no_of_interact_uom_code%TYPE;
188: l_reason_code HZ_CONTACT_PREFERENCES.reason_code%TYPE;