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

Line 1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */

1129: l_fcst_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1130:
1131: l_etc_start_date DATE;
1132:
1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

3767: END IF;
3768: END IF;
3769:
3770:
3771: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
3772: -- rates for both rate-based and non-rate based resources when generating
3773: -- work-based revenue for a Revenue-only target version.
3774:
3775: -- Added in IPM : When generating revenue-only, non-rate-based txns

Line 3814: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need

3810:
3811: /* Populate the period rates table for the Client Extension API */
3812:
3813: -- Bug 4320954: When we fetch data from and update data to the
3814: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
3815: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
3816: -- in the WHERE clause so that the plan currency is honored.
3817:
3818: SELECT /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/

Line 3818: SELECT /+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)/

3814: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
3815: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
3816: -- in the WHERE clause so that the plan currency is honored.
3817:
3818: SELECT /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
3819: period_name,
3820: raw_cost_rate,
3821: burdened_cost_rate,
3822: revenue_bill_rate

Line 3828: FROM pa_fp_gen_rate_tmp

3824: INTO l_ext_period_name_tab,
3825: l_ext_raw_cost_rate_tab,
3826: l_ext_burdened_cost_rate_tab,
3827: l_ext_revenue_bill_rate_tab
3828: FROM pa_fp_gen_rate_tmp
3829: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
3830: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
3831:
3832: l_input_period_rates_tbl.delete;

Line 3921: pa_fp_gen_rate_tmp, which is used to populate input parameter

3917: /*For client_extn, many attributes are passed as NULL is because
3918: this API is still under developmen and some parameters are not
3919: available.Null values will be replaced later*/
3920: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate
3921: pa_fp_gen_rate_tmp, which is used to populate input parameter
3922: P_PERIOD_RATES_TBL */
3923:
3924: -- hr_utility.trace('==before calling client extn api ');
3925:

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

3995: */
3996: /* end bug fix 5726773 */
3997: -- Code in client extn kept here to avoid further changes in code after client extn.
3998:
3999: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4000: -- burdened cost rates for non-rate-based resources for Calculate API
4001: -- when generating work-based revenue for a Revenue-only target version.
4002:
4003: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

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

3999: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4000: -- burdened cost rates for non-rate-based resources for Calculate API
4001: -- when generating work-based revenue for a Revenue-only target version.
4002:
4003: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
4004: -- rates for both rate-based and non-rate based resources when generating
4005: -- work-based revenue for a Revenue-only target version.
4006:
4007: IF l_use_src_rates_flag = 'Y' OR

Line 4014: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need

4010: ( p_fp_cols_rec.x_version_type = 'ALL' AND l_rev_gen_method = 'T' AND
4011: l_rev_only_src_txn_flag_tab(i) = 'Y' AND l_cal_rate_based_flag_tab(i) = 'N') THEN
4012:
4013: -- Bug 4320954: When we fetch data from and update data to the
4014: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4015: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4016: -- in the WHERE clause so that the plan currency is honored.
4017:
4018: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/

Line 4018: DELETE /+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)/

4014: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4015: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4016: -- in the WHERE clause so that the plan currency is honored.
4017:
4018: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
4019: FROM pa_fp_gen_rate_tmp
4020: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
4021: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4022:

Line 4019: FROM pa_fp_gen_rate_tmp

4015: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4016: -- in the WHERE clause so that the plan currency is honored.
4017:
4018: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
4019: FROM pa_fp_gen_rate_tmp
4020: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
4021: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4022:
4023: l_ext_period_name_tab.delete;

Line 4037: INSERT INTO PA_FP_GEN_RATE_TMP

4033: l_ext_revenue_bill_rate_tab(j) := l_input_period_rates_tbl(j).revenue_bill_rate;
4034: END LOOP;
4035:
4036: FORALL j IN 1..l_ext_period_name_tab.count
4037: INSERT INTO PA_FP_GEN_RATE_TMP
4038: ( SOURCE_RES_ASG_ID,
4039: TXN_CURRENCY_CODE,
4040: PERIOD_NAME,
4041: RAW_COST_RATE,