APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_CITIZENSHIP

Line 561: FROM HZ_CITIZENSHIP

557: p_citizenship_rec.citizenship_id <> FND_API.G_MISS_NUM
558: THEN
559: BEGIN
560: SELECT 'Y' INTO l_dummy
561: FROM HZ_CITIZENSHIP
562: WHERE CITIZENSHIP_ID = p_citizenship_rec.citizenship_id;
563:
564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
565: FND_MESSAGE.SET_TOKEN('COLUMN', 'citizenship_id');

Line 587: HZ_CITIZENSHIP_PKG.INSERT_ROW(

583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585:
586: -- call table handler to insert a row
587: HZ_CITIZENSHIP_PKG.INSERT_ROW(
588: X_CITIZENSHIP_ID => p_citizenship_rec.citizenship_id,
589: X_BIRTH_OR_SELECTED => p_citizenship_rec.BIRTH_OR_SELECTED,
590: X_PARTY_ID => p_citizenship_rec.PARTY_ID,
591: X_COUNTRY_CODE => p_citizenship_rec.COUNTRY_CODE,

Line 654: FROM HZ_citizenship

650: BEGIN
651: -- check object_version_number
652: SELECT rowid, object_version_number, party_id
653: INTO l_rowid, l_object_version_number, l_party_id
654: FROM HZ_citizenship
655: WHERE citizenship_id = p_citizenship_rec.citizenship_id
656: FOR UPDATE NOWAIT;
657:
658: IF NOT

Line 669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');

665: )
666: )
667: THEN
668: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
669: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CITIZENSHIP');
670: FND_MSG_PUB.ADD;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:

Line 679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');

675:
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
679: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CITIZENSHIP');
680: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_citizenship_rec.citizenship_id ), 'null' ) );
681: FND_MSG_PUB.ADD;
682: RAISE FND_API.G_EXC_ERROR;
683: END;

Line 697: HZ_CITIZENSHIP_PKG.UPDATE_ROW(

693: RAISE FND_API.G_EXC_ERROR;
694: END IF;
695:
696: -- call table handler to update a row
697: HZ_CITIZENSHIP_PKG.UPDATE_ROW(
698: X_Rowid => l_rowid,
699: X_CITIZENSHIP_ID => p_citizenship_rec.CITIZENSHIP_ID,
700: X_BIRTH_OR_SELECTED => p_citizenship_rec.BIRTH_OR_SELECTED,
701: X_PARTY_ID => p_citizenship_rec.PARTY_ID,

Line 1989: HZ_POPULATE_BOT_PKG.pop_hz_citizenship(

1985: l_citizenship_rec );
1986: END IF;
1987:
1988: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1989: HZ_POPULATE_BOT_PKG.pop_hz_citizenship(
1990: p_operation => 'I',
1991: p_citizenship_id => x_citizenship_id);
1992: END IF;
1993: END IF;

Line 2119: HZ_POPULATE_BOT_PKG.pop_hz_citizenship(

2115: l_old_citizenship_rec );
2116: END IF;
2117:
2118: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2119: HZ_POPULATE_BOT_PKG.pop_hz_citizenship(
2120: p_operation => 'U',
2121: p_citizenship_id => l_citizenship_rec.citizenship_id);
2122: END IF;
2123: END IF;

Line 2168: * HZ_CITIZENSHIP_PKG.Select_Row

2164: * DESCRIPTION
2165: * Gets class citizenship record.
2166: *
2167: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2168: * HZ_CITIZENSHIP_PKG.Select_Row
2169: *
2170: * ARGUMENTS
2171: * IN:
2172: * p_init_msg_list Initialize message stack if it is set to

Line 2227: HZ_CITIZENSHIP_PKG.Select_Row (

2223:
2224: -- The x_citizenship_rec.citizenship_id must be initiated to x_citizenship_id
2225: x_citizenship_rec.citizenship_id := p_citizenship_id;
2226:
2227: HZ_CITIZENSHIP_PKG.Select_Row (
2228: X_CITIZENSHIP_ID => x_citizenship_rec.citizenship_id,
2229: X_BIRTH_OR_SELECTED => x_citizenship_rec.birth_or_selected,
2230: X_PARTY_ID => x_citizenship_rec.party_id,
2231: X_COUNTRY_CODE => x_citizenship_rec.country_code,