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 230: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS

226: p_module_name => l_module_name,
227: p_log_level => 5);
228: END IF;
229:
230: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS
231: tables when the flag is set to N */
232: IF l_fp_cols_rec.x_gen_ret_manual_line_flag = 'N' THEN
233: DELETE FROM PA_BUDGET_LINES
234: WHERE budget_version_id = p_budget_version_id ;

Line 233: DELETE FROM PA_BUDGET_LINES

229:
230: /* Records are deleted from pa_budget_lines and PA_RESOURCE_ASSIGNMENTS
231: tables when the flag is set to N */
232: IF l_fp_cols_rec.x_gen_ret_manual_line_flag = 'N' THEN
233: DELETE FROM PA_BUDGET_LINES
234: WHERE budget_version_id = p_budget_version_id ;
235:
236: DELETE FROM PA_RESOURCE_ASSIGNMENTS
237: WHERE budget_version_id = p_budget_version_id ;

Line 292: DELETE FROM PA_BUDGET_LINES

288: transaction_source_code IS NOT NULL;
289:
290: IF (l_res_as_id.count > 0) THEN
291: FORALL i IN 1 .. l_res_as_id.count
292: DELETE FROM PA_BUDGET_LINES
293: WHERE resource_assignment_id = l_res_as_id(i);
294:
295: FORALL j IN 1 .. l_res_as_id.count
296: UPDATE PA_RESOURCE_ASSIGNMENTS

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

583:
584: -- Bug 4549862: When generating a Cost and Revenue together version
585: -- from Staffing Plan with revenue accrual method of COST, the
586: -- currency conversion step is performed on the PA_FP_ROLLUP_TMP
587: -- table (instead of pa_budget_lines) earlier in the code flow by the
588: -- GENERATE_BUDGET_AMT_RES_SCH API so that pc/pfc Commitment amounts
589: -- can be honored. We should not call the currency conversion API in
590: -- this case.
591:

Line 926: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

922: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
923:
924: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH';
925:
926: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
927:
928: CURSOR PROJ_DETAILS IS
929: SELECT P.PROJECT_TYPE,
930: P.PROJECT_CURRENCY_CODE,

Line 1101: FROM PA_BUDGET_LINES BL,

1097: c_resource_assignment_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE) IS
1098: SELECT BL.PERIOD_NAME,
1099: BL.START_DATE,
1100: BL.BURDENED_COST
1101: FROM PA_BUDGET_LINES BL,
1102: PA_RESOURCE_ASSIGNMENTS RA
1103: WHERE BL.RESOURCE_ASSIGNMENT_ID = RA.RESOURCE_ASSIGNMENT_ID
1104: AND RA.BUDGET_VERSION_ID = c_budget_version_id
1105: AND RA.PROJECT_ID = c_project_id

Line 1478: -- Inserted into pa_budget_lines.

1474: -- Bug 4549862: Added cursor for when the target version is None
1475: -- Time Phased and the context is Forecast Generation. In this
1476: -- case, budget lines may exist with actuals. Fetch temp table
1477: -- data for which budget lines do not yet exist, which should be
1478: -- Inserted into pa_budget_lines.
1479:
1480: -- Bug 4615787: Removed start_date, end_date, period_name,
1481: -- bill_markup_percentage, and cost_ind_compiled_set_id from the
1482: -- GROUP BY clause. In the SELECT clause, take MIN(start_date),

Line 1509: FROM pa_budget_lines bl

1505: COST_REJECTION_CODE,
1506: BURDEN_REJECTION_CODE,
1507: REVENUE_REJECTION_CODE
1508: HAVING ( SELECT count(*)
1509: FROM pa_budget_lines bl
1510: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1511: AND tmp.txn_currency_code = bl.txn_currency_code ) = 0;
1512:
1513:

Line 1518: -- into pa_budget_lines.

1514: -- Bug 4549862: Added cursor for when the target version is None
1515: -- Time Phased and the context is Forecast Generation. In this
1516: -- case, budget lines may exist with actuals. Fetch temp table
1517: -- data for which budget lines exist, which whould be Updated
1518: -- into pa_budget_lines.
1519:
1520: -- Bug 4615787: Removed start_date, end_date, period_name,
1521: -- bill_markup_percentage, and cost_ind_compiled_set_id from the
1522: -- GROUP BY clause. In the SELECT clause, take MIN(start_date),

Line 1549: FROM pa_budget_lines bl

1545: COST_REJECTION_CODE,
1546: BURDEN_REJECTION_CODE,
1547: REVENUE_REJECTION_CODE
1548: HAVING ( SELECT count(*)
1549: FROM pa_budget_lines bl
1550: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1551: AND tmp.txn_currency_code = bl.txn_currency_code ) > 0;
1552:
1553:

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

2027:
2028: -- Bug 4549862: Added counter to track unique budget_line_id values for
2029: -- the PA_FP_ROLLUP_TMP table. Will be arbitrarily initialized to 0 and
2030: -- then incremented by 1 prior to each Insert to the temp table.
2031: -- Note: these are not valid budget_line_id values in pa_budget_lines.
2032: -- Rather, we are using the column to index records for processing of
2033: -- cost-based revenue amounts, since an Index exists for the column.
2034: l_bl_id_counter NUMBER;
2035:

Line 2149: DELETE FROM pa_budget_lines

2145: code is NOT NULL should be deleted. for forecast version, 'P' and 'G' time phased, all
2146: ETC budget lines should be deleted; 'N' time phased, ETC should be deleted or negated.*/
2147: IF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
2148: IF P_PLAN_CLASS_CODE = 'BUDGET' THEN
2149: DELETE FROM pa_budget_lines
2150: WHERE budget_version_id = p_budget_version_id
2151: AND budget_line_id IN
2152: (SELECT bl.budget_line_id
2153: FROM pa_budget_lines bl, pa_resource_assignments ra

Line 2153: FROM pa_budget_lines bl, pa_resource_assignments ra

2149: DELETE FROM pa_budget_lines
2150: WHERE budget_version_id = p_budget_version_id
2151: AND budget_line_id IN
2152: (SELECT bl.budget_line_id
2153: FROM pa_budget_lines bl, pa_resource_assignments ra
2154: WHERE ra.budget_version_id = p_budget_version_id
2155: AND bl.budget_version_id = p_budget_version_id
2156: AND ra.transaction_source_code IS NOT NULL
2157: AND ra.resource_assignment_id = bl.resource_assignment_id);

Line 2160: DELETE FROM pa_budget_lines

2156: AND ra.transaction_source_code IS NOT NULL
2157: AND ra.resource_assignment_id = bl.resource_assignment_id);
2158: ELSIF P_PLAN_CLASS_CODE = 'FORECAST' THEN
2159: IF P_FP_COLS_REC.x_time_phased_code IN ('P','G') THEN
2160: DELETE FROM pa_budget_lines
2161: WHERE budget_version_id = p_budget_version_id
2162: AND budget_line_id IN
2163: (SELECT bl.budget_line_id
2164: FROM pa_budget_lines bl, pa_resource_assignments ra

Line 2164: FROM pa_budget_lines bl, pa_resource_assignments ra

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

Line 2171: DELETE FROM pa_budget_lines

2167: AND ra.transaction_source_code IS NOT NULL
2168: AND ra.resource_assignment_id = bl.resource_assignment_id
2169: AND bl.start_date > p_actuals_thru_date);
2170: ELSE
2171: DELETE FROM pa_budget_lines
2172: WHERE budget_version_id = p_budget_version_id
2173: AND NVL(init_quantity,0) = 0
2174: AND NVL(init_raw_cost,0) = 0
2175: AND NVL(init_burdened_cost,0) = 0

Line 2178: UPDATE pa_budget_lines

2174: AND NVL(init_raw_cost,0) = 0
2175: AND NVL(init_burdened_cost,0) = 0
2176: AND NVL(init_revenue,0) = 0;
2177:
2178: UPDATE pa_budget_lines
2179: SET quantity = init_quantity,
2180: txn_raw_cost = txn_init_raw_cost,
2181: txn_burdened_cost = txn_init_burdened_cost,
2182: txn_revenue = txn_init_revenue,

Line 2198: FROM pa_budget_lines bl, pa_resource_assignments ra

2194: projfunc_rev_exchange_rate = DECODE(NVL(txn_init_revenue,0),0,NULL,init_revenue/txn_init_revenue)
2195: WHERE budget_version_id = p_budget_version_id
2196: AND budget_line_id IN
2197: (SELECT bl.budget_line_id
2198: FROM pa_budget_lines bl, pa_resource_assignments ra
2199: WHERE ra.budget_version_id = p_budget_version_id
2200: AND bl.budget_version_id = p_budget_version_id
2201: AND ra.transaction_source_code IS NOT NULL
2202: AND ra.resource_assignment_id = bl.resource_assignment_id);

Line 3436: -- PA_BUDGET_LINES table.

3432:
3433: -- Bug 4549862: Call currency conversion API. Passing 'N' for
3434: -- the p_entire_version parameter tells to the API to convert
3435: -- currencies in the PA_FP_ROLLUP_TMP table instead of in the
3436: -- PA_BUDGET_LINES table.
3437:
3438: IF p_pa_debug_mode = 'Y' THEN
3439: pa_fp_gen_amount_utils.fp_debug
3440: (p_called_mode => p_called_mode,

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

3692: -- Bug 4549862: If the target version is None timephased and the
3693: -- context is Forecast generation, then budget lines containing
3694: -- actuals may exist. As a result, some of the data in the temp
3695: -- table may need to be Inserted while other data in the table
3696: -- may need to be Updated in pa_budget_lines.
3697: --
3698: -- Group the temporary table data by resource assignment and txn
3699: -- currency code using separate cursors for the Insert/Update cases.
3700:

Line 3807: INSERT INTO PA_BUDGET_LINES(

3803: -- cost ind compiled set id and rejection codes
3804: IF l_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
3805:
3806: FORALL bl_index IN 1 .. l_bl_START_DATE_tab.COUNT
3807: INSERT INTO PA_BUDGET_LINES(
3808: RESOURCE_ASSIGNMENT_ID,
3809: START_DATE,
3810: LAST_UPDATE_DATE,
3811: LAST_UPDATED_BY,

Line 3846: PA_BUDGET_LINES_S.nextval,

3842: l_bl_END_DATE_tab(bl_index),
3843: l_bl_PERIOD_NAME_tab(bl_index),
3844: l_bl_QUANTITY_tab(bl_index),
3845: l_bl_TXN_CURRENCY_CODE_tab(bl_index),
3846: PA_BUDGET_LINES_S.nextval,
3847: P_BUDGET_VERSION_ID,
3848: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_RAW_COST_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),
3849: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_REVENUE_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),
3850: DECODE(l_bl_QUANTITY_tab(bl_index), 0, NULL, l_bl_TXN_BURDENED_COST_tab(bl_index)/l_bl_QUANTITY_tab(bl_index)),

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

3863: -- Bug 4549862: If the target version is None timephased and the
3864: -- context is Forecast generation, then budget lines containing
3865: -- actuals may exist. As a result, some of the data in the temp
3866: -- table may need to be Inserted while other data in the table
3867: -- may need to be Updated in pa_budget_lines.
3868: --
3869: -- The following code Updates the budget lines.
3870:
3871: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN

Line 3874: UPDATE PA_BUDGET_LINES

3870:
3871: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
3872:
3873: FORALL bl_index IN 1 .. l_upd_bl_START_DATE_tab.COUNT
3874: UPDATE PA_BUDGET_LINES
3875: SET LAST_UPDATE_DATE = l_sysdate,
3876: LAST_UPDATED_BY = l_last_updated_by,
3877: LAST_UPDATE_LOGIN = l_last_update_login,
3878: START_DATE = LEAST(START_DATE, l_upd_bl_START_DATE_tab(bl_index)),

Line 4017: FROM pa_budget_lines

4013: p_log_level => 5);
4014: END IF;
4015: SELECT count(*)
4016: INTO l_count
4017: FROM pa_budget_lines
4018: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4019: AND rownum <2;
4020:
4021: --dbms_output.put_line('==j=='||j

Line 4046: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,

4042: --end loop;
4043:
4044: IF l_count = 0 THEN
4045: FORALL fp IN 1 .. l_rt_start_date_tab.COUNT
4046: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,
4047: START_DATE,
4048: LAST_UPDATE_DATE,
4049: LAST_UPDATED_BY,
4050: CREATION_DATE,

Line 4072: PA_BUDGET_LINES_S.nextval,

4068: l_rt_end_date_tab(fp),
4069: l_rt_pd_name_tab(fp),
4070: l_rt_qty_tab(fp),
4071: l_project_currency_code,
4072: PA_BUDGET_LINES_S.nextval,
4073: P_BUDGET_VERSION_ID,
4074: p_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
4075: p_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE);
4076: ELSE

Line 4086: FROM pa_budget_lines

4082: -- for budget line existence differently based on Target timephase.
4083: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
4084: SELECT count(*)
4085: INTO l_count1
4086: FROM pa_budget_lines
4087: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4088: AND txn_currency_code = l_project_currency_code
4089: AND start_date = l_rt_start_date_tab(fp);
4090: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN

Line 4093: FROM pa_budget_lines

4089: AND start_date = l_rt_start_date_tab(fp);
4090: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
4091: SELECT count(*)
4092: INTO l_count1
4093: FROM pa_budget_lines
4094: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4095: AND txn_currency_code = l_project_currency_code;
4096: END IF;
4097: IF l_count1 = 0 then

Line 4098: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,

4094: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4095: AND txn_currency_code = l_project_currency_code;
4096: END IF;
4097: IF l_count1 = 0 then
4098: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,
4099: START_DATE,
4100: LAST_UPDATE_DATE,
4101: LAST_UPDATED_BY,
4102: CREATION_DATE,

Line 4124: PA_BUDGET_LINES_S.nextval,

4120: l_rt_end_date_tab(fp),
4121: l_rt_pd_name_tab(fp),
4122: l_rt_qty_tab(fp),
4123: l_project_currency_code,
4124: PA_BUDGET_LINES_S.nextval,
4125: P_BUDGET_VERSION_ID,
4126: p_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
4127: p_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE);
4128: ELSE

Line 4135: UPDATE pa_budget_lines

4131: -- When the Target is None timephased, budget lines should be unique
4132: -- given (Resource Assignment Id, Currency Code). Split Update logic into
4133: -- 2 cases based on Target timephase.
4134: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
4135: UPDATE pa_budget_lines
4136: SET quantity = nvl(quantity,0) +
4137: l_rt_qty_tab(fp)
4138: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4139: AND txn_currency_code = l_project_currency_code

Line 4142: UPDATE pa_budget_lines

4138: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)
4139: AND txn_currency_code = l_project_currency_code
4140: AND start_date = l_rt_start_date_tab(fp);
4141: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
4142: UPDATE pa_budget_lines
4143: SET quantity = nvl(quantity,0) + l_rt_qty_tab(fp),
4144: start_date = least(start_date, l_rt_start_date_tab(fp)),
4145: end_date = greatest(end_date, l_rt_end_date_tab(fp))
4146: WHERE resource_assignment_id = l_proj_res_assgn_id_tab(j)

Line 4193: FROM pa_budget_lines

4189:
4190: FOR i IN 1..l_res_assgn_id_tmp_tab.count LOOP
4191: SELECT SUM(quantity)
4192: INTO l_total_plan_quantity
4193: FROM pa_budget_lines
4194: WHERE resource_assignment_id = l_res_assgn_id_tmp_tab(i); /* Bug 4093872 - Column name corrected from budget_version_id to resource_assignment_id */
4195:
4196: INSERT INTO pa_fp_calc_amt_tmp2(
4197: resource_assignment_id,

Line 5478: FROM pa_budget_lines bl

5474: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
5475: AND ra.transaction_source_code IS NULL
5476: AND EXISTS
5477: ( SELECT 1
5478: FROM pa_budget_lines bl
5479: WHERE bl.resource_assignment_id = ra.resource_assignment_id
5480: AND rownum = 1 ));
5481: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
5482: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

Line 5493: FROM pa_budget_lines bl

5489: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
5490: AND ra.transaction_source_code IS NULL
5491: AND EXISTS
5492: ( SELECT 1
5493: FROM pa_budget_lines bl
5494: WHERE bl.resource_assignment_id = ra.resource_assignment_id
5495: AND bl.start_date >= l_etc_start_date
5496: AND rownum = 1 ));
5497: END IF;

Line 5636: DELETE FROM PA_BUDGET_LINES

5632: PX_DELETED_RES_ASG_ID_TAB(k) := l_del_res_asg_id_tab(k);
5633: END LOOP;
5634:
5635: FORALL i in 1..PX_DELETED_RES_ASG_ID_TAB.count
5636: DELETE FROM PA_BUDGET_LINES
5637: WHERE RESOURCE_ASSIGNMENT_ID = PX_DELETED_RES_ASG_ID_TAB(i);
5638:
5639: IF p_pa_debug_mode = 'Y' THEN
5640: pa_fp_gen_amount_utils.fp_debug

Line 5706: UPDATE PA_BUDGET_LINES

5702: ,p_debug_mode => p_pa_debug_mode);
5703: END IF;
5704:
5705: FORALL i IN 1..P_RES_ASG_ID_TAB.count
5706: UPDATE PA_BUDGET_LINES
5707: SET INIT_QUANTITY = QUANTITY,
5708: INIT_QUANTITY_SOURCE = QUANTITY_SOURCE,
5709: INIT_RAW_COST = RAW_COST,
5710: INIT_BURDENED_COST = BURDENED_COST,

Line 5907: l_pc pa_budget_lines.txn_currency_code%type;

5903: l_budget_version_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5904: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5905:
5906: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
5907: l_pc pa_budget_lines.txn_currency_code%type;
5908: l_pfc pa_budget_lines.txn_currency_code%type;
5909:
5910: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
5911: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 5908: l_pfc pa_budget_lines.txn_currency_code%type;

5904: l_proj_fp_options_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5905:
5906: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
5907: l_pc pa_budget_lines.txn_currency_code%type;
5908: l_pfc pa_budget_lines.txn_currency_code%type;
5909:
5910: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
5911: l_last_update_login NUMBER := FND_GLOBAL.login_id;
5912: l_sysdate DATE := SYSDATE;

Line 6029: FROM PA_BUDGET_LINES BL

6025: -- Bulk collect all the txn currencies that should be added
6026: SELECT DISTINCT BL.TXN_CURRENCY_CODE
6027: BULK COLLECT
6028: INTO l_txn_curr_code_tab
6029: FROM PA_BUDGET_LINES BL
6030: WHERE BL.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
6031: AND NOT EXISTS
6032: (SELECT 1
6033: FROM PA_FP_TXN_CURRENCIES TC

Line 6113: UPDATE PA_BUDGET_LINES

6109: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'
6110: ,p_debug_mode => p_pa_debug_mode);
6111: END IF;
6112:
6113: UPDATE PA_BUDGET_LINES
6114: SET RAW_COST = null,
6115: BURDENED_COST = null,
6116: PROJECT_RAW_COST = null,
6117: PROJECT_BURDENED_COST = null,