DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 307: /* FND_PROFILE_OPTION_VALUES */

303: /* */
304: /* FND_USER */
305: /* FND_APPLICATION */
306: /* FND_RESPONSIBILITY */
307: /* FND_PROFILE_OPTION_VALUES */
308: /* FND_PRODUCT_INSTALLATIONS */
309: /* */
310: /* ------------------------------------------------------------------------- */
311:

Line 737: l_industry fnd_profile_option_values.profile_option_value%TYPE;

733: p_calling_prog_flag IN VARCHAR2) RETURN BOOLEAN IS
734:
735: i BINARY_INTEGER;
736: l_status fnd_product_installations.status%TYPE;
737: l_industry fnd_profile_option_values.profile_option_value%TYPE;
738: l_value fnd_profile_option_values.profile_option_value%TYPE;
739: l_reverse_tc_flag fnd_profile_option_values.profile_option_value%TYPE;
740: l_fv_prepay_prof fnd_profile_option_values.profile_option_value%TYPE;
741: l_fv_prepay_defined BOOLEAN;

Line 738: l_value fnd_profile_option_values.profile_option_value%TYPE;

734:
735: i BINARY_INTEGER;
736: l_status fnd_product_installations.status%TYPE;
737: l_industry fnd_profile_option_values.profile_option_value%TYPE;
738: l_value fnd_profile_option_values.profile_option_value%TYPE;
739: l_reverse_tc_flag fnd_profile_option_values.profile_option_value%TYPE;
740: l_fv_prepay_prof fnd_profile_option_values.profile_option_value%TYPE;
741: l_fv_prepay_defined BOOLEAN;
742: l_defined BOOLEAN;

Line 739: l_reverse_tc_flag fnd_profile_option_values.profile_option_value%TYPE;

735: i BINARY_INTEGER;
736: l_status fnd_product_installations.status%TYPE;
737: l_industry fnd_profile_option_values.profile_option_value%TYPE;
738: l_value fnd_profile_option_values.profile_option_value%TYPE;
739: l_reverse_tc_flag fnd_profile_option_values.profile_option_value%TYPE;
740: l_fv_prepay_prof fnd_profile_option_values.profile_option_value%TYPE;
741: l_fv_prepay_defined BOOLEAN;
742: l_defined BOOLEAN;
743: l_reverse_tc_defined BOOLEAN;

Line 740: l_fv_prepay_prof fnd_profile_option_values.profile_option_value%TYPE;

736: l_status fnd_product_installations.status%TYPE;
737: l_industry fnd_profile_option_values.profile_option_value%TYPE;
738: l_value fnd_profile_option_values.profile_option_value%TYPE;
739: l_reverse_tc_flag fnd_profile_option_values.profile_option_value%TYPE;
740: l_fv_prepay_prof fnd_profile_option_values.profile_option_value%TYPE;
741: l_fv_prepay_defined BOOLEAN;
742: l_defined BOOLEAN;
743: l_reverse_tc_defined BOOLEAN;
744:

Line 3435: l_psa_max_lock_wait_count fnd_profile_option_values.profile_option_value%TYPE :=0;

3431: l_quarter_num gl_period_statuses.quarter_num%TYPE;
3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:
3434: resource_busy exception;
3435: l_psa_max_lock_wait_count fnd_profile_option_values.profile_option_value%TYPE :=0;
3436: l_psa_lock_wait_interval fnd_profile_option_values.profile_option_value%TYPE :=0;
3437: pragma exception_init(resource_busy, -54);
3438: -- ========================= FND LOG ===========================
3439: l_full_path VARCHAR2(100);

Line 3436: l_psa_lock_wait_interval fnd_profile_option_values.profile_option_value%TYPE :=0;

3432: l_period_year gl_period_statuses.period_year%TYPE;
3433:
3434: resource_busy exception;
3435: l_psa_max_lock_wait_count fnd_profile_option_values.profile_option_value%TYPE :=0;
3436: l_psa_lock_wait_interval fnd_profile_option_values.profile_option_value%TYPE :=0;
3437: pragma exception_init(resource_busy, -54);
3438: -- ========================= FND LOG ===========================
3439: l_full_path VARCHAR2(100);
3440: -- ========================= FND LOG ===========================