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_CI_IMPLEMENT_PKG dependencies on PA_BUDGET_VERSIONS

Line 23: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

19: p_impl_txn_rev_amt IN NUMBER,
20: p_impl_pc_rev_amt IN NUMBER,
21: p_impl_pfc_rev_amt IN NUMBER) IS
22: l_agreement_id pa_agreements_all.agreement_id%TYPE;
23: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;
25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;
26: l_bv_id pa_budget_versions.budget_version_id%TYPE;
27:

Line 24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;

20: p_impl_pc_rev_amt IN NUMBER,
21: p_impl_pfc_rev_amt IN NUMBER) IS
22: l_agreement_id pa_agreements_all.agreement_id%TYPE;
23: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;
25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;
26: l_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: l_ci_ver_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;

21: p_impl_pfc_rev_amt IN NUMBER) IS
22: l_agreement_id pa_agreements_all.agreement_id%TYPE;
23: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;
25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;
26: l_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: l_ci_ver_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
29: l_funding_level VARCHAR2(100);

Line 26: l_bv_id pa_budget_versions.budget_version_id%TYPE;

22: l_agreement_id pa_agreements_all.agreement_id%TYPE;
23: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
24: l_total_proj_revenue pa_budget_versions.total_project_revenue%TYPE;
25: l_total_projfunc_revenue pa_budget_versions.revenue%TYPE;
26: l_bv_id pa_budget_versions.budget_version_id%TYPE;
27:
28: l_ci_ver_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
29: l_funding_level VARCHAR2(100);
30: l_err_code NUMBER := null;

Line 147: FROM PA_BUDGET_VERSIONS bv,

143: INTO
144: l_budget_version_id,
145: l_agreement_id,
146: l_ci_ver_planning_level
147: FROM PA_BUDGET_VERSIONS bv,
148: pa_proj_fp_options po WHERE
149: bv.project_id = p_project_id
150: AND bv.approved_rev_plan_type_flag = 'Y'
151: AND bv.version_type IN ('REVENUE','ALL')

Line 174: FROM pa_budget_versions

170: END IF;
171:
172: BEGIN
173: SELECT budget_version_id INTO l_bv_id
174: FROM pa_budget_versions
175: WHERE
176: project_id = p_project_id AND
177: version_type IN ('REVENUE','ALL') AND
178: NVL(current_working_flag,'N' ) = 'Y' AND

Line 871: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

867: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
869: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
870: ) IS
871: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
872: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
873: l_version_type pa_budget_versions.version_type%TYPE;
874: l_meaning pa_lookups.meaning%TYPE;
875: l_person_id NUMBER;

Line 872: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
869: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
870: ) IS
871: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
872: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
873: l_version_type pa_budget_versions.version_type%TYPE;
874: l_meaning pa_lookups.meaning%TYPE;
875: l_person_id NUMBER;
876: l_resource_id NUMBER;

Line 873: l_version_type pa_budget_versions.version_type%TYPE;

869: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
870: ) IS
871: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
872: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
873: l_version_type pa_budget_versions.version_type%TYPE;
874: l_meaning pa_lookups.meaning%TYPE;
875: l_person_id NUMBER;
876: l_resource_id NUMBER;
877: l_resource_name VARCHAR2(200);

Line 886: l_plan_proc_code pa_budget_versions.plan_processing_code%TYPE;

882: another user. In this case, error for Submit status takes precedence
883: over the lock error. */
884: l_locked_by_name per_people_x.full_name%TYPE;
885: l_request_id NUMBER;
886: l_plan_proc_code pa_budget_versions.plan_processing_code%TYPE;
887: l_refresh_required_flag VARCHAR2(1);
888: l_request_id_v VARCHAR2(100);
889: l_url_text VARCHAR2(500);
890: l_return_status VARCHAR2(30);

Line 923: FROM pa_budget_versions WHERE

919: l_version_type,
920: l_request_id,
921: l_plan_proc_code,
922: l_refresh_required_flag
923: FROM pa_budget_versions WHERE
924: budget_version_id = p_target_fp_version_id_tbl(i);
925:
926: /* code added for Patchset L */
927: /* We are not calling the API pa_fp_refresh_elements_pub.get_refresh_plan_ele_dtls

Line 929: getting information from pa_budget_versions table. */

925:
926: /* code added for Patchset L */
927: /* We are not calling the API pa_fp_refresh_elements_pub.get_refresh_plan_ele_dtls
928: for getting the status details as we are already
929: getting information from pa_budget_versions table. */
930:
931: IF l_plan_proc_code = 'WUP' AND l_wbs_update_flag = 'Y' THEN
932: x_return_status := FND_API.G_RET_STS_ERROR;
933: l_chk_flag := 'N';