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 7099: INSERT INTO pa_fp_spread_calc_tmp1

7095: End If;
7096: x_return_status := 'S';
7097: x_msg_data := NULL;
7098:
7099: INSERT INTO pa_fp_spread_calc_tmp1
7100: (RESOURCE_ASSIGNMENT_ID --resource_assignment_id
7101: ,BUDGET_VERSION_ID --budget_version_id
7102: ,BUDGET_VERSION_TYPE
7103: ,BUDGET_LINE_ID

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

7298: print_msg('mfcCostFlag['||i.mfc_cost_change_flag||'Ver['||i.budget_version_type||']');
7299: print_msg('costRtChFlag['||i.cost_rate_changed_flag||']Rt['||i.cost_rate_override||']');
7300: print_msg('burRtOvr['||i.burden_cost_rate_override||']');
7301: */
7302: UPDATE /*+ INDEX(TMP1 PA_FP_SPREAD_CALC_TMP1_N1) */ pa_fp_spread_calc_tmp1 tmp1
7303: SET tmp1.cost_rate_override = decode(i.budget_version_type,'REVENUE',tmp1.cost_rate_override
7304: ,decode(nvl(i.cost_rate_changed_flag,'N')
7305: ,'Y',decode(i.mfc_cost_change_flag,'Y'
7306: ,decode(nvl(i.cost_rate_override,0),0,NULL,i.cost_rate_override),i.cost_rate_override)

Line 7611: ,pa_fp_spread_calc_tmp1 cache

7607: cache.PROJFUNC_REV_RATE_DATE),
7608: tmp.PROJFUNC_REV_RATE_DATE),
7609: NULL) PROJFUNC_REV_RATE_DATE
7610: FROM pa_fp_rollup_tmp tmp
7611: ,pa_fp_spread_calc_tmp1 cache
7612: WHERE tmp.budget_version_id = p_budget_verson_id
7613: AND tmp.budget_version_id = cache.budget_version_id
7614: AND tmp.resource_assignment_id = cache.resource_assignment_id
7615: AND tmp.txn_currency_code = cache.txn_currency_code

Line 7673: ,pa_fp_spread_calc_tmp1 cache

7669: , cache.TRANSFER_PRICE_RATE
7670: , cache.BL_CREATED_BY
7671: , cache.BL_CREATION_DATE
7672: FROM pa_fp_rollup_tmp tmp
7673: ,pa_fp_spread_calc_tmp1 cache
7674: ,pa_budget_lines bl
7675: WHERE tmp.budget_version_id = p_budget_verson_id
7676: AND tmp.budget_version_id = cache.budget_version_id
7677: AND tmp.resource_assignment_id = cache.resource_assignment_id

Line 8487: FROM pa_fp_spread_calc_tmp1 tmp1

8483: ,tmp1.burden_rejection_code
8484: ,tmp1.pfc_cur_conv_rejection_code
8485: ,tmp1.pc_cur_conv_rejection_code
8486: ,tmp1.system_reference_num1 Existing_budget_line_id
8487: FROM pa_fp_spread_calc_tmp1 tmp1
8488: WHERE tmp1.budget_version_id = p_budget_version_id;
8489:
8490: l_del_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8491: CURSOR cur_delBlLines IS

Line 8493: FROM pa_fp_spread_calc_tmp1 tmp1

8489:
8490: l_del_budget_line_id_tab pa_plsql_datatypes.NumTabTyp;
8491: CURSOR cur_delBlLines IS
8492: SELECT tmp1.budget_line_id
8493: FROM pa_fp_spread_calc_tmp1 tmp1
8494: WHERE tmp1.budget_version_id = p_budget_version_id;
8495:
8496:
8497: CURSOR cur_Tmp2ExblAmts(p_budget_line_id Number) IS

Line 9021: DELETE FROM PA_FP_SPREAD_CALC_TMP1;

9017: ) IS
9018: BEGIN
9019: x_return_status := 'S';
9020: print_msg('Entered Populate_blkExcpRecs API');
9021: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
9022: FORALL i IN p_err_error_code_tab.FIRST .. p_err_error_code_tab.LAST
9023: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp
9024: (tmp.budget_line_id
9025: ,tmp.budget_version_id

Line 9023: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp

9019: x_return_status := 'S';
9020: print_msg('Entered Populate_blkExcpRecs API');
9021: DELETE FROM PA_FP_SPREAD_CALC_TMP1;
9022: FORALL i IN p_err_error_code_tab.FIRST .. p_err_error_code_tab.LAST
9023: INSERT INTO PA_FP_SPREAD_CALC_TMP1 tmp
9024: (tmp.budget_line_id
9025: ,tmp.budget_version_id
9026: ,tmp.resource_assignment_id
9027: ,tmp.txn_currency_code

Line 9138: From pa_fp_spread_calc_tmp1 tmp1

9134: ,bl.projfunc_currency_code
9135: FROM pa_budget_lines bl
9136: WHERE bl.budget_version_id = p_budget_version_id
9137: AND EXISTS (select null
9138: From pa_fp_spread_calc_tmp1 tmp1
9139: where tmp1.budget_version_id = p_budget_version_id
9140: and tmp1.resource_assignment_id = bl.resource_assignment_id
9141: and tmp1.txn_currency_code = bl.txn_currency_code
9142: and tmp1.start_date = bl.start_date

Line 9148: UPDATE pa_fp_spread_calc_tmp1 tmp1

9144: print_msg('Number of lines inserted['||sql%Rowcount||']');
9145:
9146: /* Now store the existing budget line id on tmp1 table to read the values
9147: * from both tables */
9148: UPDATE pa_fp_spread_calc_tmp1 tmp1
9149: SET tmp1.system_reference_num1 = (select tmp2.budget_line_id
9150: from pa_fp_spread_calc_tmp2 tmp2
9151: where tmp2.budget_version_id = p_budget_version_id
9152: and tmp2.resource_assignment_id = tmp1.resource_assignment_id

Line 10261: FROM pa_fp_spread_calc_tmp1 cache, pa_budget_lines bl

10257: , cache.TXN_DISCOUNT_PERCENTAGE
10258: , cache.TRANSFER_PRICE_RATE
10259: , cache.BL_CREATED_BY
10260: , cache.BL_CREATION_DATE
10261: FROM pa_fp_spread_calc_tmp1 cache, pa_budget_lines bl
10262: WHERE cache.budget_version_id = p_budget_verson_id
10263: AND cache.budget_version_id = bl.budget_version_id
10264: AND cache.resource_assignment_id = bl.resource_assignment_id
10265: AND cache.txn_currency_code = bl.txn_currency_code

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

10843: RAISE;
10844:
10845: END update_dffcols;
10846:
10847: /*Bug:4272944: Added new procedure to insert zero qty budget lines from pa_fp_spread_calc_tmp1 to
10848: *pa_budget_lines. This fix is done specific to Funding of Autobase line is failing.
10849: *donot populate or use pa_fp_spread_calc_tmp1 table for any other purpose.
10850: *Note: Calling API may populate this table only for AMG/MSP/Autobaseline purpose.
10851: */

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

10845: END update_dffcols;
10846:
10847: /*Bug:4272944: Added new procedure to insert zero qty budget lines from pa_fp_spread_calc_tmp1 to
10848: *pa_budget_lines. This fix is done specific to Funding of Autobase line is failing.
10849: *donot populate or use pa_fp_spread_calc_tmp1 table for any other purpose.
10850: *Note: Calling API may populate this table only for AMG/MSP/Autobaseline purpose.
10851: */
10852: PROCEDURE InsertFunding_ReqdLines
10853: ( p_budget_verson_id IN Number

Line 10869: FROM pa_fp_spread_calc_tmp1 tmp

10865: ,tmp.start_date
10866: ,tmp.end_date
10867: ,tmp.period_name
10868: ,pa_budget_lines_s.nextval
10869: FROM pa_fp_spread_calc_tmp1 tmp
10870: WHERE tmp.budget_version_id = p_budget_verson_id;
10871:
10872: l_bl_source VARCHAR2(10) := 'AB'; --'indicates lines created for funding auto baseline'
10873: l_resource_assignment_id_tab pa_plsql_datatypes.Num15TabTyp;

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

11011: ,bl.LAST_UPDATED_BY
11012: ,bl.LAST_UPDATE_LOGIN
11013: ,bl.LAST_UPDATE_DATE
11014: )
11015: SELECT /*+ INDEX(TMP PA_FP_SPREAD_CALC_TMP1_N1) */ l_budget_line_id_tab(i)
11016: ,tmp.RESOURCE_ASSIGNMENT_ID --resource_assignment_id
11017: ,tmp.BUDGET_VERSION_ID --budget_version_id
11018: ,tmp.TXN_CURRENCY_CODE --txn_currency_code
11019: ,tmp.QUANTITY --total_qty

Line 11100: FROM PA_FP_SPREAD_CALC_TMP1 tmp

11096: ,tmp.BL_CREATION_DATE
11097: ,tmp.BL_CREATED_BY --last updated by
11098: ,tmp.BL_CREATED_BY -- lastupdate login
11099: ,trunc(sysdate) -- last update dated
11100: FROM PA_FP_SPREAD_CALC_TMP1 tmp
11101: WHERE tmp.resource_assignment_id = l_resource_assignment_id_tab(i)
11102: AND tmp.txn_currency_code = l_txn_cur_code_tab(i)
11103: AND tmp.start_date = l_start_date_tab(i);
11104: