APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_EDUCATION

Line 764: FROM HZ_EDUCATION

760: p_education_rec.education_id <> FND_API.G_MISS_NUM
761: THEN
762: BEGIN
763: SELECT 'Y' INTO l_dummy
764: FROM HZ_EDUCATION
765: WHERE EDUCATION_ID = p_education_rec.education_id;
766:
767: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'education_id');

Line 790: HZ_EDUCATION_PKG.Insert_Row (

786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: -- call table handler to insert a row
790: HZ_EDUCATION_PKG.Insert_Row (
791: x_EDUCATION_ID => p_education_rec.education_id,
792: x_COURSE_MAJOR => p_education_rec.course_major,
793: x_PARTY_ID => p_education_rec.party_id,
794: x_SCHOOL_PARTY_ID => p_education_rec.school_party_id,

Line 856: FROM HZ_EDUCATION

852: BEGIN
853: -- check object_version_number
854: SELECT rowid, object_version_number, party_id
855: INTO l_rowid, l_object_version_number, l_party_id
856: FROM HZ_EDUCATION
857: WHERE education_id = p_education_rec.education_id
858: FOR UPDATE NOWAIT;
859:
860: IF NOT

Line 871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');

867: )
868: )
869: THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
871: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EDUCATION');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:

Line 881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');

877:
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
881: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EDUCATION');
882: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_education_rec.education_id ), 'null' ) );
883: FND_MSG_PUB.ADD;
884: RAISE FND_API.G_EXC_ERROR;
885: END;

Line 899: HZ_EDUCATION_PKG.Update_Row (

895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: -- call table handler to update a row
899: HZ_EDUCATION_PKG.Update_Row (
900: x_Rowid => l_rowid,
901: x_EDUCATION_ID => p_education_rec.education_id,
902: x_COURSE_MAJOR => p_education_rec.course_major,
903: x_PARTY_ID => p_education_rec.party_id,

Line 2352: HZ_POPULATE_BOT_PKG.pop_hz_education(

2348: l_education_rec );
2349: END IF;
2350:
2351: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2352: HZ_POPULATE_BOT_PKG.pop_hz_education(
2353: p_operation => 'I',
2354: p_EDUCATION_ID => x_education_id);
2355: END IF;
2356: END IF;

Line 2481: HZ_POPULATE_BOT_PKG.pop_hz_education(

2477: l_old_education_rec );
2478: END IF;
2479:
2480: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2481: HZ_POPULATE_BOT_PKG.pop_hz_education(
2482: p_operation => 'U',
2483: p_EDUCATION_ID => l_education_rec.education_id);
2484: END IF;
2485: END IF;

Line 2530: * HZ_EDUCATION_PKG.Select_Row

2526: * DESCRIPTION
2527: * Gets class education record.
2528: *
2529: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2530: * HZ_EDUCATION_PKG.Select_Row
2531: *
2532: * ARGUMENTS
2533: * IN:
2534: * p_init_msg_list Initialize message stack if it is set to

Line 2591: HZ_EDUCATION_PKG.Select_Row (

2587: -- The x_education_rec.education_id must be initiated to p_education_id
2588: x_education_rec.education_id := p_education_id;
2589:
2590:
2591: HZ_EDUCATION_PKG.Select_Row (
2592: X_EDUCATION_ID => x_education_rec.education_id,
2593: X_PARTY_ID => x_education_rec.party_id,
2594: X_COURSE_MAJOR => x_education_rec.course_major,
2595: X_DEGREE_RECEIVED => x_education_rec.degree_received,