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 1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */

1286: l_fcst_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1287:
1288: l_etc_start_date DATE;
1289:
1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

4011: END IF;
4012: END IF;
4013:
4014:
4015: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
4016: -- rates for both rate-based and non-rate based resources when generating
4017: -- work-based revenue for a Revenue-only target version.
4018:
4019: -- Added in IPM : When generating revenue-only, non-rate-based txns

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

4054:
4055: /* Populate the period rates table for the Client Extension API */
4056:
4057: -- Bug 4320954: When we fetch data from and update data to the
4058: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4059: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4060: -- in the WHERE clause so that the plan currency is honored.
4061:
4062: SELECT /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/

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

4058: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4059: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4060: -- in the WHERE clause so that the plan currency is honored.
4061:
4062: SELECT /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
4063: period_name,
4064: raw_cost_rate,
4065: burdened_cost_rate,
4066: revenue_bill_rate

Line 4072: FROM pa_fp_gen_rate_tmp

4068: INTO l_ext_period_name_tab,
4069: l_ext_raw_cost_rate_tab,
4070: l_ext_burdened_cost_rate_tab,
4071: l_ext_revenue_bill_rate_tab
4072: FROM pa_fp_gen_rate_tmp
4073: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
4074: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4075:
4076: l_input_period_rates_tbl.delete;

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

4161: /*For client_extn, many attributes are passed as NULL is because
4162: this API is still under developmen and some parameters are not
4163: available.Null values will be replaced later*/
4164: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate
4165: pa_fp_gen_rate_tmp, which is used to populate input parameter
4166: P_PERIOD_RATES_TBL */
4167:
4168: -- hr_utility.trace('==before calling client extn api ');
4169:

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

4239: */
4240: /* end bug fix 5726773 */
4241: -- Code in client extn kept here to avoid further changes in code after client extn.
4242:
4243: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4244: -- burdened cost rates for non-rate-based resources for Calculate API
4245: -- when generating work-based revenue for a Revenue-only target version.
4246:
4247: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost

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

4243: -- Bug 3968748: We need to populate the PA_FP_GEN_RATE_TMP table with
4244: -- burdened cost rates for non-rate-based resources for Calculate API
4245: -- when generating work-based revenue for a Revenue-only target version.
4246:
4247: -- Bug 4216423: We now need to populate PA_FP_GEN_RATE_TMP with cost
4248: -- rates for both rate-based and non-rate based resources when generating
4249: -- work-based revenue for a Revenue-only target version.
4250:
4251: IF l_use_src_rates_flag = 'Y' OR

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

4254: ( p_fp_cols_rec.x_version_type = 'ALL' AND l_rev_gen_method = 'T' AND
4255: l_rev_only_src_txn_flag_tab(i) = 'Y' AND l_cal_rate_based_flag_tab(i) = 'N') THEN
4256:
4257: -- Bug 4320954: When we fetch data from and update data to the
4258: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4259: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4260: -- in the WHERE clause so that the plan currency is honored.
4261:
4262: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/

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

4258: -- PA_FP_GEN_RATE_TMP table for the Client Extension API, we need
4259: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4260: -- in the WHERE clause so that the plan currency is honored.
4261:
4262: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
4263: FROM pa_fp_gen_rate_tmp
4264: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
4265: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4266:

Line 4263: FROM pa_fp_gen_rate_tmp

4259: -- to check both the target_res_asg_id AND the TXN_CURRENCY_CODE
4260: -- in the WHERE clause so that the plan currency is honored.
4261:
4262: DELETE /*+ INDEX(PA_FP_GEN_RATE_TMP,PA_FP_GEN_RATE_TMP_N1)*/
4263: FROM pa_fp_gen_rate_tmp
4264: WHERE target_res_asg_id = l_cal_ra_id_tab(i)
4265: AND txn_currency_code = l_cal_txn_currency_code_tab(i);
4266:
4267: l_ext_period_name_tab.delete;

Line 4281: INSERT INTO PA_FP_GEN_RATE_TMP

4277: l_ext_revenue_bill_rate_tab(j) := l_input_period_rates_tbl(j).revenue_bill_rate;
4278: END LOOP;
4279:
4280: FORALL j IN 1..l_ext_period_name_tab.count
4281: INSERT INTO PA_FP_GEN_RATE_TMP
4282: ( SOURCE_RES_ASG_ID,
4283: TXN_CURRENCY_CODE,
4284: PERIOD_NAME,
4285: RAW_COST_RATE,