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

Line 759: INSERT INTO PA_FP_ROLLUP_TMP

755:
756: PROCEDURE insert_dummy_record_pvt (mc_rec IN mc_cur_rec%TYPE)
757: IS
758: BEGIN
759: INSERT INTO PA_FP_ROLLUP_TMP
760: (ROLLUP_ID
761: ,RESOURCE_ASSIGNMENT_ID
762: ,BUDGET_LINE_ID
763: ,OLD_START_DATE

Line 798: SELECT pa_fp_rollup_tmp_s.nextval

794: ,PROJFUNC_REV_EXCHANGE_RATE
795: ,PROJFUNC_REV_RATE_DATE_TYPE
796: ,PROJFUNC_REV_RATE_DATE
797: )
798: SELECT pa_fp_rollup_tmp_s.nextval
799: ,p_resource_assignment_id
800: ,NULL /* BUDGET_LINE_ID */
801: ,NULL
802: ,NULL

Line 1116: DELETE FROM PA_FP_ROLLUP_TMP;

1112: /* Fix for enhancement bug # 2604957 ends*/
1113:
1114: END IF;
1115:
1116: DELETE FROM PA_FP_ROLLUP_TMP;
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from PA_FP_ROLLUP_TMP table' ;
1120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 1119: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from PA_FP_ROLLUP_TMP table' ;

1115:
1116: DELETE FROM PA_FP_ROLLUP_TMP;
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from PA_FP_ROLLUP_TMP table' ;
1120: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1121: END IF;
1122:
1123:

Line 1142: INSERT INTO PA_FP_ROLLUP_TMP

1138: /* Bug 2672548 - We are deriving the PD / SD info even when budget lines doesnt exists.
1139: So, bucketing period code can be derived by comparing the start date in pa_fp_cpy_periods_tmp
1140: with the derived preceding / succeeding information. */
1141:
1142: INSERT INTO PA_FP_ROLLUP_TMP
1143: ( ROLLUP_ID
1144: ,RESOURCE_ASSIGNMENT_ID
1145: ,BUDGET_LINE_ID
1146: ,OLD_START_DATE

Line 1217: SELECT PA_FP_ROLLUP_TMP_S.NEXTVAL

1213: ,REVENUE_SOURCE
1214: ,PM_PRODUCT_CODE
1215: )
1216: (
1217: SELECT PA_FP_ROLLUP_TMP_S.NEXTVAL
1218: ,P_RESOURCE_ASSIGNMENT_ID
1219: ,pbl.BUDGET_LINE_ID
1220: ,pbl.START_DATE OLD_START_DATE /* when old_start_Date is null then the record should be inserted in pbl */
1221: ,tmp.START_DATE START_DATE

Line 1408: INSERT INTO PA_FP_ROLLUP_TMP

1404: IF P_PA_DEBUG_MODE = 'Y' THEN
1405: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,3);
1406: END IF;
1407:
1408: INSERT INTO PA_FP_ROLLUP_TMP
1409: ( ROLLUP_ID
1410: ,RESOURCE_ASSIGNMENT_ID
1411: ,BUDGET_LINE_ID
1412: ,OLD_START_DATE

Line 1483: SELECT pa_fp_rollup_tmp_s.nextval

1479: ,REVENUE_SOURCE
1480: ,PM_PRODUCT_CODE
1481: )
1482: (
1483: SELECT pa_fp_rollup_tmp_s.nextval
1484: ,p_resource_assignment_id /* Fix for bug # 2586514 */
1485: ,pbl.BUDGET_LINE_ID
1486: ,pbl.start_date OLD_START_DATE /* when old_start_Date is null then the record should be inserted in pbl */
1487: ,nvl(pbl.start_date,l_start_date)

Line 1583: UPDATE PA_FP_ROLLUP_TMP

1579: txn_currency code is not included in the where clause as it will fail in
1580: case of Plan In Another Currency.
1581: */
1582:
1583: UPDATE PA_FP_ROLLUP_TMP
1584: SET START_DATE = l_start_date,
1585: END_DATE = l_end_date
1586: WHERE resource_assignment_id = p_resource_assignment_id;
1587: END IF;

Line 1647: This procedure now can handle more than one resource assignments in PA_FP_ROLLUP_TMP.

1643: END POPULATE_ROLLUP_TMP;
1644:
1645: /* bug 2645574: Making this process more generic. Now this procedure can be used from places
1646: other than edit line page. One example is create_finplan_line.
1647: This procedure now can handle more than one resource assignments in PA_FP_ROLLUP_TMP.
1648: Logic will now be based upon budget_line_id rather than old_start_Date.
1649: If budget_line_id is null then it will be considered as new record (to be inserted)
1650: else records will be updated.
1651: */

Line 1691: from pa_resource_list_members prlm, pa_resource_assignments pra, pa_fp_rollup_tmp tmp

1687:
1688: Cursor c_disabled_resource_exists IS
1689: select 1 from dual
1690: where exists (select prlm.resource_list_member_id
1691: from pa_resource_list_members prlm, pa_resource_assignments pra, pa_fp_rollup_tmp tmp
1692: where pra.resource_assignment_id = p_resource_assignment_id
1693: and pra.resource_list_member_id= prlm.resource_list_member_id
1694: and nvl(prlm.enabled_flag,'Y') = 'N'
1695: and tmp.resource_assignment_id = pra.resource_assignment_id

Line 1742: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Deleting records from pa_fp_rollup_tmp that are not present in the budget lines table ';

1738: /*
1739: Delete all such lines from rollup_tmp table that are not existing in
1740: pa_budget_lines and also marked for delete by user.
1741: */
1742: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Deleting records from pa_fp_rollup_tmp that are not present in the budget lines table ';
1743: IF P_PA_DEBUG_MODE = 'Y' THEN
1744: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1745: END IF;
1746:

Line 1747: delete from pa_fp_rollup_tmp

1743: IF P_PA_DEBUG_MODE = 'Y' THEN
1744: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1745: END IF;
1746:
1747: delete from pa_fp_rollup_tmp
1748: where budget_line_id is null /* FPB3: bug 2645574: Instead of old_start_date refer budget_line_id */
1749: and (delete_flag = 'Y' or
1750: (txn_raw_cost is null and
1751: txn_burdened_cost is null and

Line 1772: UPDATE pa_fp_rollup_tmp

1768: we should not be deleting the records as such. This means PD/SD bucket amounts should
1769: be set to zero if delete flag = Y for them. PC/PFC buckets of PD/SD need not be touched
1770: since they will be maintained by the call to convert_mc api
1771:
1772: UPDATE pa_fp_rollup_tmp
1773: SET delete_flag = 'N'
1774: ,txn_raw_cost = DECODE(old_txn_raw_cost, NULL,NULL,0)
1775: ,txn_burdened_cost = DECODE(old_txn_burdened_cost,NULL,NULL,0)
1776: ,txn_revenue = DECODE(old_txn_revenue,NULL,NULL,0)

Line 1881: FROM pa_fp_rollup_tmp tmp

1877: ,bl.txn_currency_code
1878: ,bl.start_date ) IN (SELECT tmp.resource_assignment_id
1879: ,tmp.txn_currency_code
1880: ,tmp.old_start_date
1881: FROM pa_fp_rollup_tmp tmp
1882: WHERE nvl(tmp.delete_flag,'N') = 'Y') ;
1883: */
1884:
1885: DELETE /*+ INDEX( bl PA_BUDGET_LINES_U2 )*/ FROM pa_budget_lines bl --Bug 2782166

Line 1887: FROM pa_fp_rollup_tmp tmp

1883: */
1884:
1885: DELETE /*+ INDEX( bl PA_BUDGET_LINES_U2 )*/ FROM pa_budget_lines bl --Bug 2782166
1886: WHERE (budget_line_id) IN (SELECT budget_line_id
1887: FROM pa_fp_rollup_tmp tmp
1888: WHERE nvl(tmp.delete_flag,'N') = 'Y');
1889:
1890: pa_debug.g_err_stage := TO_CHAR(l_stage)||': Deleted '||sql%rowcount||' records';
1891: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2049: FROM pa_fp_rollup_tmp tmp

2045: ,FND_GLOBAL.USER_ID
2046: ,FND_GLOBAL.LOGIN_ID
2047: /* Code Addition for bug 3394907 ends */
2048:
2049: FROM pa_fp_rollup_tmp tmp
2050: WHERE bl.budget_line_id = tmp.budget_line_id
2051: AND tmp.budget_line_id IS NOT NULL
2052: AND nvl(tmp.delete_flag,'N') <> 'Y')
2053: WHERE ( bl.budget_line_id ) IN (SELECT tmp.budget_line_id

Line 2054: FROM pa_fp_rollup_tmp tmp

2050: WHERE bl.budget_line_id = tmp.budget_line_id
2051: AND tmp.budget_line_id IS NOT NULL
2052: AND nvl(tmp.delete_flag,'N') <> 'Y')
2053: WHERE ( bl.budget_line_id ) IN (SELECT tmp.budget_line_id
2054: FROM pa_fp_rollup_tmp tmp
2055: where nvl(tmp.delete_flag,'N') <> 'Y'
2056: AND tmp.budget_line_id IS NOT NULL);
2057:
2058: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2073: FROM pa_fp_rollup_tmp tmp

2069: ,bl.start_date
2070: ,bl.txn_currency_code ) IN (SELECT tmp.resource_assignment_id
2071: ,tmp.old_start_date
2072: ,tmp.txn_currency_code
2073: FROM pa_fp_rollup_tmp tmp
2074: where nvl(tmp.delete_flag,'N') <> 'Y'
2075: AND tmp.old_start_date IS NOT NULL) ;
2076: */
2077: /* Introduced following cursor for bug 3289243 */

Line 2232: FROM pa_fp_rollup_tmp tmp

2228: ,PROJECT_REV_RATE_DATE_TYPE
2229: ,PROJECT_REV_RATE_DATE
2230: ,pm_product_code -- , l_pm_product_code changed to pm_product_code for bug 3858543
2231: ,pm_budget_line_reference -- Added for bug 3858543
2232: FROM pa_fp_rollup_tmp tmp
2233: /* bug 2645574 changed the condition to look into budget_line_id
2234: WHERE tmp.old_start_date IS NULL
2235: */
2236: WHERE tmp.budget_line_id IS NULL

Line 3876: -- This procedure finds out the all the records in pa_fp_rollup_tmp with same

3872: END IF;
3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3874: END CALL_CLIENT_EXTENSIONS ;
3875:
3876: -- This procedure finds out the all the records in pa_fp_rollup_tmp with same
3877: -- budget start date, txn currency code and resource assignment. This
3878: -- api will be called from process_modified_lines whenever dup_val_on_index
3879: -- exception is raised.
3880:

Line 3891: FROM pa_fp_rollup_tmp

3887: -- Cursor to detect the duplicate rows
3888: CURSOR l_duplicate_rows_csr
3889: IS
3890: SELECT resource_assignment_id,start_date,txn_currency_code
3891: FROM pa_fp_rollup_tmp
3892: GROUP BY resource_assignment_id,txn_currency_code,start_date
3893: HAVING COUNT(*)>1;
3894:
3895: -- Cursor to get the resource assignment details