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_ROLLUP_TMP

Line 4725: ,pa_fp_rollup_tmp tmp

4721: ,bl.txn_init_burdened_cost
4722: ,bl.txn_init_revenue
4723: ,tmp.start_date plan_start_date ,tmp.end_date plan_end_date
4724: FROM pa_budget_lines bl
4725: ,pa_fp_rollup_tmp tmp
4726: WHERE bl.budget_version_id = p_budget_version_id
4727: AND bl.resource_assignment_id = tmp.resource_assignment_id
4728: AND bl.txn_currency_code = tmp.txn_currency_code
4729: AND NVL(tmp.processed_flag,'N') = 'Y'

Line 4919: ,pa_fp_rollup_tmp tmp

4915: ,bl.txn_init_burdened_cost
4916: ,bl.txn_init_revenue
4917: ,tmp.quantity fp_quantity
4918: FROM pa_budget_lines bl
4919: ,pa_fp_rollup_tmp tmp
4920: WHERE bl.budget_version_id = p_budget_version_id
4921: AND bl.resource_assignment_id = tmp.resource_assignment_id
4922: AND bl.txn_currency_code = tmp.txn_currency_code
4923: AND bl.start_date = tmp.start_date

Line 4938: FROM pa_fp_rollup_tmp tmp

4934: ,tmp.period_name
4935: ,tmp.quantity
4936: ,tmp.project_currency_code
4937: ,tmp.projfunc_currency_code
4938: FROM pa_fp_rollup_tmp tmp
4939: WHERE tmp.budget_version_id = p_budget_version_id
4940: AND NOT EXISTS
4941: (SELECT null
4942: FROM pa_budget_lines bl

Line 5430: DELETE FROM pa_fp_rollup_tmp

5426: End If;
5427:
5428: /* reset the rollup tmp table */
5429: -- bug fix:5203868
5430: DELETE FROM pa_fp_rollup_tmp
5431: WHERE budget_version_id = p_budget_version_id;
5432:
5433: IF g_Rspd_RaId_tab.COUNT > 0 Then
5434: /* populate records for start date change */

Line 5436: INSERT INTO pa_fp_rollup_tmp tmp

5432:
5433: IF g_Rspd_RaId_tab.COUNT > 0 Then
5434: /* populate records for start date change */
5435: FORALL i IN g_Rspd_RaId_tab.FIRST .. g_Rspd_RaId_tab.LAST
5436: INSERT INTO pa_fp_rollup_tmp tmp
5437: (resource_assignment_id
5438: ,txn_currency_code
5439: ,start_date
5440: ,end_date

Line 5465: UPDATE pa_fp_rollup_tmp tmp

5461: AND NVL(g_Rspd_SdShrk_Flg_tab(i),'N') = 'Y';
5462: --print_msg('Number lines inserted into fp_rollupTmp for StartDateShrunk['||sql%rowcount||']');
5463:
5464: /* Now update the rollup tmp table with the sum of bl line quantities prior to new plan start date*/
5465: UPDATE pa_fp_rollup_tmp tmp
5466: SET tmp.processed_flag = 'Y'
5467: ,tmp.quantity = (SELECT SUM(nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
5468: FROM pa_budget_lines bl
5469: WHERE bl.budget_version_id = p_budget_version_id

Line 5488: INSERT INTO pa_fp_rollup_tmp tmp

5484: );
5485:
5486: /* populate records for end date change */
5487: FORALL i IN g_Rspd_RaId_tab.FIRST .. g_Rspd_RaId_tab.LAST
5488: INSERT INTO pa_fp_rollup_tmp tmp
5489: (resource_assignment_id
5490: ,txn_currency_code
5491: ,start_date
5492: ,end_date

Line 5517: UPDATE pa_fp_rollup_tmp tmp

5513: AND NVL(g_Rspd_EdShrk_Flg_tab(i),'N') = 'Y';
5514:
5515: --print_msg('Number lines inserted into fp_rollupTmp for EndDateShrunk['||sql%rowcount||']');
5516: /* Now update the rollup tmp table with the sum of bl line quantities later than new plan end date */
5517: UPDATE pa_fp_rollup_tmp tmp
5518: SET tmp.processed_flag = 'Y'
5519: ,tmp.quantity = (SELECT SUM(nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
5520: FROM pa_budget_lines bl
5521: WHERE bl.budget_version_id = p_budget_version_id

Line 6255: DELETE FROM pa_fp_rollup_tmp

6251: End If;
6252: /* populate tmp table with the data */
6253: Init_plsqlTabs;
6254: DELETE FROM pa_fp_spread_calc_tmp;
6255: DELETE FROM pa_fp_rollup_tmp
6256: WHERE budget_version_id = p_budget_version_id;
6257:
6258: bvDetailsRec := NULL;
6259: OPEN cur_bvDetails(p_budget_version_id);

Line 7610: FROM pa_fp_rollup_tmp tmp

7606: FND_API.G_MISS_DATE, NULL,
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

Line 7672: FROM pa_fp_rollup_tmp tmp

7668: , cache.TXN_DISCOUNT_PERCENTAGE
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

Line 7879: UPDATE pa_fp_rollup_tmp tmp

7875: CLOSE fptmpDetails;
7876: IF l_rowid_tab.COUNT > 0 THEN
7877: --print_msg('Number of rows fetched['||l_rowid_tab.COUNT||']');
7878: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7879: UPDATE pa_fp_rollup_tmp tmp
7880: SET tmp.rw_cost_rate_override = l_cost_rate_override_tab(i)
7881: ,tmp.burden_cost_rate_override = l_burden_rate_override_tab(i)
7882: ,tmp.bill_rate_override = l_bill_rate_override_tab(i)
7883: ,tmp.PROJECT_COST_RATE_TYPE = l_PROJECT_COST_RATE_TYPE_tab(i)

Line 7959: UPDATE pa_fp_rollup_tmp tmp

7955: CLOSE blAttribDetails;
7956: IF l_rowid_tab.COUNT > 0 THEN
7957: --print_msg('Number of blAttrib rows fetched['||l_rowid_tab.COUNT||']');
7958: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7959: UPDATE pa_fp_rollup_tmp tmp
7960: SET tmp.CHANGE_REASON_CODE = l_CHANGE_REASON_CODE_tab(i)
7961: ,tmp.DESCRIPTION = l_DESCRIPTION_tab(i)
7962: ,tmp.ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY_tab(i)
7963: ,tmp.ATTRIBUTE1 = l_ATTRIBUTE1_tab(i)

Line 8365: FROM pa_fp_rollup_tmp r

8361: ,nvl(r.TRANSFER_PRICE_RATE,b.TRANSFER_PRICE_RATE) TRANSFER_PRICE_RATE
8362: ,r.BL_CREATED_BY
8363: ,r.BL_CREATION_DATE
8364: ,NVL(ra.rate_based_flag,'N')
8365: FROM pa_fp_rollup_tmp r
8366: ,pa_budget_lines b
8367: ,pa_resource_assignments ra
8368: WHERE r.budget_line_id = b.budget_line_id
8369: AND b.budget_version_id = p_budget_version_id

Line 8398: ,pa_fp_rollup_tmp r

8394: ,bl.txn_currency_code
8395: ,bl.project_currency_code
8396: ,bl.projfunc_currency_code
8397: FROM pa_budget_lines bl
8398: ,pa_fp_rollup_tmp r
8399: WHERE bl.budget_version_id = p_budget_version_id
8400: AND bl.budget_line_id = r.budget_line_id
8401: AND NVL(r.processed_flag,'Y') <> 'N';
8402: /* bug fix:5031388

Line 9617: UPDATE PA_FP_ROLLUP_TMP tmp

9613: /*We should pass the +ve values for the updated rows. having returning clause in the bulk update returns the
9614: * rejected records with the updated values, so the returning clause cannot be used. In order to pass the correct bl values
9615: * update the rollup tmp processed flag with N for the rejected records */
9616: FORALL i IN l_err_error_code_tab.FIRST .. l_err_error_code_tab.LAST
9617: UPDATE PA_FP_ROLLUP_TMP tmp
9618: SET tmp.processed_flag = 'N'
9619: WHERE tmp.budget_line_id = l_err_budget_line_id_tab(i);
9620: /* now pass the +ve values for the updated budget lines based on the processed flag from the tmp table */
9621: IF NVL(g_rollup_required_flag,'N') = 'Y' THEN

Line 9914: UPDATE pa_fp_rollup_tmp tmp

9910: IF l_del_budget_line_id_tab.COUNT > 0 THEN --{
9911: /* MRC enhancements */
9912: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then
9913: FORALL i IN l_del_budget_line_id_tab.FIRST .. l_del_budget_line_id_tab.LAST
9914: UPDATE pa_fp_rollup_tmp tmp
9915: SET tmp.delete_flag = 'Y'
9916: WHERE tmp.budget_line_id = l_del_budget_line_id_tab(i);
9917: END IF;
9918:

Line 9929: UPDATE pa_fp_rollup_tmp tmp

9925: /* MRC ehancements changes: */
9926: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' AND l_tmp2_budget_line_id_tab.COUNT > 0 THEN --{
9927: /* update rollup data with existing budget lines data */
9928: FORALL exBlId IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9929: UPDATE pa_fp_rollup_tmp tmp
9930: SET ( tmp.quantity
9931: ,tmp.txn_raw_cost
9932: ,tmp.txn_burdened_cost
9933: ,tmp.txn_revenue

Line 9990: INSERT INTO pa_fp_rollup_tmp tmp

9986: WHERE tmp.budget_line_id = l_tmp2_budget_line_id_tab(exBlId);
9987:
9988: /* Copy the rows from budget lines to rollup tmp when existing budget line id doesnot exists in rollup tmp */
9989: FORALL exBlId IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9990: INSERT INTO pa_fp_rollup_tmp tmp
9991: ( tmp.budget_line_id
9992: ,tmp.budget_version_id
9993: ,tmp.resource_assignment_id
9994: ,tmp.txn_currency_code

Line 10061: FROM PA_FP_ROLLUP_TMP tmp1

10057: ,bl.projfunc_rev_rate_date
10058: FROM pa_budget_lines bl
10059: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(exBlId)
10060: AND NOT EXISTS ( SELECT NULL
10061: FROM PA_FP_ROLLUP_TMP tmp1
10062: WHERE tmp1.budget_line_id = l_tmp2_budget_line_id_tab(exBlId)
10063: );
10064:
10065: END IF; --}

Line 10138: /*Bug 4224464.This procedure update_dffcols would be called to insert into pa_fp_rollup_tmp

10134:
10135: END BLK_update_budget_lines;
10136:
10137:
10138: /*Bug 4224464.This procedure update_dffcols would be called to insert into pa_fp_rollup_tmp
10139: * all those budget lines which are not already present in pa_fp_rollup_tmp.
10140: * These lines would be the ones with no changes to qty/amnt and rate columns.
10141: * The lines with changes to qty/amnt and rate columns would not be processed by this API
10142: * as earlier call to copy_blattributes would have handled theselines Also using the

Line 10139: * all those budget lines which are not already present in pa_fp_rollup_tmp.

10135: END BLK_update_budget_lines;
10136:
10137:
10138: /*Bug 4224464.This procedure update_dffcols would be called to insert into pa_fp_rollup_tmp
10139: * all those budget lines which are not already present in pa_fp_rollup_tmp.
10140: * These lines would be the ones with no changes to qty/amnt and rate columns.
10141: * The lines with changes to qty/amnt and rate columns would not be processed by this API
10142: * as earlier call to copy_blattributes would have handled theselines Also using the
10143: * same signature for this API as used for copy_blattributes above.

Line 10271: AND NOT EXISTS (SELECT 'X' FROM pa_fp_rollup_tmp tmp WHERE tmp.budget_version_id = cache.budget_version_id

10267: /*If a new budget line (not exists in pa_budget_lines) is attempted to be created with all amts/qty/rate as null but
10268: * with dffs/mc/change reason, from amg flow, that budget line would not be selected due to the join with pa_budget_lines.
10269: * This is only intended as budget lines with null amts/qty are not maintained in pa_budget_lines any more.
10270: */
10271: AND NOT EXISTS (SELECT 'X' FROM pa_fp_rollup_tmp tmp WHERE tmp.budget_version_id = cache.budget_version_id
10272: AND tmp.resource_assignment_id = cache.resource_assignment_id
10273: AND tmp.txn_currency_code = cache.txn_currency_code
10274: AND tmp.start_date = cache.start_date);
10275:

Line 10610: INSERT INTO pa_fp_rollup_tmp tmp

10606: IF l_resource_assignment_id_tab.COUNT > 0 THEN
10607: --print_msg('Number of blAttrib rows fetched['||l_resource_assignment_id_tab.COUNT||']');
10608:
10609: FORALL i IN l_resource_assignment_id_tab.FIRST .. l_resource_assignment_id_tab.LAST
10610: INSERT INTO pa_fp_rollup_tmp tmp
10611: (
10612: budget_version_id
10613: ,resource_assignment_id
10614: ,start_date