APPS.CAC_SYNC_CONTACT_MAPPINGS_PKG dependencies on CAC_SYNC_CONTACT_MAPPINGS

Line 1: PACKAGE BODY CAC_SYNC_CONTACT_MAPPINGS_PKG AS

1: PACKAGE BODY CAC_SYNC_CONTACT_MAPPINGS_PKG AS
2: /* $Header: cacvscmb.pls 120.1 2005/07/02 02:20:21 appldev noship $ */
3:
4: PROCEDURE INSERT_ROW
5: ( x_rowid IN OUT NOCOPY VARCHAR2

Line 26: FROM cac_sync_contact_mappings

22: )
23: IS
24: CURSOR c_rowid IS
25: SELECT ROWID
26: FROM cac_sync_contact_mappings
27: WHERE sync_contact_mapping_id = x_sync_contact_mapping_id;
28: BEGIN
29: INSERT INTO cac_sync_contact_mappings
30: (sync_contact_mapping_id

Line 29: INSERT INTO cac_sync_contact_mappings

25: SELECT ROWID
26: FROM cac_sync_contact_mappings
27: WHERE sync_contact_mapping_id = x_sync_contact_mapping_id;
28: BEGIN
29: INSERT INTO cac_sync_contact_mappings
30: (sync_contact_mapping_id
31: ,contact_party_id
32: ,org_party_id
33: ,person_party_id

Line 95: UPDATE cac_sync_contact_mappings

91: , x_last_update_login IN NUMBER
92: )
93: IS
94: BEGIN
95: UPDATE cac_sync_contact_mappings
96: SET contact_party_id = x_contact_party_id
97: , org_party_id = x_org_party_id
98: , person_party_id = x_person_party_id
99: , party_site_id = x_party_site_id

Line 121: DELETE cac_sync_contact_mappings

117: PROCEDURE DELETE_ROW(x_sync_contact_mapping_id IN NUMBER)
118: IS
119: BEGIN
120:
121: DELETE cac_sync_contact_mappings
122: WHERE sync_contact_mapping_id = x_sync_contact_mapping_id;
123:
124: IF SQL%NOTFOUND THEN
125: RAISE NO_DATA_FOUND;

Line 130: end CAC_SYNC_CONTACT_MAPPINGS_PKG;

126: END IF;
127:
128: END DELETE_ROW;
129:
130: end CAC_SYNC_CONTACT_MAPPINGS_PKG;