APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_PARTIES

Line 231: l_country_code hz_parties.country%type;--4742586

227: l_loc_actual_content_source hz_locations.actual_content_source%TYPE;
228: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
229: l_msg_count NUMBER;
230: l_msg_data VARCHAR2(2000);
231: l_country_code hz_parties.country%type;--4742586
232:
233: BEGIN
234:
235: -- Debug info.

Line 827: -- and null out NOCOPY address components in hz_parties

823: -- no active sites present.
824:
825: -- Make the current site as Inactive.
826: -- Bug 2306201: reset primary flag to 'N'
827: -- and null out NOCOPY address components in hz_parties
828:
829: IF p_party_site_rec.status = 'I' THEN
830: l_identifying_location_id := null;
831: p_party_site_rec.identifying_address_flag := 'N';

Line 1377: | Denormalize identifying address to hz_parties

1373: | PROCEDURE
1374: | do_update_address
1375: |
1376: | DESCRIPTION
1377: | Denormalize identifying address to hz_parties
1378: |
1379: | SCOPE - PRIVATE
1380: |
1381: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1395: | denormalizing address into hz_parties.

1391: | NOTES
1392: |
1393: | MODIFICATION HISTORY
1394: | 13-APR-2003 P.Suresh o Bug No 2820991. Populated the who columns when
1395: | denormalizing address into hz_parties.
1396: +===========================================================================*/
1397:
1398: PROCEDURE do_update_address(
1399: p_party_id IN NUMBER,

Line 1409: FROM hz_parties

1405: WHERE location_id = p_location_id;
1406:
1407: CURSOR c_party IS
1408: SELECT 'Y'
1409: FROM hz_parties
1410: WHERE party_id = p_party_id
1411: FOR UPDATE NOWAIT;
1412:
1413: l_location_rec c_loc%ROWTYPE;

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

1422: CLOSE c_party;
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1427: FND_MSG_PUB.ADD;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END;
1430:

Line 1432: -- components in hz_parties.

1428: RAISE FND_API.G_EXC_ERROR;
1429: END;
1430:
1431: -- if location_id is null, we will null out NOCOPY the location
1432: -- components in hz_parties.
1433:
1434: IF p_location_id IS NULL THEN
1435: l_location_rec.country := NULL;
1436: l_location_rec.address1 := NULL;

Line 1464: UPDATE hz_parties

1460: -- address. Therefore, commenting out NOCOPY the below 'IF' condition.
1461:
1462: -- IF l_location_rec.content_source_type = 'USER_ENTERED' THEN
1463:
1464: UPDATE hz_parties
1465: SET country = l_location_rec.country,
1466: address1 = l_location_rec.address1,
1467: address2 = l_location_rec.address2,
1468: address3 = l_location_rec.address3,