APPS.PON_PROFILE_UTIL_PKG dependencies on FND_PROFILE

Line 403: l_language := fnd_profile.value_specific('ICX_LANGUAGE', ln_user_id, NULL, NULL);

399: WHEN NO_DATA_FOUND THEN
400: ln_user_id := null;
401: END;
402:
403: l_language := fnd_profile.value_specific('ICX_LANGUAGE', ln_user_id, NULL, NULL);
404: SELECT LANGUAGE_CODE
405: INTO x_language_code
406: FROM FND_LANGUAGES
407: WHERE NLS_LANGUAGE = l_language;

Line 420: l_language := fnd_profile.value_specific('ICX_LANGUAGE', p_user_id, NULL, NULL);

416: IS
417: l_language VARCHAR2(150);
418: BEGIN
419:
420: l_language := fnd_profile.value_specific('ICX_LANGUAGE', p_user_id, NULL, NULL);
421: SELECT LANGUAGE_CODE
422: INTO x_language_code
423: FROM FND_LANGUAGES
424: WHERE NLS_LANGUAGE = l_language;

Line 459: l_territory := fnd_profile.value_specific('ICX_TERRITORY', ln_user_id, NULL, NULL);

455: INTO ln_user_id
456: FROM fnd_user
457: WHERE user_name = upper(p_user_name);
458:
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

Line 587: l_saved := FND_PROFILE.SAVE(p_option_name, p_option_value, p_level_name, null, null);

583: l_status VARCHAR2(3);
584:
585: BEGIN
586:
587: l_saved := FND_PROFILE.SAVE(p_option_name, p_option_value, p_level_name, null, null);
588:
589:
590: IF l_saved = TRUE THEN
591: l_status := 'Y';