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 831: -- and null out NOCOPY address components in hz_parties

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

Line 1381: | Denormalize identifying address to hz_parties

1377: | PROCEDURE
1378: | do_update_address
1379: |
1380: | DESCRIPTION
1381: | Denormalize identifying address to hz_parties
1382: |
1383: | SCOPE - PRIVATE
1384: |
1385: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1399: | denormalizing address into hz_parties.

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

Line 1413: FROM hz_parties

1409: WHERE location_id = p_location_id;
1410:
1411: CURSOR c_party IS
1412: SELECT 'Y'
1413: FROM hz_parties
1414: WHERE party_id = p_party_id
1415: FOR UPDATE NOWAIT;
1416:
1417: l_location_rec c_loc%ROWTYPE;

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

1426: CLOSE c_party;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1431: FND_MSG_PUB.ADD;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END;
1434:

Line 1436: -- components in hz_parties.

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

Line 1468: UPDATE hz_parties

1464: -- address. Therefore, commenting out NOCOPY the below 'IF' condition.
1465:
1466: -- IF l_location_rec.content_source_type = 'USER_ENTERED' THEN
1467:
1468: UPDATE hz_parties
1469: SET country = l_location_rec.country,
1470: address1 = l_location_rec.address1,
1471: address2 = l_location_rec.address2,
1472: address3 = l_location_rec.address3,