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 148: FROM PA_BUDGET_VERSIONS bv,

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

Line 175: FROM pa_budget_versions

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

Line 874: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

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

Line 875: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

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

Line 876: l_version_type pa_budget_versions.version_type%TYPE;

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

Line 889: l_plan_proc_code pa_budget_versions.plan_processing_code%TYPE;

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

Line 926: FROM pa_budget_versions WHERE

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

Line 932: getting information from pa_budget_versions table. */

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