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

Line 33: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

29: AND lookup_code = c_change_reason_code;
30:
31: --Bug 2871603: Added the following PLSQL table to remove build dependency.
32: TYPE l_txn_currency_code_tbl_typ IS TABLE OF
33: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
34:
35: --This record type will contain key and a value. A pl/sql tbl of this record type can be declared and it can be
36: --used for different purposes. One such case is : if its required to get the wbs level for a task id at many
37: --places in the code then instead of firing a select each time we can fetch it and store in this record. The key

Line 348: ,pa_budget_lines bl

344: IS
345: SELECT 'x'
346: FROM pa_budget_versions bv
347: ,pa_resource_assignments ra
348: ,pa_budget_lines bl
349: WHERE bv.budget_version_id = c_budget_version_id
350: AND bv.budget_version_id = ra.budget_version_id (+)
351: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
352: AND bv.ci_id IS NULL -- Bug # 3507156 --Added an extra clause ci_id IS NULL

Line 432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

428: l_is_rate_type_valid BOOLEAN;
429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;

Line 434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:

Line 435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:
439: l_called_from_agr_pub VARCHAR2(1) := NULL; -- Bug 3099706

Line 4078: l_budget_start_date pa_budget_lines.start_date%TYPE;

4074: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;

Line 4079: l_budget_end_date pa_budget_lines.start_date%TYPE;

4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;

Line 4080: l_period_name pa_budget_lines.period_name%TYPE;

4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4084:

Line 4081: l_description pa_budget_lines.description%TYPE;

4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4084:
4085: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */

Line 4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;

4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4084:
4085: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4086: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;

Line 4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;

4079: l_budget_end_date pa_budget_lines.start_date%TYPE;
4080: l_period_name pa_budget_lines.period_name%TYPE;
4081: l_description pa_budget_lines.description%TYPE;
4082: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4083: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4084:
4085: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4086: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;
4087: i NUMBER;

Line 4800: SELECT pa_budget_lines.*, rowid

4796: CURSOR l_budget_line_csr
4797: (p_resource_assigment_id NUMBER
4798: ,p_budget_start_date DATE )
4799: IS
4800: SELECT pa_budget_lines.*, rowid
4801: FROM pa_budget_lines
4802: WHERE resource_assignment_id = p_resource_assigment_id
4803: AND start_date = p_budget_start_date;
4804:

Line 4801: FROM pa_budget_lines

4797: (p_resource_assigment_id NUMBER
4798: ,p_budget_start_date DATE )
4799: IS
4800: SELECT pa_budget_lines.*, rowid
4801: FROM pa_budget_lines
4802: WHERE resource_assignment_id = p_resource_assigment_id
4803: AND start_date = p_budget_start_date;
4804:
4805: --cursor added as part of fix for Bug#1406799 to check the burdened_cost_flag

Line 4830: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

4826: -- added as part of fix for Bug#1406799 to check for burdened_cost_flag
4827: l_burdened_cost_flag VARCHAR2(1) := 'Y';
4828:
4829: /* FPB2: MRC */
4830: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4831: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4832: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4833: l_msg_count NUMBER := 0;
4834: l_msg_data VARCHAR2(2000);

Line 4831: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;

4827: l_burdened_cost_flag VARCHAR2(1) := 'Y';
4828:
4829: /* FPB2: MRC */
4830: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4831: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4832: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4833: l_msg_count NUMBER := 0;
4834: l_msg_data VARCHAR2(2000);
4835:

Line 4832: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;

4828:
4829: /* FPB2: MRC */
4830: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4831: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4832: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4833: l_msg_count NUMBER := 0;
4834: l_msg_data VARCHAR2(2000);
4835:
4836:

Line 4858: l_statement := ' UPDATE PA_BUDGET_LINES SET ';

4854:
4855: --building the dynamic SQL statement
4856: -- Changes made by Xin Liu for using of SQL BIND VARIABLE 12-MAY-2003
4857:
4858: l_statement := ' UPDATE PA_BUDGET_LINES SET ';
4859:
4860: --dbms_output.put_line('p_description : '||p_description);
4861: --dbms_output.put_line('l_budget_line_rec.description: '||l_budget_line_rec.description);
4862:

Line 5372: FROM pa_budget_lines

5368: /* FPB2: MRC */
5369: BEGIN
5370: SELECT budget_line_id, budget_version_id --Bug 4224464
5371: INTO l_budget_line_id, l_budget_version_id
5372: FROM pa_budget_lines
5373: WHERE resource_assignment_id = p_resource_assignment_id
5374: AND start_date = p_start_date
5375: AND txn_currency_code = l_txn_currency_code;
5376: EXCEPTION

Line 5441: PA_BUDGET_LINES_V_PKG.delete_row

5437: THEN
5438:
5439: BEGIN
5440: --dbms_output.put_line('About to delete the budget line because of zero values');
5441: PA_BUDGET_LINES_V_PKG.delete_row
5442: ( x_rowid => l_budget_line_rec.rowid );
5443: -- Bug Fix: 4569365. Removed MRC code.
5444: -- ,x_mrc_flag => 'Y'); /* FPB2: MRC */
5445:

Line 5482: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

5478:
5479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5480: THEN
5481: FND_MSG_PUB.add_exc_msg
5482: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5483: , p_procedure_name => 'DELETE_ROW'
5484: , p_error_text => SQLCODE );
5485: END IF;
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

5689: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5690: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5691: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5692: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

5693: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5694: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5695: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5696: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

5697: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5698: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5699: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5700: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

5701: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5702: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5703: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5704: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5705: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5706:
5707: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5708: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols
5709: ,p_allow_raw_cost_rate_flag IN VARCHAR2

Line 5904: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;

5900: l_valid_rlmid VARCHAR2(1);
5901: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5902: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5903: l_context_info pa_fin_plan_types_tl.name%TYPE;
5904: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5905:
5906: -- Cursor used in validating the product code
5907: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
5908: Is

Line 5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

5937:
5938: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5939: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5940: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

Line 5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

5941: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5942: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5943: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5944: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

5945: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5946: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5947: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5948: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

5949: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5950: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5951: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5952: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5953: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5954: l_wa_val_conv_attr_flag VARCHAR2(1);
5955: l_calling_model_context VARCHAR(30);
5956:
5957:

Line 8564: FROM pa_resource_assignments ra , pa_budget_lines bl

8560: DECODE(bl.other_rejection_code,NULL,
8561: DECODE(bl.pfc_cur_conv_rejection_code,NULL,
8562: DECODE(bl.pc_cur_conv_rejection_code,NULL,NULL,'E')
8563: ,'E'),'E'),'E'),'E'),'E') return_status
8564: FROM pa_resource_assignments ra , pa_budget_lines bl
8565: where ra.budget_version_id = p_fin_plan_version_id
8566: and ra.resource_assignment_id = bl.resource_assignment_id;
8567:
8568: BEGIN