APPS.FND_OID_USERS dependencies on FND_TERRITORIES

Line 1288: cursor cur_fnd_territories is

1284: p_ldap_message in fnd_oid_util.ldap_message_type
1285: , x_location_rec out nocopy hz_location_v2pub.location_rec_type
1286: ) is
1287:
1288: cursor cur_fnd_territories is
1289: SELECT TERRITORY_CODE
1290: FROM FND_TERRITORIES_VL
1291: WHERE TERRITORY_CODE = p_ldap_message.c
1292: OR TERRITORY_SHORT_NAME = p_ldap_message.c

Line 1290: FROM FND_TERRITORIES_VL

1286: ) is
1287:
1288: cursor cur_fnd_territories is
1289: SELECT TERRITORY_CODE
1290: FROM FND_TERRITORIES_VL
1291: WHERE TERRITORY_CODE = p_ldap_message.c
1292: OR TERRITORY_SHORT_NAME = p_ldap_message.c
1293: OR DESCRIPTION = p_ldap_message.c;
1294:

Line 1296: l_territory_code fnd_territories.TERRITORY_CODE%type;

1292: OR TERRITORY_SHORT_NAME = p_ldap_message.c
1293: OR DESCRIPTION = p_ldap_message.c;
1294:
1295: l_module_source varchar2(256);
1296: l_territory_code fnd_territories.TERRITORY_CODE%type;
1297: l_found boolean;
1298:
1299: begin
1300: l_module_source := G_MODULE_SOURCE || 'get_location_rec';

Line 1319: open cur_fnd_territories;

1315: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1316: 'Country from OID: '||p_ldap_message.c);
1317: end if;
1318:
1319: open cur_fnd_territories;
1320: fetch cur_fnd_territories into l_territory_code;
1321: l_found := cur_fnd_territories%found;
1322:
1323: if(l_found)

Line 1320: fetch cur_fnd_territories into l_territory_code;

1316: 'Country from OID: '||p_ldap_message.c);
1317: end if;
1318:
1319: open cur_fnd_territories;
1320: fetch cur_fnd_territories into l_territory_code;
1321: l_found := cur_fnd_territories%found;
1322:
1323: if(l_found)
1324: then

Line 1321: l_found := cur_fnd_territories%found;

1317: end if;
1318:
1319: open cur_fnd_territories;
1320: fetch cur_fnd_territories into l_territory_code;
1321: l_found := cur_fnd_territories%found;
1322:
1323: if(l_found)
1324: then
1325: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1339: close cur_fnd_territories;

1335: 'Setting country to null');
1336: end if;
1337: x_location_rec.country := null;
1338: end if;
1339: close cur_fnd_territories;
1340: end if;
1341:
1342: if (p_ldap_message.street is not null) then
1343: x_location_rec.address1 := p_ldap_message.street;

Line 1367: if (cur_fnd_territories%isopen)

1363: end if;
1364:
1365: exception
1366: when others then
1367: if (cur_fnd_territories%isopen)
1368: then
1369: close cur_fnd_territories;
1370: end if;
1371:

Line 1369: close cur_fnd_territories;

1365: exception
1366: when others then
1367: if (cur_fnd_territories%isopen)
1368: then
1369: close cur_fnd_territories;
1370: end if;
1371:
1372: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1373: then