APPS.HZ_PERSON_INFO_V2PUB dependencies on HZ_WORK_CLASS

Line 1194: FROM HZ_WORK_CLASS

1190: p_work_class_rec.work_class_id <> FND_API.G_MISS_NUM
1191: THEN
1192: BEGIN
1193: SELECT 'Y' INTO l_dummy
1194: FROM HZ_WORK_CLASS
1195: WHERE WORK_CLASS_ID = p_work_class_rec.work_class_id;
1196:
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1198: FND_MESSAGE.SET_TOKEN('COLUMN', 'work_class_id');

Line 1221: HZ_WORK_CLASS_PKG.Insert_Row (

1217: END IF;
1218:
1219: -- call table handler to insert a row
1220:
1221: HZ_WORK_CLASS_PKG.Insert_Row (
1222:
1223: x_WORK_CLASS_ID => p_work_class_rec.work_class_id,
1224: x_LEVEL_OF_EXPERIENCE => p_work_class_rec.LEVEL_OF_EXPERIENCE,
1225: x_WORK_CLASS_NAME => p_work_class_rec.WORK_CLASS_NAME,

Line 1285: FROM HZ_WORK_CLASS

1281: BEGIN
1282: -- check object_version_number
1283: SELECT rowid, object_version_number
1284: INTO l_rowid, l_object_version_number
1285: FROM HZ_WORK_CLASS
1286: WHERE work_class_id = p_work_class_rec.work_class_id
1287: FOR UPDATE NOWAIT;
1288:
1289: IF NOT

Line 1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');

1296: )
1297: )
1298: THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1300: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_WORK_CLASS');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:

Line 1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');

1306:
1307: EXCEPTION
1308: WHEN NO_DATA_FOUND THEN
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1310: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_WORK_CLASS');
1311: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_work_class_rec.work_class_id ), 'null' ) );
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END;

Line 1328: HZ_WORK_CLASS_PKG.Update_Row (

1324: RAISE FND_API.G_EXC_ERROR;
1325: END IF;
1326:
1327: -- call table handler to update a row
1328: HZ_WORK_CLASS_PKG.Update_Row (
1329:
1330: x_Rowid => l_rowid,
1331: x_WORK_CLASS_ID => p_work_class_rec.work_class_id,
1332: x_LEVEL_OF_EXPERIENCE => p_work_class_rec.LEVEL_OF_EXPERIENCE,

Line 3086: HZ_POPULATE_BOT_PKG.pop_hz_work_class(

3082: l_work_class_rec );
3083: END IF;
3084:
3085: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3086: HZ_POPULATE_BOT_PKG.pop_hz_work_class(
3087: p_operation => 'I',
3088: p_work_class_id => x_work_class_id);
3089: END IF;
3090: END IF;

Line 3214: HZ_POPULATE_BOT_PKG.pop_hz_work_class(

3210: l_old_work_class_rec );
3211: END IF;
3212:
3213: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3214: HZ_POPULATE_BOT_PKG.pop_hz_work_class(
3215: p_operation => 'U',
3216: p_work_class_id => l_work_class_rec.work_class_id);
3217: END IF;
3218: END IF;

Line 3263: * HZ_WORK_CLASS_PKG.Select_Row

3259: * DESCRIPTION
3260: * Gets class work_class record.
3261: *
3262: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3263: * HZ_WORK_CLASS_PKG.Select_Row
3264: *
3265: * ARGUMENTS
3266: * IN:
3267: * p_init_msg_list Initialize message stack if it is set to

Line 3322: HZ_WORK_CLASS_PKG.Select_Row (

3318:
3319: -- The x_work_class_rec.work_class_id must be initiated to p_work_class_id
3320: x_work_class_rec.work_class_id := p_work_class_id;
3321:
3322: HZ_WORK_CLASS_PKG.Select_Row (
3323:
3324: x_work_class_id => x_work_class_rec.work_class_id,
3325: x_level_of_experience => x_work_class_rec.level_of_experience,
3326: x_work_class_name => x_work_class_rec.work_class_name,