APPS.PA_FP_TXN_CURRENCIES_PUB dependencies on PA_PROJECTS

Line 45: l_source_project_id pa_projects_all.project_id%TYPE;

41:
42:
43: /* End of Variables to be used for debugging purpose */
44:
45: l_source_project_id pa_projects_all.project_id%TYPE;
46: l_source_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
47:
48: l_srce_cost_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
49: l_srce_rev_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;

Line 66: CURSOR proj_pf_currencies_cur(c_project_id pa_projects.project_id%TYPE) IS

62: WHERE proj_fp_options_id = p_target_fp_option_id;
63:
64: target_fp_options_rec target_fp_options_cur%ROWTYPE;
65:
66: CURSOR proj_pf_currencies_cur(c_project_id pa_projects.project_id%TYPE) IS
67: SELECT project_currency_code
68: ,projfunc_currency_code
69: FROM pa_projects_all
70: WHERE project_id = c_project_id;

Line 69: FROM pa_projects_all

65:
66: CURSOR proj_pf_currencies_cur(c_project_id pa_projects.project_id%TYPE) IS
67: SELECT project_currency_code
68: ,projfunc_currency_code
69: FROM pa_projects_all
70: WHERE project_id = c_project_id;
71:
72: proj_pf_currencies_rec proj_pf_currencies_cur%ROWTYPE;
73:

Line 841: ,p_project_currency_code IN pa_projects.project_currency_code%TYPE

837: PROCEDURE enter_agreement_curr_for_ci
838: ( p_project_id IN pa_budget_versions.project_id%TYPE
839: ,p_fin_plan_version_id IN pa_budget_versions.budget_Version_id%TYPE
840: ,p_ci_id IN pa_budget_Versions.ci_id%TYPE
841: ,p_project_currency_code IN pa_projects.project_currency_code%TYPE
842: ,p_projfunc_currency_code IN pa_projects.projfunc_currency_code%TYPE
843: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
844: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
845: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 842: ,p_projfunc_currency_code IN pa_projects.projfunc_currency_code%TYPE

838: ( p_project_id IN pa_budget_versions.project_id%TYPE
839: ,p_fin_plan_version_id IN pa_budget_versions.budget_Version_id%TYPE
840: ,p_ci_id IN pa_budget_Versions.ci_id%TYPE
841: ,p_project_currency_code IN pa_projects.project_currency_code%TYPE
842: ,p_projfunc_currency_code IN pa_projects.projfunc_currency_code%TYPE
843: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
844: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
845: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
846: AS

Line 859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

855: l_agreement_num pa_agreements_all.agreement_num%TYPE;
856: l_agreement_amount pa_agreements_all.amount%TYPE;
857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:

Line 860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

856: l_agreement_amount pa_agreements_all.amount%TYPE;
857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:
864: CURSOR version_details_cur IS

Line 861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:
864: CURSOR version_details_cur IS
865: SELECT proj_fp_options_id,