eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on HZ_CLASS_CODE_RELATIONS

Line 573: hz_class_code_relations b

569: CURSOR c1
570: IS
571: SELECT 'Y'
572: FROM hz_code_assignments a,
573: hz_class_code_relations b
574: WHERE a.class_category = p_class_category
575: AND b.class_category = p_class_category
576: AND a.class_code = b.class_code
577: AND (( a.start_date_active <= SYSDATE

Line 614: FROM hz_class_code_relations

610: CURSOR c0
611: IS
612: SELECT start_date_active,
613: end_date_active
614: FROM hz_class_code_relations
615: WHERE class_category = p_class_category
616: AND class_code = p_sub_class_code
617: AND sub_class_code = p_class_code
618: AND (( NVL(end_date_active , SYSDATE) >= SYSDATE

Line 659: FROM hz_class_code_relations

655: IS
656: SELECT sub_class_code,
657: start_date_active,
658: end_date_active
659: FROM hz_class_code_relations
660: WHERE class_category = p_class_category;
661: CURSOR c1(p_class_category VARCHAR2, p_sub_class_code VARCHAR2)
662: IS
663: SELECT class_code,

Line 666: FROM hz_class_code_relations

662: IS
663: SELECT class_code,
664: start_date_active,
665: end_date_active
666: FROM hz_class_code_relations
667: WHERE class_category = p_class_category
668: AND sub_class_code = p_sub_class_code;
669: sub_code_has_two_parents EXCEPTION;
670: l_class_code VARCHAR2(30);

Line 2519: from hz_class_code_relations c_rel

2515: /**
2516: BEGIN
2517: select decode(sign(count(*)-1),0,null,'Y')
2518: into allow_leaf_error
2519: from hz_class_code_relations c_rel
2520: , hz_class_categories c_cate
2521: where c_cate.class_category=c_rel.class_category and
2522: allow_leaf_node_only_flag = 'Y' and
2523: --owner_table_name = nvl(p_in_rec.owner_table_name, l_owner_table_name) AND

Line 2555: from hz_class_code_relations c_rel, hz_class_categories c_cate

2551:
2552: -- START validation
2553: Begin
2554: select 'Y' into allow_leaf_error
2555: from hz_class_code_relations c_rel, hz_class_categories c_cate
2556: where c_cate.class_category=c_rel.class_category and
2557: allow_leaf_node_only_flag = 'Y' and
2558: c_cate.class_category = nvl(p_in_rec.class_category, l_class_category) AND
2559: class_code = nvl(p_in_rec.class_code, l_class_code) AND

Line 3039: -- Validate Hz_Class_Code_Relations --

3035:
3036:
3037:
3038: /*---------------------------------------
3039: -- Validate Hz_Class_Code_Relations --
3040: ---------------------------------------*/
3041: FUNCTION child_code
3042: -- Return Y if the p_class_code in the p_class_category for that period has one or more parent
3043: -- N otherwise

Line 3058: FROM hz_class_code_relations

3054: IS
3055: SELECT class_code,
3056: start_date_active,
3057: end_date_active
3058: FROM hz_class_code_relations
3059: WHERE class_category = p_class_category
3060: AND sub_class_code = p_class_code
3061: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
3062: p_start_date_active, p_end_date_active)='Y'

Line 3095: FROM hz_class_code_relations

3091: IS
3092: SELECT start_date_active,
3093: end_date_active ,
3094: sub_class_code
3095: FROM hz_class_code_relations
3096: WHERE class_category = p_class_category
3097: AND class_code = p_class_code
3098: AND ( NVL(end_date_active, p_start_date_active) >= p_start_date_active
3099: OR start_date_active <= NVL(p_end_date_active, start_date_active) )

Line 3156: from hz_class_code_relations

3152: select class_code,
3153: sub_class_code,
3154: start_date_active,
3155: end_date_active
3156: from hz_class_code_relations
3157: where class_category = in_class_category
3158: and sub_class_code = l_class_code
3159: and (hz_class_validate_v2pub.is_overlap
3160: (in_date_start, in_date_end,

Line 3240: from hz_class_code_relations

3236: select class_code,
3237: sub_class_code,
3238: start_date_active,
3239: end_date_active
3240: from hz_class_code_relations
3241: where class_category = in_class_category
3242: and class_code = l_sub_class_code
3243: and (hz_class_validate_v2pub.is_overlap
3244: (in_date_start, in_date_end,

Line 3553: from hz_class_code_relations

3549: IS
3550: cursor c0
3551: IS
3552: select end_date_active
3553: from hz_class_code_relations
3554: where class_category = p_class_category
3555: and class_code = p_class_code
3556: and sub_class_code = p_sub_class_code
3557: and start_date_active = p_start_date_active

Line 3589: from hz_class_code_relations

3585: cursor c_create
3586: is
3587: select start_date_active,
3588: end_date_active
3589: from hz_class_code_relations
3590: where class_category = p_class_category
3591: and class_code = p_class_code
3592: and sub_class_code = p_sub_class_code
3593: and hz_class_validate_v2pub.is_overlap(start_date_active , end_date_active,

Line 3599: from hz_class_code_relations

3595: cursor c_update
3596: is
3597: select start_date_active,
3598: end_date_active
3599: from hz_class_code_relations
3600: where class_category = p_class_category
3601: and class_code = p_class_code
3602: and sub_class_code = p_sub_class_code
3603: and start_date_active <> p_start_date_active

Line 3638: l_created_by_module hz_class_code_relations.created_by_module%TYPE;

3634: ) IS
3635: l_end_date DATE := NULL;
3636: l_count NUMBER := 0;
3637: l_end VARCHAR2(12);
3638: l_created_by_module hz_class_code_relations.created_by_module%TYPE;
3639: --Bug 4897711
3640: la_start DATE := to_date(NULL);
3641: la_end DATE := to_date(NULL);
3642: CURSOR c_code_rel(

Line 3648: FROM hz_class_code_relations

3644: p_class_code VARCHAR2,
3645: p_sub_class_code VARCHAR2)
3646: IS
3647: SELECT created_by_module
3648: FROM hz_class_code_relations
3649: WHERE class_category = p_class_category
3650: AND class_code = p_class_code
3651: AND sub_class_code = p_sub_class_code;
3652: