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 586: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP

582: AND l_rev_gen_method = 'C' THEN
583:
584: -- Bug 4549862: When generating a Cost and Revenue together version
585: -- from Staffing Plan with revenue accrual method of COST, the
586: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
587: -- table (instead of pa_budget_lines) earlier in the code flow by the
588: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
589: -- can be honored. We should not call the currency conversion API in
590: -- this case.

Line 1429: FROM pa_fp_rollup_tmp

1425: COST_REJECTION_CODE,
1426: BURDEN_REJECTION_CODE,
1427: REVENUE_REJECTION_CODE,
1428: COST_IND_COMPILED_SET_ID
1429: FROM pa_fp_rollup_tmp
1430: GROUP BY resource_assignment_id,
1431: txn_currency_code,
1432: start_date,
1433: end_date,

Line 1467: FROM pa_fp_rollup_tmp

1463: COST_REJECTION_CODE,
1464: BURDEN_REJECTION_CODE,
1465: REVENUE_REJECTION_CODE,
1466: NULL --COST_IND_COMPILED_SET_ID
1467: FROM pa_fp_rollup_tmp
1468: GROUP BY resource_assignment_id,
1469: txn_currency_code,
1470: COST_REJECTION_CODE,
1471: BURDEN_REJECTION_CODE,

Line 1502: FROM pa_fp_rollup_tmp tmp

1498: COST_REJECTION_CODE,
1499: BURDEN_REJECTION_CODE,
1500: REVENUE_REJECTION_CODE,
1501: NULL --COST_IND_COMPILED_SET_ID
1502: FROM pa_fp_rollup_tmp tmp
1503: GROUP BY resource_assignment_id,
1504: txn_currency_code,
1505: COST_REJECTION_CODE,
1506: BURDEN_REJECTION_CODE,

Line 1542: FROM pa_fp_rollup_tmp tmp

1538: COST_REJECTION_CODE,
1539: BURDEN_REJECTION_CODE,
1540: REVENUE_REJECTION_CODE,
1541: NULL --COST_IND_COMPILED_SET_ID
1542: FROM pa_fp_rollup_tmp tmp
1543: GROUP BY resource_assignment_id,
1544: txn_currency_code,
1545: COST_REJECTION_CODE,
1546: BURDEN_REJECTION_CODE,

Line 1559: FROM pa_fp_rollup_tmp tmp1,

1555: SELECT tmp1.resource_assignment_id,
1556: tmp1.start_date,
1557: tmp1.txn_currency_code,
1558: tmp1.revenue_rejection_code
1559: FROM pa_fp_rollup_tmp tmp1,
1560: pa_fp_rollup_tmp tmp2
1561: WHERE tmp2.txn_revenue IS NOT NULL
1562: AND tmp1.revenue_rejection_code IS NOT NULL
1563: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id

Line 1560: pa_fp_rollup_tmp tmp2

1556: tmp1.start_date,
1557: tmp1.txn_currency_code,
1558: tmp1.revenue_rejection_code
1559: FROM pa_fp_rollup_tmp tmp1,
1560: pa_fp_rollup_tmp tmp2
1561: WHERE tmp2.txn_revenue IS NOT NULL
1562: AND tmp1.revenue_rejection_code IS NOT NULL
1563: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
1564: AND tmp1.txn_currency_code = tmp2.txn_currency_code

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

2025: -- Calculate API. Corresponds to p_fp_task_billable_flag_tab IN parameter.
2026: l_calc_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2027:
2028: -- Bug 4549862: Added counter to track unique budget_line_id values for
2029: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2030: -- then incremented by 1 prior to each Insert to the temp table.
2031: -- Note: these are not valid budget_line_id values in pa_budget_lines.
2032: -- Rather, we are using the column to index records for processing of
2033: -- cost-based revenue amounts, since an Index exists for the column.

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

2069: ,p_debug_mode => p_pa_debug_mode);
2070: END IF;
2071:
2072: -- Bug 4549862: Added counter to track unique budget_line_id values for
2073: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2074: -- then incremented by 1 prior to each Insert to the temp table.
2075: l_bl_id_counter := 0;
2076:
2077: -- Bug 4549862: Moved initialization of l_rev_gen_method before

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

2594:
2595: -- Bug 4549862: Modified IF condition so that the code also proceeds
2596: -- along the Rate API flow when target version is ALL and revenue
2597: -- accrual method is COST.
2598: -- The goal is to populate the PA_FP_ROLLUP_TMP global temp table
2599: -- with generation data and then let control return to the Budget
2600: -- or Forecast wrapper API without propagating data to the budget
2601: -- lines. The GEN_COST_BASED_REVENUE API will expect data in the
2602: -- temp table, which it will use to compute revenue amounts. The

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

2602: -- temp table, which it will use to compute revenue amounts. The
2603: -- cost-based revenue API will propagate data from the temp table
2604: -- to the budget lines. Before the cost-based revenue API is called
2605: -- (e.g. in GEN_COMMITMENT_AMOUNTS), inserts/updates to the budget
2606: -- lines should go to the PA_FP_ROLLUP_TMP table instead so that
2607: -- the cost-based revenue API has all of the necessary data in the
2608: -- temp table when it is called.
2609: -- Note: this info only applies when generating ALL versions from
2610: -- Staffing Plan with revenue accrual method of COST.

Line 2623: DELETE FROM pa_fp_rollup_tmp;

2619: p_module_name => l_module_name,
2620: p_log_level => 5);
2621: END IF;
2622:
2623: DELETE FROM pa_fp_rollup_tmp;
2624:
2625: FOR j IN 1..l_proj_assgn_id_tab.count LOOP
2626: --dbms_output.put_line('before cursor:l_proj_res_assgn_id_tab('||j
2627: -- ||'):'||l_proj_res_assgn_id_tab(j)

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

3344:
3345: IF p_pa_debug_mode = 'Y' THEN
3346: pa_fp_gen_amount_utils.fp_debug
3347: (p_called_mode => p_called_mode,
3348: p_msg => 'Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code',
3349: p_module_name => l_module_name,
3350: p_log_level => 5);
3351: pa_fp_gen_amount_utils.fp_debug
3352: (p_called_mode => p_called_mode,

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

3364: p_module_name => l_module_name,
3365: p_log_level => 5);
3366: END IF;
3367:
3368: -- 5. Populate temporary table (pa_fp_rollup_tmp) with rates and rejection code
3369:
3370: -- Bug 4549862: Increment counter to a new unique id.
3371: l_bl_id_counter := l_bl_id_counter + 1;
3372:

Line 3377: INSERT INTO pa_fp_rollup_tmp(

3373: -- Bug 4549862: Added 2 additional columns to Insert statement (BUDGET_LINE_ID
3374: -- and BILLABLE_FLAG) for further processing by other APIs when generating
3375: -- ALL versions from Staffing Plan with revenue accrual method of COST.
3376:
3377: INSERT INTO pa_fp_rollup_tmp(
3378: RESOURCE_ASSIGNMENT_ID,
3379: START_DATE,
3380: END_DATE,
3381: PERIOD_NAME,

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

3415: END LOOP; -- FOR k in 1..l_rt_start_date_tab.COUNT LOOP
3416:
3417: END LOOP; -- FOR j IN 1..l_proj_assgn_id_tab.count LOOP
3418:
3419: -- Bug 4549862: The PA_FP_ROLLUP_TMP global temp table has now
3420: -- been populated with Txn generation data as well as rejection
3421: -- codes for raw cost, burden cost, and revenue.
3422: --
3423: -- If the revenue accrual method is COST, we should call the

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

3431: IF l_rev_gen_method = 'C' THEN
3432:
3433: -- Bug 4549862: Call currency conversion API. Passing 'N' for
3434: -- the p_entire_version parameter tells to the API to convert
3435: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3436: -- PA_BUDGET_LINES table.
3437:
3438: IF p_pa_debug_mode = 'Y' THEN
3439: pa_fp_gen_amount_utils.fp_debug

Line 3493: FROM pa_fp_rollup_tmp

3489: BULK COLLECT INTO
3490: l_rej_code_ra_id_tab,
3491: l_rej_code_txn_currency_tab,
3492: l_rej_code_msg_name_tab
3493: FROM pa_fp_rollup_tmp
3494: WHERE cost_rejection_code is not null
3495: GROUP BY RESOURCE_ASSIGNMENT_ID,
3496: TXN_CURRENCY_CODE;
3497:

Line 3499: UPDATE pa_fp_rollup_tmp

3495: GROUP BY RESOURCE_ASSIGNMENT_ID,
3496: TXN_CURRENCY_CODE;
3497:
3498: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3499: UPDATE pa_fp_rollup_tmp
3500: SET TXN_RAW_COST = NULL,
3501: PROJECT_RAW_COST = NULL,
3502: PROJFUNC_RAW_COST = NULL,
3503: COST_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3515: FROM pa_fp_rollup_tmp

3511: BULK COLLECT INTO
3512: l_rej_code_ra_id_tab,
3513: l_rej_code_txn_currency_tab,
3514: l_rej_code_msg_name_tab
3515: FROM pa_fp_rollup_tmp
3516: WHERE burden_rejection_code is not null
3517: GROUP BY RESOURCE_ASSIGNMENT_ID,
3518: TXN_CURRENCY_CODE;
3519:

Line 3521: UPDATE pa_fp_rollup_tmp

3517: GROUP BY RESOURCE_ASSIGNMENT_ID,
3518: TXN_CURRENCY_CODE;
3519:
3520: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3521: UPDATE pa_fp_rollup_tmp
3522: SET TXN_BURDENED_COST = NULL,
3523: PROJECT_BURDENED_COST = NULL,
3524: PROJFUNC_BURDENED_COST = NULL,
3525: BURDEN_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3537: FROM pa_fp_rollup_tmp

3533: BULK COLLECT INTO
3534: l_rej_code_ra_id_tab,
3535: l_rej_code_txn_currency_tab,
3536: l_rej_code_msg_name_tab
3537: FROM pa_fp_rollup_tmp
3538: WHERE pc_cur_conv_rejection_code is not null
3539: GROUP BY RESOURCE_ASSIGNMENT_ID,
3540: TXN_CURRENCY_CODE;
3541:

Line 3543: UPDATE pa_fp_rollup_tmp

3539: GROUP BY RESOURCE_ASSIGNMENT_ID,
3540: TXN_CURRENCY_CODE;
3541:
3542: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3543: UPDATE pa_fp_rollup_tmp
3544: SET PROJECT_RAW_COST = NULL,
3545: PROJECT_BURDENED_COST = NULL,
3546: PROJECT_REVENUE = NULL,
3547: PC_CUR_CONV_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3559: FROM pa_fp_rollup_tmp

3555: BULK COLLECT INTO
3556: l_rej_code_ra_id_tab,
3557: l_rej_code_txn_currency_tab,
3558: l_rej_code_msg_name_tab
3559: FROM pa_fp_rollup_tmp
3560: WHERE pfc_cur_conv_rejection_code is not null
3561: GROUP BY RESOURCE_ASSIGNMENT_ID,
3562: TXN_CURRENCY_CODE;
3563:

Line 3565: UPDATE pa_fp_rollup_tmp

3561: GROUP BY RESOURCE_ASSIGNMENT_ID,
3562: TXN_CURRENCY_CODE;
3563:
3564: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3565: UPDATE pa_fp_rollup_tmp
3566: SET PROJFUNC_RAW_COST = NULL,
3567: PROJFUNC_BURDENED_COST = NULL,
3568: PROJFUNC_REVENUE = NULL,
3569: PFC_CUR_CONV_REJECTION_CODE = l_rej_code_msg_name_tab(i)

Line 3583: FROM pa_fp_rollup_tmp

3579: BULK COLLECT INTO
3580: l_rej_code_ra_id_tab,
3581: l_rej_code_txn_currency_tab,
3582: l_rej_code_msg_name_tab
3583: FROM pa_fp_rollup_tmp
3584: WHERE cost_rejection_code is not null
3585: GROUP BY RESOURCE_ASSIGNMENT_ID,
3586: TXN_CURRENCY_CODE;
3587:

Line 3589: UPDATE pa_fp_rollup_tmp

3585: GROUP BY RESOURCE_ASSIGNMENT_ID,
3586: TXN_CURRENCY_CODE;
3587:
3588: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3589: UPDATE pa_fp_rollup_tmp
3590: SET TXN_RAW_COST = NULL,
3591: COST_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3592: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3593: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

Line 3603: FROM pa_fp_rollup_tmp

3599: BULK COLLECT INTO
3600: l_rej_code_ra_id_tab,
3601: l_rej_code_txn_currency_tab,
3602: l_rej_code_msg_name_tab
3603: FROM pa_fp_rollup_tmp
3604: WHERE burden_rejection_code is not null
3605: GROUP BY RESOURCE_ASSIGNMENT_ID,
3606: TXN_CURRENCY_CODE;
3607:

Line 3609: UPDATE pa_fp_rollup_tmp

3605: GROUP BY RESOURCE_ASSIGNMENT_ID,
3606: TXN_CURRENCY_CODE;
3607:
3608: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3609: UPDATE pa_fp_rollup_tmp
3610: SET TXN_BURDENED_COST = NULL,
3611: BURDEN_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3612: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3613: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

Line 3627: FROM pa_fp_rollup_tmp

3623: BULK COLLECT INTO
3624: l_rej_code_ra_id_tab,
3625: l_rej_code_txn_currency_tab,
3626: l_rej_code_msg_name_tab
3627: FROM pa_fp_rollup_tmp
3628: WHERE revenue_rejection_code is not null
3629: GROUP BY RESOURCE_ASSIGNMENT_ID,
3630: TXN_CURRENCY_CODE;
3631:

Line 3633: UPDATE pa_fp_rollup_tmp

3629: GROUP BY RESOURCE_ASSIGNMENT_ID,
3630: TXN_CURRENCY_CODE;
3631:
3632: FORALL i IN 1..l_rej_code_ra_id_tab.COUNT
3633: UPDATE pa_fp_rollup_tmp
3634: SET TXN_REVENUE = NULL,
3635: REVENUE_REJECTION_CODE = l_rej_code_msg_name_tab(i)
3636: WHERE resource_assignment_id = l_rej_code_ra_id_tab(i)
3637: AND txn_currency_code = l_rej_code_txn_currency_tab(i);

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

3644: IF l_rev_gen_method = 'C' THEN
3645:
3646: -- Bug 4549862: Returning control to the Budget or Forecast
3647: -- wrapper API, which will call GEN_COST_BASED_REVENUE to
3648: -- finish processing the data in PA_FP_ROLLUP_TMP and write
3649: -- it to the budget lines.
3650:
3651: RETURN;
3652:

Line 3671: UPDATE pa_fp_rollup_tmp

3667: CLOSE FIND_REJECTION_CODE;
3668:
3669: FOR m IN 1..l_rej_res_assignment_id_tab.COUNT LOOP
3670:
3671: UPDATE pa_fp_rollup_tmp
3672: SET TXN_REVENUE = NULL,
3673: REVENUE_REJECTION_CODE = l_rej_revenue_rej_code_tab(m)
3674: WHERE resource_assignment_id = l_rej_res_assignment_id_tab(m)
3675: AND start_date = l_rej_start_date_tab(m)

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

3751:
3752: ELSE
3753:
3754: -- Bug 4615787: When the Target is timephased by PA or GL, we
3755: -- should continue to fetch pa_fp_rollup_tmp data using the
3756: -- GROUP_TO_INSERT_INTO_PA_GL_BL cursor. When the Target is None
3757: -- timephased, use the new GROUP_TO_INSERT_INTO_PA_GL_BL cursor
3758: -- instead so that only a single record is fetched for each
3759: -- (Resource Assignment Id, Txn Currency) combination.