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 500: --l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/

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

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

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

Line 1057: , 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),

1053: , ei.attribute8 , ei.attribute9 , ei.attribute10
1054: , ei.attribute_category , l_person_type_tbl(i) , ei.po_line_id
1055: , ei.system_linkage_function , ei.expenditure_type , cdl.ind_compiled_set_id
1056: , cdl.prev_ind_compiled_set_id , ei.expenditure_item_id , cdl.line_num
1057: , 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),
1058: cdl.amount , cdl.projfunc_currency_code
1059: , cdl.denom_raw_cost , cdl.denom_currency_code , cdl.acct_raw_cost
1060: , cdl.acct_currency_code , cdl.project_raw_cost , cdl.project_currency_code
1061: , current_run_id , cdl.burden_sum_rejection_code , cdl.system_reference1

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

3207:
3208: BEGIN
3209: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
3210: l_program_application_id := FND_GLOBAL.PROG_APPL_ID();
3211: FND_PROFILE.GET('PA_NUM_CDL_PER_SET', l_profile_set_size );
3212: x_status := 0;
3213:
3214: FORALL i in 1..l_tbl_eiid.count
3215: INSERT INTO pa_aud_cost_dist_lines (

Line 3300: , 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)

3296: , ei.attribute8 , ei.attribute9 , ei.attribute10
3297: , ei.attribute_category , e.person_type , ei.po_line_id
3298: , ei.system_linkage_function , ei.expenditure_type , cdl.ind_compiled_set_id
3299: , cdl.prev_ind_compiled_set_id , ei.expenditure_item_id , cdl.line_num
3300: , 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)
3301: , cdl.amount , cdl.projfunc_currency_code
3302: , cdl.denom_raw_cost , cdl.denom_currency_code , cdl.acct_raw_cost
3303: , cdl.acct_currency_code , cdl.project_raw_cost , cdl.project_currency_code
3304: , cdl.burden_sum_source_run_id , cdl.burden_sum_rejection_code , cdl.system_reference1