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_GEN_PKG dependencies on HZ_GNR_UTIL_PKG

Line 6: G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;

2: /*$Header: ARHGNRGB.pls 120.32 2007/11/15 01:40:53 nsinghai ship $ */
3: --------------------------------------
4: -- declaration of private global varibles
5: --------------------------------------
6: G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
7: G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
8: G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
9: G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
10: g_pkgName VARCHAR2(30);

Line 7: G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

3: --------------------------------------
4: -- declaration of private global varibles
5: --------------------------------------
6: G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
7: G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
8: G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
9: G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
10: g_pkgName VARCHAR2(30);
11:

Line 8: G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;

4: -- declaration of private global varibles
5: --------------------------------------
6: G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
7: G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
8: G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
9: G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
10: g_pkgName VARCHAR2(30);
11:
12: g_indent CONSTANT VARCHAR2(2) := ' ';

Line 9: G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;

5: --------------------------------------
6: G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
7: G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
8: G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
9: G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
10: g_pkgName VARCHAR2(30);
11:
12: g_indent CONSTANT VARCHAR2(2) := ' ';
13: -- Hari 2 Lines

Line 318: PROCEDURE populate_mdu_tbl(p_usage_id in number,x_mdu_tbl OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS

314: *
315: *
316: */
317: --------------------------------------
318: PROCEDURE populate_mdu_tbl(p_usage_id in number,x_mdu_tbl OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE) IS
319: i number := 0;
320: FUNCTION exists_mapping(p_usage_id in number,p_geography_type in varchar2) return boolean IS
321: j NUMBER;
322: BEGIN

Line 379: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

375: x_status OUT NOCOPY VARCHAR2) IS
376:
377: i NUMBER := 0;
378: j NUMBER := 0;
379: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
380:
381:
382: BEGIN
383: -- initializing the retun value

Line 831: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

827: x_status OUT NOCOPY VARCHAR2) IS
828:
829: -- local variable declaration
830: l_procName varchar2(30);
831: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
832: l_usage_id number;
833: l_open_cur varchar2(2000);
834: l_fetch_cur varchar2(2000);
835: l_mdu_tbl_name varchar2(30);

Line 870: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

866: li(' l_sql VARCHAR2(9000);');
867: li(' l_status VARCHAR2(1);');
868: li(' l_geography_type VARCHAR2(30);');
869: li(' l_geography_id NUMBER;');
870: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
871: li(' LL_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
872: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE; -- not actually required here');
873: l(' ');
874: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');

Line 871: li(' LL_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

867: li(' l_status VARCHAR2(1);');
868: li(' l_geography_type VARCHAR2(30);');
869: li(' l_geography_id NUMBER;');
870: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
871: li(' LL_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
872: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE; -- not actually required here');
873: l(' ');
874: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');
875: l(' l_module CONSTANT VARCHAR2(30) := ''ADDRESS_VALIDATION'';');

Line 872: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE; -- not actually required here');

868: li(' l_geography_type VARCHAR2(30);');
869: li(' l_geography_id NUMBER;');
870: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
871: li(' LL_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
872: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE; -- not actually required here');
873: l(' ');
874: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');
875: l(' l_module CONSTANT VARCHAR2(30) := ''ADDRESS_VALIDATION'';');
876: l(' l_debug_prefix VARCHAR2(30) := p_location_id;');

Line 927: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

923: l(' -- and country is already populated in the L_MDU_TBL in the initialization section of this package.');
924: l(' --hk_debugt(L_MDU_TBL); ----- Code to display the output.');
925: l(' --hk_debugl(''Calling create_gnr With Map_status "S"'');');
926: l(' IF P_LOCATION_ID IS NOT NULL THEN');
927: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
928: l(' ''TAX'',''S'',l_loc_components_rec,''T'',L_MDU_TBL,l_status);');
929: l(' END IF;');
930: l(' x_status := FND_API.g_ret_sts_success;');
931: l(' RETURN;');

Line 993: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MDU_TBL,L_MDU_TBL,x_status);');

989: l(' ');
990: l_open_cur := l_open_cur||',l_geography_type;';
991: l_fetch_cur := l_fetch_cur||';';
992: l(' LL_MDU_TBL := L_MDU_TBL;');
993: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MDU_TBL,L_MDU_TBL,x_status);');
994: l(' --hk_debugl(''The SQL query'');');
995: l(' --hk_debugl(l_sql);');
996: l(' ');
997: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1024: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MDU_TBL,x_status);');

1020: l(' p_module => l_module');
1021: l(' );');
1022: l(' END IF; ');
1023: l(' ');
1024: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MDU_TBL,x_status);');
1025: l(' x_status := FND_API.G_RET_STS_ERROR;');
1026: l(' ELSE ');
1027: l(' --Fetching once more to see where there are multiple records');
1028: l(' ');

Line 1047: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MDU_TBL,L_MDU_TBL,x_status);');

1043:
1044:
1045: l(' -- Get the query again with identifier type as NAME if multiple match found');
1046: l(' -- If it returns a record, we are able to derive a unique record for identifier type as NAME');
1047: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MDU_TBL,L_MDU_TBL,x_status);');
1048: l(' OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id');
1049: l(' '||l_open_cur);
1050: l(' ');
1051: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1109: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MDU_TBL) = TRUE THEN');

1105: l(' END IF;');
1106: l(' ');
1107: l(' IF l_multiple_parent_flag = ''Y'' AND x_status <> FND_API.G_RET_STS_ERROR THEN');
1108: l(' --hk_debugl(''Multiple Parent Match found for the usage level search'');');
1109: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MDU_TBL) = TRUE THEN');
1110: l(' --hk_debugl(''Sucessfully Fixed the Multiple Parent Case '');');
1111: l(' NULL;');
1112: l(' ELSE -- Multiple parent case not able to find a unique record ');
1113: l(' ');

Line 1159: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MDU_TBL) = FALSE THEN');

1155: l(' p_module => l_module');
1156: l(' );');
1157: l(' END IF; ');
1158: l(' ');
1159: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MDU_TBL) = FALSE THEN');
1160: l(' --hk_debugl(''LL_MDU Table after Fix_child '');');
1161: l(' --hk_debugt(LL_MDU_TBL);');
1162: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MDU_TBL,L_MDU_TBL);');
1163: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.get_usage_val_status '');');

Line 1162: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MDU_TBL,L_MDU_TBL);');

1158: l(' ');
1159: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MDU_TBL) = FALSE THEN');
1160: l(' --hk_debugl(''LL_MDU Table after Fix_child '');');
1161: l(' --hk_debugt(LL_MDU_TBL);');
1162: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MDU_TBL,L_MDU_TBL);');
1163: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.get_usage_val_status '');');
1164: l(' --hk_debugt(LL_MDU_TBL);');
1165: l(' END IF;');
1166: l(' ');

Line 1163: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.get_usage_val_status '');');

1159: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MDU_TBL) = FALSE THEN');
1160: l(' --hk_debugl(''LL_MDU Table after Fix_child '');');
1161: l(' --hk_debugt(LL_MDU_TBL);');
1162: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MDU_TBL,L_MDU_TBL);');
1163: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.get_usage_val_status '');');
1164: l(' --hk_debugt(LL_MDU_TBL);');
1165: l(' END IF;');
1166: l(' ');
1167: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1179: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MDU_TBL);');

1175: l(' END IF; ');
1176: l(' ');
1177: l(' END IF;');
1178: l(' ');
1179: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MDU_TBL);');
1180: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.fill_values '');');
1181: l(' --hk_debugt(LL_MDU_TBL);');
1182: l(' ');
1183: l(' IF x_status = FND_API.g_ret_sts_success THEN');

Line 1180: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.fill_values '');');

1176: l(' ');
1177: l(' END IF;');
1178: l(' ');
1179: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MDU_TBL);');
1180: l(' --hk_debugl(''LL_MDU Table after HZ_GNR_UTIL_PKG.fill_values '');');
1181: l(' --hk_debugt(LL_MDU_TBL);');
1182: l(' ');
1183: l(' IF x_status = FND_API.g_ret_sts_success THEN');
1184: l(' ');

Line 1195: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1191: l(' p_module => l_module');
1192: l(' );');
1193: l(' END IF; ');
1194: l(' ');
1195: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1196: l(' ''TAX'',''S'',l_loc_components_rec,''T'',LL_MDU_TBL,l_status);');
1197: l(' ELSE ');
1198: l(' ');
1199: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1209: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1205: l(' p_module => l_module');
1206: l(' );');
1207: l(' END IF; ');
1208: l(' ');
1209: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1210: l(' ''TAX'',''E'',l_loc_components_rec,''T'',LL_MDU_TBL,l_status);');
1211: l(' END IF;');
1212: l(' ');
1213: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1250: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

1246: -- local variable declaration
1247: l_procName varchar2(30);
1248: i number;
1249: j number;
1250: l_mdu_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
1251: l_open_cur varchar2(2000);
1252: l_fetch_cur varchar2(2000);
1253: l_usage_id number;
1254: l_usage_code varchar2(30);

Line 1263: li(' p_loc_components_rec IN HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE,');

1259: l(' ');
1260: -- write the header comments, procedure name
1261: l_procName := 'validateForMap';
1262: procBegin(l_procName);
1263: li(' p_loc_components_rec IN HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE,');
1264: li(' x_map_dtls_tbl IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,');
1265: li(' X_CAUSE OUT NOCOPY VARCHAR2,');
1266: li(' X_STATUS OUT NOCOPY VARCHAR2) IS');
1267: l(' ');

Line 1264: li(' x_map_dtls_tbl IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,');

1260: -- write the header comments, procedure name
1261: l_procName := 'validateForMap';
1262: procBegin(l_procName);
1263: li(' p_loc_components_rec IN HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE,');
1264: li(' x_map_dtls_tbl IN OUT NOCOPY HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE,');
1265: li(' X_CAUSE OUT NOCOPY VARCHAR2,');
1266: li(' X_STATUS OUT NOCOPY VARCHAR2) IS');
1267: l(' ');
1268: l(' ');

Line 1278: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

1274: li(' l_sql VARCHAR2(9000);');
1275: li(' l_status VARCHAR2(1);');
1276: li(' l_geography_type VARCHAR2(30);');
1277: li(' l_geography_id NUMBER;');
1278: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1279: l(' ');
1280: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');
1281: l(' l_module CONSTANT VARCHAR2(30) := ''ADDRESS_VALIDATION'';');
1282: l(' l_debug_prefix VARCHAR2(30);');

Line 1325: l(' IF HZ_GNR_UTIL_PKG.getLocCompCount(L_MAP_DTLS_TBL) = 0 THEN');

1321: l(' x_status := FND_API.g_ret_sts_success;');
1322: l(' RETURN;');
1323: l(' END IF;');
1324: l(' ');
1325: l(' IF HZ_GNR_UTIL_PKG.getLocCompCount(L_MAP_DTLS_TBL) = 0 THEN');
1326: l(' --hk_debugl(''HZ_GNR_UTIL_PKG.getLocCompCount = 0'');');
1327: l(' ');
1328: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1329: l(' hz_utility_v2pub.debug ');

Line 1326: l(' --hk_debugl(''HZ_GNR_UTIL_PKG.getLocCompCount = 0'');');

1322: l(' RETURN;');
1323: l(' END IF;');
1324: l(' ');
1325: l(' IF HZ_GNR_UTIL_PKG.getLocCompCount(L_MAP_DTLS_TBL) = 0 THEN');
1326: l(' --hk_debugl(''HZ_GNR_UTIL_PKG.getLocCompCount = 0'');');
1327: l(' ');
1328: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1329: l(' hz_utility_v2pub.debug ');
1330: l(' (p_message => '' HZ_GNR_UTIL_PKG.getLocCompCount = 0 '',');

Line 1330: l(' (p_message => '' HZ_GNR_UTIL_PKG.getLocCompCount = 0 '',');

1326: l(' --hk_debugl(''HZ_GNR_UTIL_PKG.getLocCompCount = 0'');');
1327: l(' ');
1328: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1329: l(' hz_utility_v2pub.debug ');
1330: l(' (p_message => '' HZ_GNR_UTIL_PKG.getLocCompCount = 0 '',');
1331: l(' p_prefix => l_debug_prefix,');
1332: l(' p_msg_level => fnd_log.level_statement,');
1333: l(' p_module_prefix => l_module_prefix,');
1334: l(' p_module => l_module');

Line 1340: l(' IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN');

1336: l(' END IF; ');
1337: l(' ');
1338: l(' --No other location component value other than country is passed. ');
1339: l(' --Following call will try to derive missing lower level compoents ');
1340: l(' IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN');
1341: l(' x_cause := ''MISSING_CHILD'';');
1342: l(' ');
1343: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1344: l(' hz_utility_v2pub.debug ');

Line 1353: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');

1349: l(' p_module => l_module');
1350: l(' );');
1351: l(' END IF; ');
1352: l(' ');
1353: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');
1354: l(' x_status := FND_API.G_RET_STS_ERROR;');
1355: l(' X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
1356: l(' RETURN;');
1357: l(' ELSE');

Line 1369: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');

1365: l(' p_module => l_module');
1366: l(' );');
1367: l(' END IF; ');
1368: l(' ');
1369: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');
1370: l(' x_status := FND_API.G_RET_STS_SUCCESS;');
1371: l(' X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
1372: l(' RETURN;');
1373: l(' END IF;');

Line 1405: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);');

1401: l(' ');
1402: l_open_cur := l_open_cur||',l_geography_type;';
1403: l_fetch_cur := l_fetch_cur||';';
1404:
1405: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);');
1406: l(' --hk_debugl(''The SQL query'');');
1407: l(' --hk_debugl(l_sql);');
1408: l(' ');
1409: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1451: l(' HZ_GNR_UTIL_PKG.fix_no_match(L_MAP_DTLS_TBL,x_status);');

1447: l(' ');
1448: l(' --hk_debugl(''NOT FOUND of the first fetch'');');
1449: l(' --hk_debugt(L_MAP_DTLS_TBL);');
1450: l(' x_cause := ''NO_MATCH'';');
1451: l(' HZ_GNR_UTIL_PKG.fix_no_match(L_MAP_DTLS_TBL,x_status);');
1452: l(' --hk_debugl(''Map_loc table after Fix'');');
1453: l(' --hk_debugt(L_MAP_DTLS_TBL);');
1454: l(' x_status := FND_API.G_RET_STS_ERROR;');
1455: l(' ELSE ');

Line 1474: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);');

1470: l(' IF c_getGeo%FOUND THEN -- not able to identify a unique record');
1471: l(' ');
1472: l(' -- Get the query again with identifier type as NAME if multiple match found');
1473: l(' -- If it returns a record, we are able to derive a unique record for identifier type as NAME');
1474: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);');
1475: l(' OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id');
1476: l(' '||l_open_cur);
1477: l(' ');
1478: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1560: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,L_MAP_DTLS_TBL) = TRUE THEN');

1556: l(' ');
1557: l(' END IF;');
1558: l(' ');
1559: l(' IF l_multiple_parent_flag = ''Y'' THEN');
1560: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,L_MAP_DTLS_TBL) = TRUE THEN');
1561: l(' NULL; -- a unique record is found');
1562: l(' ELSE -- Multiple parent case not able to find a unique record ');
1563: l(' ');
1564: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1621: l(' IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN');

1617: l(' );');
1618: l(' END IF; ');
1619: l(' ');
1620: l(' --Following call will try to derive missing lower level compoents ');
1621: l(' IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN');
1622: l(' x_cause := ''MISSING_CHILD'';');
1623: l(' ');
1624: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1625: l(' hz_utility_v2pub.debug ');

Line 1634: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');

1630: l(' p_module => l_module');
1631: l(' );');
1632: l(' END IF; ');
1633: l(' ');
1634: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');
1635: l(' x_status := FND_API.G_RET_STS_ERROR;');
1636: l(' X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
1637: l(' RETURN;');
1638: l(' END IF;');

Line 1639: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');

1635: l(' x_status := FND_API.G_RET_STS_ERROR;');
1636: l(' X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
1637: l(' RETURN;');
1638: l(' END IF;');
1639: -- l(' HZ_GNR_UTIL_PKG.fill_values(L_MAP_DTLS_TBL);');
1640: l(' ');
1641: l(' X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
1642: l(' ');
1643: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1705: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE;');

1701: li(' X_STATUS OUT NOCOPY VARCHAR2) IS');
1702: l(' ');
1703:
1704: -- cursor or local variable declaration
1705: li(' l_loc_components_rec HZ_GNR_UTIL_PKG.LOC_COMPONENTS_REC_TYPE;');
1706: l(' ');
1707: li(' TYPE getGeo IS REF CURSOR;');
1708: li(' c_getGeo getGeo;');
1709: li(' c_getGeo1 getGeo;');

Line 1720: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

1716: li(' l_status VARCHAR2(1);');
1717: li(' l_get_addr_val VARCHAR2(1);');
1718: li(' l_geography_type VARCHAR2(30);');
1719: li(' l_geography_id NUMBER;');
1720: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1721: li(' LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1722: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1723: l(' ');
1724: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');

Line 1721: li(' LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

1717: li(' l_get_addr_val VARCHAR2(1);');
1718: li(' l_geography_type VARCHAR2(30);');
1719: li(' l_geography_id NUMBER;');
1720: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1721: li(' LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1722: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1723: l(' ');
1724: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');
1725: l(' l_module CONSTANT VARCHAR2(30) := ''ADDRESS_VALIDATION'';');

Line 1722: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

1718: li(' l_geography_type VARCHAR2(30);');
1719: li(' l_geography_id NUMBER;');
1720: li(' L_MDU_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1721: li(' LL_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1722: li(' L_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
1723: l(' ');
1724: l(' l_module_prefix CONSTANT VARCHAR2(30) := ''HZ:ARHGNRGB:'||g_pkgName||''';');
1725: l(' l_module CONSTANT VARCHAR2(30) := ''ADDRESS_VALIDATION'';');
1726: l(' l_debug_prefix VARCHAR2(30) := p_location_id;');

Line 1786: l(' IF HZ_GNR_UTIL_PKG.check_GNR_For_Usage(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1782: l(' END IF; ');
1783: l(' ');
1784: l(' IF P_LOCATION_ID IS NOT NULL AND P_CALLED_FROM <> ''GNR'' THEN');
1785: l(' --hk_debugl(''Before check_GNR_For_Usage'');');
1786: l(' IF HZ_GNR_UTIL_PKG.check_GNR_For_Usage(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1787: l(' L_USAGE_CODE,L_MDU_TBL,x_status) = TRUE THEN');
1788: l(' --hk_debugl(''After check_GNR_For_Usage with status :- ''||x_status);');
1789: l(' ');
1790: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1817: l(' HZ_GNR_UTIL_PKG.getLocCompValues(G_MAP_REC.LOC_TBL_NAME,L_LOC_COMPONENTS_REC,L_MAP_DTLS_TBL,x_status);');

1813: l(' );');
1814: l(' END IF; ');
1815: l(' ');
1816: l(' -- After the following call L_MAP_DTLS_TBL will have the components value populated.');
1817: l(' HZ_GNR_UTIL_PKG.getLocCompValues(G_MAP_REC.LOC_TBL_NAME,L_LOC_COMPONENTS_REC,L_MAP_DTLS_TBL,x_status);');
1818: l(' ');
1819: l(' -- Below code will overwrite the LOC_COMPVAL for COUNTRY to COUNTRY_CODE');
1820: l(' -- This change is to update COUNTRY column in locations table with COUNTRY_CODE ');
1821: l(' -- even if the table has Country name in this column and the validation is success ');

Line 1825: l(' HZ_GNR_UTIL_PKG.getLocCompValues(G_MAP_REC.LOC_TBL_NAME,L_LOC_COMPONENTS_REC,L_MDU_TBL,x_status);');

1821: l(' -- even if the table has Country name in this column and the validation is success ');
1822: l(' L_MAP_DTLS_TBL(1).LOC_COMPVAL := G_MAP_REC.COUNTRY_CODE;');
1823: l(' ');
1824: l(' -- After the following call L_MDU_TBL will have the components value populated.');
1825: l(' HZ_GNR_UTIL_PKG.getLocCompValues(G_MAP_REC.LOC_TBL_NAME,L_LOC_COMPONENTS_REC,L_MDU_TBL,x_status);');
1826: l(' ');
1827: l(' --hk_debugl('' value of X_CALL_MAP : ''||X_CALL_MAP);');
1828: l(' IF X_CALL_MAP = ''Y'' THEN');
1829: l(' LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');

Line 1865: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN ');

1861: l(' -- hk_debugt(LL_MAP_DTLS_TBL); ');
1862: l(' -- hk_debugl(''Usage Map Table With loc comp values''); ');
1863: l(' -- hk_debugt(L_MDU_TBL); ');
1864: l(' ');
1865: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN ');
1866: l(' -- hk_debugl(''COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success''); ');
1867: l(' x_status := FND_API.g_ret_sts_success; ');
1868: l(' ');
1869: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 1900: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');

1896: l(' p_module => l_module');
1897: l(' );');
1898: l(' END IF; ');
1899: l(' ');
1900: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1901: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1902: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
1903: l(' END IF;');
1904: l(' ');

Line 1901: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1897: l(' );');
1898: l(' END IF; ');
1899: l(' ');
1900: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1901: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1902: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
1903: l(' END IF;');
1904: l(' ');
1905: l(' X_CALL_MAP := ''N'';');

Line 1915: l(' IF HZ_GNR_UTIL_PKG.do_usage_val(l_cause,L_MAP_DTLS_TBL,L_MDU_TBL,LL_MAP_DTLS_TBL,l_status) = FALSE THEN');

1911: l(' --hk_debugl(''Table that is returned by Validate For Map'');');
1912: l(' --hk_debugt(LL_MAP_DTLS_TBL);');
1913: l(' --hk_debugl(''Usage Map Table With loc comp values'');');
1914: l(' --hk_debugt(L_MDU_TBL);');
1915: l(' IF HZ_GNR_UTIL_PKG.do_usage_val(l_cause,L_MAP_DTLS_TBL,L_MDU_TBL,LL_MAP_DTLS_TBL,l_status) = FALSE THEN');
1916: l(' ');
1917: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1918: l(' hz_utility_v2pub.debug ');
1919: l(' (p_message => '' No usage level validation is required. Call create_gnr with the map status'',');

Line 1928: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN');

1924: l(' );');
1925: l(' END IF; ');
1926: l(' ');
1927: l(' -- This means no usage level validation is required');
1928: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN');
1929: l(' ');
1930: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1931: l(' -- This below call is to derive the address validation status and set the message ');
1932: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''E'',x_status);');

Line 1930: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');

1926: l(' ');
1927: l(' -- This means no usage level validation is required');
1928: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN');
1929: l(' ');
1930: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1931: l(' -- This below call is to derive the address validation status and set the message ');
1932: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''E'',x_status);');
1933: l(' --hk_debugl(''Calling create_gnr With Map_status "E"'');');
1934: l(' ');

Line 1932: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''E'',x_status);');

1928: l(' IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN');
1929: l(' ');
1930: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1931: l(' -- This below call is to derive the address validation status and set the message ');
1932: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''E'',x_status);');
1933: l(' --hk_debugl(''Calling create_gnr With Map_status "E"'');');
1934: l(' ');
1935: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1936: l(' hz_utility_v2pub.debug ');

Line 1945: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1941: l(' p_module => l_module');
1942: l(' );');
1943: l(' END IF; ');
1944: l(' ');
1945: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1946: l(' L_USAGE_CODE,''E'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
1947: l(' --hk_debugl(''Status after create_gnr : ''||l_status);');
1948: l(' ELSE ');
1949: l(' ');

Line 1950: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');

1946: l(' L_USAGE_CODE,''E'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
1947: l(' --hk_debugl(''Status after create_gnr : ''||l_status);');
1948: l(' ELSE ');
1949: l(' ');
1950: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1951: l(' -- This below call is to derive the address validation status and set the message ');
1952: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');
1953: l(' --hk_debugl(''Calling create_gnr With Map_status "S"'');');
1954: l(' ');

Line 1952: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');

1948: l(' ELSE ');
1949: l(' ');
1950: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
1951: l(' -- This below call is to derive the address validation status and set the message ');
1952: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');
1953: l(' --hk_debugl(''Calling create_gnr With Map_status "S"'');');
1954: l(' ');
1955: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
1956: l(' hz_utility_v2pub.debug ');

Line 1965: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

1961: l(' p_module => l_module');
1962: l(' );');
1963: l(' END IF; ');
1964: l(' ');
1965: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
1966: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
1967: l(' --hk_debugl(''Status after create_gnr : ''||l_status);');
1968: l(' x_status := FND_API.g_ret_sts_success;');
1969: l(' END IF;');

Line 2002: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(L_MDU_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');

1998: l(' -- and country is already populated in the L_MDU_TBL in the initialization section of this package.');
1999: l(' --hk_debugt(L_MDU_TBL); ----- Code to display the output.');
2000: l(' --hk_debugl(''Calling create_gnr With Map_status "S"'');');
2001: l(' -- This below call is to derive the address validation status and set the message ');
2002: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(L_MDU_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');
2003: l(' ');
2004: l(' IF P_LOCATION_ID IS NOT NULL THEN');
2005: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
2006: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,L_MDU_TBL,l_status);');

Line 2005: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

2001: l(' -- This below call is to derive the address validation status and set the message ');
2002: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(L_MDU_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,''S'',x_status);');
2003: l(' ');
2004: l(' IF P_LOCATION_ID IS NOT NULL THEN');
2005: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
2006: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,L_MDU_TBL,l_status);');
2007: l(' END IF;');
2008: l(' ');
2009: l(' x_status := FND_API.g_ret_sts_success;');

Line 2056: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);');

2052: l_open_cur := l_open_cur||',l_geography_type;';
2053: l_fetch_cur := l_fetch_cur||';';
2054:
2055: l(' LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;');
2056: l(' l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);');
2057: l(' --hk_debugl(''The SQL query'');');
2058: l(' --hk_debugl(l_sql);');
2059: l(' ');
2060: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 2087: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);');

2083: l(' p_module => l_module');
2084: l(' );');
2085: l(' END IF; ');
2086: l(' ');
2087: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);');
2088: l(' x_status := FND_API.G_RET_STS_ERROR;');
2089: l(' ELSE ');
2090: l(' --Fetching once more to see where there are multiple records');
2091: l(' ');

Line 2108: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);');

2104: l(' IF c_getGeo%FOUND THEN -- not able to identify a unique record');
2105: l(' ');
2106: l(' -- Get the query again with identifier type as NAME if multiple match found');
2107: l(' -- If it returns a record, we are able to derive a unique record for identifier type as NAME');
2108: l(' l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);');
2109: l(' OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id');
2110: l(' '||l_open_cur);
2111: l(' ');
2112: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 2156: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status); ');

2152: l(' ); ');
2153: l(' END IF; ');
2154: l(' ');
2155: l(' LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL; ');
2156: l(' HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status); ');
2157: l(' x_status := FND_API.G_RET_STS_ERROR; ');
2158: l(' END IF; ');
2159: l(' ');
2160: ----- End of fix for Bug 5011366 (Nishant)

Line 2193: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN');

2189: l(' ');
2190: l(' END IF;');
2191: l(' ');
2192: l(' IF l_multiple_parent_flag = ''Y'' AND x_status <> FND_API.G_RET_STS_ERROR THEN');
2193: l(' IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN');
2194: l(' NULL;');
2195: l(' ELSE -- Multiple parent case not able to find a unique record ');
2196: l(' ');
2197: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 2249: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MAP_DTLS_TBL) = FALSE THEN');

2245: l(' p_module => l_module');
2246: l(' );');
2247: l(' END IF; ');
2248: l(' ');
2249: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MAP_DTLS_TBL) = FALSE THEN');
2250: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL);');
2251: l(' END IF;');
2252: l(' ');
2253: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');

Line 2250: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL);');

2246: l(' );');
2247: l(' END IF; ');
2248: l(' ');
2249: l(' IF HZ_GNR_UTIL_PKG.fix_child(LL_MAP_DTLS_TBL) = FALSE THEN');
2250: l(' x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL);');
2251: l(' END IF;');
2252: l(' ');
2253: l(' IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN ');
2254: l(' hz_utility_v2pub.debug ');

Line 2265: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');

2261: l(' END IF; ');
2262: l(' ');
2263: l(' --hk_debugl(''LL_MAP_DTLS_TBL before fill_values'');');
2264: l(' --hk_debugt(LL_MAP_DTLS_TBL);');
2265: l(' HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);');
2266: l(' --hk_debugl(''LL_MAP_DTLS_TBL after fill_values'');');
2267: l(' --hk_debugt(LL_MAP_DTLS_TBL);');
2268: l(' ');
2269: l(' IF x_status = FND_API.g_ret_sts_success THEN');

Line 2274: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,x_status,x_status);');

2270: l(' -- We need to call the getAddrValStatus only once. All other cases we are looking into x_call_map ');
2271: l(' -- In some case the below code will execute with the x_call_map as N ');
2272: l(' IF l_get_addr_val = ''Y'' THEN');
2273: l(' -- This below call is to derive the address validation status and set the message ');
2274: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,x_status,x_status);');
2275: l(' END IF;');
2276: l(' ');
2277: l(' IF P_LOCATION_ID IS NOT NULL THEN');
2278: l(' ');

Line 2289: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

2285: l(' p_module => l_module');
2286: l(' );');
2287: l(' END IF; ');
2288: l(' ');
2289: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
2290: l(' L_USAGE_CODE,''S'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
2291: l(' --hk_debugl(''Prceossed GNR With Status : S and returned with Status : ''||l_status);');
2292: l(' END IF;');
2293: l(' ELSE ');

Line 2298: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,x_status,x_status);');

2294: l(' -- We need to call the getAddrValStatus only once. All other cases we are looking into x_call_map ');
2295: l(' -- In some case the below code will execute with the x_call_map as N ');
2296: l(' IF l_get_addr_val = ''Y'' THEN');
2297: l(' -- This below call is to derive the address validation status and set the message ');
2298: l(' X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,x_status,x_status);');
2299: l(' END IF;');
2300: l(' ');
2301: l(' IF P_LOCATION_ID IS NOT NULL THEN');
2302: l(' ');

Line 2313: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');

2309: l(' p_module => l_module');
2310: l(' );');
2311: l(' END IF; ');
2312: l(' ');
2313: l(' HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,');
2314: l(' L_USAGE_CODE,''E'',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);');
2315: l(' --hk_debugl(''Prceossed GNR With Status : E and returned with Status : ''||l_status);');
2316: l(' END IF;');
2317: l(' END IF;');

Line 2399: li(' G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;');

2395: li(' --------------------------------------');
2396: l(' ');
2397: li(' g_debug_count NUMBER := 0;');
2398: li(' g_country_geo_id NUMBER;');
2399: li(' G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;');
2400: li(' G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
2401: li(' G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;');
2402: li(' G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;');
2403: -- create global variables with mapping details per usage

Line 2400: li(' G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

2396: l(' ');
2397: li(' g_debug_count NUMBER := 0;');
2398: li(' g_country_geo_id NUMBER;');
2399: li(' G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;');
2400: li(' G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
2401: li(' G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;');
2402: li(' G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;');
2403: -- create global variables with mapping details per usage
2404: i:=0;

Line 2401: li(' G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;');

2397: li(' g_debug_count NUMBER := 0;');
2398: li(' g_country_geo_id NUMBER;');
2399: li(' G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;');
2400: li(' G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
2401: li(' G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;');
2402: li(' G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;');
2403: -- create global variables with mapping details per usage
2404: i:=0;
2405: IF G_USAGE_TBL.COUNT > 0 THEN

Line 2402: li(' G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;');

2398: li(' g_country_geo_id NUMBER;');
2399: li(' G_MAP_REC HZ_GNR_UTIL_PKG.MAP_REC_TYPE;');
2400: li(' G_MAP_DTLS_TBL HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
2401: li(' G_USAGE_TBL HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;');
2402: li(' G_USAGE_DTLS_TBL HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;');
2403: -- create global variables with mapping details per usage
2404: i:=0;
2405: IF G_USAGE_TBL.COUNT > 0 THEN
2406: i := G_USAGE_TBL.FIRST;

Line 2408: li(' G_MDU_TBL'||G_USAGE_TBL(i).USAGE_ID||' HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');

2404: i:=0;
2405: IF G_USAGE_TBL.COUNT > 0 THEN
2406: i := G_USAGE_TBL.FIRST;
2407: LOOP
2408: li(' G_MDU_TBL'||G_USAGE_TBL(i).USAGE_ID||' HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;');
2409: EXIT WHEN i = G_USAGE_TBL.LAST;
2410: i := G_USAGE_TBL.NEXT(i);
2411: END LOOP;
2412: END IF;

Line 2472: p_map_rec IN HZ_GNR_UTIL_PKG.map_rec_type,

2468: *
2469: */
2470: --------------------------------------
2471: procedure genPkg(
2472: p_map_rec IN HZ_GNR_UTIL_PKG.map_rec_type,
2473: p_map_dtls_tbl IN HZ_GNR_UTIL_PKG.maploc_rec_tbl_type,
2474: p_usage_tbl IN HZ_GNR_UTIL_PKG.usage_tbl_type,
2475: p_usage_dtls_tbl IN HZ_GNR_UTIL_PKG.usage_dtls_tbl_type,
2476: x_pkgName OUT NOCOPY VARCHAR2,

Line 2473: p_map_dtls_tbl IN HZ_GNR_UTIL_PKG.maploc_rec_tbl_type,

2469: */
2470: --------------------------------------
2471: procedure genPkg(
2472: p_map_rec IN HZ_GNR_UTIL_PKG.map_rec_type,
2473: p_map_dtls_tbl IN HZ_GNR_UTIL_PKG.maploc_rec_tbl_type,
2474: p_usage_tbl IN HZ_GNR_UTIL_PKG.usage_tbl_type,
2475: p_usage_dtls_tbl IN HZ_GNR_UTIL_PKG.usage_dtls_tbl_type,
2476: x_pkgName OUT NOCOPY VARCHAR2,
2477: x_status OUT NOCOPY VARCHAR2) IS

Line 2474: p_usage_tbl IN HZ_GNR_UTIL_PKG.usage_tbl_type,

2470: --------------------------------------
2471: procedure genPkg(
2472: p_map_rec IN HZ_GNR_UTIL_PKG.map_rec_type,
2473: p_map_dtls_tbl IN HZ_GNR_UTIL_PKG.maploc_rec_tbl_type,
2474: p_usage_tbl IN HZ_GNR_UTIL_PKG.usage_tbl_type,
2475: p_usage_dtls_tbl IN HZ_GNR_UTIL_PKG.usage_dtls_tbl_type,
2476: x_pkgName OUT NOCOPY VARCHAR2,
2477: x_status OUT NOCOPY VARCHAR2) IS
2478:

Line 2475: p_usage_dtls_tbl IN HZ_GNR_UTIL_PKG.usage_dtls_tbl_type,

2471: procedure genPkg(
2472: p_map_rec IN HZ_GNR_UTIL_PKG.map_rec_type,
2473: p_map_dtls_tbl IN HZ_GNR_UTIL_PKG.maploc_rec_tbl_type,
2474: p_usage_tbl IN HZ_GNR_UTIL_PKG.usage_tbl_type,
2475: p_usage_dtls_tbl IN HZ_GNR_UTIL_PKG.usage_dtls_tbl_type,
2476: x_pkgName OUT NOCOPY VARCHAR2,
2477: x_status OUT NOCOPY VARCHAR2) IS
2478:
2479: BEGIN

Line 2523: l_map_rec HZ_GNR_UTIL_PKG.MAP_REC_TYPE;

2519:
2520: m number := 0;
2521: n number := 0;
2522:
2523: l_map_rec HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
2524: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
2525: l_usage_tbl HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2527:

Line 2524: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;

2520: m number := 0;
2521: n number := 0;
2522:
2523: l_map_rec HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
2524: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
2525: l_usage_tbl HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2527:
2528: CURSOR c_map(p_map_id IN NUMBER) IS

Line 2525: l_usage_tbl HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;

2521: n number := 0;
2522:
2523: l_map_rec HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
2524: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
2525: l_usage_tbl HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2527:
2528: CURSOR c_map(p_map_id IN NUMBER) IS
2529: SELECT MAP_ID,COUNTRY_CODE,LOC_TBL_NAME,ADDRESS_STYLE

Line 2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;

2522:
2523: l_map_rec HZ_GNR_UTIL_PKG.MAP_REC_TYPE;
2524: l_map_dtls_tbl HZ_GNR_UTIL_PKG.MAPLOC_REC_TBL_TYPE;
2525: l_usage_tbl HZ_GNR_UTIL_PKG.USAGE_TBL_TYPE;
2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2527:
2528: CURSOR c_map(p_map_id IN NUMBER) IS
2529: SELECT MAP_ID,COUNTRY_CODE,LOC_TBL_NAME,ADDRESS_STYLE
2530: FROM hz_geo_struct_map