APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_EMPLOYMENT_HISTORY

Line 964: FROM HZ_EMPLOYMENT_HISTORY

960: p_employment_history_rec.employment_history_id <> FND_API.G_MISS_NUM
961: THEN
962: BEGIN
963: SELECT 'Y' INTO l_dummy
964: FROM HZ_EMPLOYMENT_HISTORY
965: WHERE EMPLOYMENT_HISTORY_ID = p_employment_history_rec.employment_history_id;
966:
967: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
968: FND_MESSAGE.SET_TOKEN('COLUMN', 'employment_history_id');

Line 990: HZ_EMPLOYMENT_HISTORY_PKG.Insert_Row (

986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988:
989: -- call table handler to insert a row
990: HZ_EMPLOYMENT_HISTORY_PKG.Insert_Row (
991:
992: x_EMPLOYMENT_HISTORY_ID => p_employment_history_rec.employment_history_id,
993: x_BEGIN_DATE => p_employment_history_rec.begin_date,
994: x_PARTY_ID => p_employment_history_rec.party_id,

Line 1072: FROM HZ_EMPLOYMENT_HISTORY

1068: BEGIN
1069: -- check object_version_number
1070: SELECT rowid, object_version_number, party_id
1071: INTO l_rowid, l_object_version_number, l_party_id
1072: FROM HZ_EMPLOYMENT_HISTORY
1073: WHERE employment_history_id = p_employment_history_rec.employment_history_id
1074: FOR UPDATE NOWAIT;
1075:
1076: IF NOT

Line 1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');

1083: )
1084: )
1085: THEN
1086: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_EMPLOYMENT_HISTORY');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:

Line 1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');

1093:
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1097: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_EMPLOYMENT_HISTORY');
1098: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_employment_history_rec.employment_history_id ), 'null' ) );
1099: FND_MSG_PUB.ADD;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END;

Line 1115: HZ_employment_history_PKG.Update_Row (

1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:
1114: -- call table handler to update a row
1115: HZ_employment_history_PKG.Update_Row (
1116:
1117: x_Rowid => l_rowid,
1118: x_EMPLOYMENT_HISTORY_ID => p_employment_history_rec.employment_history_id,
1119: x_BEGIN_DATE => p_employment_history_rec.begin_date,

Line 2714: HZ_POPULATE_BOT_PKG.pop_hz_employment_history(

2710: l_employment_history_rec );
2711: END IF;
2712:
2713: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2714: HZ_POPULATE_BOT_PKG.pop_hz_employment_history(
2715: p_operation => 'I',
2716: p_EMPLOYMENT_HISTORY_ID => x_employment_history_id);
2717: END IF;
2718: END IF;

Line 2842: HZ_POPULATE_BOT_PKG.pop_hz_employment_history(

2838: l_old_employment_history_rec );
2839: END IF;
2840:
2841: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2842: HZ_POPULATE_BOT_PKG.pop_hz_employment_history(
2843: p_operation => 'U',
2844: p_EMPLOYMENT_HISTORY_ID => l_employment_history_rec.employment_history_id);
2845: END IF;
2846: END IF;

Line 2891: * HZ_EMPLOYMENT_HISTORY_PKG.Select_Row

2887: * DESCRIPTION
2888: * Gets class employment_history record.
2889: *
2890: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2891: * HZ_EMPLOYMENT_HISTORY_PKG.Select_Row
2892: *
2893: * ARGUMENTS
2894: * IN:
2895: * p_init_msg_list Initialize message stack if it is set to

Line 2950: HZ_EMPLOYMENT_HISTORY_PKG.Select_Row (

2946:
2947: -- The x_employment_history_rec.employment_history_id must be initiated to p_employment_history_id
2948: x_employment_history_rec.employment_history_id := p_employment_history_id;
2949:
2950: HZ_EMPLOYMENT_HISTORY_PKG.Select_Row (
2951:
2952: X_EMPLOYMENT_HISTORY_ID => x_employment_history_rec.employment_history_id,
2953: X_BEGIN_DATE => x_employment_history_rec.begin_date,
2954: X_PARTY_ID => x_employment_history_rec.party_id,