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 480: l_project_id pa_projects_all.project_id%TYPE;

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

Line 1667: p_org_id IN pa_projects_all.org_id%TYPE,

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

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

1875: l_ra_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE; -- Bug 5068203.
1876:
1877:
1878: -- cursor to get the start/end date of the first period before the first period displayed in the period mask
1879: CURSOR l_first_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,
1880: c_first_prd_st_dt DATE,
1881: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
1882: IS
1883: SELECT gl.start_date start_date,

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

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

Line 2085: FROM pa_projects_all p

2081: UNION ALL
2082: SELECT p.long_name task_name, /* Bug 5345336 */
2083: p.segment1 task_number,
2084: 0 task_id
2085: FROM pa_projects_all p
2086: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2087: WHERE (inf.task_name IS NOT NULL
2088: AND inf.task_number IS NULL
2089: AND inf.task_name = pt.task_name) OR

Line 2208: FROM pa_projects_all p

2204: UNION ALL
2205: SELECT p.long_name task_name, /* Bug 5345336 */
2206: p.segment1 task_number,
2207: 0 task_id
2208: FROM pa_projects_all p
2209: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2210: WHERE (inf.task_name IS NOT NULL
2211: AND inf.task_number IS NULL
2212: AND inf.task_name = pt.task_name) OR

Line 2346: FROM pa_projects_all p

2342: UNION ALL
2343: SELECT p.long_name task_name, /* Bug 5345336 */
2344: p.segment1 task_number,
2345: 0 task_id
2346: FROM pa_projects_all p
2347: WHERE p.project_id = p_version_info_rec.x_project_id) pt
2348: WHERE (inf.task_name IS NOT NULL
2349: AND inf.task_number IS NULL
2350: AND inf.task_name = pt.task_name) OR

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

6064: END get_amount_in_prd_x;
6065:
6066: --This API is internally called from prepare_pbl_input
6067: PROCEDURE get_total_fcst_amounts
6068: (p_project_id IN pa_projects_all.project_id%TYPE,
6069: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6070: p_task_id IN pa_tasks.task_id%TYPE,
6071: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6072: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 6674: p_project_id IN pa_projects_all.project_id%TYPE,

6670: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6671: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6672: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6673: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6674: p_project_id IN pa_projects_all.project_id%TYPE,
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6677: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,

Line 10132: l_project_id pa_projects_all.project_id%TYPE;

10128:
10129: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;
10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10135:
10136: -- variable to held the start_date and end_date of individual periods

Line 10133: l_org_id pa_projects_all.org_id%TYPE;

10129: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;
10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
10135:
10136: -- variable to held the start_date and end_date of individual periods
10137: l_prd_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

10218: l_prc_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
10219: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10220: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10221:
10222: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10224: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10225: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10226: IS

Line 10450: pa_projects_all pl

10446: INTO l_project_id,
10447: l_org_id,
10448: l_etc_start_date
10449: FROM pa_budget_versions bv,
10450: pa_projects_all pl
10451: WHERE bv.budget_version_id = l_budget_version_id
10452: AND bv.project_id = pl.project_id;
10453: EXCEPTION
10454: WHEN NO_DATA_FOUND THEN

Line 11570: p_org_id IN pa_projects_all.org_id%TYPE,

11566: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11567:
11568: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11569: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11570: p_org_id IN pa_projects_all.org_id%TYPE,
11571: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11572: x_periods_tbl OUT NOCOPY periods_tbl,
11573: x_return_status OUT NOCOPY VARCHAR2,
11574: x_msg_count OUT NOCOPY NUMBER,

Line 11842: c_project_id pa_projects_all.project_id%TYPE,

11838: done in 11i into R12.
11839: */
11840: --This Cursor is used to get Resource Assignment information associated with the budget version.
11841: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
11842: c_project_id pa_projects_all.project_id%TYPE,
11843: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
11844: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
11845: IS
11846: SELECT pra.resource_assignment_id resource_assignment_id,

Line 11886: pa_projects_all ppa

11882: pa_lookups uom,
11883: pa_spread_curves_tl psc,
11884: cst_cost_types cct,
11885: pa_lookups etc,
11886: pa_projects_all ppa
11887: WHERE pra.budget_version_id = c_budget_version_id
11888: AND prac.budget_version_id = pra.budget_version_id
11889: AND prac.resource_assignment_id = pra.resource_assignment_id
11890: AND pftc.fin_plan_version_id = prac.budget_version_id

Line 12052: l_org_id pa_projects_all.org_id%TYPE;

12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;

Line 12056: l_project_name pa_projects_all.name%TYPE;

12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 12057: l_project_number pa_projects_all.segment1%TYPE;

12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12062: l_start_date DATE;
12063: l_end_date DATE;

Line 12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12062: l_start_date DATE;
12063: l_end_date DATE;
12064: l_preceding_date DATE;

Line 12119: pa_projects_all ppa

12115: INTO l_project_id,
12116: l_project_name,
12117: l_project_number
12118: FROM pa_budget_versions pbv,
12119: pa_projects_all ppa
12120: WHERE pbv.budget_version_id = l_budget_version_id
12121: AND pbv.project_id = ppa.project_id;
12122: EXCEPTION
12123: WHEN NO_DATA_FOUND THEN