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 2660: FROM hz_class_code_relations

2656: x_class_code_rel_rec.class_code,
2657: x_class_code_rel_rec.sub_class_code,
2658: x_class_code_rel_rec.start_date_active,
2659: x_class_code_rel_rec.end_date_active
2660: FROM hz_class_code_relations
2661: WHERE
2662: class_category = p_class_code_rel_rec.class_category AND
2663: class_code = p_class_code_rel_rec.class_code AND
2664: sub_class_code = p_class_code_rel_rec.sub_class_code AND

Line 2992: * HZ_CLASS_CODE_RELATIONS_PKG.Select_Row

2988: * DESCRIPTION
2989: * Gets class code relation record.
2990: *
2991: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2992: * HZ_CLASS_CODE_RELATIONS_PKG.Select_Row
2993: *
2994: * ARGUMENTS
2995: * IN:
2996: * p_init_msg_list Initialize message stack if it is set to

Line 3080: HZ_CLASS_CODE_RELATIONS_PKG.Select_Row (

3076: x_class_code_relation_rec.class_code := p_class_code;
3077: x_class_code_relation_rec.sub_class_code := p_sub_class_code;
3078: x_class_code_relation_rec.start_date_active := p_start_date_active;
3079:
3080: HZ_CLASS_CODE_RELATIONS_PKG.Select_Row (
3081: X_CLASS_CATEGORY => x_class_code_relation_rec.class_category,
3082: X_CLASS_CODE => x_class_code_relation_rec.class_code,
3083: X_SUB_CLASS_CODE => x_class_code_relation_rec.sub_class_code,
3084: X_START_DATE_ACTIVE => x_class_code_relation_rec.start_date_active,

Line 3898: FROM HZ_CLASS_CODE_RELATIONS

3894: SELECT CLASS_CODE,
3895: SUB_CLASS_CODE,
3896: START_DATE_ACTIVE,
3897: END_DATE_ACTIVE
3898: FROM HZ_CLASS_CODE_RELATIONS
3899: WHERE CLASS_CATEGORY = p_class_category;
3900:
3901:
3902: BEGIN