APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_PERSON_INTEREST

Line 1389: FROM HZ_person_interest

1385: p_person_interest_rec.person_interest_id <> FND_API.G_MISS_NUM
1386: THEN
1387: BEGIN
1388: SELECT 'Y' INTO l_dummy
1389: FROM HZ_person_interest
1390: WHERE person_interest_ID = p_person_interest_rec.person_interest_id;
1391:
1392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'person_interest_id');

Line 1415: HZ_person_interest_PKG.Insert_Row (

1411: RAISE FND_API.G_EXC_ERROR;
1412: END IF;
1413:
1414: -- call table handler to insert a row
1415: HZ_person_interest_PKG.Insert_Row (
1416:
1417: x_person_interest_ID => p_person_interest_rec.person_interest_id,
1418: x_LEVEL_OF_INTEREST => p_person_interest_rec.LEVEL_OF_INTEREST,
1419: x_PARTY_ID => p_person_interest_rec.PARTY_ID,

Line 1486: FROM HZ_person_interest

1482: BEGIN
1483: -- check object_version_number
1484: SELECT rowid, object_version_number
1485: INTO l_rowid, l_object_version_number
1486: FROM HZ_person_interest
1487: WHERE person_interest_id = p_person_interest_rec.person_interest_id
1488: FOR UPDATE NOWAIT;
1489:
1490: IF NOT

Line 1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');

1497: )
1498: )
1499: THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1501: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_person_interest');
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:

Line 1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');

1507:
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1511: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_person_interest');
1512: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_person_interest_rec.person_interest_id ), 'null' ) );
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END;

Line 1530: HZ_person_interest_PKG.Update_Row (

1526: RAISE FND_API.G_EXC_ERROR;
1527: END IF;
1528:
1529: -- call table handler to update a row
1530: HZ_person_interest_PKG.Update_Row (
1531:
1532: x_Rowid => l_rowid,
1533: x_person_interest_ID => p_person_interest_rec.person_interest_id,
1534: x_LEVEL_OF_INTEREST => p_person_interest_rec.LEVEL_OF_INTEREST,

Line 3440: HZ_POPULATE_BOT_PKG.pop_hz_person_interest(

3436: l_person_interest_rec );
3437: END IF;
3438:
3439: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3440: HZ_POPULATE_BOT_PKG.pop_hz_person_interest(
3441: p_operation => 'I',
3442: p_person_interest_id => x_person_interest_id);
3443: END IF;
3444: END IF;

Line 3568: HZ_POPULATE_BOT_PKG.pop_hz_person_interest(

3564: l_old_person_interest_rec );
3565: END IF;
3566:
3567: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3568: HZ_POPULATE_BOT_PKG.pop_hz_person_interest(
3569: p_operation => 'U',
3570: p_person_interest_id => l_person_interest_rec.person_interest_id);
3571: END IF;
3572: END IF;

Line 3617: * HZ_PERSON_INTEREST_PKG.Select_Row

3613: * DESCRIPTION
3614: * Gets class person_interest record.
3615: *
3616: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3617: * HZ_PERSON_INTEREST_PKG.Select_Row
3618: *
3619: * ARGUMENTS
3620: * IN:
3621: * p_init_msg_list Initialize message stack if it is set to

Line 3676: HZ_PERSON_INTEREST_PKG.Select_Row (

3672:
3673: -- The x_person_interest_rec.person_interest_id must be initiated to p_person_interest_id
3674: x_person_interest_rec.person_interest_id := p_person_interest_id;
3675:
3676: HZ_PERSON_INTEREST_PKG.Select_Row (
3677:
3678: x_person_interest_id => x_person_interest_rec.person_interest_id,
3679: x_level_of_interest => x_person_interest_rec.level_of_interest,
3680: x_party_id => x_person_interest_rec.party_id,