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 4696: ,pa_fp_rollup_tmp tmp

4692: ,bl.txn_init_burdened_cost
4693: ,bl.txn_init_revenue
4694: ,tmp.start_date plan_start_date ,tmp.end_date plan_end_date
4695: FROM pa_budget_lines bl
4696: ,pa_fp_rollup_tmp tmp
4697: WHERE bl.budget_version_id = p_budget_version_id
4698: AND bl.resource_assignment_id = tmp.resource_assignment_id
4699: AND bl.txn_currency_code = tmp.txn_currency_code
4700: AND NVL(tmp.processed_flag,'N') = 'Y'

Line 4890: ,pa_fp_rollup_tmp tmp

4886: ,bl.txn_init_burdened_cost
4887: ,bl.txn_init_revenue
4888: ,tmp.quantity fp_quantity
4889: FROM pa_budget_lines bl
4890: ,pa_fp_rollup_tmp tmp
4891: WHERE bl.budget_version_id = p_budget_version_id
4892: AND bl.resource_assignment_id = tmp.resource_assignment_id
4893: AND bl.txn_currency_code = tmp.txn_currency_code
4894: AND bl.start_date = tmp.start_date

Line 4909: FROM pa_fp_rollup_tmp tmp

4905: ,tmp.period_name
4906: ,tmp.quantity
4907: ,tmp.project_currency_code
4908: ,tmp.projfunc_currency_code
4909: FROM pa_fp_rollup_tmp tmp
4910: WHERE tmp.budget_version_id = p_budget_version_id
4911: AND NOT EXISTS
4912: (SELECT null
4913: FROM pa_budget_lines bl

Line 5401: DELETE FROM pa_fp_rollup_tmp

5397: End If;
5398:
5399: /* reset the rollup tmp table */
5400: -- bug fix:5203868
5401: DELETE FROM pa_fp_rollup_tmp
5402: WHERE budget_version_id = p_budget_version_id;
5403:
5404: IF g_Rspd_RaId_tab.COUNT > 0 Then
5405: /* populate records for start date change */

Line 5407: INSERT INTO pa_fp_rollup_tmp tmp

5403:
5404: IF g_Rspd_RaId_tab.COUNT > 0 Then
5405: /* populate records for start date change */
5406: FORALL i IN g_Rspd_RaId_tab.FIRST .. g_Rspd_RaId_tab.LAST
5407: INSERT INTO pa_fp_rollup_tmp tmp
5408: (resource_assignment_id
5409: ,txn_currency_code
5410: ,start_date
5411: ,end_date

Line 5436: UPDATE pa_fp_rollup_tmp tmp

5432: AND NVL(g_Rspd_SdShrk_Flg_tab(i),'N') = 'Y';
5433: --print_msg('Number lines inserted into fp_rollupTmp for StartDateShrunk['||sql%rowcount||']');
5434:
5435: /* Now update the rollup tmp table with the sum of bl line quantities prior to new plan start date*/
5436: UPDATE pa_fp_rollup_tmp tmp
5437: SET tmp.processed_flag = 'Y'
5438: ,tmp.quantity = (SELECT SUM(nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
5439: FROM pa_budget_lines bl
5440: WHERE bl.budget_version_id = p_budget_version_id

Line 5459: INSERT INTO pa_fp_rollup_tmp tmp

5455: );
5456:
5457: /* populate records for end date change */
5458: FORALL i IN g_Rspd_RaId_tab.FIRST .. g_Rspd_RaId_tab.LAST
5459: INSERT INTO pa_fp_rollup_tmp tmp
5460: (resource_assignment_id
5461: ,txn_currency_code
5462: ,start_date
5463: ,end_date

Line 5488: UPDATE pa_fp_rollup_tmp tmp

5484: AND NVL(g_Rspd_EdShrk_Flg_tab(i),'N') = 'Y';
5485:
5486: --print_msg('Number lines inserted into fp_rollupTmp for EndDateShrunk['||sql%rowcount||']');
5487: /* Now update the rollup tmp table with the sum of bl line quantities later than new plan end date */
5488: UPDATE pa_fp_rollup_tmp tmp
5489: SET tmp.processed_flag = 'Y'
5490: ,tmp.quantity = (SELECT SUM(nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
5491: FROM pa_budget_lines bl
5492: WHERE bl.budget_version_id = p_budget_version_id

Line 6226: DELETE FROM pa_fp_rollup_tmp

6222: End If;
6223: /* populate tmp table with the data */
6224: Init_plsqlTabs;
6225: DELETE FROM pa_fp_spread_calc_tmp;
6226: DELETE FROM pa_fp_rollup_tmp
6227: WHERE budget_version_id = p_budget_version_id;
6228:
6229: bvDetailsRec := NULL;
6230: OPEN cur_bvDetails(p_budget_version_id);

Line 7579: FROM pa_fp_rollup_tmp tmp

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

Line 7641: FROM pa_fp_rollup_tmp tmp

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

Line 7848: UPDATE pa_fp_rollup_tmp tmp

7844: CLOSE fptmpDetails;
7845: IF l_rowid_tab.COUNT > 0 THEN
7846: --print_msg('Number of rows fetched['||l_rowid_tab.COUNT||']');
7847: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7848: UPDATE pa_fp_rollup_tmp tmp
7849: SET tmp.rw_cost_rate_override = l_cost_rate_override_tab(i)
7850: ,tmp.burden_cost_rate_override = l_burden_rate_override_tab(i)
7851: ,tmp.bill_rate_override = l_bill_rate_override_tab(i)
7852: ,tmp.PROJECT_COST_RATE_TYPE = l_PROJECT_COST_RATE_TYPE_tab(i)

Line 7928: UPDATE pa_fp_rollup_tmp tmp

7924: CLOSE blAttribDetails;
7925: IF l_rowid_tab.COUNT > 0 THEN
7926: --print_msg('Number of blAttrib rows fetched['||l_rowid_tab.COUNT||']');
7927: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7928: UPDATE pa_fp_rollup_tmp tmp
7929: SET tmp.CHANGE_REASON_CODE = l_CHANGE_REASON_CODE_tab(i)
7930: ,tmp.DESCRIPTION = l_DESCRIPTION_tab(i)
7931: ,tmp.ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY_tab(i)
7932: ,tmp.ATTRIBUTE1 = l_ATTRIBUTE1_tab(i)

Line 8334: FROM pa_fp_rollup_tmp r

8330: ,nvl(r.TRANSFER_PRICE_RATE,b.TRANSFER_PRICE_RATE) TRANSFER_PRICE_RATE
8331: ,r.BL_CREATED_BY
8332: ,r.BL_CREATION_DATE
8333: ,NVL(ra.rate_based_flag,'N')
8334: FROM pa_fp_rollup_tmp r
8335: ,pa_budget_lines b
8336: ,pa_resource_assignments ra
8337: WHERE r.budget_line_id = b.budget_line_id
8338: AND b.budget_version_id = p_budget_version_id

Line 8367: ,pa_fp_rollup_tmp r

8363: ,bl.txn_currency_code
8364: ,bl.project_currency_code
8365: ,bl.projfunc_currency_code
8366: FROM pa_budget_lines bl
8367: ,pa_fp_rollup_tmp r
8368: WHERE bl.budget_version_id = p_budget_version_id
8369: AND bl.budget_line_id = r.budget_line_id
8370: AND NVL(r.processed_flag,'Y') <> 'N';
8371: /* bug fix:5031388

Line 9383: UPDATE PA_FP_ROLLUP_TMP tmp

9379: /*We should pass the +ve values for the updated rows. having returning clause in the bulk update returns the
9380: * rejected records with the updated values, so the returning clause cannot be used. In order to pass the correct bl values
9381: * update the rollup tmp processed flag with N for the rejected records */
9382: FORALL i IN l_err_error_code_tab.FIRST .. l_err_error_code_tab.LAST
9383: UPDATE PA_FP_ROLLUP_TMP tmp
9384: SET tmp.processed_flag = 'N'
9385: WHERE tmp.budget_line_id = l_err_budget_line_id_tab(i);
9386: /* now pass the +ve values for the updated budget lines based on the processed flag from the tmp table */
9387: IF NVL(g_rollup_required_flag,'N') = 'Y' THEN

Line 9668: UPDATE pa_fp_rollup_tmp tmp

9664: IF l_del_budget_line_id_tab.COUNT > 0 THEN --{
9665: /* MRC enhancements */
9666: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then
9667: FORALL i IN l_del_budget_line_id_tab.FIRST .. l_del_budget_line_id_tab.LAST
9668: UPDATE pa_fp_rollup_tmp tmp
9669: SET tmp.delete_flag = 'Y'
9670: WHERE tmp.budget_line_id = l_del_budget_line_id_tab(i);
9671: END IF;
9672:

Line 9683: UPDATE pa_fp_rollup_tmp tmp

9679: /* MRC ehancements changes: */
9680: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' AND l_tmp2_budget_line_id_tab.COUNT > 0 THEN --{
9681: /* update rollup data with existing budget lines data */
9682: FORALL exBlId IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9683: UPDATE pa_fp_rollup_tmp tmp
9684: SET ( tmp.quantity
9685: ,tmp.txn_raw_cost
9686: ,tmp.txn_burdened_cost
9687: ,tmp.txn_revenue

Line 9744: INSERT INTO pa_fp_rollup_tmp tmp

9740: WHERE tmp.budget_line_id = l_tmp2_budget_line_id_tab(exBlId);
9741:
9742: /* Copy the rows from budget lines to rollup tmp when existing budget line id doesnot exists in rollup tmp */
9743: FORALL exBlId IN l_tmp2_budget_line_id_tab.FIRST .. l_tmp2_budget_line_id_tab.LAST
9744: INSERT INTO pa_fp_rollup_tmp tmp
9745: ( tmp.budget_line_id
9746: ,tmp.budget_version_id
9747: ,tmp.resource_assignment_id
9748: ,tmp.txn_currency_code

Line 9815: FROM PA_FP_ROLLUP_TMP tmp1

9811: ,bl.projfunc_rev_rate_date
9812: FROM pa_budget_lines bl
9813: WHERE bl.budget_line_id = l_tmp2_budget_line_id_tab(exBlId)
9814: AND NOT EXISTS ( SELECT NULL
9815: FROM PA_FP_ROLLUP_TMP tmp1
9816: WHERE tmp1.budget_line_id = l_tmp2_budget_line_id_tab(exBlId)
9817: );
9818:
9819: END IF; --}

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

9888:
9889: END BLK_update_budget_lines;
9890:
9891:
9892: /*Bug 4224464.This procedure update_dffcols would be called to insert into pa_fp_rollup_tmp
9893: * all those budget lines which are not already present in pa_fp_rollup_tmp.
9894: * These lines would be the ones with no changes to qty/amnt and rate columns.
9895: * The lines with changes to qty/amnt and rate columns would not be processed by this API
9896: * as earlier call to copy_blattributes would have handled theselines Also using the

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

9889: END BLK_update_budget_lines;
9890:
9891:
9892: /*Bug 4224464.This procedure update_dffcols would be called to insert into pa_fp_rollup_tmp
9893: * all those budget lines which are not already present in pa_fp_rollup_tmp.
9894: * These lines would be the ones with no changes to qty/amnt and rate columns.
9895: * The lines with changes to qty/amnt and rate columns would not be processed by this API
9896: * as earlier call to copy_blattributes would have handled theselines Also using the
9897: * same signature for this API as used for copy_blattributes above.

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

10021: /*If a new budget line (not exists in pa_budget_lines) is attempted to be created with all amts/qty/rate as null but
10022: * with dffs/mc/change reason, from amg flow, that budget line would not be selected due to the join with pa_budget_lines.
10023: * This is only intended as budget lines with null amts/qty are not maintained in pa_budget_lines any more.
10024: */
10025: AND NOT EXISTS (SELECT 'X' FROM pa_fp_rollup_tmp tmp WHERE tmp.budget_version_id = cache.budget_version_id
10026: AND tmp.resource_assignment_id = cache.resource_assignment_id
10027: AND tmp.txn_currency_code = cache.txn_currency_code
10028: AND tmp.start_date = cache.start_date);
10029:

Line 10364: INSERT INTO pa_fp_rollup_tmp tmp

10360: IF l_resource_assignment_id_tab.COUNT > 0 THEN
10361: --print_msg('Number of blAttrib rows fetched['||l_resource_assignment_id_tab.COUNT||']');
10362:
10363: FORALL i IN l_resource_assignment_id_tab.FIRST .. l_resource_assignment_id_tab.LAST
10364: INSERT INTO pa_fp_rollup_tmp tmp
10365: (
10366: budget_version_id
10367: ,resource_assignment_id
10368: ,start_date