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_VALIDATE_V2PUB

Line 1: PACKAGE BODY HZ_CLASS_VALIDATE_V2PUB AS

1: PACKAGE BODY HZ_CLASS_VALIDATE_V2PUB AS
2: /*$Header: ARH2CLVB.pls 120.57.12000000.2 2007/10/01 14:48:20 manjayar ship $ */
3:
4:
5: /*---------------------

Line 1670: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1666: AND owner_table_id = p_owner_table_id
1667: AND class_category = p_class_category
1668: AND actual_content_source = p_content_source_type
1669: AND primary_flag = 'Y'
1670: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1671: p_start_date_active, p_end_date_active) = 'Y';
1672: cursor c_update
1673: is
1674: SELECT class_code,

Line 1684: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1680: AND class_category = p_class_category
1681: AND actual_content_source = p_content_source_type
1682: AND primary_flag = 'Y'
1683: AND start_date_active <> p_start_date_active
1684: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1685: p_start_date_active, p_end_date_active) = 'Y';
1686: result varchar2(1);
1687: begin
1688: result := 'Y';

Line 1735: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1731: AND owner_table_id = p_owner_table_id
1732: AND class_category = p_class_category
1733: AND class_code = p_class_code
1734: AND actual_content_source = p_content_source_type
1735: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1736: p_start_date_active, p_end_date_active) = 'Y';
1737: cursor c_update
1738: is
1739: SELECT class_code,

Line 1749: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1745: AND class_category = p_class_category
1746: AND class_code = p_class_code
1747: AND actual_content_source = p_content_source_type
1748: AND start_date_active <> p_start_date_active
1749: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1750: p_start_date_active, p_end_date_active) = 'Y';
1751: result varchar2(1);
1752: begin
1753: result := 'Y';

Line 1801: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1797: AND class_category = p_class_category
1798: AND class_code = p_class_code
1799: AND actual_content_source = p_content_source_type
1800: AND primary_flag = 'N'
1801: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1802: p_start_date_active, p_end_date_active) = 'Y';
1803: cursor c_update
1804: is
1805: SELECT class_code,

Line 1816: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,

1812: AND class_code = p_class_code
1813: AND actual_content_source = p_content_source_type
1814: AND start_date_active <> p_start_date_active
1815: AND primary_flag = 'N'
1816: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_date_active,
1817: p_start_date_active, p_end_date_active) = 'Y';
1818: result varchar2(1);
1819: begin
1820: result := 'Y';

Line 3061: AND hz_class_validate_v2pub.is_overlap(start_date_active, end_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'
3063: AND ROWNUM = 1;
3064: result VARCHAR2(1);
3065: BEGIN

Line 3159: and (hz_class_validate_v2pub.is_overlap

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,
3161: start_date_active, end_date_active)= 'Y');
3162:
3163: ltab gen_list;

Line 3243: and (hz_class_validate_v2pub.is_overlap

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,
3245: start_date_active, end_date_active)= 'Y');
3246:
3247: ltab gen_list;

Line 3593: and hz_class_validate_v2pub.is_overlap(start_date_active , 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,
3594: p_start_date_active, p_end_date_active )= 'Y';
3595: cursor c_update
3596: is
3597: select start_date_active,

Line 3604: and hz_class_validate_v2pub.is_overlap(start_date_active , end_date_active,

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
3604: and hz_class_validate_v2pub.is_overlap(start_date_active , end_date_active,
3605: p_start_date_active, p_end_date_active ) = 'Y';
3606: result varchar2(1);
3607: begin
3608: if p_create_update_flag = 'C' then

Line 4044: END HZ_CLASS_VALIDATE_V2PUB;

4040:
4041: END chk_exist_clas_catgry_typ_mng;
4042:
4043:
4044: END HZ_CLASS_VALIDATE_V2PUB;