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.

[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_BUDGET_LINES

Line 177: FROM pa_budget_lines

173:
174: CURSOR c_data_in_db_csr(c_resource_asg_id pa_resource_assignments.resource_assignment_id%TYPE)
175: IS
176: SELECT sum(quantity) quantity
177: FROM pa_budget_lines
178: WHERE resource_assignment_id = c_resource_asg_id;
179: -- ORDER BY resource_assignment_id,txn_currency_code;
180:
181: l_data_in_db_rec c_data_in_db_csr%ROWTYPE;

Line 251: l_actuals_start_date pa_budget_lines.start_date%TYPE;

247:
248: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
249:
250: --Bug 4083605
251: l_actuals_start_date pa_budget_lines.start_date%TYPE;
252: l_actuals_end_date pa_budget_lines.start_date%TYPE;
253:
254: /*Bug fix: 5752337 */
255: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS

Line 252: l_actuals_end_date pa_budget_lines.start_date%TYPE;

248: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
249:
250: --Bug 4083605
251: l_actuals_start_date pa_budget_lines.start_date%TYPE;
252: l_actuals_end_date pa_budget_lines.start_date%TYPE;
253:
254: /*Bug fix: 5752337 */
255: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
256: SELECT ppa.name project_name

Line 556: FROM pa_budget_lines pbl,

552: l_task_id_tbl(i)
553: FROM pa_resource_assignments pra,
554: (SELECT pra.resource_assignment_id
555: ,pbl.txn_currency_code
556: FROM pa_budget_lines pbl,
557: pa_resource_assignments pra
558: WHERE pbl.resource_assignment_id(+)=pra.resource_assignment_id
559: AND pra.resource_assignment_id=p_resource_assignment_id_tbl(i)
560: AND ROWNUM=1) pbl

Line 657: FROM pa_budget_lines

653: END IF;
654:
655: SELECT min(start_date), max(end_date)
656: INTO l_actuals_start_date, l_actuals_end_date
657: FROM pa_budget_lines
658: WHERE budget_version_id = p_budget_version_id
659: AND resource_assignment_id = p_resource_assignment_id_tbl(i)
660: AND end_date < l_plan_ver_settings_rec.etc_start_date;
661:

Line 3857: -- All data is deleted in bulk from pa_budget_lines and pa_resource_assignment

3853: -- Now derive the resource_assignment id for all the task_element_version_id
3854: -- based on the resource_class_code(l_del_task_level_rec_code_tbl) to be
3855: -- 'PEOPLE'.
3856: -- The resource_assignment_id is bulk collected into a PLSql table and then
3857: -- All data is deleted in bulk from pa_budget_lines and pa_resource_assignment
3858: -- based on the resource_assignment_id
3859:
3860: --***************************************************************************************
3861: -- Bug 3749516 resource_class_code(l_del_task_level_rec_code_tbl) will not be 'EQUIPMENT'

Line 3867: pa_debug.g_err_stage:='data is deleted in bulk from pa_budget_lines and pa_resource_assignment based on the resource_assignment_id ';

3863: --***************************************************************************************
3864: ------------------------------------------------------------------------------
3865:
3866: IF l_debug_mode = 'Y' THEN
3867: pa_debug.g_err_stage:='data is deleted in bulk from pa_budget_lines and pa_resource_assignment based on the resource_assignment_id ';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3869: END IF;
3870:
3871: END IF;

Line 6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;

6207: */
6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;

6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
6216:

Line 6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;

6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
6216:
6217: /* added for bug 3678814 */

Line 7458: FROM pa_budget_lines pbl,

7454: INTO l_currency_code_tbl(i)
7455: FROM pa_resource_assignments b,
7456: (SELECT pbl.txn_currency_code,
7457: pra.resource_assignment_id
7458: FROM pa_budget_lines pbl,
7459: pa_resource_assignments pra
7460: WHERE pbl.resource_assignment_id(+)=pra.resource_assignment_id
7461: AND pra.resource_assignment_id=l_resource_assignment_id_tbl(i)
7462: AND ROWNUM=1) pbl

Line 7755: FROM pa_budget_lines pbl,

7751: l_tot_qty_tbl,
7752: l_txn_raw_cost_tbl,
7753: l_txn_burdened_cost_tbl,
7754: l_delete_budget_lines_tbl
7755: FROM pa_budget_lines pbl,
7756: pa_budget_versions pbv
7757: WHERE pbl.budget_version_id=l_budget_version_id
7758: AND pbl.resource_assignment_id=l_resource_assignment_id_tbl(i)
7759: AND pbl.txn_currency_code=l_currency_code_tbl(i)

Line 8381: TYPE l_txn_curr_code_table IS TABLE OF PA_BUDGET_LINES.TXN_CURRENCY_CODE%type

8377: l_tot_rc_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8378: l_pji_rollup_required VARCHAR2(1);
8379:
8380: --Code addition for bug#4200168 starts here.
8381: TYPE l_txn_curr_code_table IS TABLE OF PA_BUDGET_LINES.TXN_CURRENCY_CODE%type
8382: INDEX BY BINARY_INTEGER;
8383:
8384: l_txn_curr_code_tbl l_txn_curr_code_table;
8385:

Line 8745: --pa_budget_lines bl

8741: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
8742: src_rbc.TXN_BILL_RATE_OVERRIDE
8743: FROM pa_resource_asgn_curr src_rbc,
8744: pa_fp_ra_map_tmp map,
8745: --pa_budget_lines bl
8746: pa_resource_assignments ra
8747: WHERE ra.budget_version_id =l_targ_budget_version_id
8748: -- AND src_rbc.budget_version_id = l_src_budget_version_id
8749: AND map.target_res_assignment_id = ra.resource_assignment_id

Line 8898: FROM pa_budget_lines

8894:
8895: BEGIN
8896: SELECT nvl(txn_currency_code,l_proj_curr_code)--For workplan txn curr code can be null
8897: INTO l_currency_code_tbl(i)
8898: FROM pa_budget_lines
8899: WHERE resource_assignment_id=
8900: c_calc_api_param_rec.source_res_assignment_id -- bug 3781932 l_calc_ra_id_tbl(i)
8901: AND ROWNUM=1;
8902: EXCEPTION

Line 9005: ---->on pa_budget_lines

9001: ---->Copy_Budget_Lines which is called above will consider all the resource assignments with Non Null
9002: ---->parent assignment id as candidates for copy. If parent_assignemt_id is not nulled out
9003: ---->then in future copy task flows the resource assignments which were are copied now will also be considered
9004: ---->as NEW and copy_budget_lines will try to insert them which will violate the unique constraint
9005: ---->on pa_budget_lines
9006: FORALL i IN 1..l_ra_id_tbl.COUNT
9007: UPDATE pa_resource_assignments
9008: SET named_role = l_named_role_tbl(i),
9009: parent_assignment_id=NULL

Line 9029: FROM PA_BUDGET_LINES BL

9025: -- scan on PA_FP_TXN_CURRENCIES
9026: SELECT DISTINCT BL.TXN_CURRENCY_CODE
9027: BULK COLLECT
9028: INTO l_txn_curr_code_tbl
9029: FROM PA_BUDGET_LINES BL
9030: WHERE BL.BUDGET_VERSION_ID = l_targ_budget_version_id
9031: AND NOT EXISTS
9032: (SELECT 1
9033: FROM PA_FP_TXN_CURRENCIES TC

Line 9195: --pa_budget_lines bl

9191: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
9192: src_rbc.TXN_BILL_RATE_OVERRIDE
9193: FROM pa_resource_asgn_curr src_rbc,
9194: pa_fp_ra_map_tmp map,
9195: --pa_budget_lines bl
9196: pa_resource_assignments ra
9197: WHERE ra.budget_version_id =l_targ_budget_version_id
9198: -- AND src_rbc.budget_version_id = l_src_budget_version_id
9199: AND map.target_res_assignment_id = ra.resource_assignment_id

Line 9807: FROM pa_budget_lines pbl

9803: print_msg(pa_debug.g_err_stage,l_module_name);
9804: END IF;
9805: FORALL i IN 1..l_task_assmt_ids_tbl.COUNT
9806: DELETE
9807: FROM pa_budget_lines pbl
9808: WHERE pbl.resource_assignment_id=l_task_assmt_ids_tbl(i)
9809: RETURNING
9810: pbl.period_name,
9811: pbl.start_date,

Line 9952: FROM pa_budget_lines pbl

9948: END IF;
9949:
9950: FORALL i IN l_delete_assmt_flag_tbl.first..l_delete_assmt_flag_tbl.last
9951: DELETE
9952: FROM pa_budget_lines pbl
9953: WHERE resource_assignment_id=p_resource_assignment_tbl(i)
9954: AND l_delete_assmt_flag_tbl(i)='Y'
9955: AND ( nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' OR
9956: (init_quantity is NULL AND

Line 10122: FROM pa_budget_lines pbl

10118: print_msg(pa_debug.g_err_stage,l_module_name);
10119: END IF;
10120: FORALL i IN p_element_version_id_tbl.first..p_element_version_id_tbl.last
10121: DELETE
10122: FROM pa_budget_lines pbl
10123: WHERE pbl.resource_assignment_id IN (SELECT pra.resource_assignment_id
10124: FROM pa_resource_assignments pra,
10125: pa_budget_versions pbv
10126: WHERE pra.budget_Version_id=pbv.budget_Version_id

Line 10305: FROM pa_budget_lines pbl,

10301: SELECT 'Y'
10302: INTO l_exists
10303: FROM DUAL
10304: WHERE EXISTS (SELECT 'X'
10305: FROM pa_budget_lines pbl,
10306: pa_resource_assignments pra
10307: WHERE pra.resource_assignment_id=p_resource_assignment_tbl(i)
10308: AND pbl.budget_Version_id=pra.budget_version_id
10309: AND pbl.resource_assignment_id=pra.resource_assignment_id);

Line 10349: FROM pa_budget_lines pbl

10345: END IF;
10346:
10347: FORALL i IN p_resource_assignment_tbl.first..p_resource_assignment_tbl.last
10348: DELETE
10349: FROM pa_budget_lines pbl
10350: WHERE pbl.resource_assignment_id=p_resource_assignment_tbl(i)
10351: AND ( nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' OR
10352: (init_quantity is NULL AND
10353: txn_init_raw_cost is NULL AND

Line 10443: FROM PA_BUDGET_LINES PBL

10439: WHERE pra.resource_assignment_id=p_resource_assignment_tbl(i)
10440: AND (l_currency_code_tbl(i) IS NULL
10441: OR
10442: NOT EXISTS ( SELECT 'EXISTS'
10443: FROM PA_BUDGET_LINES PBL
10444: WHERE PBL.RESOURCE_ASSIGNMENT_ID = pra.resource_assignment_id))
10445: RETURNING
10446: pra.resource_assignment_id,
10447: pra.task_id,

Line 10707: pa_debug.g_err_stage:='No of rows deleted from pa_budget_lines= '||l_resource_assignment_id_tbl.count;

10703:
10704: END IF;
10705:
10706: IF l_debug_mode = 'Y' THEN
10707: pa_debug.g_err_stage:='No of rows deleted from pa_budget_lines= '||l_resource_assignment_id_tbl.count;
10708: print_msg(pa_debug.g_err_stage,l_module_name);
10709: END IF;
10710:
10711:

Line 11705: FROM pa_budget_lines

11701: WHERE budget_version_id = p_budget_version_id;
11702: */
11703:
11704: DELETE
11705: FROM pa_budget_lines
11706: WHERE budget_version_id = p_budget_version_id;
11707:
11708: -- --IPM Arch Enhancement Bug 4865563, Bug 5003827 Issue 28
11709: IF (nvl(p_ci_ver_agr_change_flag,'N') = 'Y'