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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_GEN_RATE_TMP

Line 422: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */

418:
419: l_calc_qty_tmp NUMBER;
420: l_calc_tmp_rev NUMBER;
421:
422: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
423: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
424: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
425: l_nrb_bcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
426: l_nrb_rcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1986: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

1982:
1983: -- Bug 4568011: When Source revenue amounts exist, the
1984: -- Calculate API should honor those amounts instead of
1985: -- computing revenue amounts. For this to happen, the
1986: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
1987: -- table needs to be populated with the bill rate override.
1988: -- Likewise, when Source revenue amounts do not exist,
1989: -- the Calculate API should compute revenue amounts. In
1990: -- this case, the bill rate override should be NULL.

Line 2161: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

2157:
2158: -- Bug 4568011: When Source revenue amounts exist, the
2159: -- Calculate API should honor those amounts instead of
2160: -- computing revenue amounts. For this to happen, the
2161: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
2162: -- table needs to be populated with the bill rate override.
2163: -- Likewise, when Source revenue amounts do not exist,
2164: -- the Calculate API should compute revenue amounts. In
2165: -- this case, the bill rate override should be NULL.

Line 2427: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with

2423: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
2424: END IF;
2425: ******************** End Commenting **********************/
2426:
2427: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
2428: -- burdened cost rates for non-rate-based resources for Calculate API
2429: -- when generating work-based revenue for a Revenue-only target version.
2430:
2431: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

Line 2431: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

2427: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
2428: -- burdened cost rates for non-rate-based resources for Calculate API
2429: -- when generating work-based revenue for a Revenue-only target version.
2430:
2431: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
2432: -- rates for both rate-based and non-rate based resources when generating
2433: -- work-based revenue for a Revenue-only target version.
2434:
2435: /* ER 4376722: Note that we do not need to modify the logic for populating

Line 2436: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records

2432: -- rates for both rate-based and non-rate based resources when generating
2433: -- work-based revenue for a Revenue-only target version.
2434:
2435: /* ER 4376722: Note that we do not need to modify the logic for populating
2436: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records
2437: * for non-billable tasks earlier in the code for Revenue-only target versions. */
2438:
2439: -- Bug 4568011: Added REVENUE_BILL_RATE to list of inserted columns.
2440: -- When the value is non-null, the Calculate API will honor the given

Line 2444: DELETE pa_fp_gen_rate_tmp;

2440: -- When the value is non-null, the Calculate API will honor the given
2441: -- bill rate instead of computing revenue amounts.
2442:
2443: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
2444: DELETE pa_fp_gen_rate_tmp;
2445: /* For summary level calculation, we should leave period_name NULL */
2446: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2447: INSERT INTO pa_fp_gen_rate_tmp
2448: ( TARGET_RES_ASG_ID,

Line 2447: INSERT INTO pa_fp_gen_rate_tmp

2443: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
2444: DELETE pa_fp_gen_rate_tmp;
2445: /* For summary level calculation, we should leave period_name NULL */
2446: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2447: INSERT INTO pa_fp_gen_rate_tmp
2448: ( TARGET_RES_ASG_ID,
2449: TXN_CURRENCY_CODE,
2450: RAW_COST_RATE,
2451: BURDENED_COST_RATE,

Line 3246: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */

3242:
3243: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3244: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3245:
3246: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3247: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3248: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3249: l_nrb_bcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
3250: l_nrb_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4348: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

4344:
4345: -- Bug 4568011: When Source revenue amounts exist, the
4346: -- Calculate API should honor those amounts instead of
4347: -- computing revenue amounts. For this to happen, the
4348: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
4349: -- table needs to be populated with the bill rate override.
4350: -- Likewise, when Source revenue amounts do not exist,
4351: -- the Calculate API should compute revenue amounts. In
4352: -- this case, the bill rate override should be NULL.

Line 4542: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

4538:
4539: -- Bug 4568011: When Source revenue amounts exist, the
4540: -- Calculate API should honor those amounts instead of
4541: -- computing revenue amounts. For this to happen, the
4542: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
4543: -- table needs to be populated with the bill rate override.
4544: -- Likewise, when Source revenue amounts do not exist,
4545: -- the Calculate API should compute revenue amounts. In
4546: -- this case, the bill rate override should be NULL.

Line 4928: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with

4924: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
4925: END IF;
4926: ******************** End Commenting **********************/
4927:
4928: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4929: -- burdened cost rates for non-rate-based resources for Calculate API
4930: -- when generating work-based revenue for a Revenue-only target version.
4931:
4932: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

Line 4932: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

4928: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4929: -- burdened cost rates for non-rate-based resources for Calculate API
4930: -- when generating work-based revenue for a Revenue-only target version.
4931:
4932: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
4933: -- rates for both rate-based and non-rate based resources when generating
4934: -- work-based revenue for a Revenue-only target version.
4935:
4936: /* ER 4376722: Note that we do not need to modify the logic for populating

Line 4937: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records

4933: -- rates for both rate-based and non-rate based resources when generating
4934: -- work-based revenue for a Revenue-only target version.
4935:
4936: /* ER 4376722: Note that we do not need to modify the logic for populating
4937: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records
4938: * for non-billable tasks earlier in the code for Revenue-only target versions. */
4939:
4940: -- Bug 4568011: Added REVENUE_BILL_RATE to list of inserted columns.
4941: -- When the value is non-null, the Calculate API will honor the given

Line 4945: DELETE pa_fp_gen_rate_tmp;

4941: -- When the value is non-null, the Calculate API will honor the given
4942: -- bill rate instead of computing revenue amounts.
4943:
4944: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
4945: DELETE pa_fp_gen_rate_tmp;
4946: /* For periodic calculation, we should populate the period name. */
4947: FORALL i IN 1..l_tgt_res_asg_id_tab.count
4948: INSERT INTO pa_fp_gen_rate_tmp
4949: ( TARGET_RES_ASG_ID,

Line 4948: INSERT INTO pa_fp_gen_rate_tmp

4944: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
4945: DELETE pa_fp_gen_rate_tmp;
4946: /* For periodic calculation, we should populate the period name. */
4947: FORALL i IN 1..l_tgt_res_asg_id_tab.count
4948: INSERT INTO pa_fp_gen_rate_tmp
4949: ( TARGET_RES_ASG_ID,
4950: TXN_CURRENCY_CODE,
4951: PERIOD_NAME,
4952: RAW_COST_RATE,