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

Line 121: FROM pa_budget_lines

117:
118: CURSOR c_data_in_db_csr(c_resource_asg_id pa_resource_assignments.resource_assignment_id%TYPE)
119: IS
120: SELECT sum(quantity) quantity
121: FROM pa_budget_lines
122: WHERE resource_assignment_id = c_resource_asg_id;
123: -- ORDER BY resource_assignment_id,txn_currency_code;
124:
125: l_data_in_db_rec c_data_in_db_csr%ROWTYPE;

Line 195: l_actuals_start_date pa_budget_lines.start_date%TYPE;

191:
192: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
193:
194: --Bug 4083605
195: l_actuals_start_date pa_budget_lines.start_date%TYPE;
196: l_actuals_end_date pa_budget_lines.start_date%TYPE;
197:
198: /*Bug fix: 5752337 */
199: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS

Line 196: l_actuals_end_date pa_budget_lines.start_date%TYPE;

192: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
193:
194: --Bug 4083605
195: l_actuals_start_date pa_budget_lines.start_date%TYPE;
196: l_actuals_end_date pa_budget_lines.start_date%TYPE;
197:
198: /*Bug fix: 5752337 */
199: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
200: SELECT ppa.name project_name

Line 500: FROM pa_budget_lines pbl,

496: l_task_id_tbl(i)
497: FROM pa_resource_assignments pra,
498: (SELECT pra.resource_assignment_id
499: ,pbl.txn_currency_code
500: FROM pa_budget_lines pbl,
501: pa_resource_assignments pra
502: WHERE pbl.resource_assignment_id(+)=pra.resource_assignment_id
503: AND pra.resource_assignment_id=p_resource_assignment_id_tbl(i)
504: AND ROWNUM=1) pbl

Line 601: FROM pa_budget_lines

597: END IF;
598:
599: SELECT min(start_date), max(end_date)
600: INTO l_actuals_start_date, l_actuals_end_date
601: FROM pa_budget_lines
602: WHERE budget_version_id = p_budget_version_id
603: AND resource_assignment_id = p_resource_assignment_id_tbl(i)
604: AND end_date < l_plan_ver_settings_rec.etc_start_date;
605:

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

3574: -- Now derive the resource_assignment id for all the task_element_version_id
3575: -- based on the resource_class_code(l_del_task_level_rec_code_tbl) to be
3576: -- 'PEOPLE'.
3577: -- The resource_assignment_id is bulk collected into a PLSql table and then
3578: -- All data is deleted in bulk from pa_budget_lines and pa_resource_assignment
3579: -- based on the resource_assignment_id
3580:
3581: --***************************************************************************************
3582: -- Bug 3749516 resource_class_code(l_del_task_level_rec_code_tbl) will not be 'EQUIPMENT'

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

3584: --***************************************************************************************
3585: ------------------------------------------------------------------------------
3586:
3587: IF l_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='data is deleted in bulk from pa_budget_lines and pa_resource_assignment based on the resource_assignment_id ';
3589: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3590: END IF;
3591:
3592: END IF;

Line 5553: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;

5549: */
5550: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5551: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5552: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5553: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
5554: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
5555: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
5556: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
5557: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 5554: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;

5550: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5551: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5552: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5553: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
5554: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
5555: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
5556: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
5557: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
5558:

Line 5555: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;

5551: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5552: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5553: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
5554: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
5555: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
5556: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
5557: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
5558:
5559: /* added for bug 3678814 */

Line 6769: FROM pa_budget_lines pbl,

6765: INTO l_currency_code_tbl(i)
6766: FROM pa_resource_assignments b,
6767: (SELECT pbl.txn_currency_code,
6768: pra.resource_assignment_id
6769: FROM pa_budget_lines pbl,
6770: pa_resource_assignments pra
6771: WHERE pbl.resource_assignment_id(+)=pra.resource_assignment_id
6772: AND pra.resource_assignment_id=l_resource_assignment_id_tbl(i)
6773: AND ROWNUM=1) pbl

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

7551: l_tot_rc_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7552: l_pji_rollup_required VARCHAR2(1);
7553:
7554: --Code addition for bug#4200168 starts here.
7555: TYPE l_txn_curr_code_table IS TABLE OF PA_BUDGET_LINES.TXN_CURRENCY_CODE%type
7556: INDEX BY BINARY_INTEGER;
7557:
7558: l_txn_curr_code_tbl l_txn_curr_code_table;
7559:

Line 7919: --pa_budget_lines bl

7915: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
7916: src_rbc.TXN_BILL_RATE_OVERRIDE
7917: FROM pa_resource_asgn_curr src_rbc,
7918: pa_fp_ra_map_tmp map,
7919: --pa_budget_lines bl
7920: pa_resource_assignments ra
7921: WHERE ra.budget_version_id =l_targ_budget_version_id
7922: -- AND src_rbc.budget_version_id = l_src_budget_version_id
7923: AND map.target_res_assignment_id = ra.resource_assignment_id

Line 8072: FROM pa_budget_lines

8068:
8069: BEGIN
8070: SELECT nvl(txn_currency_code,l_proj_curr_code)--For workplan txn curr code can be null
8071: INTO l_currency_code_tbl(i)
8072: FROM pa_budget_lines
8073: WHERE resource_assignment_id=
8074: c_calc_api_param_rec.source_res_assignment_id -- bug 3781932 l_calc_ra_id_tbl(i)
8075: AND ROWNUM=1;
8076: EXCEPTION

Line 8179: ---->on pa_budget_lines

8175: ---->Copy_Budget_Lines which is called above will consider all the resource assignments with Non Null
8176: ---->parent assignment id as candidates for copy. If parent_assignemt_id is not nulled out
8177: ---->then in future copy task flows the resource assignments which were are copied now will also be considered
8178: ---->as NEW and copy_budget_lines will try to insert them which will violate the unique constraint
8179: ---->on pa_budget_lines
8180: FORALL i IN 1..l_ra_id_tbl.COUNT
8181: UPDATE pa_resource_assignments
8182: SET named_role = l_named_role_tbl(i),
8183: parent_assignment_id=NULL

Line 8203: FROM PA_BUDGET_LINES BL

8199: -- scan on PA_FP_TXN_CURRENCIES
8200: SELECT DISTINCT BL.TXN_CURRENCY_CODE
8201: BULK COLLECT
8202: INTO l_txn_curr_code_tbl
8203: FROM PA_BUDGET_LINES BL
8204: WHERE BL.BUDGET_VERSION_ID = l_targ_budget_version_id
8205: AND NOT EXISTS
8206: (SELECT 1
8207: FROM PA_FP_TXN_CURRENCIES TC

Line 8369: --pa_budget_lines bl

8365: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
8366: src_rbc.TXN_BILL_RATE_OVERRIDE
8367: FROM pa_resource_asgn_curr src_rbc,
8368: pa_fp_ra_map_tmp map,
8369: --pa_budget_lines bl
8370: pa_resource_assignments ra
8371: WHERE ra.budget_version_id =l_targ_budget_version_id
8372: -- AND src_rbc.budget_version_id = l_src_budget_version_id
8373: AND map.target_res_assignment_id = ra.resource_assignment_id

Line 8975: FROM pa_budget_lines pbl

8971: print_msg(pa_debug.g_err_stage,l_module_name);
8972: END IF;
8973: FORALL i IN 1..l_task_assmt_ids_tbl.COUNT
8974: DELETE
8975: FROM pa_budget_lines pbl
8976: WHERE pbl.resource_assignment_id=l_task_assmt_ids_tbl(i)
8977: RETURNING
8978: pbl.period_name,
8979: pbl.start_date,

Line 9113: FROM pa_budget_lines pbl

9109: END IF;
9110:
9111: FORALL i IN l_delete_assmt_flag_tbl.first..l_delete_assmt_flag_tbl.last
9112: DELETE
9113: FROM pa_budget_lines pbl
9114: WHERE resource_assignment_id=p_resource_assignment_tbl(i)
9115: AND l_delete_assmt_flag_tbl(i)='Y'
9116: AND ( nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' OR
9117: (init_quantity is NULL AND

Line 9276: FROM pa_budget_lines pbl

9272: print_msg(pa_debug.g_err_stage,l_module_name);
9273: END IF;
9274: FORALL i IN p_element_version_id_tbl.first..p_element_version_id_tbl.last
9275: DELETE
9276: FROM pa_budget_lines pbl
9277: WHERE pbl.resource_assignment_id IN (SELECT pra.resource_assignment_id
9278: FROM pa_resource_assignments pra,
9279: pa_budget_versions pbv
9280: WHERE pra.budget_Version_id=pbv.budget_Version_id

Line 9451: FROM pa_budget_lines pbl,

9447: SELECT 'Y'
9448: INTO l_exists
9449: FROM DUAL
9450: WHERE EXISTS (SELECT 'X'
9451: FROM pa_budget_lines pbl,
9452: pa_resource_assignments pra
9453: WHERE pra.resource_assignment_id=p_resource_assignment_tbl(i)
9454: AND pbl.budget_Version_id=pra.budget_version_id
9455: AND pbl.resource_assignment_id=pra.resource_assignment_id);

Line 9495: FROM pa_budget_lines pbl

9491: END IF;
9492:
9493: FORALL i IN p_resource_assignment_tbl.first..p_resource_assignment_tbl.last
9494: DELETE
9495: FROM pa_budget_lines pbl
9496: WHERE pbl.resource_assignment_id=p_resource_assignment_tbl(i)
9497: AND ( nvl(p_calling_module,'-99') <> 'PROCESS_RES_CHG_DERV_CALC_PRMS' OR
9498: (init_quantity is NULL AND
9499: txn_init_raw_cost is NULL AND

Line 9581: FROM PA_BUDGET_LINES PBL

9577: WHERE pra.resource_assignment_id=p_resource_assignment_tbl(i)
9578: AND (l_currency_code_tbl(i) IS NULL
9579: OR
9580: NOT EXISTS ( SELECT 'EXISTS'
9581: FROM PA_BUDGET_LINES PBL
9582: WHERE PBL.RESOURCE_ASSIGNMENT_ID = pra.resource_assignment_id))
9583: RETURNING
9584: pra.resource_assignment_id,
9585: pra.task_id,

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

9841:
9842: END IF;
9843:
9844: IF l_debug_mode = 'Y' THEN
9845: pa_debug.g_err_stage:='No of rows deleted from pa_budget_lines= '||l_resource_assignment_id_tbl.count;
9846: print_msg(pa_debug.g_err_stage,l_module_name);
9847: END IF;
9848:
9849: pa_planning_transaction_utils.call_update_rep_lines_api

Line 10838: FROM pa_budget_lines

10834: WHERE budget_version_id = p_budget_version_id;
10835: */
10836:
10837: DELETE
10838: FROM pa_budget_lines
10839: WHERE budget_version_id = p_budget_version_id;
10840:
10841: -- --IPM Arch Enhancement Bug 4865563, Bug 5003827 Issue 28
10842: IF (nvl(p_ci_ver_agr_change_flag,'N') = 'Y'