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_FP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_ROLLUP_TMP

Line 598: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP

594: AND l_rev_gen_method = 'C' THEN
595:
596: -- Bug 4549862: When generating a Cost and Revenue together version
597: -- from Staffing Plan with revenue accrual method of COST, the
598: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
599: -- table (instead of pa_budget_lines) earlier in the code flow by the
600: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
601: -- can be honored. We should not call the currency conversion API in
602: -- this case.

Line 1441: FROM pa_fp_rollup_tmp

1437: COST_REJECTION_CODE,
1438: BURDEN_REJECTION_CODE,
1439: REVENUE_REJECTION_CODE,
1440: COST_IND_COMPILED_SET_ID
1441: FROM pa_fp_rollup_tmp
1442: GROUP BY resource_assignment_id,
1443: txn_currency_code,
1444: start_date,
1445: end_date,

Line 1479: FROM pa_fp_rollup_tmp

1475: COST_REJECTION_CODE,
1476: BURDEN_REJECTION_CODE,
1477: REVENUE_REJECTION_CODE,
1478: NULL --COST_IND_COMPILED_SET_ID
1479: FROM pa_fp_rollup_tmp
1480: GROUP BY resource_assignment_id,
1481: txn_currency_code,
1482: COST_REJECTION_CODE,
1483: BURDEN_REJECTION_CODE,

Line 1514: FROM pa_fp_rollup_tmp tmp

1510: COST_REJECTION_CODE,
1511: BURDEN_REJECTION_CODE,
1512: REVENUE_REJECTION_CODE,
1513: NULL --COST_IND_COMPILED_SET_ID
1514: FROM pa_fp_rollup_tmp tmp
1515: GROUP BY resource_assignment_id,
1516: txn_currency_code,
1517: COST_REJECTION_CODE,
1518: BURDEN_REJECTION_CODE,

Line 1554: FROM pa_fp_rollup_tmp tmp

1550: COST_REJECTION_CODE,
1551: BURDEN_REJECTION_CODE,
1552: REVENUE_REJECTION_CODE,
1553: NULL --COST_IND_COMPILED_SET_ID
1554: FROM pa_fp_rollup_tmp tmp
1555: GROUP BY resource_assignment_id,
1556: txn_currency_code,
1557: COST_REJECTION_CODE,
1558: BURDEN_REJECTION_CODE,

Line 1571: FROM pa_fp_rollup_tmp tmp1,

1567: SELECT tmp1.resource_assignment_id,
1568: tmp1.start_date,
1569: tmp1.txn_currency_code,
1570: tmp1.revenue_rejection_code
1571: FROM pa_fp_rollup_tmp tmp1,
1572: pa_fp_rollup_tmp tmp2
1573: WHERE tmp2.txn_revenue IS NOT NULL
1574: AND tmp1.revenue_rejection_code IS NOT NULL
1575: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id

Line 1572: pa_fp_rollup_tmp tmp2

1568: tmp1.start_date,
1569: tmp1.txn_currency_code,
1570: tmp1.revenue_rejection_code
1571: FROM pa_fp_rollup_tmp tmp1,
1572: pa_fp_rollup_tmp tmp2
1573: WHERE tmp2.txn_revenue IS NOT NULL
1574: AND tmp1.revenue_rejection_code IS NOT NULL
1575: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
1576: AND tmp1.txn_currency_code = tmp2.txn_currency_code

Line 2041: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and

2037: -- Calculate API. Corresponds to p_fp_task_billable_flag_tab IN parameter.
2038: l_calc_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2039:
2040: -- Bug 4549862: Added counter to track unique budget_line_id values for
2041: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2042: -- then incremented by 1 prior to each Insert to the temp table.
2043: -- Note: these are not valid budget_line_id values in pa_budget_lines.
2044: -- Rather, we are using the column to index records for processing of
2045: -- cost-based revenue amounts, since an Index exists for the column.

Line 2085: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and

2081: ,p_debug_mode => p_pa_debug_mode);
2082: END IF;
2083:
2084: -- Bug 4549862: Added counter to track unique budget_line_id values for
2085: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2086: -- then incremented by 1 prior to each Insert to the temp table.
2087: l_bl_id_counter := 0;
2088:
2089: -- Bug 4549862: Moved initialization of l_rev_gen_method before

Line 2610: -- The goal is to populate the PA_FP_ROLLUP_TMP global temp table

2606:
2607: -- Bug 4549862: Modified IF condition so that the code also proceeds
2608: -- along the Rate API flow when target version is ALL and revenue
2609: -- accrual method is COST.
2610: -- The goal is to populate the PA_FP_ROLLUP_TMP global temp table
2611: -- with generation data and then let control return to the Budget
2612: -- or Forecast wrapper API without propagating data to the budget
2613: -- lines. The GEN_COST_BASED_REVENUE API will expect data in the
2614: -- temp table, which it will use to compute revenue amounts. The

Line 2618: -- lines should go to the PA_FP_ROLLUP_TMP table instead so that

2614: -- temp table, which it will use to compute revenue amounts. The
2615: -- cost-based revenue API will propagate data from the temp table
2616: -- to the budget lines. Before the cost-based revenue API is called
2617: -- (e.g. in GEN_COMMITMENT_AMOUNTS), inserts/updates to the budget
2618: -- lines should go to the PA_FP_ROLLUP_TMP table instead so that
2619: -- the cost-based revenue API has all of the necessary data in the
2620: -- temp table when it is called.
2621: -- Note: this info only applies when generating ALL versions from
2622: -- Staffing Plan with revenue accrual method of COST.

Line 2635: DELETE FROM pa_fp_rollup_tmp;

2631: p_module_name => l_module_name,
2632: p_log_level => 5);
2633: END IF;
2634:
2635: DELETE FROM pa_fp_rollup_tmp;
2636:
2637: FOR j IN 1..l_proj_assgn_id_tab.count LOOP
2638: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
2639: -- ||'):'||l_proj_res_assgn_id_tab(j)

Line 3360: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',

3356:
3357: IF p_pa_debug_mode = 'Y' THEN
3358: pa_fp_gen_amount_utils.fp_debug
3359: (p_called_mode => p_called_mode,
3360: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3361: p_module_name => l_module_name,
3362: p_log_level => 5);
3363: pa_fp_gen_amount_utils.fp_debug
3364: (p_called_mode => p_called_mode,

Line 3380: -- 5. Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code

3376: p_module_name => l_module_name,
3377: p_log_level => 5);
3378: END IF;
3379:
3380: -- 5. Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code
3381:
3382: -- Bug 4549862: Increment counter to a new unique id.
3383: l_bl_id_counter := l_bl_id_counter + 1;
3384:

Line 3389: INSERT INTO pa_fp_rollup_tmp(

3385: -- Bug 4549862: Added 2 additional columns to Insert statement (BUDGET_LINE_ID
3386: -- and BILLABLE_FLAG) for further processing by other APIs when generating
3387: -- ALL versions from Staffing Plan with revenue accrual method of COST.
3388:
3389: INSERT INTO pa_fp_rollup_tmp(
3390: RESOURCE_ASSIGNMENT_ID,
3391: START_DATE,
3392: END_DATE,
3393: PERIOD_NAME,

Line 3431: -- Bug 4549862: The PA_FP_ROLLUP_TMP global temp table has now

3427: END LOOP; -- FOR k in 1..l_rt_start_date_tab.COUNT LOOP
3428:
3429: END LOOP; -- FOR j IN 1..l_proj_assgn_id_tab.count LOOP
3430:
3431: -- Bug 4549862: The PA_FP_ROLLUP_TMP global temp table has now
3432: -- been populated with Txn generation data as well as rejection
3433: -- codes for raw cost, burden cost, and revenue.
3434: --
3435: -- If the revenue accrual method is COST, we should call the

Line 3447: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the

3443: IF l_rev_gen_method = 'C' THEN
3444:
3445: -- Bug 4549862: Call currency conversion API. Passing 'N' for
3446: -- the p_entire_version parameter tells to the API to convert
3447: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3448: -- PA_BUDGET_LINES table.
3449:
3450: IF p_pa_debug_mode = 'Y' THEN
3451: pa_fp_gen_amount_utils.fp_debug

Line 3505: FROM pa_fp_rollup_tmp

3501: BULK COLLECT INTO
3502: l_rej_code_ra_id_tab,
3503: l_rej_code_txn_currency_tab,
3504: l_rej_code_msg_name_tab
3505: FROM pa_fp_rollup_tmp
3506: WHERE cost_rejection_code is not null
3507: GROUP BY RESOURCE_ASSIGNMENT_ID,
3508: TXN_CURRENCY_CODE;
3509:

Line 3511: UPDATE pa_fp_rollup_tmp

3507: GROUP BY RESOURCE_ASSIGNMENT_ID,
3508: TXN_CURRENCY_CODE;
3509:
3510: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3511: UPDATE pa_fp_rollup_tmp
3512: SET TXN_RAW_COST = NULL,
3513: PROJECT_RAW_COST = NULL,
3514: PROJFUNC_RAW_COST = NULL,
3515: COST_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3527: FROM pa_fp_rollup_tmp

3523: BULK COLLECT INTO
3524: l_rej_code_ra_id_tab,
3525: l_rej_code_txn_currency_tab,
3526: l_rej_code_msg_name_tab
3527: FROM pa_fp_rollup_tmp
3528: WHERE burden_rejection_code is not null
3529: GROUP BY RESOURCE_ASSIGNMENT_ID,
3530: TXN_CURRENCY_CODE;
3531:

Line 3533: UPDATE pa_fp_rollup_tmp

3529: GROUP BY RESOURCE_ASSIGNMENT_ID,
3530: TXN_CURRENCY_CODE;
3531:
3532: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3533: UPDATE pa_fp_rollup_tmp
3534: SET TXN_BURDENED_COST = NULL,
3535: PROJECT_BURDENED_COST = NULL,
3536: PROJFUNC_BURDENED_COST = NULL,
3537: BURDEN_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3549: FROM pa_fp_rollup_tmp

3545: BULK COLLECT INTO
3546: l_rej_code_ra_id_tab,
3547: l_rej_code_txn_currency_tab,
3548: l_rej_code_msg_name_tab
3549: FROM pa_fp_rollup_tmp
3550: WHERE pc_cur_conv_rejection_code is not null
3551: GROUP BY RESOURCE_ASSIGNMENT_ID,
3552: TXN_CURRENCY_CODE;
3553:

Line 3555: UPDATE pa_fp_rollup_tmp

3551: GROUP BY RESOURCE_ASSIGNMENT_ID,
3552: TXN_CURRENCY_CODE;
3553:
3554: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3555: UPDATE pa_fp_rollup_tmp
3556: SET PROJECT_RAW_COST = NULL,
3557: PROJECT_BURDENED_COST = NULL,
3558: PROJECT_REVENUE = NULL,
3559: PC_CUR_CONV_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3571: FROM pa_fp_rollup_tmp

3567: BULK COLLECT INTO
3568: l_rej_code_ra_id_tab,
3569: l_rej_code_txn_currency_tab,
3570: l_rej_code_msg_name_tab
3571: FROM pa_fp_rollup_tmp
3572: WHERE pfc_cur_conv_rejection_code is not null
3573: GROUP BY RESOURCE_ASSIGNMENT_ID,
3574: TXN_CURRENCY_CODE;
3575:

Line 3577: UPDATE pa_fp_rollup_tmp

3573: GROUP BY RESOURCE_ASSIGNMENT_ID,
3574: TXN_CURRENCY_CODE;
3575:
3576: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3577: UPDATE pa_fp_rollup_tmp
3578: SET PROJFUNC_RAW_COST = NULL,
3579: PROJFUNC_BURDENED_COST = NULL,
3580: PROJFUNC_REVENUE = NULL,
3581: PFC_CUR_CONV_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3595: FROM pa_fp_rollup_tmp

3591: BULK COLLECT INTO
3592: l_rej_code_ra_id_tab,
3593: l_rej_code_txn_currency_tab,
3594: l_rej_code_msg_name_tab
3595: FROM pa_fp_rollup_tmp
3596: WHERE cost_rejection_code is not null
3597: GROUP BY RESOURCE_ASSIGNMENT_ID,
3598: TXN_CURRENCY_CODE;
3599:

Line 3601: UPDATE pa_fp_rollup_tmp

3597: GROUP BY RESOURCE_ASSIGNMENT_ID,
3598: TXN_CURRENCY_CODE;
3599:
3600: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3601: UPDATE pa_fp_rollup_tmp
3602: SET TXN_RAW_COST = NULL,
3603: COST_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3604: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3605: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

Line 3615: FROM pa_fp_rollup_tmp

3611: BULK COLLECT INTO
3612: l_rej_code_ra_id_tab,
3613: l_rej_code_txn_currency_tab,
3614: l_rej_code_msg_name_tab
3615: FROM pa_fp_rollup_tmp
3616: WHERE burden_rejection_code is not null
3617: GROUP BY RESOURCE_ASSIGNMENT_ID,
3618: TXN_CURRENCY_CODE;
3619:

Line 3621: UPDATE pa_fp_rollup_tmp

3617: GROUP BY RESOURCE_ASSIGNMENT_ID,
3618: TXN_CURRENCY_CODE;
3619:
3620: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3621: UPDATE pa_fp_rollup_tmp
3622: SET TXN_BURDENED_COST = NULL,
3623: BURDEN_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3624: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3625: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

Line 3639: FROM pa_fp_rollup_tmp

3635: BULK COLLECT INTO
3636: l_rej_code_ra_id_tab,
3637: l_rej_code_txn_currency_tab,
3638: l_rej_code_msg_name_tab
3639: FROM pa_fp_rollup_tmp
3640: WHERE revenue_rejection_code is not null
3641: GROUP BY RESOURCE_ASSIGNMENT_ID,
3642: TXN_CURRENCY_CODE;
3643:

Line 3645: UPDATE pa_fp_rollup_tmp

3641: GROUP BY RESOURCE_ASSIGNMENT_ID,
3642: TXN_CURRENCY_CODE;
3643:
3644: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3645: UPDATE pa_fp_rollup_tmp
3646: SET TXN_REVENUE = NULL,
3647: REVENUE_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3648: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3649: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

Line 3660: -- finish processing the data in PA_FP_ROLLUP_TMP and write

3656: IF l_rev_gen_method = 'C' THEN
3657:
3658: -- Bug 4549862: Returning control to the Budget or Forecast
3659: -- wrapper API, which will call GEN_COST_BASED_REVENUE to
3660: -- finish processing the data in PA_FP_ROLLUP_TMP and write
3661: -- it to the budget lines.
3662:
3663: RETURN;
3664:

Line 3683: UPDATE pa_fp_rollup_tmp

3679: CLOSE FIND_REJECTION_CODE;
3680:
3681: FOR m IN 1..l_rej_res_assignment_id_tab.COUNT LOOP
3682:
3683: UPDATE pa_fp_rollup_tmp
3684: SET TXN_REVENUE = NULL,
3685: REVENUE_REJECTION_CODE = l_rej_revenue_rej_code_tab(m)
3686: WHERE resource_assignment_id = l_rej_res_assignment_id_tab(m)
3687: AND start_date = l_rej_start_date_tab(m)

Line 3767: -- should continue to fetch pa_fp_rollup_tmp data using the

3763:
3764: ELSE
3765:
3766: -- Bug 4615787: When the Target is timephased by PA or GL, we
3767: -- should continue to fetch pa_fp_rollup_tmp data using the
3768: -- GROUP_TO_INSERT_INTO_PA_GL_BL cursor. When the Target is None
3769: -- timephased, use the new GROUP_TO_INSERT_INTO_PA_GL_BL cursor
3770: -- instead so that only a single record is fetched for each
3771: -- (Resource Assignment Id, Txn Currency) combination.