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_CALC_UTILS dependencies on PA_FP_SPREAD_CALC_TMP1

Line 7068: INSERT INTO pa_fp_spread_calc_tmp1

7064: End If;
7065: x_return_status := 'S';
7066: x_msg_data := NULL;
7067:
7068: INSERT INTO pa_fp_spread_calc_tmp1
7069: (RESOURCE_ASSIGNMENT_ID --resource_assignment_id
7070: ,BUDGET_VERSION_ID --budget_version_id
7071: ,BUDGET_VERSION_TYPE
7072: ,BUDGET_LINE_ID

Line 7271: UPDATE /+ INDEX(TMP1 PA_FP_SPREAD_CALC_TMP1_N1) / pa_fp_spread_calc_tmp1 tmp1

7267: print_msg('mfcCostFlag['||i.mfc_cost_change_flag||'Ver['||i.budget_version_type||']');
7268: print_msg('costRtChFlag['||i.cost_rate_changed_flag||']Rt['||i.cost_rate_override||']');
7269: print_msg('burRtOvr['||i.burden_cost_rate_override||']');
7270: */
7271: UPDATE /*+ INDEX(TMP1 PA_FP_SPREAD_CALC_TMP1_N1) */ pa_fp_spread_calc_tmp1 tmp1
7272: SET tmp1.cost_rate_override = decode(i.budget_version_type,'REVENUE',tmp1.cost_rate_override
7273: ,decode(nvl(i.cost_rate_changed_flag,'N')
7274: ,'Y',decode(i.mfc_cost_change_flag,'Y'
7275: ,decode(nvl(i.cost_rate_override,0),0,NULL,i.cost_rate_override),i.cost_rate_override)

Line 7580: ,pa_fp_spread_calc_tmp1 cache

7576: cache.PROJFUNC_REV_RATE_DATE),
7577: tmp.PROJFUNC_REV_RATE_DATE),
7578: NULL) PROJFUNC_REV_RATE_DATE
7579: FROM pa_fp_rollup_tmp tmp
7580: ,pa_fp_spread_calc_tmp1 cache
7581: WHERE tmp.budget_version_id = p_budget_verson_id
7582: AND tmp.budget_version_id = cache.budget_version_id
7583: AND tmp.resource_assignment_id = cache.resource_assignment_id
7584: AND tmp.txn_currency_code = cache.txn_currency_code

Line 7642: ,pa_fp_spread_calc_tmp1 cache

7638: , cache.TRANSFER_PRICE_RATE
7639: , cache.BL_CREATED_BY
7640: , cache.BL_CREATION_DATE
7641: FROM pa_fp_rollup_tmp tmp
7642: ,pa_fp_spread_calc_tmp1 cache
7643: ,pa_budget_lines bl
7644: WHERE tmp.budget_version_id = p_budget_verson_id
7645: AND tmp.budget_version_id = cache.budget_version_id
7646: AND tmp.resource_assignment_id = cache.resource_assignment_id

Line 8456: FROM pa_fp_spread_calc_tmp1 tmp1

8452: ,tmp1.burden_rejection_code
8453: ,tmp1.pfc_cur_conv_rejection_code
8454: ,tmp1.pc_cur_conv_rejection_code
8455: ,tmp1.system_reference_num1 Existing_budget_line_id
8456: FROM pa_fp_spread_calc_tmp1 tmp1
8457: WHERE tmp1.budget_version_id = p_budget_version_id;
8458:
8459: l_del_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8460: CURSOR cur_delBlLines IS

Line 8462: FROM pa_fp_spread_calc_tmp1 tmp1

8458:
8459: l_del_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8460: CURSOR cur_delBlLines IS
8461: SELECT tmp1.budget_line_id
8462: FROM pa_fp_spread_calc_tmp1 tmp1
8463: WHERE tmp1.budget_version_id = p_budget_version_id;
8464:
8465:
8466: CURSOR cur_Tmp2ExblAmts(p_budget_line_id Number) IS

Line 8789: DELETE FROM PA_FP_SPREAD_CALC_TMP1;

8785: ) IS
8786: BEGIN
8787: x_return_status := 'S';
8788: print_msg('Entered Populate_blkExcpRecs API');
8789: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
8790: FORALL i IN p_err_error_code_tab.FIRST .. p_err_error_code_tab.LAST
8791: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp
8792: (tmp.budget_line_id
8793: ,tmp.budget_version_id

Line 8791: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp

8787: x_return_status := 'S';
8788: print_msg('Entered Populate_blkExcpRecs API');
8789: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
8790: FORALL i IN p_err_error_code_tab.FIRST .. p_err_error_code_tab.LAST
8791: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp
8792: (tmp.budget_line_id
8793: ,tmp.budget_version_id
8794: ,tmp.resource_assignment_id
8795: ,tmp.txn_currency_code

Line 8906: From pa_fp_spread_calc_tmp1 tmp1

8902: ,bl.projfunc_currency_code
8903: FROM pa_budget_lines bl
8904: WHERE bl.budget_version_id = p_budget_version_id
8905: AND EXISTS (select null
8906: From pa_fp_spread_calc_tmp1 tmp1
8907: where tmp1.budget_version_id = p_budget_version_id
8908: and tmp1.resource_assignment_id = bl.resource_assignment_id
8909: and tmp1.txn_currency_code = bl.txn_currency_code
8910: and tmp1.start_date = bl.start_date

Line 8916: UPDATE pa_fp_spread_calc_tmp1 tmp1

8912: print_msg('Number of lines inserted['||sql%Rowcount||']');
8913:
8914: /* Now store the existing budget line id on tmp1 table to read the values
8915: * from both tables */
8916: UPDATE pa_fp_spread_calc_tmp1 tmp1
8917: SET tmp1.system_reference_num1 = (select tmp2.budget_line_id
8918: from pa_fp_spread_calc_tmp2 tmp2
8919: where tmp2.budget_version_id = p_budget_version_id
8920: and tmp2.resource_assignment_id = tmp1.resource_assignment_id

Line 10015: FROM pa_fp_spread_calc_tmp1 cache, pa_budget_lines bl

10011: , cache.TXN_DISCOUNT_PERCENTAGE
10012: , cache.TRANSFER_PRICE_RATE
10013: , cache.BL_CREATED_BY
10014: , cache.BL_CREATION_DATE
10015: FROM pa_fp_spread_calc_tmp1 cache, pa_budget_lines bl
10016: WHERE cache.budget_version_id = p_budget_verson_id
10017: AND cache.budget_version_id = bl.budget_version_id
10018: AND cache.resource_assignment_id = bl.resource_assignment_id
10019: AND cache.txn_currency_code = bl.txn_currency_code

Line 10601: /*Bug:4272944: Added new procedure to insert zero qty budget lines from pa_fp_spread_calc_tmp1 to

10597: RAISE;
10598:
10599: END update_dffcols;
10600:
10601: /*Bug:4272944: Added new procedure to insert zero qty budget lines from pa_fp_spread_calc_tmp1 to
10602: *pa_budget_lines. This fix is done specific to Funding of Autobase line is failing.
10603: *donot populate or use pa_fp_spread_calc_tmp1 table for any other purpose.
10604: *Note: Calling API may populate this table only for AMG/MSP/Autobaseline purpose.
10605: */

Line 10603: *donot populate or use pa_fp_spread_calc_tmp1 table for any other purpose.

10599: END update_dffcols;
10600:
10601: /*Bug:4272944: Added new procedure to insert zero qty budget lines from pa_fp_spread_calc_tmp1 to
10602: *pa_budget_lines. This fix is done specific to Funding of Autobase line is failing.
10603: *donot populate or use pa_fp_spread_calc_tmp1 table for any other purpose.
10604: *Note: Calling API may populate this table only for AMG/MSP/Autobaseline purpose.
10605: */
10606: PROCEDURE InsertFunding_ReqdLines
10607: ( p_budget_verson_id IN Number

Line 10623: FROM pa_fp_spread_calc_tmp1 tmp

10619: ,tmp.start_date
10620: ,tmp.end_date
10621: ,tmp.period_name
10622: ,pa_budget_lines_s.nextval
10623: FROM pa_fp_spread_calc_tmp1 tmp
10624: WHERE tmp.budget_version_id = p_budget_verson_id;
10625:
10626: l_bl_source VARCHAR2(10) := 'AB'; --'indicates lines created for funding auto baseline'
10627: l_resource_assignment_id_tab pa_plsql_datatypes.Num15TabTyp;

Line 10769: SELECT /+ INDEX(TMP PA_FP_SPREAD_CALC_TMP1_N1) / l_budget_line_id_tab(i)

10765: ,bl.LAST_UPDATED_BY
10766: ,bl.LAST_UPDATE_LOGIN
10767: ,bl.LAST_UPDATE_DATE
10768: )
10769: SELECT /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP1_N1) */ l_budget_line_id_tab(i)
10770: ,tmp.RESOURCE_ASSIGNMENT_ID --resource_assignment_id
10771: ,tmp.BUDGET_VERSION_ID --budget_version_id
10772: ,tmp.TXN_CURRENCY_CODE --txn_currency_code
10773: ,tmp.QUANTITY --total_qty

Line 10854: FROM PA_FP_SPREAD_CALC_TMP1 tmp

10850: ,tmp.BL_CREATION_DATE
10851: ,tmp.BL_CREATED_BY --last updated by
10852: ,tmp.BL_CREATED_BY -- lastupdate login
10853: ,trunc(sysdate) -- last update dated
10854: FROM PA_FP_SPREAD_CALC_TMP1 tmp
10855: WHERE tmp.resource_assignment_id = l_resource_assignment_id_tab(i)
10856: AND tmp.txn_currency_code = l_txn_cur_code_tab(i)
10857: AND tmp.start_date = l_start_date_tab(i);
10858: