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_GNR_UTIL_PKG dependencies on HZ_GEOGRAPHIES

Line 1462: l_from := ' FROM HZ_GEOGRAPHIES g ';

1458: END IF;
1459:
1460: l_select := 'SELECT g.GEOGRAPHY_ID,g.MULTIPLE_PARENT_FLAG';
1461: l_select := l_select||',GEOGRAPHY_ELEMENT1_ID';
1462: l_from := ' FROM HZ_GEOGRAPHIES g ';
1463: l_where := ' WHERE g.GEOGRAPHY_USE = ''MASTER_REF''';
1464: l_where := l_where||' AND g.COUNTRY_CODE = :country_code';
1465: -- Added +0 in the below line to fix the performance bug # 4642581
1466: l_where := l_where||' AND g.GEOGRAPHY_ELEMENT1_ID+0 = :id1';

Line 1565: l_from := ' FROM HZ_GEOGRAPHIES g ';

1561: END IF;
1562:
1563: l_select := 'SELECT g.GEOGRAPHY_ID,g.MULTIPLE_PARENT_FLAG';
1564: l_select := l_select||',GEOGRAPHY_ELEMENT1_ID';
1565: l_from := ' FROM HZ_GEOGRAPHIES g ';
1566: l_where := ' WHERE g.GEOGRAPHY_USE = ''MASTER_REF''';
1567: l_where := l_where||' AND g.COUNTRY_CODE = :country_code';
1568: -- Added +0 in the below line to fix the performance bug # 4642581
1569: l_where := l_where||' AND g.GEOGRAPHY_ELEMENT1_ID+0 = :id1';

Line 2070: FROM HZ_GEOGRAPHIES

2066: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NOT NULL) THEN
2067: -- IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NOT NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NULL) THEN
2068: SELECT GEOGRAPHY_NAME, GEOGRAPHY_CODE
2069: INTO x_map_dtls_tbl(i).LOC_COMPVAL, x_map_dtls_tbl(i).GEOGRAPHY_CODE
2070: FROM HZ_GEOGRAPHIES
2071: WHERE GEOGRAPHY_ID = x_map_dtls_tbl(i).GEOGRAPHY_ID;
2072: END IF;
2073: EXIT WHEN i = x_map_dtls_tbl.LAST;
2074: i := x_map_dtls_tbl.NEXT(i);

Line 2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec

2322: putLocCompValues(p_map_dtls_tbl,l_loc_components_rec);
2323:
2324: -- Fix for Bug 5231893. Added UPPER to make case insensitive comaprison. It does not make sense to update
2325: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case
2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

Line 3159: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3155: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NOT NULL) THEN
3156: BEGIN
3157: SELECT g.GEOGRAPHY_ID
3158: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3159: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3160: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3161: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3162: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3163: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3162: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3158: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3159: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3160: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3161: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3162: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3163: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3164: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3165: AND hn.PARENT_ID = l_parent_geography_id
3166: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type

Line 3164: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3160: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3161: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3162: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3163: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3164: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3165: AND hn.PARENT_ID = l_parent_geography_id
3166: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3167: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3168: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3230: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3226: IF l_child_geography_id IS NOT NULL THEN
3227: BEGIN
3228: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3229: INTO l_geography_id,l_geography_name
3230: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3231: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3232: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3233: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3234: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3233: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3229: INTO l_geography_id,l_geography_name
3230: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3231: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3232: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3233: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3234: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3235: AND hn.level_number = 1
3236: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3237: AND hn.CHILD_ID = l_child_geography_id

Line 3236: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3232: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3233: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3234: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3235: AND hn.level_number = 1
3236: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3237: AND hn.CHILD_ID = l_child_geography_id
3238: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3239: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3240: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE;

Line 3258: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3254: IF l_child_geography_id IS NOT NULL THEN
3255: BEGIN
3256: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3257: INTO l_geography_id,l_geography_name
3258: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3259: -- Nishant
3260: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3261: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3262: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE

Line 3263: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3259: -- Nishant
3260: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3261: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3262: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3263: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3264: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3265: AND hn.level_number = 1
3266: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3267: AND hn.CHILD_ID = l_child_geography_id

Line 3266: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3262: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3263: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3264: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3265: AND hn.level_number = 1
3266: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3267: AND hn.CHILD_ID = l_child_geography_id
3268: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3269: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3270: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3295: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3291: ELSE -- Loc compoent value is not null and child_geo_id is null
3292: BEGIN
3293: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3294: INTO l_geography_id,l_geography_name
3295: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3296: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3297: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3298: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3299: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3298: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3294: INTO l_geography_id,l_geography_name
3295: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3296: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3297: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3298: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3299: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3300: AND hn.level_number = x_map_dtls_tbl(p_iteration).LOC_SEQ_NUM - 1
3301: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3302: AND hn.PARENT_ID+0 = p_country_geo_id

Line 3301: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3297: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3298: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3299: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3300: AND hn.level_number = x_map_dtls_tbl(p_iteration).LOC_SEQ_NUM - 1
3301: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3302: AND hn.PARENT_ID+0 = p_country_geo_id
3303: AND hn.PARENT_OBJECT_TYPE = l_country_geo_type
3304: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3305: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3386: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3382: SELECT hn.CHILD_ID
3383: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3384: FROM HZ_HIERARCHY_NODES hn
3385: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3386: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3387: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3388: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3389: AND hn.PARENT_ID = l_parent_geography_id
3390: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type

Line 3388: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3384: FROM HZ_HIERARCHY_NODES hn
3385: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3386: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3387: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3388: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3389: AND hn.PARENT_ID = l_parent_geography_id
3390: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3391: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE;
3392: EXCEPTION WHEN OTHERS THEN