DBA Data[Home] [Help]

APPS.INV_EBI_UTIL dependencies on FND_PROFILE_OPTION_VALUES

Line 10: l_pimdl_profile_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

6: -- Type : Public
7: -- Function :
8: ************************************************************************************/
9: FUNCTION is_pim_installed RETURN BOOLEAN IS
10: l_pimdl_profile_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
11: BEGIN
12: l_pimdl_profile_value := FND_PROFILE.value('EGO_ENABLE_PIMDL');
13: IF (l_pimdl_profile_value = 1) THEN
14: RETURN TRUE;

Line 486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

482: l_user_id NUMBER(15);
483: l_resp_id NUMBER(15);
484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

Line 487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

483: l_resp_id NUMBER(15);
484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

Line 488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

484: l_resp_appl_id NUMBER(15);
485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

Line 489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

485: l_sec_grp_id NUMBER(15);
486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;

Line 490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

486: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;

Line 491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

487: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

Line 492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

488: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
489: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
490: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
496: l_timeout NUMBER;

Line 495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

491: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
492: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
493: l_limit_time NUMBER;
494: l_limit_connects NUMBER;
495: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
496: l_timeout NUMBER;
497: BEGIN
498: IF p_name_value_tbl IS NOT NULL AND p_name_value_tbl.COUNT>0
499: THEN