APPS.HZ_PARTY_CERT_PKG dependencies on HZ_PARTIES

Line 5: -- THIS API WAS CREATED TO UPDATE THE NEWLY CREATED COLUMN CERTIFICATION_LEVEL IN HZ_PARTIES

1: PACKAGE BODY HZ_PARTY_CERT_PKG AS
2: /* $Header: ARHCERTB.pls 120.14 2005/10/30 04:17:45 appldev noship $ */
3:
4: -- AUTHOR : CVIJAYAN ("VJN")
5: -- THIS API WAS CREATED TO UPDATE THE NEWLY CREATED COLUMN CERTIFICATION_LEVEL IN HZ_PARTIES
6: -- BASE BUG -- 3125139
7:
8:
9:

Line 14: * Sets the value of the newly added certification level flag in HZ_PARTIES .

10: /**
11: * PROCEDURE set_certification_level
12: *
13: * DESCRIPTION
14: * Sets the value of the newly added certification level flag in HZ_PARTIES .
15: *
16: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
17: *
18: *

Line 47: from hz_parties

43: IS
44:
45: cursor get_party_type_csr is
46: select party_type
47: from hz_parties
48: where party_id = p_party_id;
49:
50: l_object_version_number NUMBER;
51: l_rowid ROWID;

Line 80: FROM HZ_PARTIES

76:
77: BEGIN
78: SELECT object_version_number, rowid , party_id
79: INTO l_object_version_number, l_rowid , l_party_id
80: FROM HZ_PARTIES
81: WHERE party_id = p_party_id
82: and party_type in ('ORGANIZATION','PERSON')
83: FOR UPDATE NOWAIT;
84: EXCEPTION

Line 98: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

94: IF NOT ((x_object_version_number is null and l_object_version_number is null)
95: OR (nvl(x_object_version_number,-1) = l_object_version_number))
96: THEN
97: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
98: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:

Line 160: p_db_object_name => 'HZ_PARTIES',

156: /* IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
157: l_test_security :=
158: hz_dss_util_pub.test_instance(
159: p_operation_code => 'UPDATE',
160: p_db_object_name => 'HZ_PARTIES',
161: p_instance_pk1_value => l_party_id,
162: p_user_name => fnd_global.user_name,
163: x_return_status => dss_return_status,
164: x_msg_count => dss_msg_count,

Line 175: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));

171: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
172:
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
174: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
175: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_ERROR;
178: end if;
179: END IF;

Line 183: UPDATE HZ_PARTIES SET

179: END IF;
180:
181: */
182: -- do the actual update
183: UPDATE HZ_PARTIES SET
184: CERTIFICATION_LEVEL = DECODE( p_cert_level, FND_API.G_MISS_CHAR, NULL, p_cert_level ),
185: CERT_REASON_CODE = DECODE( l_cert_reason_code, FND_API.G_MISS_CHAR, NULL, l_cert_reason_code ),
186: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
187: CREATION_DATE = CREATION_DATE,

Line 264: from hz_parties

260: x_msg_data OUT NOCOPY VARCHAR2
261: ) is
262: cursor get_party_type_csr is
263: select party_type
264: from hz_parties
265: where party_id = p_party_id;
266:
267: l_party_type varchar2(30);
268: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 290: p_db_object_name => 'HZ_PARTIES',

286: /* IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
287: l_test_security :=
288: hz_dss_util_pub.test_instance(
289: p_operation_code => 'UPDATE',
290: p_db_object_name => 'HZ_PARTIES',
291: p_instance_pk1_value => p_party_id,
292: p_user_name => fnd_global.user_name,
293: x_return_status => dss_return_status,
294: x_msg_count => dss_msg_count,

Line 305: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));

301: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
302:
303: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
304: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
305: hz_dss_util_pub.get_display_name('HZ_PARTIES', null));
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
308: end if;
309: END IF;

Line 360: UPDATE HZ_PARTIES SET

356: end if; -- internal_flag is not null
357:
358: if p_status is not null
359: then
360: UPDATE HZ_PARTIES SET
361: status = p_status,
362: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
363: CREATION_DATE = CREATION_DATE,
364: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,