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_WEBADI_PKG dependencies on PA_FP_ROLLUP_TMP

Line 8283: -- variables used to insert into pa_fp_rollup_tmp

8279: l_new_cbs_elemet_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();-- cbs enhancement changes bug#16445106
8280: l_new_planning_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8281: l_new_planning_end_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8282:
8283: -- variables used to insert into pa_fp_rollup_tmp
8284: -- with delete flag = Y
8285: l_bl_del_flag_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8286: l_bl_del_flag_st_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8287: l_bl_del_flag_en_dt_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 9007: for which delete flag is set as 'Y' in Excel will be populated in pa_fp_rollup_tmp as

9003: END IF;
9004: --log1('PBL 11 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
9005:
9006: /* Bug 5144013 : Modified the logic so that the attributes of the transaction
9007: for which delete flag is set as 'Y' in Excel will be populated in pa_fp_rollup_tmp as
9008: deletion of those planning transactions are taken care by delete_planning_transaction api.
9009: This is done as part of merging the MRUP3 changes done in 11i into R12.
9010: */
9011: /* commenting for bug 10160317 ..

Line 9172: pa_debug.g_err_stage := 'Inserting these records into pa_fp_rollup_tmp';

9168: IF l_bl_del_flag_ra_id_tbl.COUNT > 0 THEN
9169: IF l_debug_mode = 'Y' THEN
9170: pa_debug.g_err_stage := l_bl_del_flag_ra_id_tbl.COUNT || ' records deleted from pa_budget_lines';
9171: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9172: pa_debug.g_err_stage := 'Inserting these records into pa_fp_rollup_tmp';
9173: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9174: END IF;
9175:
9176: --log1('Preparing ra attr tbls for rollup tmp ins');

Line 9278: FROM pa_fp_rollup_tmp);

9274: SELECT 'Y'
9275: INTO l_bls_proccessed_flag
9276: FROM DUAL
9277: WHERE EXISTS (SELECT 1
9278: FROM pa_fp_rollup_tmp);
9279: EXCEPTION
9280: WHEN NO_DATA_FOUND THEN
9281: l_bls_proccessed_flag:='N';
9282: END;

Line 9296: pa_debug.g_err_stage := 'Inserting these records into pa_fp_rollup_tmp';

9292: IF l_bl_del_flag_ra_id_tbl.COUNT > 0 THEN
9293: IF l_debug_mode = 'Y' THEN
9294: pa_debug.g_err_stage := l_bl_del_flag_ra_id_tbl.COUNT || ' records deleted from pa_budget_lines';
9295: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9296: pa_debug.g_err_stage := 'Inserting these records into pa_fp_rollup_tmp';
9297: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9298: END IF;
9299:
9300: --log1('Preparing ra attr tbls for rollup tmp ins');

Line 9303: -- inserting these deleted records into pa_fp_rollup_tmp with delete flag as Y

9299:
9300: --log1('Preparing ra attr tbls for rollup tmp ins');
9301:
9302: /* Bug 10160317
9303: -- inserting these deleted records into pa_fp_rollup_tmp with delete flag as Y
9304: FORALL i IN l_bl_del_flag_ra_id_tbl.FIRST .. l_bl_del_flag_ra_id_tbl.LAST
9305: INSERT INTO
9306: pa_fp_rollup_tmp
9307: (resource_assignment_id,

Line 9306: pa_fp_rollup_tmp

9302: /* Bug 10160317
9303: -- inserting these deleted records into pa_fp_rollup_tmp with delete flag as Y
9304: FORALL i IN l_bl_del_flag_ra_id_tbl.FIRST .. l_bl_del_flag_ra_id_tbl.LAST
9305: INSERT INTO
9306: pa_fp_rollup_tmp
9307: (resource_assignment_id,
9308: start_date,
9309: end_date,
9310: txn_currency_code,

Line 9392: pa_debug.g_err_stage := 'records inserted into pa_fp_rollup_tmp';

9388: l_bl_del_fg_pf_cnv_rej_cd_tbl(i),
9389: l_bl_del_flag_o_rej_code_tbl(i));
9390: --log1('PBL 14 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
9391: IF l_debug_mode = 'Y' THEN
9392: pa_debug.g_err_stage := 'records inserted into pa_fp_rollup_tmp';
9393: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9394: END IF;
9395: */
9396: ELSE

Line 9492: -- Bug 4424457 : In all the below updates replaced pa_budget_lines with pa_fp_rollup_tmp. These

9488: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
9489: END IF;
9490:
9491: -- updating conversion attributes if the version is enabled for multi currency
9492: -- Bug 4424457 : In all the below updates replaced pa_budget_lines with pa_fp_rollup_tmp. These
9493: -- attributes will be finally stamped back in pa_budget_lines after MC conversion
9494: IF p_version_info_rec.x_plan_in_multi_curr_flag = 'Y' AND
9495: p_context = 'WEBADI_PERIODIC' THEN
9496: IF l_ra_id_tbl.COUNT > 0 AND

Line 9501: UPDATE pa_fp_rollup_tmp pbl

9497: l_bls_proccessed_flag ='Y' THEN
9498: --log1('----- STAGE CRC1-------');
9499: --log1('PBL 15 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
9500: FORALL i IN l_ra_id_tbl.FIRST .. l_ra_id_tbl.LAST
9501: UPDATE pa_fp_rollup_tmp pbl
9502: SET pbl.projfunc_cost_rate_type = DECODE (l_pfunc_cost_rate_type_tbl(i), NULL, pbl.projfunc_cost_rate_type,
9503: DECODE(l_pfunc_cost_rate_type_tbl(i), l_g_miss_char, NULL, l_pfunc_cost_rate_type_tbl(i))),
9504: pbl.projfunc_cost_rate_date_type = DECODE (l_pfunc_cost_rate_date_typ_tbl(i), NULL, pbl.projfunc_cost_rate_date_type,
9505: DECODE(l_pfunc_cost_rate_date_typ_tbl(i), l_g_miss_char, NULL, l_pfunc_cost_rate_date_typ_tbl(i))),

Line 9550: UPDATE pa_fp_rollup_tmp pbl

9546: l_bls_proccessed_flag ='Y' THEN
9547: --log1('----- STAGE CRC2-------');
9548: --log1('PBL 17 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
9549: FORALL i IN l_ra_id_tbl.FIRST .. l_ra_id_tbl.LAST
9550: UPDATE pa_fp_rollup_tmp pbl
9551: SET pbl.change_reason_code = l_change_reason_code_tbl(i),
9552: pbl.description = l_description_tbl(i)
9553: WHERE pbl.resource_assignment_id = l_ra_id_tbl(i)
9554: AND pbl.txn_currency_code = l_txn_currency_code_tbl(i);

Line 9565: UPDATE pa_fp_rollup_tmp pbl

9561: IF l_ra_id_tbl.COUNT > 0 AND
9562: l_bls_proccessed_flag ='Y' THEN
9563: --log1('PBL 19 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
9564: FORALL i IN l_ra_id_tbl.FIRST .. l_ra_id_tbl.LAST
9565: UPDATE pa_fp_rollup_tmp pbl
9566: SET pbl.change_reason_code = l_change_reason_code_tbl(i),
9567: pbl.description = DECODE(l_description_tbl(i), NULL, pbl.description,
9568: DECODE(l_description_tbl(i), l_g_miss_char, NULL, l_description_tbl(i))),
9569: pbl.projfunc_cost_rate_type = DECODE (l_pfunc_cost_rate_type_tbl(i), NULL, pbl.projfunc_cost_rate_type,

Line 9763: FROM pa_fp_rollup_tmp rlp

9759: l_upd_pf_rev_rate_date_tbl,
9760: l_bl_count_tbl,
9761: l_chg_reason_code_tbl,
9762: l_desc_tbl
9763: FROM pa_fp_rollup_tmp rlp
9764: WHERE delete_flag IS NULL OR delete_flag <> 'Y'
9765: GROUP BY rlp.resource_assignment_id,rlp.txn_currency_code,rlp.start_date;
9766:
9767: --log1('PBL 28 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));