DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_BO_PVT dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 30: px_contact_pref_rec IN OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE

26: PROCEDURE assign_contact_pref_rec(
27: p_contact_pref_obj IN HZ_CONTACT_PREF_OBJ,
28: p_contact_level_table_id IN NUMBER,
29: p_contact_level_table IN VARCHAR2,
30: px_contact_pref_rec IN OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
31: );
32:
33: -- PROCEDURE create_contact_preferences
34: --

Line 70: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

66: x_msg_data OUT NOCOPY VARCHAR2
67: ) IS
68: l_debug_prefix VARCHAR2(30);
69: l_contact_pref_id NUMBER;
70: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
71: BEGIN
72: -- Standard start of API savepoint
73: SAVEPOINT create_contact_preferences_pvt;
74:

Line 94: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(

90: p_contact_level_table => p_contact_level_table,
91: px_contact_pref_rec => l_contact_pref_rec
92: );
93:
94: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
95: p_contact_preference_rec => l_contact_pref_rec,
96: x_contact_preference_id => l_contact_pref_id,
97: x_return_status => x_return_status,
98: x_msg_count => x_msg_count,

Line 259: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;

255: AND rownum = 1;
256:
257: l_debug_prefix VARCHAR2(30);
258: l_contact_pref_id NUMBER;
259: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
260: l_ovn NUMBER := NULL;
261: BEGIN
262: -- Standard start of API savepoint
263: SAVEPOINT save_contact_preferences_pvt;

Line 311: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(

307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309:
310: IF(l_ovn IS NULL) THEN
311: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
312: p_contact_preference_rec => l_contact_pref_rec,
313: x_contact_preference_id => l_contact_pref_id,
314: x_return_status => x_return_status,
315: x_msg_count => x_msg_count,

Line 324: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(

320: p_cp_pref_objs(i).contact_preference_id := l_contact_pref_id;
321: ELSE
322: -- clean up created_by_module during update
323: l_contact_pref_rec.created_by_module := NULL;
324: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
325: p_contact_preference_rec => l_contact_pref_rec,
326: p_object_version_number => l_ovn,
327: x_return_status => x_return_status,
328: x_msg_count => x_msg_count,

Line 465: px_contact_pref_rec IN OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE

461: PROCEDURE assign_contact_pref_rec(
462: p_contact_pref_obj IN HZ_CONTACT_PREF_OBJ,
463: p_contact_level_table_id IN NUMBER,
464: p_contact_level_table IN VARCHAR2,
465: px_contact_pref_rec IN OUT NOCOPY HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
466: ) IS
467: BEGIN
468: px_contact_pref_rec.contact_preference_id := p_contact_pref_obj.contact_preference_id;
469: px_contact_pref_rec.contact_level_table := p_contact_level_table;