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 2331: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec

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

Line 3164: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3160: IF (x_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL AND x_map_dtls_tbl(i).LOC_COMPVAL IS NOT NULL) THEN
3161: BEGIN
3162: SELECT g.GEOGRAPHY_ID
3163: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3164: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3165: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3166: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3167: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3168: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3167: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3163: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3164: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3165: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3166: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3167: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3168: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3169: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3170: AND hn.PARENT_ID = l_parent_geography_id
3171: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type

Line 3169: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3165: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3166: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3167: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3168: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3169: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3170: AND hn.PARENT_ID = l_parent_geography_id
3171: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3172: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3173: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3235: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3231: IF l_child_geography_id IS NOT NULL THEN
3232: BEGIN
3233: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3234: INTO l_geography_id,l_geography_name
3235: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3236: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3237: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3238: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3239: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3238: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3234: INTO l_geography_id,l_geography_name
3235: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3236: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3237: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3238: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3239: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3240: AND hn.level_number = 1
3241: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3242: AND hn.CHILD_ID = l_child_geography_id

Line 3241: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3237: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3238: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3239: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3240: AND hn.level_number = 1
3241: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3242: AND hn.CHILD_ID = l_child_geography_id
3243: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3244: AND SYSDATE between hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3245: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE;

Line 3263: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3259: IF l_child_geography_id IS NOT NULL THEN
3260: BEGIN
3261: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3262: INTO l_geography_id,l_geography_name
3263: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3264: -- Nishant
3265: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3266: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3267: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE

Line 3268: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3264: -- Nishant
3265: --WHERE g.GEOGRAPHY_ID = hn.PARENT_ID
3266: WHERE g.GEOGRAPHY_ID = hn.PARENT_ID+0
3267: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3268: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3269: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3270: AND hn.level_number = 1
3271: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3272: AND hn.CHILD_ID = l_child_geography_id

Line 3271: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3267: AND g.GEOGRAPHY_TYPE = hn.PARENT_OBJECT_TYPE
3268: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3269: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3270: AND hn.level_number = 1
3271: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3272: AND hn.CHILD_ID = l_child_geography_id
3273: AND hn.CHILD_OBJECT_TYPE = l_child_geography_type
3274: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3275: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3300: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn

3296: ELSE -- Loc compoent value is not null and child_geo_id is null
3297: BEGIN
3298: SELECT g.GEOGRAPHY_ID,g.GEOGRAPHY_NAME
3299: INTO l_geography_id,l_geography_name
3300: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3301: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3302: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3303: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3304: AND hn.HIERARCHY_TYPE = 'MASTER_REF'

Line 3303: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3299: INTO l_geography_id,l_geography_name
3300: FROM HZ_GEOGRAPHIES g,HZ_HIERARCHY_NODES hn
3301: WHERE g.GEOGRAPHY_ID = hn.CHILD_ID
3302: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3303: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3304: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3305: AND hn.level_number = x_map_dtls_tbl(p_iteration).LOC_SEQ_NUM - 1
3306: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3307: AND hn.PARENT_ID+0 = p_country_geo_id

Line 3306: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3302: AND g.GEOGRAPHY_TYPE = hn.CHILD_OBJECT_TYPE
3303: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3304: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3305: AND hn.level_number = x_map_dtls_tbl(p_iteration).LOC_SEQ_NUM - 1
3306: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3307: AND hn.PARENT_ID+0 = p_country_geo_id
3308: AND hn.PARENT_OBJECT_TYPE = l_country_geo_type
3309: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE
3310: AND SYSDATE BETWEEN g.START_DATE AND g.END_DATE

Line 3391: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'

3387: SELECT hn.CHILD_ID
3388: INTO x_map_dtls_tbl(i).GEOGRAPHY_ID
3389: FROM HZ_HIERARCHY_NODES hn
3390: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3391: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3392: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3393: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3394: AND hn.PARENT_ID = l_parent_geography_id
3395: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type

Line 3393: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'

3389: FROM HZ_HIERARCHY_NODES hn
3390: WHERE hn.CHILD_OBJECT_TYPE = x_map_dtls_tbl(i).GEOGRAPHY_TYPE
3391: AND hn.CHILD_TABLE_NAME = 'HZ_GEOGRAPHIES'
3392: AND hn.HIERARCHY_TYPE = 'MASTER_REF'
3393: AND hn.PARENT_TABLE_NAME = 'HZ_GEOGRAPHIES'
3394: AND hn.PARENT_ID = l_parent_geography_id
3395: AND hn.PARENT_OBJECT_TYPE = l_parent_geography_type
3396: AND SYSDATE BETWEEN hn.EFFECTIVE_START_DATE AND hn.EFFECTIVE_END_DATE;
3397: EXCEPTION WHEN OTHERS THEN