APPS.CAC_SYNC_CONTACT_MAPPINGS_PVT dependencies on CAC_SYNC_CONTACT_MAPPINGS

Line 1: PACKAGE BODY CAC_SYNC_CONTACT_MAPPINGS_PVT AS

1: PACKAGE BODY CAC_SYNC_CONTACT_MAPPINGS_PVT AS
2: /* $Header: cacvscvb.pls 120.1 2005/07/02 02:20:59 appldev noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CAC_SYNC_CONTACT_MAPPINGS_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'CAC_SYNC_CONTACT_MAPPINGS_PVT';

1: PACKAGE BODY CAC_SYNC_CONTACT_MAPPINGS_PVT AS
2: /* $Header: cacvscvb.pls 120.1 2005/07/02 02:20:59 appldev noship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CAC_SYNC_CONTACT_MAPPINGS_PVT';
5:
6: PROCEDURE CREATE_CONTACT_MAPPING
7: ( p_api_version IN NUMBER
8: , p_init_msg_list IN VARCHAR2

Line 43: FROM cac_sync_contact_mappings

39: , fax_contact_point_id
40: , cell_contact_point_id
41: , pager_contact_point_id
42: , email_contact_point_id
43: FROM cac_sync_contact_mappings
44: WHERE contact_party_id = p_contact_party_id;
45:
46: rec_mapping c_mapping%ROWTYPE;
47: BEGIN

Line 104: SELECT cac_sync_contact_mappings_s.nextval

100: CLOSE c_mapping;
101:
102: IF p_sync_contact_mapping_id IS NULL
103: THEN
104: SELECT cac_sync_contact_mappings_s.nextval
105: INTO x_sync_contact_mapping_id
106: FROM DUAL;
107: ELSE
108: x_sync_contact_mapping_id := p_sync_contact_mapping_id;

Line 111: cac_sync_contact_mappings_pkg.insert_row

107: ELSE
108: x_sync_contact_mapping_id := p_sync_contact_mapping_id;
109: END IF;
110:
111: cac_sync_contact_mappings_pkg.insert_row
112: ( x_rowid => l_rowid
113: , x_sync_contact_mapping_id => p_sync_contact_mapping_id
114: , x_contact_party_id => p_contact_party_id
115: , x_org_party_id => p_org_party_id

Line 186: FROM cac_sync_contact_mappings

182: l_api_name CONSTANT VARCHAR2(30) := 'UDPATE_CONTACT_MAPPING';
183:
184: CURSOR c_mapping IS
185: SELECT NULL
186: FROM cac_sync_contact_mappings
187: WHERE sync_contact_mapping_id = p_sync_contact_mapping_id;
188:
189: rec_mapping c_mapping%ROWTYPE;
190: BEGIN

Line 218: cac_sync_contact_mappings_pkg.update_row

214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216: CLOSE c_mapping;
217:
218: cac_sync_contact_mappings_pkg.update_row
219: ( x_sync_contact_mapping_id => p_sync_contact_mapping_id
220: , x_contact_party_id => p_contact_party_id
221: , x_org_party_id => p_org_party_id
222: , x_person_party_id => p_person_party_id

Line 290: cac_sync_contact_mappings_pkg.delete_row

286: THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: cac_sync_contact_mappings_pkg.delete_row
291: (x_sync_contact_mapping_id => p_sync_contact_mapping_id);
292:
293: IF fnd_api.to_boolean(p_commit)
294: THEN

Line 316: END CAC_SYNC_CONTACT_MAPPINGS_PVT;

312: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
313: END DELETE_CONTACT_MAPPING;
314:
315:
316: END CAC_SYNC_CONTACT_MAPPINGS_PVT;