DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_UTILS2

Line 497: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

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

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

1074: )
1075: select
1076: cdl.project_id ,cdl.task_id ,l_org_id_tbl(i)
1077: ,cdl.pa_date ,decode(cdl.prev_ind_compiled_set_id, null, cdl.pa_period_name
1078: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))
1079: , ei.attribute1
1080: , ei.attribute2 , ei.attribute3 , ei.attribute4
1081: , ei.attribute5 , ei.attribute6 , ei.attribute7
1082: , ei.attribute8 , ei.attribute9 , ei.attribute10

Line 1113: --pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ); modified as part of 12331962

1109: AND cdl.project_id = current_project_id
1110: AND cdl.burden_sum_rejection_code is NULL
1111: AND cdl.line_type = 'R'
1112: AND ( ei.transaction_source IS NULL or
1113: --pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ); modified as part of 12331962
1114: 'Y' <> ( SELECT allow_burden_flag
1115: FROM pa_transaction_sources pts
1116: WHERE pts.transaction_source = ei.transaction_source
1117: )

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

1677: pa_transactions.InsertExp(
1678: x_expenditure_id =>exp_id,
1679: x_expend_status =>'APPROVED',
1680: x_expend_ending => pa_utils.NewGetWeekEnding((bcc_rec.source_exp_item_date)), --Bug 2236707,3551106
1681: -- x_expend_ending =>pa_utils.NewGetWeekEnding(pa_utils2.get_pa_period_end_date_OU(bcc_rec.source_pa_date)-6), -- Bug 2933915,3551106
1682: x_expend_class => 'BT',
1683: x_inc_by_person => bcc_rec.source_incurred_by_person_id, -- 4057874
1684: x_inc_by_org => bcc_rec.source_org_id,
1685: x_expend_group => exp_group,

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

3437: ,cdl.task_id
3438: ,nvl(ei.override_to_organization_id,e.incurred_by_organization_id)
3439: ,cdl.pa_date
3440: ,decode(cdl.prev_ind_compiled_set_id, null, cdl.pa_period_name
3441: ,nvl(pa_utils2.get_pa_period_name(ei.expenditure_item_date, ei.org_id), cdl.pa_period_name))
3442: , ei.attribute1 , ei.attribute2 , ei.attribute3 , ei.attribute4
3443: , ei.attribute5 , ei.attribute6 , ei.attribute7
3444: , ei.attribute8 , ei.attribute9 , ei.attribute10
3445: , ei.attribute_category , e.person_type , ei.po_line_id

Line 3480: --pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ); modified as part of 12331962

3476: AND cdl.burden_sum_rejection_code is NULL
3477: AND cdl.prev_ind_compiled_set_id IS NULL
3478: AND ei.expenditure_item_date <= nvl(l_end_date,ei.expenditure_item_date)
3479: AND ( ei.transaction_source IS NULL or
3480: --pa_utils2.get_ts_allow_burden_flag(ei.transaction_source)<>'Y' ); modified as part of 12331962
3481: 'Y' <> ( SELECT allow_burden_flag
3482: FROM pa_transaction_sources pts
3483: WHERE pts.transaction_source = ei.transaction_source
3484: )