DBA Data[Home] [Help]

APPS.IBU_EBLAST_PREF_PKG dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 13: p_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2 )
12: IS
13: p_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
14: BEGIN
15: p_contact_preference_rec.contact_preference_id := FND_API.G_MISS_NUM;
16: p_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
17: p_contact_preference_rec.contact_level_table_id := p_party_id;

Line 38: hz_contact_preference_v2pub.create_contact_preference(FND_API.G_TRUE,p_contact_preference_rec,x_contact_preference_id,x_return_status,x_msg_count,x_msg_data);

34: p_contact_preference_rec.created_by_module := 'ISUPPORT PROFILE';
35: p_contact_preference_rec.application_id := 672;
36:
37: -- Now call the stored program
38: hz_contact_preference_v2pub.create_contact_preference(FND_API.G_TRUE,p_contact_preference_rec,x_contact_preference_id,x_return_status,x_msg_count,x_msg_data);
39:
40: -- Output the results
41: /*dbms_output.put_line('x_contact_preference_id = '||TO_CHAR(x_contact_preference_id));
42: dbms_output.put_line(SubStr('x_return_status = '||x_return_status,1,255));

Line 59: p_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2)
58: IS
59: p_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
60: BEGIN
61: p_contact_preference_rec.contact_preference_id := p_contact_preference_id;
62: p_contact_preference_rec.preference_code := p_preference_code;
63: p_object_version_number := p_object_version_number;

Line 66: hz_contact_preference_v2pub.update_contact_preference(FND_API.G_TRUE,p_contact_preference_rec,p_object_version_number,x_return_status,x_msg_count,x_msg_data);

62: p_contact_preference_rec.preference_code := p_preference_code;
63: p_object_version_number := p_object_version_number;
64:
65: -- Now call the stored program
66: hz_contact_preference_v2pub.update_contact_preference(FND_API.G_TRUE,p_contact_preference_rec,p_object_version_number,x_return_status,x_msg_count,x_msg_data);
67:
68: -- Output the results
69: /*dbms_output.put_line('p_object_version_number = '||TO_CHAR(p_object_version_number));
70: dbms_output.put_line(SubStr('x_return_status = '||x_return_status,1,255));