DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on FND_PROFILE

Line 18: P_BTC_SRC_RESRC varchar2(1) := NVL(FND_PROFILE.value('PA_RPT_BTC_SRC_RESRC'), 'N'); -- 4057874

14: current_sponsored_flag gms_project_types.sponsored_flag%TYPE := 'N' ;
15:
16: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode ;
17:
18: P_BTC_SRC_RESRC varchar2(1) := NVL(FND_PROFILE.value('PA_RPT_BTC_SRC_RESRC'), 'N'); -- 4057874
19: G_MOAC_ORG_ID NUMBER ;
20:
21: -- ======
22: -- Bug : 3699045 - PJ.M:B4:P13:OTH:PERF:XPL PERFORMANCE ISSUES IN PAVW341.SQL

Line 496: --l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/

492: /*2933915 :Caching the value of user_id and burden profile */
493:
494: l_user_id:=FND_GLOBAL.USER_ID();
495:
496: --l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
497: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
498:
499: -- Step 1 . Select All projects
500:

Line 544: FND_PROFILE.GET('PA_NUM_CDL_PER_SET', l_profile_set_size );

540: /*
541: * Bug#2255068
542: * Select the profile set size for CDLs per batch.
543: */
544: FND_PROFILE.GET('PA_NUM_CDL_PER_SET', l_profile_set_size );
545: IF ( NVL(l_profile_set_size, 0) = 0 )
546: THEN
547: l_profile_set_size := l_default_set_size ;
548: END IF;

Line 1086: , decode(NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N'),'N',nvl(ei.prvdr_accrual_date,ei.expenditure_item_date),ei.expenditure_item_date),

1082: , ei.attribute8 , ei.attribute9 , ei.attribute10
1083: , ei.attribute_category , l_person_type_tbl(i) , ei.po_line_id
1084: , ei.system_linkage_function , ei.expenditure_type , cdl.ind_compiled_set_id
1085: , cdl.prev_ind_compiled_set_id , ei.expenditure_item_id , cdl.line_num
1086: , decode(NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N'),'N',nvl(ei.prvdr_accrual_date,ei.expenditure_item_date),ei.expenditure_item_date),
1087: cdl.amount , cdl.projfunc_currency_code
1088: , cdl.denom_raw_cost , cdl.denom_currency_code , cdl.acct_raw_cost
1089: , cdl.acct_currency_code , cdl.project_raw_cost , cdl.project_currency_code
1090: , current_run_id , cdl.burden_sum_rejection_code , cdl.system_reference1

Line 3355: FND_PROFILE.GET('PA_NUM_CDL_PER_SET', l_profile_set_size );

3351:
3352: BEGIN
3353: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
3354: l_program_application_id := FND_GLOBAL.PROG_APPL_ID();
3355: FND_PROFILE.GET('PA_NUM_CDL_PER_SET', l_profile_set_size );
3356: x_status := 0;
3357:
3358: FORALL i in 1..l_tbl_eiid.count
3359: INSERT INTO pa_aud_cost_dist_lines (

Line 3448: , decode(NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N'),'N',nvl(ei.prvdr_accrual_date,ei.expenditure_item_date),ei.expenditure_item_date)

3444: , ei.attribute8 , ei.attribute9 , ei.attribute10
3445: , ei.attribute_category , e.person_type , ei.po_line_id
3446: , ei.system_linkage_function , ei.expenditure_type , cdl.ind_compiled_set_id
3447: , cdl.prev_ind_compiled_set_id , ei.expenditure_item_id , cdl.line_num
3448: , decode(NVL(fnd_profile.value_specific('PA_REVENUE_ORIGINAL_RATE_FORRECALC'),'N'),'N',nvl(ei.prvdr_accrual_date,ei.expenditure_item_date),ei.expenditure_item_date)
3449: , cdl.amount , cdl.projfunc_currency_code
3450: , cdl.denom_raw_cost , cdl.denom_currency_code , cdl.acct_raw_cost
3451: , cdl.acct_currency_code , cdl.project_raw_cost , cdl.project_currency_code
3452: , cdl.burden_sum_source_run_id , cdl.burden_sum_rejection_code , cdl.system_reference1