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 458: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */

454:
455: l_calc_qty_tmp NUMBER;
456: l_calc_tmp_rev NUMBER;
457:
458: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
459: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
460: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
461: l_nrb_bcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
462: l_nrb_rcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 2028: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

2024:
2025: -- Bug 4568011: When Source revenue amounts exist, the
2026: -- Calculate API should honor those amounts instead of
2027: -- computing revenue amounts. For this to happen, the
2028: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
2029: -- table needs to be populated with the bill rate override.
2030: -- Likewise, when Source revenue amounts do not exist,
2031: -- the Calculate API should compute revenue amounts. In
2032: -- this case, the bill rate override should be NULL.

Line 2203: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

2199:
2200: -- Bug 4568011: When Source revenue amounts exist, the
2201: -- Calculate API should honor those amounts instead of
2202: -- computing revenue amounts. For this to happen, the
2203: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
2204: -- table needs to be populated with the bill rate override.
2205: -- Likewise, when Source revenue amounts do not exist,
2206: -- the Calculate API should compute revenue amounts. In
2207: -- this case, the bill rate override should be NULL.

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

2465: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
2466: END IF;
2467: ******************** End Commenting **********************/
2468:
2469: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
2470: -- burdened cost rates for non-rate-based resources for Calculate API
2471: -- when generating work-based revenue for a Revenue-only target version.
2472:
2473: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

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

2469: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
2470: -- burdened cost rates for non-rate-based resources for Calculate API
2471: -- when generating work-based revenue for a Revenue-only target version.
2472:
2473: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
2474: -- rates for both rate-based and non-rate based resources when generating
2475: -- work-based revenue for a Revenue-only target version.
2476:
2477: /* ER 4376722: Note that we do not need to modify the logic for populating

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

2474: -- rates for both rate-based and non-rate based resources when generating
2475: -- work-based revenue for a Revenue-only target version.
2476:
2477: /* ER 4376722: Note that we do not need to modify the logic for populating
2478: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records
2479: * for non-billable tasks earlier in the code for Revenue-only target versions. */
2480:
2481: -- Bug 4568011: Added REVENUE_BILL_RATE to list of inserted columns.
2482: -- When the value is non-null, the Calculate API will honor the given

Line 2486: DELETE pa_fp_gen_rate_tmp;

2482: -- When the value is non-null, the Calculate API will honor the given
2483: -- bill rate instead of computing revenue amounts.
2484:
2485: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
2486: DELETE pa_fp_gen_rate_tmp;
2487: /* For summary level calculation, we should leave period_name NULL */
2488: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2489: INSERT INTO pa_fp_gen_rate_tmp
2490: ( TARGET_RES_ASG_ID,

Line 2489: INSERT INTO pa_fp_gen_rate_tmp

2485: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
2486: DELETE pa_fp_gen_rate_tmp;
2487: /* For summary level calculation, we should leave period_name NULL */
2488: FORALL i IN 1..l_tgt_res_asg_id_tab.count
2489: INSERT INTO pa_fp_gen_rate_tmp
2490: ( TARGET_RES_ASG_ID,
2491: TXN_CURRENCY_CODE,
2492: RAW_COST_RATE,
2493: BURDENED_COST_RATE,

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

3320:
3321: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3322: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3323:
3324: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3325: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3326: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3327: l_nrb_bcost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
3328: l_nrb_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 4427: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

4423:
4424: -- Bug 4568011: When Source revenue amounts exist, the
4425: -- Calculate API should honor those amounts instead of
4426: -- computing revenue amounts. For this to happen, the
4427: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
4428: -- table needs to be populated with the bill rate override.
4429: -- Likewise, when Source revenue amounts do not exist,
4430: -- the Calculate API should compute revenue amounts. In
4431: -- this case, the bill rate override should be NULL.

Line 4621: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP

4617:
4618: -- Bug 4568011: When Source revenue amounts exist, the
4619: -- Calculate API should honor those amounts instead of
4620: -- computing revenue amounts. For this to happen, the
4621: -- REVENUE_BILL_RATE column of the PA_FP_GEN_RATE_TMP
4622: -- table needs to be populated with the bill rate override.
4623: -- Likewise, when Source revenue amounts do not exist,
4624: -- the Calculate API should compute revenue amounts. In
4625: -- this case, the bill rate override should be NULL.

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

5003: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
5004: END IF;
5005: ******************** End Commenting **********************/
5006:
5007: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
5008: -- burdened cost rates for non-rate-based resources for Calculate API
5009: -- when generating work-based revenue for a Revenue-only target version.
5010:
5011: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

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

5007: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
5008: -- burdened cost rates for non-rate-based resources for Calculate API
5009: -- when generating work-based revenue for a Revenue-only target version.
5010:
5011: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
5012: -- rates for both rate-based and non-rate based resources when generating
5013: -- work-based revenue for a Revenue-only target version.
5014:
5015: /* ER 4376722: Note that we do not need to modify the logic for populating

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

5012: -- rates for both rate-based and non-rate based resources when generating
5013: -- work-based revenue for a Revenue-only target version.
5014:
5015: /* ER 4376722: Note that we do not need to modify the logic for populating
5016: * PA_FP_GEN_RATE_TMP here, since we already removed pl/sql table records
5017: * for non-billable tasks earlier in the code for Revenue-only target versions. */
5018:
5019: -- Bug 4568011: Added REVENUE_BILL_RATE to list of inserted columns.
5020: -- When the value is non-null, the Calculate API will honor the given

Line 5024: DELETE pa_fp_gen_rate_tmp;

5020: -- When the value is non-null, the Calculate API will honor the given
5021: -- bill rate instead of computing revenue amounts.
5022:
5023: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
5024: DELETE pa_fp_gen_rate_tmp;
5025: /* For periodic calculation, we should populate the period name. */
5026: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5027: INSERT INTO pa_fp_gen_rate_tmp
5028: ( TARGET_RES_ASG_ID,

Line 5027: INSERT INTO pa_fp_gen_rate_tmp

5023: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' AND l_rev_gen_method = 'T' THEN
5024: DELETE pa_fp_gen_rate_tmp;
5025: /* For periodic calculation, we should populate the period name. */
5026: FORALL i IN 1..l_tgt_res_asg_id_tab.count
5027: INSERT INTO pa_fp_gen_rate_tmp
5028: ( TARGET_RES_ASG_ID,
5029: TXN_CURRENCY_CODE,
5030: PERIOD_NAME,
5031: RAW_COST_RATE,