APPS.HZ_CLASSIFICATION_V2PUB dependencies on HZ_CLASS_CODE_RELATIONS

Line 423: HZ_CLASS_CODE_RELATIONS_PKG.Insert_Row (

419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423: HZ_CLASS_CODE_RELATIONS_PKG.Insert_Row (
424: X_CLASS_CATEGORY => p_class_code_rel_rec.class_category,
425: X_CLASS_CODE => p_class_code_rel_rec.class_code,
426: X_SUB_CLASS_CODE => p_class_code_rel_rec.sub_class_code,
427: X_START_DATE_ACTIVE => p_class_code_rel_rec.start_date_active,

Line 480: FROM HZ_CLASS_CODE_RELATIONS

476: SELECT OBJECT_VERSION_NUMBER,
477: ROWID,END_DATE_ACTIVE
478: INTO l_object_version_number,
479: l_rowid,l_end_date_active
480: FROM HZ_CLASS_CODE_RELATIONS
481: WHERE CLASS_CATEGORY = p_class_code_rel_rec.class_category
482: AND CLASS_CODE = p_class_code_rel_rec.class_code
483: AND SUB_CLASS_CODE = p_class_code_rel_rec.sub_class_code
484: AND START_DATE_ACTIVE = p_class_code_rel_rec.START_DATE_ACTIVE

Line 491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');

487: IF NOT ((p_object_version_number is null and l_object_version_number is null)
488: OR (p_object_version_number = l_object_version_number))
489: THEN
490: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
491: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CLASS_CODE_RELATIONS');
492: FND_MSG_PUB.ADD;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:

Line 500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');

496: p_object_version_number := nvl(l_object_version_number, 1) + 1;
497:
498: EXCEPTION WHEN NO_DATA_FOUND THEN
499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
500: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CLASS_CODE_RELATIONS');
501: FND_MESSAGE.SET_TOKEN('VALUE', 'p_class_code_rel_rec.class_category');
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: END;

Line 523: HZ_CLASS_CODE_RELATIONS_PKG.Update_Row (

519: set_frozen_flag(p_class_code_rel_rec.class_category);
520: end if;
521:
522: -- call to table-handler.
523: HZ_CLASS_CODE_RELATIONS_PKG.Update_Row (
524: X_CLASS_CATEGORY => p_class_code_rel_rec.class_category,
525: X_CLASS_CODE => p_class_code_rel_rec.class_code,
526: X_SUB_CLASS_CODE => p_class_code_rel_rec.sub_class_code,
527: X_START_DATE_ACTIVE => p_class_code_rel_rec.start_date_active,

Line 2686: FROM hz_class_code_relations

2682: x_class_code_rel_rec.class_code,
2683: x_class_code_rel_rec.sub_class_code,
2684: x_class_code_rel_rec.start_date_active,
2685: x_class_code_rel_rec.end_date_active
2686: FROM hz_class_code_relations
2687: WHERE
2688: class_category = p_class_code_rel_rec.class_category AND
2689: class_code = p_class_code_rel_rec.class_code AND
2690: sub_class_code = p_class_code_rel_rec.sub_class_code AND

Line 3018: * HZ_CLASS_CODE_RELATIONS_PKG.Select_Row

3014: * DESCRIPTION
3015: * Gets class code relation record.
3016: *
3017: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
3018: * HZ_CLASS_CODE_RELATIONS_PKG.Select_Row
3019: *
3020: * ARGUMENTS
3021: * IN:
3022: * p_init_msg_list Initialize message stack if it is set to

Line 3106: HZ_CLASS_CODE_RELATIONS_PKG.Select_Row (

3102: x_class_code_relation_rec.class_code := p_class_code;
3103: x_class_code_relation_rec.sub_class_code := p_sub_class_code;
3104: x_class_code_relation_rec.start_date_active := p_start_date_active;
3105:
3106: HZ_CLASS_CODE_RELATIONS_PKG.Select_Row (
3107: X_CLASS_CATEGORY => x_class_code_relation_rec.class_category,
3108: X_CLASS_CODE => x_class_code_relation_rec.class_code,
3109: X_SUB_CLASS_CODE => x_class_code_relation_rec.sub_class_code,
3110: X_START_DATE_ACTIVE => x_class_code_relation_rec.start_date_active,

Line 3924: FROM HZ_CLASS_CODE_RELATIONS

3920: SELECT CLASS_CODE,
3921: SUB_CLASS_CODE,
3922: START_DATE_ACTIVE,
3923: END_DATE_ACTIVE
3924: FROM HZ_CLASS_CODE_RELATIONS
3925: WHERE CLASS_CATEGORY = p_class_category;
3926:
3927:
3928: BEGIN