DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_UTILS2

Line 501: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

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:
505: if pa_cc_utils.g_debug_mode then

Line 1049: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))

1045: ,PROJFUNC_COST_EXCHANGE_RATE)
1046: select
1047: cdl.project_id ,cdl.task_id ,l_org_id_tbl(i)
1048: ,cdl.pa_date ,decode(cdl.prev_ind_compiled_set_id, null, cdl.pa_period_name
1049: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))
1050: , ei.attribute1
1051: , ei.attribute2 , ei.attribute3 , ei.attribute4
1052: , ei.attribute5 , ei.attribute6 , ei.attribute7
1053: , ei.attribute8 , ei.attribute9 , ei.attribute10

Line 1083: or pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' );

1079: AND cdl.project_id = current_project_id
1080: AND cdl.burden_sum_rejection_code is NULL
1081: AND cdl.line_type = 'R'
1082: AND ( ei.transaction_source IS NULL
1083: or pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' );
1084:
1085: --InsertIntoDummy (' After inserting into global temp ');
1086:
1087:

Line 1545: -- x_expend_ending =>pa_utils.NewGetWeekEnding(pa_utils2.get_pa_period_end_date_OU(bcc_rec.source_pa_date)-6), -- Bug 2933915,3551106

1541: pa_transactions.InsertExp(
1542: x_expenditure_id =>exp_id,
1543: x_expend_status =>'APPROVED',
1544: x_expend_ending => pa_utils.NewGetWeekEnding((bcc_rec.source_exp_item_date)), --Bug 2236707,3551106
1545: -- x_expend_ending =>pa_utils.NewGetWeekEnding(pa_utils2.get_pa_period_end_date_OU(bcc_rec.source_pa_date)-6), -- Bug 2933915,3551106
1546: x_expend_class => 'BT',
1547: x_inc_by_person => bcc_rec.source_incurred_by_person_id, -- 4057874
1548: x_inc_by_org => bcc_rec.source_org_id,
1549: x_expend_group => exp_group,

Line 3293: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))

3289: ,cdl.task_id
3290: ,nvl(ei.override_to_organization_id,e.incurred_by_organization_id)
3291: ,cdl.pa_date
3292: ,decode(cdl.prev_ind_compiled_set_id, null, cdl.pa_period_name
3293: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))
3294: , ei.attribute1 , ei.attribute2 , ei.attribute3 , ei.attribute4
3295: , ei.attribute5 , ei.attribute6 , ei.attribute7
3296: , ei.attribute8 , ei.attribute9 , ei.attribute10
3297: , ei.attribute_category , e.person_type , ei.po_line_id

Line 3330: AND ( ei.transaction_source IS NULL or pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ));

3326: AND nvl(ei.adjustment_type,'-999') <> 'BURDEN_RESUMMARIZE' /*Bug# 6449677*/
3327: AND cdl.burden_sum_rejection_code is NULL
3328: AND cdl.prev_ind_compiled_set_id IS NULL
3329: AND ei.expenditure_item_date <= nvl(l_end_date,ei.expenditure_item_date)
3330: AND ( ei.transaction_source IS NULL or pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ));
3331:
3332:
3333: IF SQL%ROWCOUNT > 0 THEN
3334: