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_WEBADI_PKG dependencies on PA_PROJECTS_ALL

Line 51: c_project_id pa_projects_all.project_id%TYPE,

47: c_allow_revenue_flag VARCHAR2,
48: c_allow_raw_cost_rate_flag VARCHAR2,
49: c_allow_burd_cost_rate_flag VARCHAR2,
50: c_allow_bill_rate_flag VARCHAR2,
51: c_project_id pa_projects_all.project_id%TYPE,
52: c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE,
53: c_version_type pa_budget_versions.version_type%TYPE,
54: c_request_id pa_budget_versions.request_id%TYPE
55: )

Line 481: l_project_id pa_projects_all.project_id%TYPE;

477: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
478:
479: l_record_version_number pa_budget_versions.record_version_number%TYPE;
480: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;
481: l_project_id pa_projects_all.project_id%TYPE;
482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

Line 1668: p_org_id IN pa_projects_all.org_id%TYPE,

1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1668: p_org_id IN pa_projects_all.org_id%TYPE,
1669: x_budget_lines OUT NOCOPY PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE, --File.Sql.39 bug 4440895
1670: x_etc_quantity_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1671: x_etc_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895
1672: x_etc_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE, --File.Sql.39 bug 4440895

Line 1883: CURSOR l_first_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,

1879: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- cbs enhancement changes bug#16445106
1880:
1881:
1882: -- cursor to get the start/end date of the first period before the first period displayed in the period mask
1883: CURSOR l_first_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,
1884: c_first_prd_st_dt DATE,
1885: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
1886: IS
1887: SELECT gl.start_date start_date,

Line 1904: CURSOR l_last_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,

1900:
1901: l_first_pd_st_en_dt_rec l_first_pd_st_en_dt_csr%ROWTYPE;
1902:
1903: -- cursor to get the start/end date of the last period before the last period displayed in the period mask
1904: CURSOR l_last_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,
1905: c_last_prd_en_dt DATE,
1906: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
1907: IS
1908: SELECT gl.start_date start_date,

Line 2101: FROM pa_projects_all p

2097: UNION ALL
2098: SELECT p.long_name task_name, /* Bug 5345336 */
2099: p.segment1 task_number,
2100: 0 task_id
2101: FROM pa_projects_all p
2102: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2103: WHERE (inf.task_name IS NOT NULL
2104: AND inf.task_number IS NULL
2105: AND inf.task_name = pt.task_name) OR

Line 2208: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and

2204: AND rlm.object_type = 'PROJECT'
2205: AND rlm.object_id = p_version_info_rec.x_project_id),
2206: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2207: (select pre.rbs_element_id from pa_rbs_elements pre where
2208: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2209: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2210:
2211: WHERE inf.run_id= p_run_id
2212: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);

Line 2231: FROM pa_projects_all p

2227: UNION ALL
2228: SELECT p.long_name task_name, /* Bug 5345336 */
2229: p.segment1 task_number,
2230: 0 task_id
2231: FROM pa_projects_all p
2232: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2233: WHERE (inf.task_name IS NOT NULL
2234: AND inf.task_number IS NULL
2235: AND inf.task_name = pt.task_name) OR

Line 2338: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and

2334: AND rlm.object_type = 'RESOURCE_LIST'
2335: AND rlm.object_id = p_version_info_rec.x_resource_list_id),
2336: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2337: (select pre.rbs_element_id from pa_rbs_elements pre where
2338: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2339: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2340: WHERE inf.run_id= p_run_id
2341: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);
2342: END IF; -- control_flag = N

Line 2375: FROM pa_projects_all p

2371: UNION ALL
2372: SELECT p.long_name task_name, /* Bug 5345336 */
2373: p.segment1 task_number,
2374: 0 task_id
2375: FROM pa_projects_all p
2376: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2377: WHERE (inf.task_name IS NOT NULL
2378: AND inf.task_number IS NULL
2379: AND inf.task_name = pt.task_name) OR

Line 2477: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and

2473: inf.sd_prd = DECODE(inf.delete_flag,'Y',l_fnd_miss_num , inf.sd_prd),
2474: inf.resource_list_member_id = l_unct_rlm_id,
2475: inf.cbs_element_id = DECODE(l_Cbs_Enabled,'N',NULL,
2476: (select pre.rbs_element_id from pa_rbs_elements pre where
2477: pre.rbs_version_id = (select cbs_version_id from pa_projects_all where project_id = p_version_info_rec.x_project_id) and
2478: inf.cost_code = pre.cost_code))-- cbs enhancement changes bug#16445106
2479: WHERE inf.run_id= p_run_id
2480: AND Nvl(p_request_id, -99) = Nvl(inf.request_id, -99);
2481: END IF; -- uncategorized flag

Line 6161: (p_project_id IN pa_projects_all.project_id%TYPE,

6157: END get_amount_in_prd_x;
6158:
6159: --This API is internally called from prepare_pbl_input
6160: PROCEDURE get_total_fcst_amounts
6161: (p_project_id IN pa_projects_all.project_id%TYPE,
6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6163: p_task_id IN pa_tasks.task_id%TYPE,
6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106

Line 6781: p_project_id IN pa_projects_all.project_id%TYPE,

6777: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6779: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6781: p_project_id IN pa_projects_all.project_id%TYPE,
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6784: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,

Line 10310: l_project_id pa_projects_all.project_id%TYPE;

10306:
10307: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods

Line 10311: l_org_id pa_projects_all.org_id%TYPE;

10307: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10313:
10314: -- variable to held the start_date and end_date of individual periods
10315: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,

10399: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10400: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10401: l_prc_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type;-- cbs enhancement changes bug#16445106
10402:
10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10404: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10405: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10406: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10407: IS

Line 10634: pa_projects_all pl

10630: INTO l_project_id,
10631: l_org_id,
10632: l_etc_start_date
10633: FROM pa_budget_versions bv,
10634: pa_projects_all pl
10635: WHERE bv.budget_version_id = l_budget_version_id
10636: AND bv.project_id = pl.project_id;
10637: EXCEPTION
10638: WHEN NO_DATA_FOUND THEN

Line 11801: p_org_id IN pa_projects_all.org_id%TYPE,

11797: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11798:
11799: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11800: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11801: p_org_id IN pa_projects_all.org_id%TYPE,
11802: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11803: x_periods_tbl OUT NOCOPY periods_tbl,
11804: x_return_status OUT NOCOPY VARCHAR2,
11805: x_msg_count OUT NOCOPY NUMBER,

Line 12073: c_project_id pa_projects_all.project_id%TYPE,

12069: done in 11i into R12.
12070: */
12071: --This Cursor is used to get Resource Assignment information associated with the budget version.
12072: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
12073: c_project_id pa_projects_all.project_id%TYPE,
12074: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
12075: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
12076: IS
12077: SELECT pra.resource_assignment_id resource_assignment_id,

Line 12119: pa_projects_all ppa

12115: pa_lookups uom,
12116: pa_spread_curves_tl psc,
12117: cst_cost_types cct,
12118: pa_lookups etc,
12119: pa_projects_all ppa
12120: WHERE pra.budget_version_id = c_budget_version_id
12121: AND prac.budget_version_id = pra.budget_version_id
12122: AND prac.resource_assignment_id = pra.resource_assignment_id
12123: AND pftc.fin_plan_version_id = prac.budget_version_id

Line 12285: l_org_id pa_projects_all.org_id%TYPE;

12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;

Line 12289: l_project_name pa_projects_all.name%TYPE;

12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 12290: l_project_number pa_projects_all.segment1%TYPE;

12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12295: l_start_date DATE;
12296: l_end_date DATE;

Line 12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12295: l_start_date DATE;
12296: l_end_date DATE;
12297: l_preceding_date DATE;

Line 12359: pa_projects_all ppa

12355: l_project_name,
12356: l_project_number,
12357: l_rec_version_number --Bug 7863205
12358: FROM pa_budget_versions pbv,
12359: pa_projects_all ppa
12360: WHERE pbv.budget_version_id = l_budget_version_id
12361: AND pbv.project_id = ppa.project_id;
12362: EXCEPTION
12363: WHEN NO_DATA_FOUND THEN