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

Line 1: PACKAGE BODY HZ_GEOGRAPHIES_PKG AS

1: PACKAGE BODY HZ_GEOGRAPHIES_PKG AS
2: /*$Header: ARHGEOTB.pls 120.1.12020000.2 2012/07/30 09:35:40 rgokavar ship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,

Line 76: INSERT INTO HZ_GEOGRAPHIES (

72:
73: --dbms_output.put_line.PUT_LINE('Before Insert');
74: WHILE l_success = 'N' LOOP
75: BEGIN
76: INSERT INTO HZ_GEOGRAPHIES (
77: geography_id,
78: object_version_number,
79: geography_type,
80: geography_name,

Line 149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,

145: attribute20
146: )
147: VALUES (
148: DECODE(x_geography_id,
149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,
150: NULL, HZ_GEOGRAPHIES_S.NEXTVAL,
151: x_geography_id),
152: DECODE(x_object_version_number,
153: FND_API.G_MISS_NUM, NULL,

Line 150: NULL, HZ_GEOGRAPHIES_S.NEXTVAL,

146: )
147: VALUES (
148: DECODE(x_geography_id,
149: FND_API.G_MISS_NUM, HZ_GEOGRAPHIES_S.NEXTVAL,
150: NULL, HZ_GEOGRAPHIES_S.NEXTVAL,
151: x_geography_id),
152: DECODE(x_object_version_number,
153: FND_API.G_MISS_NUM, NULL,
154: x_object_version_number),

Line 351: IF INSTR(SQLERRM, 'HZ_GEOGRAPHIES_S') <> 0 THEN

347: --dbms_output.put_line.PUT_LINE('l_success in after insert '||l_success);
348:
349: EXCEPTION
350: WHEN DUP_VAL_ON_INDEX THEN
351: IF INSTR(SQLERRM, 'HZ_GEOGRAPHIES_S') <> 0 THEN
352: DECLARE
353: l_count NUMBER;
354: l_dummy VARCHAR2(1);
355: BEGIN

Line 358: SELECT HZ_GEOGRAPHIES_S.NEXTVAL

354: l_dummy VARCHAR2(1);
355: BEGIN
356: l_count := 1;
357: WHILE l_count > 0 LOOP
358: SELECT HZ_GEOGRAPHIES_S.NEXTVAL
359: INTO x_geography_id FROM dual;
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM HZ_GEOGRAPHIES

Line 362: FROM HZ_GEOGRAPHIES

358: SELECT HZ_GEOGRAPHIES_S.NEXTVAL
359: INTO x_geography_id FROM dual;
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM HZ_GEOGRAPHIES
363: WHERE geography_id = x_geography_id;
364: l_count := 1;
365: EXCEPTION
366: WHEN NO_DATA_FOUND THEN

Line 444: UPDATE HZ_GEOGRAPHIES

440: x_attribute20 IN VARCHAR2
441: ) IS
442: BEGIN
443:
444: UPDATE HZ_GEOGRAPHIES
445: SET
446: geography_id =
447: DECODE(x_geography_id,
448: NULL, geography_id,

Line 837: SELECT * FROM hz_geographies

833: x_attribute20 IN VARCHAR2
834: ) IS
835:
836: CURSOR c IS
837: SELECT * FROM hz_geographies
838: WHERE rowid = x_rowid
839: FOR UPDATE NOWAIT;
840: Recinfo c%ROWTYPE;
841:

Line 1257: FROM HZ_GEOGRAPHIES

1253: x_attribute17,
1254: x_attribute18,
1255: x_attribute19,
1256: x_attribute20
1257: FROM HZ_GEOGRAPHIES
1258: WHERE geography_id = x_geography_id;
1259:
1260: EXCEPTION
1261: WHEN NO_DATA_FOUND THEN

Line 1275: DELETE FROM HZ_GEOGRAPHIES

1271: x_geography_id IN NUMBER
1272: ) IS
1273: BEGIN
1274:
1275: DELETE FROM HZ_GEOGRAPHIES
1276: WHERE geography_id = x_geography_id;
1277:
1278: IF ( SQL%NOTFOUND ) THEN
1279: RAISE NO_DATA_FOUND;

Line 1286: (ARHGEOEU) which will update the HZ_GEOGRAPHIES name/code value for updated identifier

1282: END Delete_Row;
1283:
1284: /*
1285: Procedure update_geo_element_cp is concurrent program 'Update Geography Element Columns'
1286: (ARHGEOEU) which will update the HZ_GEOGRAPHIES name/code value for updated identifier
1287: values (if primary flag is Y).
1288: Created By Nishant Singhai 25-Oct-2005 For Bug 4578867
1289: */
1290: PROCEDURE update_geo_element_cp (

Line 1310: FROM hz_geographies

1306: l_geo_element_id VARCHAR2(60);
1307:
1308: CURSOR c_get_geo_details (l_geo_id IN NUMBER) IS
1309: SELECT geography_name, geography_code, geography_type, country_code
1310: FROM hz_geographies
1311: WHERE geography_id = l_geo_id
1312: AND geography_use = 'MASTER_REF'
1313: ;
1314: BEGIN

Line 1353: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME' and 'CODE'

1349: l_geo_element_code := 'GEOGRAPHY_ELEMENT1_CODE';
1350: l_geo_element_id := 'GEOGRAPHY_ELEMENT1_ID';
1351: END IF;
1352:
1353: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME' and 'CODE'
1354: -- for this geography_id
1355:
1356: IF p_identifier_type = 'CODE' THEN
1357: UPDATE HZ_GEOGRAPHIES

Line 1357: UPDATE HZ_GEOGRAPHIES

1353: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME' and 'CODE'
1354: -- for this geography_id
1355:
1356: IF p_identifier_type = 'CODE' THEN
1357: UPDATE HZ_GEOGRAPHIES
1358: SET geography_code = l_identifier_value,
1359: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1360: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1361: WHERE geography_id = p_geography_id;

Line 1365: UPDATE HZ_GEOGRAPHIES

1361: WHERE geography_id = p_geography_id;
1362: END IF;
1363:
1364: IF p_identifier_type = 'NAME' THEN
1365: UPDATE HZ_GEOGRAPHIES
1366: SET geography_name = l_identifier_value,
1367: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1368: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1369: WHERE geography_id = p_geography_id;

Line 1372: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME'/'CODE' in all the rows

1368: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1369: WHERE geography_id = p_geography_id;
1370: END IF;
1371:
1372: -- denormalize the primary identifier in HZ_GEOGRAPHIES for identifier_type='NAME'/'CODE' in all the rows
1373: -- where this geography_id is de-normalized as a parent
1374:
1375: IF (p_identifier_type='NAME' AND l_geo_element_col IS NOT NULL)THEN
1376:

Line 1377: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||

1373: -- where this geography_id is de-normalized as a parent
1374:
1375: IF (p_identifier_type='NAME' AND l_geo_element_col IS NOT NULL)THEN
1376:
1377: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_col||'= :l_identifier_value '||
1378: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1379: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1380: ' WHERE country_code = :l_country_code and '||
1381: l_geo_element_id||'= :l_geography_id '

Line 1388: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_code||'= :l_identifier_value '||

1384: END IF;
1385:
1386: IF p_identifier_type='CODE' THEN
1387: IF l_geo_element_col IN ('GEOGRAPHY_ELEMENT1','GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5') THEN
1388: EXECUTE IMMEDIATE 'UPDATE HZ_GEOGRAPHIES SET '||l_geo_element_code||'= :l_identifier_value '||
1389: ', last_updated_by = hz_utility_pub.LAST_UPDATED_BY '||
1390: ', last_update_date = hz_utility_pub.LAST_UPDATE_DATE '||
1391: ' WHERE country_code = :l_country_code and '||
1392: l_geo_element_id||'= :l_geography_id '

Line 1408: END HZ_GEOGRAPHIES_PKG;

1404: retcode := '2'; -- Error
1405: errbuf := SQLERRM;
1406: END update_geo_element_cp;
1407:
1408: END HZ_GEOGRAPHIES_PKG;