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

Line 219: FROM pa_fp_rollup_tmp bl

215: l_stage := 'Get sum of quantity from rollup tmp';
216: --print_msg(l_stage);
217: SELECT sum(nvl(bl.quantity,0))
218: INTO v_total_quantity
219: FROM pa_fp_rollup_tmp bl
220: WHERE bl.RESOURCE_ASSIGNMENT_ID = g_edist_RaId(i)
221: AND bl.TXN_CURRENCY_CODE = NVL(g_edist_Curcode_ovr(i),g_edist_Curcode(i))
222: AND bl.START_DATE BETWEEN g_edist_sdate(i) AND g_edist_edate(i)
223: AND bl.END_DATE BETWEEN g_edist_sdate(i) AND g_edist_edate(i)

Line 275: UPDATE PA_FP_ROLLUP_TMP tmp

271: IF g_edist_blId.COUNT > 0 THEN
272: l_stage := 'Finally one bulk update of rollup tmp lines ';
273: print_msg(l_stage);
274: FORALL i IN g_edist_blId.FIRST .. g_edist_blId.LAST
275: UPDATE PA_FP_ROLLUP_TMP tmp
276: SET tmp.QUANTITY = decode(NVL(g_edist_txn_quantity_addl(i),0),0,tmp.QUANTITY,(nvl(tmp.QUANTITY,0)+g_edist_rndiff_quantity(i)))
277: WHERE tmp.budget_version_id = p_budget_version_id
278: AND tmp.BUDGET_LINE_ID = g_edist_blId(i);
279: END IF;

Line 436: /* This API bulk inserts the lines into pa_fp_rollup_tmp from plsql tables */

432: End If;
433: raise FND_API.G_EXC_UNEXPECTED_ERROR;
434: END blkInsertBudgetLines;
435:
436: /* This API bulk inserts the lines into pa_fp_rollup_tmp from plsql tables */
437: PROCEDURE blkInsertFpLines(x_return_status OUT NOCOPY Varchar2) IS
438:
439: l_stage varchar2(1000);
440: BEGIN

Line 445: INSERT INTO PA_FP_ROLLUP_TMP

441: x_return_status := 'S';
442: IF g_rl_res_assignment_id_tab.COUNT > 0 THEN
443: l_stage := 'Bulk Insert of Fp rollup Tmp lines';
444: FORALL i IN g_rl_res_assignment_id_tab.FIRST .. g_rl_res_assignment_id_tab.LAST
445: INSERT INTO PA_FP_ROLLUP_TMP
446: (
447: BUDGET_LINE_ID
448: ,BUDGET_VERSION_ID
449: ,RESOURCE_ASSIGNMENT_ID

Line 516: /* This API bulk inserts lines into pa_fp_rollup_tmp from pa_budget_lines */

512: raise FND_API.G_EXC_UNEXPECTED_ERROR;
513:
514: END blkInsertFpLines;
515:
516: /* This API bulk inserts lines into pa_fp_rollup_tmp from pa_budget_lines */
517: PROCEDURE blkInsertBlFpLines(x_return_status OUT NOCOPY Varchar2) IS
518:
519: l_stage varchar2(1000);
520: BEGIN

Line 538: INSERT INTO PA_FP_ROLLUP_TMP

534:
535: As a fix the following insert is commented out and a new insert is written with a change
536: in the select statement of values clause.
537:
538: INSERT INTO PA_FP_ROLLUP_TMP
539: (
540: BUDGET_LINE_ID
541: ,BUDGET_VERSION_ID
542: ,RESOURCE_ASSIGNMENT_ID

Line 671: INSERT INTO PA_FP_ROLLUP_TMP

667:
668: End of Bug Fix 4332086.
669: */
670:
671: INSERT INTO PA_FP_ROLLUP_TMP
672: (
673: BUDGET_LINE_ID
674: ,BUDGET_VERSION_ID
675: ,RESOURCE_ASSIGNMENT_ID

Line 877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE

873: /* This API populates the plsql tables with rollup tmp lines for bulk insert */
874: PROCEDURE insert_rollup_tmp(
875: p_ra_rec IN resource_assignment_rec_type
876: ,p_budget_version_id IN NUMBER
877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE

Line 878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE

874: PROCEDURE insert_rollup_tmp(
875: p_ra_rec IN resource_assignment_rec_type
876: ,p_budget_version_id IN NUMBER
877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE

Line 879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE

875: p_ra_rec IN resource_assignment_rec_type
876: ,p_budget_version_id IN NUMBER
877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE

Line 880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE

876: ,p_budget_version_id IN NUMBER
877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE

Line 881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE

877: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
885: ,x_return_status OUT NOCOPY VARCHAR2

Line 882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE

878: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
885: ,x_return_status OUT NOCOPY VARCHAR2
886: ,x_msg_count OUT NOCOPY NUMBER

Line 883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE

879: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
885: ,x_return_status OUT NOCOPY VARCHAR2
886: ,x_msg_count OUT NOCOPY NUMBER
887: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE

880: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
881: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
882: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
883: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
884: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
885: ,x_return_status OUT NOCOPY VARCHAR2
886: ,x_msg_count OUT NOCOPY NUMBER
887: ,x_msg_data OUT NOCOPY VARCHAR2) IS
888:

Line 935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE

931: /* This API populates the plsql tables with rollup tmp lines for bulk insert */
932: PROCEDURE insert_rollup_tmp_with_bl(
933: p_ra_rec IN resource_assignment_rec_type
934: ,p_budget_version_id IN NUMBER
935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE

Line 936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE

932: PROCEDURE insert_rollup_tmp_with_bl(
933: p_ra_rec IN resource_assignment_rec_type
934: ,p_budget_version_id IN NUMBER
935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE

Line 937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE

933: p_ra_rec IN resource_assignment_rec_type
934: ,p_budget_version_id IN NUMBER
935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE

Line 938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE

934: ,p_budget_version_id IN NUMBER
935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE

Line 939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE

935: ,p_start_date IN pa_fp_rollup_tmp.START_DATE%TYPE
936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
943: ,x_return_status OUT NOCOPY VARCHAR2

Line 940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE

936: ,p_end_date IN pa_fp_rollup_tmp.END_DATE%TYPE
937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_count OUT NOCOPY NUMBER

Line 941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE

937: ,p_period_name IN pa_fp_rollup_tmp.PERIOD_NAME%TYPE
938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_count OUT NOCOPY NUMBER
945: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE

938: ,p_budget_line_id IN pa_fp_rollup_tmp.BUDGET_LINE_ID%TYPE
939: ,p_quantity IN pa_fp_rollup_tmp.QUANTITY%TYPE
940: ,p_txn_raw_cost IN pa_fp_rollup_tmp.TXN_RAW_COST%TYPE
941: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.TXN_BURDENED_COST%TYPE
942: ,p_txn_revenue IN pa_fp_rollup_tmp.TXN_REVENUE%TYPE
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_count OUT NOCOPY NUMBER
945: ,x_msg_data OUT NOCOPY VARCHAR2) IS
946:

Line 4325: print_msg(' Adding last budget line id to plsql tab of PA_FP_ROLLUP_TMP with l_last_budget_line_id');

4321: END LOOP; -- existing amounts, for each budget line
4322: print_msg('End of Existing line distribution Loop');
4323:
4324: If l_last_budget_line_id is NOT NULL Then --{
4325: print_msg(' Adding last budget line id to plsql tab of PA_FP_ROLLUP_TMP with l_last_budget_line_id');
4326: /* getting the totals from budgetline to add final difference */
4327: g_edist_blId(NVL(g_edist_blId.LAST,0)+1) := l_last_budget_line_id;
4328: g_edist_RaId(NVL(g_edist_RaId.LAST,0)+1) := v_resource_assignment_id;
4329: g_edist_Curcode(NVL(g_edist_Curcode.LAST,0)+1) := v_txn_currency_code;

Line 4549: -- INSERT INTO PA_FP_ROLLUP_TMP

4545: END IF;
4546:
4547:
4548: -- Insert into Rollup Temporary Table
4549: -- INSERT INTO PA_FP_ROLLUP_TMP
4550: insert_rollup_tmp(
4551: resource_assignment_rec,
4552: p_budget_version_id,
4553: v_spread_amounts(i).start_date,

Line 4655: FROM pa_fp_rollup_tmp tmp

4651: ,sum(tmp.txn_init_raw_cost) initraw
4652: ,sum(tmp.txn_init_burdened_cost) initbud
4653: ,sum(tmp.txn_init_revenue) initrev
4654: ,count(*) numrows
4655: FROM pa_fp_rollup_tmp tmp
4656: WHERE tmp.budget_version_id = p_budget_version_id
4657: AND NVL(tmp.system_reference5,'N') = 'N'
4658: GROUP BY tmp.resource_assignment_id,tmp.txn_currency_code ) LOOP
4659: print_msg('Number of Records in rolluptmp after Spread['||i.numrows||']');