eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BURDEN_COSTING dependencies on PA_UTILS

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 1469: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);

1465: end if; -- profile option
1466:
1467: /* Introduced Caching for deriving weekend date for Bug# 5406802 */
1468: IF prev_bcc_rec.source_exp_item_date IS NULL THEN
1469: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1470: ELSE
1471: l_prev_next_weekend_date := l_next_weekend_date;
1472: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1473: END IF;

Line 1472: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);

1468: IF prev_bcc_rec.source_exp_item_date IS NULL THEN
1469: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1470: ELSE
1471: l_prev_next_weekend_date := l_next_weekend_date;
1472: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1473: END IF;
1474:
1475: /* Changed the if condition for Bug# 5406802 */
1476: if ( bcc_rec.source_org_id = prev_bcc_rec.source_org_id

Line 1544: x_expend_ending => pa_utils.NewGetWeekEnding((bcc_rec.source_exp_item_date)), --Bug 2236707,3551106

1540: END IF;
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,

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 1680: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )

1676: end if;
1677: end if;
1678:
1679: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
1680: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1681: THEN
1682: IF P_DEBUG_MODE THEN
1683: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||
1684: to_char(over_project_id) ||

Line 1688: l_work_type_id := pa_utils4.Get_work_type_id

1684: to_char(over_project_id) ||
1685: '] task_id [' || to_char(over_task_id) || ']');
1686: END IF;
1687:
1688: l_work_type_id := pa_utils4.Get_work_type_id
1689: ( p_project_id => over_project_id
1690: ,p_task_id => over_task_id
1691: ,p_assignment_id => NULL
1692: );

Line 1804: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )

1800: * AddEi Attributes - related change.
1801: * Deriving work_type_id.
1802: */
1803: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
1804: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1805: THEN
1806: IF P_DEBUG_MODE THEN
1807: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||
1808: to_char(over_project_id) ||

Line 1812: l_work_type_id := pa_utils4.Get_work_type_id

1808: to_char(over_project_id) ||
1809: '] task_id [' || to_char(over_task_id) || ']');
1810: END IF;
1811:
1812: l_work_type_id := pa_utils4.Get_work_type_id
1813: ( p_project_id => over_project_id
1814: ,p_task_id => over_task_id
1815: ,p_assignment_id => NULL
1816: );

Line 1843: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),

1839: x_expenditure_item_id =>exp_item_id,
1840: x_expenditure_id =>x_exp_id,
1841: x_expenditure_item_date
1842: =>prev_bcc_rec.source_exp_item_date ,
1843: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),
1844: x_project_id => over_project_id, -- NULL, bugfix: 2201207
1845: x_task_id =>over_task_id ,
1846: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,
1847: x_non_labor_resource =>prev_bcc_rec.source_nl_resource, -- 4057874

Line 2202: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )

2198: select pa_expenditure_items_s.nextval
2199: into exp_item_id from dual;
2200:
2201: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2202: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2203: THEN
2204: IF P_DEBUG_MODE THEN
2205: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2206: to_char(over_project_id) ||

Line 2209: l_work_type_id := pa_utils4.Get_work_type_id

2205: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2206: to_char(over_project_id) ||
2207: '] task_id [' || to_char(over_task_id) || ']');
2208: END IF;
2209: l_work_type_id := pa_utils4.Get_work_type_id
2210: ( p_project_id => over_project_id
2211: ,p_task_id => over_task_id
2212: ,p_assignment_id => NULL
2213: );

Line 2305: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )

2301: * AddEi Attributes - related change.
2302: * Deriving work_type_id.
2303: */
2304: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
2305: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2306: THEN
2307: IF P_DEBUG_MODE THEN
2308: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2309: to_char(over_project_id) ||

Line 2312: l_work_type_id := pa_utils4.Get_work_type_id

2308: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2309: to_char(over_project_id) ||
2310: '] task_id [' || to_char(over_task_id) || ']');
2311: END IF;
2312: l_work_type_id := pa_utils4.Get_work_type_id
2313: ( p_project_id => over_project_id
2314: ,p_task_id => over_task_id
2315: ,p_assignment_id => NULL
2316: );

Line 2342: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),

2338: x_expenditure_item_id =>exp_item_id,
2339: x_expenditure_id =>x_exp_id,
2340: x_expenditure_item_date
2341: =>prev_bcc_rec.source_exp_item_date ,
2342: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),
2343: x_project_id => over_project_id , --bugfix: 2201207 NULL,
2344: x_task_id =>over_task_id ,
2345: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,
2346: x_non_labor_resource =>prev_bcc_rec.source_nl_resource, -- 4057874

Line 2869: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);

2865: from dual;
2866:
2867: -- Getting expenditure_item_date as the end_date for that pa period
2868: stage := 235; -- Getting expenditure_item_date
2869: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
2870: -- Getting GL period from the view itself
2871: stage := 240; -- creating transactions
2872: insert into pa_commitment_txns (
2873: cmt_line_id,

Line 3065: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);

3061: from dual;
3062:
3063: -- Getting expenditure_item_date as the end_date for that pa period
3064: stage := 245; -- Getting expenditure_item_date
3065: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3066: -- create summarized commitment transaction
3067: insert into pa_commitment_txns (
3068: cmt_line_id,
3069: project_id,

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: