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_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_LINES

Line 242: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS

238: p_module_name => l_module_name,
239: p_log_level => 5);
240: END IF;
241:
242: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS
243: tables when the flag is set to N */
244: IF l_fp_cols_rec.x_gen_ret_manual_line_flag = 'N' THEN
245: DELETE FROM PA_BUDGET_LINES
246: WHERE budget_version_id = p_budget_version_id ;

Line 245: DELETE FROM PA_BUDGET_LINES

241:
242: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS
243: tables when the flag is set to N */
244: IF l_fp_cols_rec.x_gen_ret_manual_line_flag = 'N' THEN
245: DELETE FROM PA_BUDGET_LINES
246: WHERE budget_version_id = p_budget_version_id ;
247:
248: DELETE FROM PA_RESOURCE_ASSIGNMENTS
249: WHERE budget_version_id = p_budget_version_id ;

Line 304: DELETE FROM PA_BUDGET_LINES

300: transaction_source_code IS NOT NULL;
301:
302: IF (l_res_as_id.count > 0) THEN
303: FORALL i IN 1 .. l_res_as_id.count
304: DELETE FROM PA_BUDGET_LINES
305: WHERE resource_assignment_id = l_res_as_id(i);
306:
307: FORALL j IN 1 .. l_res_as_id.count
308: UPDATE PA_RESOURCE_ASSIGNMENTS

Line 599: -- table (instead of pa_budget_lines) earlier in the code flow by the

595:
596: -- Bug 4549862: When generating a Cost and Revenue together version
597: -- from Staffing Plan with revenue accrual method of COST, the
598: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
599: -- table (instead of pa_budget_lines) earlier in the code flow by the
600: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
601: -- can be honored. We should not call the currency conversion API in
602: -- this case.
603:

Line 938: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

934: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
935:
936: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH';
937:
938: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
939:
940: CURSOR PROJ_DETAILS IS
941: SELECT P.PROJECT_TYPE,
942: P.PROJECT_CURRENCY_CODE,

Line 1113: FROM PA_BUDGET_LINES BL,

1109: c_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE) IS
1110: SELECT BL.PERIOD_NAME,
1111: BL.START_DATE,
1112: BL.BURDENED_COST
1113: FROM PA_BUDGET_LINES BL,
1114: PA_RESOURCE_ASSIGNMENTS RA
1115: WHERE BL.RESOURCE_ASSIGNMENT_ID = RA.RESOURCE_ASSIGNMENT_ID
1116: AND RA.BUDGET_VERSION_ID = c_budget_version_id
1117: AND RA.PROJECT_ID = c_project_id

Line 1490: -- Inserted into pa_budget_lines.

1486: -- Bug 4549862: Added cursor for when the target version is None
1487: -- Time Phased and the context is Forecast Generation. In this
1488: -- case, budget lines may exist with actuals. Fetch temp table
1489: -- data for which budget lines do not yet exist, which should be
1490: -- Inserted into pa_budget_lines.
1491:
1492: -- Bug 4615787: Removed start_date, end_date, period_name,
1493: -- bill_markup_percentage, and cost_ind_compiled_set_id from the
1494: -- GROUP BY clause. In the SELECT clause, take MIN(start_date),

Line 1521: FROM pa_budget_lines bl

1517: COST_REJECTION_CODE,
1518: BURDEN_REJECTION_CODE,
1519: REVENUE_REJECTION_CODE
1520: HAVING ( SELECT count(*)
1521: FROM pa_budget_lines bl
1522: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1523: AND tmp.txn_currency_code = bl.txn_currency_code ) = 0;
1524:
1525:

Line 1530: -- into pa_budget_lines.

1526: -- Bug 4549862: Added cursor for when the target version is None
1527: -- Time Phased and the context is Forecast Generation. In this
1528: -- case, budget lines may exist with actuals. Fetch temp table
1529: -- data for which budget lines exist, which whould be Updated
1530: -- into pa_budget_lines.
1531:
1532: -- Bug 4615787: Removed start_date, end_date, period_name,
1533: -- bill_markup_percentage, and cost_ind_compiled_set_id from the
1534: -- GROUP BY clause. In the SELECT clause, take MIN(start_date),

Line 1561: FROM pa_budget_lines bl

1557: COST_REJECTION_CODE,
1558: BURDEN_REJECTION_CODE,
1559: REVENUE_REJECTION_CODE
1560: HAVING ( SELECT count(*)
1561: FROM pa_budget_lines bl
1562: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1563: AND tmp.txn_currency_code = bl.txn_currency_code ) > 0;
1564:
1565:

Line 2043: -- Note: these are not valid budget_line_id values in pa_budget_lines.

2039:
2040: -- Bug 4549862: Added counter to track unique budget_line_id values for
2041: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2042: -- then incremented by 1 prior to each Insert to the temp table.
2043: -- Note: these are not valid budget_line_id values in pa_budget_lines.
2044: -- Rather, we are using the column to index records for processing of
2045: -- cost-based revenue amounts, since an Index exists for the column.
2046: l_bl_id_counter NUMBER;
2047:

Line 2161: DELETE FROM pa_budget_lines

2157: code is NOT NULL should be deleted. for forecast version, 'P' and 'G' time phased, all
2158: ETC budget lines should be deleted; 'N' time phased, ETC should be deleted or negated.*/
2159: IF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
2160: IF P_PLAN_CLASS_CODE = 'BUDGET' THEN
2161: DELETE FROM pa_budget_lines
2162: WHERE budget_version_id = p_budget_version_id
2163: AND budget_line_id IN
2164: (SELECT bl.budget_line_id
2165: FROM pa_budget_lines bl, pa_resource_assignments ra

Line 2165: FROM pa_budget_lines bl, pa_resource_assignments ra

2161: DELETE FROM pa_budget_lines
2162: WHERE budget_version_id = p_budget_version_id
2163: AND budget_line_id IN
2164: (SELECT bl.budget_line_id
2165: FROM pa_budget_lines bl, pa_resource_assignments ra
2166: WHERE ra.budget_version_id = p_budget_version_id
2167: AND bl.budget_version_id = p_budget_version_id
2168: AND ra.transaction_source_code IS NOT NULL
2169: AND ra.resource_assignment_id = bl.resource_assignment_id);

Line 2172: DELETE FROM pa_budget_lines

2168: AND ra.transaction_source_code IS NOT NULL
2169: AND ra.resource_assignment_id = bl.resource_assignment_id);
2170: ELSIF P_PLAN_CLASS_CODE = 'FORECAST' THEN
2171: IF P_FP_COLS_REC.x_time_phased_code IN ('P','G') THEN
2172: DELETE FROM pa_budget_lines
2173: WHERE budget_version_id = p_budget_version_id
2174: AND budget_line_id IN
2175: (SELECT bl.budget_line_id
2176: FROM pa_budget_lines bl, pa_resource_assignments ra

Line 2176: FROM pa_budget_lines bl, pa_resource_assignments ra

2172: DELETE FROM pa_budget_lines
2173: WHERE budget_version_id = p_budget_version_id
2174: AND budget_line_id IN
2175: (SELECT bl.budget_line_id
2176: FROM pa_budget_lines bl, pa_resource_assignments ra
2177: WHERE ra.budget_version_id = p_budget_version_id
2178: AND bl.budget_version_id = p_budget_version_id
2179: AND ra.transaction_source_code IS NOT NULL
2180: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 2183: DELETE FROM pa_budget_lines

2179: AND ra.transaction_source_code IS NOT NULL
2180: AND ra.resource_assignment_id = bl.resource_assignment_id
2181: AND bl.start_date > p_actuals_thru_date);
2182: ELSE
2183: DELETE FROM pa_budget_lines
2184: WHERE budget_version_id = p_budget_version_id
2185: AND NVL(init_quantity,0) = 0
2186: AND NVL(init_raw_cost,0) = 0
2187: AND NVL(init_burdened_cost,0) = 0

Line 2190: UPDATE pa_budget_lines

2186: AND NVL(init_raw_cost,0) = 0
2187: AND NVL(init_burdened_cost,0) = 0
2188: AND NVL(init_revenue,0) = 0;
2189:
2190: UPDATE pa_budget_lines
2191: SET quantity = init_quantity,
2192: txn_raw_cost = txn_init_raw_cost,
2193: txn_burdened_cost = txn_init_burdened_cost,
2194: txn_revenue = txn_init_revenue,

Line 2210: FROM pa_budget_lines bl, pa_resource_assignments ra

2206: projfunc_rev_exchange_rate = DECODE(NVL(txn_init_revenue,0),0,NULL,init_revenue/txn_init_revenue)
2207: WHERE budget_version_id = p_budget_version_id
2208: AND budget_line_id IN
2209: (SELECT bl.budget_line_id
2210: FROM pa_budget_lines bl, pa_resource_assignments ra
2211: WHERE ra.budget_version_id = p_budget_version_id
2212: AND bl.budget_version_id = p_budget_version_id
2213: AND ra.transaction_source_code IS NOT NULL
2214: AND ra.resource_assignment_id = bl.resource_assignment_id);

Line 3448: -- PA_BUDGET_LINES table.

3444:
3445: -- Bug 4549862: Call currency conversion API. Passing 'N' for
3446: -- the p_entire_version parameter tells to the API to convert
3447: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3448: -- PA_BUDGET_LINES table.
3449:
3450: IF p_pa_debug_mode = 'Y' THEN
3451: pa_fp_gen_amount_utils.fp_debug
3452: (p_called_mode => p_called_mode,

Line 3708: -- may need to be Updated in pa_budget_lines.

3704: -- Bug 4549862: If the target version is None timephased and the
3705: -- context is Forecast generation, then budget lines containing
3706: -- actuals may exist. As a result, some of the data in the temp
3707: -- table may need to be Inserted while other data in the table
3708: -- may need to be Updated in pa_budget_lines.
3709: --
3710: -- Group the temporary table data by resource assignment and txn
3711: -- currency code using separate cursors for the Insert/Update cases.
3712:

Line 3819: INSERT INTO PA_BUDGET_LINES(

3815: -- cost ind compiled set id and rejection codes
3816: IF l_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
3817:
3818: FORALL bl_index IN 1 .. l_bl_START_DATE_tab.COUNT
3819: INSERT INTO PA_BUDGET_LINES(
3820: RESOURCE_ASSIGNMENT_ID,
3821: START_DATE,
3822: LAST_UPDATE_DATE,
3823: LAST_UPDATED_BY,

Line 3858: PA_BUDGET_LINES_S.nextval,

3854: l_bl_END_DATE_tab(bl_index),
3855: l_bl_PERIOD_NAME_tab(bl_index),
3856: l_bl_QUANTITY_tab(bl_index),
3857: l_bl_TXN_CURRENCY_CODE_tab(bl_index),
3858: PA_BUDGET_LINES_S.nextval,
3859: P_BUDGET_VERSION_ID,
3860: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_RAW_COST_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),
3861: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_REVENUE_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),
3862: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_BURDENED_COST_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),

Line 3879: -- may need to be Updated in pa_budget_lines.

3875: -- Bug 4549862: If the target version is None timephased and the
3876: -- context is Forecast generation, then budget lines containing
3877: -- actuals may exist. As a result, some of the data in the temp
3878: -- table may need to be Inserted while other data in the table
3879: -- may need to be Updated in pa_budget_lines.
3880: --
3881: -- The following code Updates the budget lines.
3882:
3883: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN

Line 3886: UPDATE PA_BUDGET_LINES

3882:
3883: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
3884:
3885: FORALL bl_index IN 1 .. l_upd_bl_START_DATE_tab.COUNT
3886: UPDATE PA_BUDGET_LINES
3887: SET LAST_UPDATE_DATE = l_sysdate,
3888: LAST_UPDATED_BY = l_last_updated_by,
3889: LAST_UPDATE_LOGIN = l_last_update_login,
3890: START_DATE = LEAST(START_DATE, l_upd_bl_START_DATE_tab(bl_index)),

Line 4029: FROM pa_budget_lines

4025: p_log_level => 5);
4026: END IF;
4027: SELECT count(*)
4028: INTO l_count
4029: FROM pa_budget_lines
4030: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4031: AND rownum <2;
4032:
4033: --dbms_output.put_line('==j=='||j

Line 4058: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,

4054: --end loop;
4055:
4056: IF l_count = 0 THEN
4057: FORALL fp IN 1 .. l_rt_start_date_tab.COUNT
4058: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,
4059: START_DATE,
4060: LAST_UPDATE_DATE,
4061: LAST_UPDATED_BY,
4062: CREATION_DATE,

Line 4084: PA_BUDGET_LINES_S.nextval,

4080: l_rt_end_date_tab(fp),
4081: l_rt_pd_name_tab(fp),
4082: l_rt_qty_tab(fp),
4083: l_project_currency_code,
4084: PA_BUDGET_LINES_S.nextval,
4085: P_BUDGET_VERSION_ID,
4086: p_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
4087: p_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE);
4088: ELSE

Line 4098: FROM pa_budget_lines

4094: -- for budget line existence differently based on Target timephase.
4095: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
4096: SELECT count(*)
4097: INTO l_count1
4098: FROM pa_budget_lines
4099: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4100: AND txn_currency_code = l_project_currency_code
4101: AND start_date = l_rt_start_date_tab(fp);
4102: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN

Line 4105: FROM pa_budget_lines

4101: AND start_date = l_rt_start_date_tab(fp);
4102: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
4103: SELECT count(*)
4104: INTO l_count1
4105: FROM pa_budget_lines
4106: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4107: AND txn_currency_code = l_project_currency_code;
4108: END IF;
4109: IF l_count1 = 0 then

Line 4110: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,

4106: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4107: AND txn_currency_code = l_project_currency_code;
4108: END IF;
4109: IF l_count1 = 0 then
4110: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,
4111: START_DATE,
4112: LAST_UPDATE_DATE,
4113: LAST_UPDATED_BY,
4114: CREATION_DATE,

Line 4136: PA_BUDGET_LINES_S.nextval,

4132: l_rt_end_date_tab(fp),
4133: l_rt_pd_name_tab(fp),
4134: l_rt_qty_tab(fp),
4135: l_project_currency_code,
4136: PA_BUDGET_LINES_S.nextval,
4137: P_BUDGET_VERSION_ID,
4138: p_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
4139: p_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE);
4140: ELSE

Line 4147: UPDATE pa_budget_lines

4143: -- When the Target is None timephased, budget lines should be unique
4144: -- given (Resource Assignment Id, Currency Code). Split Update logic into
4145: -- 2 cases based on Target timephase.
4146: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
4147: UPDATE pa_budget_lines
4148: SET quantity = nvl(quantity,0) +
4149: l_rt_qty_tab(fp)
4150: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4151: AND txn_currency_code = l_project_currency_code

Line 4154: UPDATE pa_budget_lines

4150: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4151: AND txn_currency_code = l_project_currency_code
4152: AND start_date = l_rt_start_date_tab(fp);
4153: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
4154: UPDATE pa_budget_lines
4155: SET quantity = nvl(quantity,0) + l_rt_qty_tab(fp),
4156: start_date = least(start_date, l_rt_start_date_tab(fp)),
4157: end_date = greatest(end_date, l_rt_end_date_tab(fp))
4158: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)

Line 4205: FROM pa_budget_lines

4201:
4202: FOR i IN 1..l_res_assgn_id_tmp_tab.count LOOP
4203: SELECT SUM(quantity)
4204: INTO l_total_plan_quantity
4205: FROM pa_budget_lines
4206: WHERE resource_assignment_id = l_res_assgn_id_tmp_tab(i); /* Bug 4093872 - Column name corrected from budget_version_id to resource_assignment_id */
4207:
4208: INSERT INTO pa_fp_calc_amt_tmp2(
4209: resource_assignment_id,

Line 6135: FROM pa_budget_lines bl

6131: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
6132: AND ra.transaction_source_code IS NULL
6133: AND EXISTS
6134: ( SELECT 1
6135: FROM pa_budget_lines bl
6136: WHERE bl.resource_assignment_id = ra.resource_assignment_id
6137: AND rownum = 1 ));
6138: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
6139: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

Line 6150: FROM pa_budget_lines bl

6146: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
6147: AND ra.transaction_source_code IS NULL
6148: AND EXISTS
6149: ( SELECT 1
6150: FROM pa_budget_lines bl
6151: WHERE bl.resource_assignment_id = ra.resource_assignment_id
6152: AND bl.start_date >= l_etc_start_date
6153: AND rownum = 1 ));
6154: END IF;

Line 6293: DELETE FROM PA_BUDGET_LINES

6289: PX_DELETED_RES_ASG_ID_TAB(k) := l_del_res_asg_id_tab(k);
6290: END LOOP;
6291:
6292: FORALL i in 1..PX_DELETED_RES_ASG_ID_TAB.count
6293: DELETE FROM PA_BUDGET_LINES
6294: WHERE RESOURCE_ASSIGNMENT_ID = PX_DELETED_RES_ASG_ID_TAB(i);
6295:
6296: IF p_pa_debug_mode = 'Y' THEN
6297: pa_fp_gen_amount_utils.fp_debug

Line 6363: UPDATE PA_BUDGET_LINES

6359: ,p_debug_mode => p_pa_debug_mode);
6360: END IF;
6361:
6362: FORALL i IN 1..P_RES_ASG_ID_TAB.count
6363: UPDATE PA_BUDGET_LINES
6364: SET INIT_QUANTITY = QUANTITY,
6365: INIT_QUANTITY_SOURCE = QUANTITY_SOURCE,
6366: INIT_RAW_COST = RAW_COST,
6367: INIT_BURDENED_COST = BURDENED_COST,

Line 6564: l_pc pa_budget_lines.txn_currency_code%type;

6560: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6564: l_pc pa_budget_lines.txn_currency_code%type;
6565: l_pfc pa_budget_lines.txn_currency_code%type;
6566:
6567: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
6568: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 6565: l_pfc pa_budget_lines.txn_currency_code%type;

6561: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6562:
6563: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
6564: l_pc pa_budget_lines.txn_currency_code%type;
6565: l_pfc pa_budget_lines.txn_currency_code%type;
6566:
6567: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
6568: l_last_update_login NUMBER := FND_GLOBAL.login_id;
6569: l_sysdate DATE := SYSDATE;

Line 6686: FROM PA_BUDGET_LINES BL

6682: -- Bulk collect all the txn currencies that should be added
6683: SELECT DISTINCT BL.TXN_CURRENCY_CODE
6684: BULK COLLECT
6685: INTO l_txn_curr_code_tab
6686: FROM PA_BUDGET_LINES BL
6687: WHERE BL.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
6688: AND NOT EXISTS
6689: (SELECT 1
6690: FROM PA_FP_TXN_CURRENCIES TC

Line 6770: UPDATE PA_BUDGET_LINES

6766: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'
6767: ,p_debug_mode => p_pa_debug_mode);
6768: END IF;
6769:
6770: UPDATE PA_BUDGET_LINES
6771: SET RAW_COST = null,
6772: BURDENED_COST = null,
6773: PROJECT_RAW_COST = null,
6774: PROJECT_BURDENED_COST = null,