APPS.PON_PROFILE_UTIL_PKG dependencies on FND_TERRITORIES

Line 438: FROM FND_TERRITORIES

434: BEGIN
435:
436: SELECT NLS_TERRITORY
437: INTO l_territory
438: FROM FND_TERRITORIES
439: WHERE TERRITORY_CODE = p_territory_code;
440:
441: fnd_preference.put(upper(p_user_name), 'WF', 'TERRITORY', l_territory);
442:

Line 463: FROM FND_TERRITORIES

459: l_territory := fnd_profile.value_specific('ICX_TERRITORY', ln_user_id, NULL, NULL);
460:
461: SELECT TERRITORY_CODE
462: INTO x_territory_code
463: FROM FND_TERRITORIES
464: WHERE NLS_TERRITORY = l_territory;
465:
466: END GET_WF_TERRITORY;
467:

Line 487: FROM FND_TERRITORIES

483: WHERE LANGUAGE_CODE = p_language_code;
484:
485: SELECT NLS_TERRITORY
486: INTO l_territory
487: FROM FND_TERRITORIES
488: WHERE TERRITORY_CODE = p_territory_code;
489:
490: fnd_preference.put(upper(p_user_name), 'WF', 'LANGUAGE', l_language);
491: fnd_preference.put(upper(p_user_name), 'WF', 'TERRITORY', l_territory);