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

1600: end if; -- profile option
1601:
1602: /* Introduced Caching for deriving weekend date for Bug# 5406802 */
1603: IF prev_bcc_rec.source_exp_item_date IS NULL THEN
1604: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1605: ELSE
1606: l_prev_next_weekend_date := l_next_weekend_date;
1607: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1608: END IF;

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

1603: IF prev_bcc_rec.source_exp_item_date IS NULL THEN
1604: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1605: ELSE
1606: l_prev_next_weekend_date := l_next_weekend_date;
1607: l_next_weekend_date := pa_utils.NewGetWeekEnding(bcc_rec.source_exp_item_date);
1608: END IF;
1609:
1610: /* Changed the if condition for Bug# 5406802 */
1611: if ( bcc_rec.source_org_id = prev_bcc_rec.source_org_id

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

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

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

1815: end if;
1816: end if;
1817:
1818: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
1819: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1820: THEN
1821: IF P_DEBUG_MODE THEN
1822: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||
1823: to_char(over_project_id) ||

Line 1827: l_work_type_id := pa_utils4.Get_work_type_id

1823: to_char(over_project_id) ||
1824: '] task_id [' || to_char(over_task_id) || ']');
1825: END IF;
1826:
1827: l_work_type_id := pa_utils4.Get_work_type_id
1828: ( p_project_id => over_project_id
1829: ,p_task_id => over_task_id
1830: ,p_assignment_id => NULL
1831: );

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

1939: * AddEi Attributes - related change.
1940: * Deriving work_type_id.
1941: */
1942: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
1943: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1944: THEN
1945: IF P_DEBUG_MODE THEN
1946: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||
1947: to_char(over_project_id) ||

Line 1951: l_work_type_id := pa_utils4.Get_work_type_id

1947: to_char(over_project_id) ||
1948: '] task_id [' || to_char(over_task_id) || ']');
1949: END IF;
1950:
1951: l_work_type_id := pa_utils4.Get_work_type_id
1952: ( p_project_id => over_project_id
1953: ,p_task_id => over_task_id
1954: ,p_assignment_id => NULL
1955: );

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

1978: x_expenditure_item_id =>exp_item_id,
1979: x_expenditure_id =>x_exp_id,
1980: x_expenditure_item_date
1981: =>prev_bcc_rec.source_exp_item_date ,
1982: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),
1983: x_project_id => over_project_id, -- NULL, bugfix: 2201207
1984: x_task_id =>over_task_id ,
1985: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,
1986: x_non_labor_resource =>prev_bcc_rec.source_nl_resource, -- 4057874

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

2340: select pa_expenditure_items_s.nextval
2341: into exp_item_id from dual;
2342:
2343: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2344: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2345: THEN
2346: IF P_DEBUG_MODE THEN
2347: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2348: to_char(over_project_id) ||

Line 2351: l_work_type_id := pa_utils4.Get_work_type_id

2347: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2348: to_char(over_project_id) ||
2349: '] task_id [' || to_char(over_task_id) || ']');
2350: END IF;
2351: l_work_type_id := pa_utils4.Get_work_type_id
2352: ( p_project_id => over_project_id
2353: ,p_task_id => over_task_id
2354: ,p_assignment_id => NULL
2355: );

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

2443: * AddEi Attributes - related change.
2444: * Deriving work_type_id.
2445: */
2446: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
2447: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2448: THEN
2449: IF P_DEBUG_MODE THEN
2450: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2451: to_char(over_project_id) ||

Line 2454: l_work_type_id := pa_utils4.Get_work_type_id

2450: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2451: to_char(over_project_id) ||
2452: '] task_id [' || to_char(over_task_id) || ']');
2453: END IF;
2454: l_work_type_id := pa_utils4.Get_work_type_id
2455: ( p_project_id => over_project_id
2456: ,p_task_id => over_task_id
2457: ,p_assignment_id => NULL
2458: );

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

2480: x_expenditure_item_id =>exp_item_id,
2481: x_expenditure_id =>x_exp_id,
2482: x_expenditure_item_date
2483: =>prev_bcc_rec.source_exp_item_date ,
2484: -- for 1664962 pa_utils.GetWeekEnding((prev_bcc_rec.source_pa_date)-6),
2485: x_project_id => over_project_id , --bugfix: 2201207 NULL,
2486: x_task_id =>over_task_id ,
2487: x_expenditure_type =>prev_bcc_rec.source_ind_expenditure_type,
2488: x_non_labor_resource =>prev_bcc_rec.source_nl_resource, -- 4057874

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

3009: from dual;
3010:
3011: -- Getting expenditure_item_date as the end_date for that pa period
3012: stage := 235; -- Getting expenditure_item_date
3013: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3014: -- Getting GL period from the view itself
3015: stage := 240; -- creating transactions
3016: insert into pa_commitment_txns (
3017: cmt_line_id,

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

3205: from dual;
3206:
3207: -- Getting expenditure_item_date as the end_date for that pa period
3208: stage := 245; -- Getting expenditure_item_date
3209: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3210: -- create summarized commitment transaction
3211: insert into pa_commitment_txns (
3212: cmt_line_id,
3213: project_id,

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: )