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_MERGE dependencies on PA_AGREEMENTS_ALL

Line 2794: ,P_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.

2790: ,P_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
2791: ,p_cost_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether cost can be implemented or not.
2792: ,p_rev_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether rev can be implemented or not.
2793: ,P_submit_version_flag IN VARCHAR2 -- Can be Y or N. Indicates whether the version can be submitted for baseline after implementing CO or not.
2794: ,P_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
2795: ,P_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
2796: ,P_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement
2797: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 -- Indicates whether the pa_resource_asgn_curr maintenance api should be called
2798: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 2828: l_agreement_num pa_agreements_all.agreement_num%TYPE;

2824: l_rev_impl_flag VARCHAR2(1);
2825: l_cost_impact_impl_flag VARCHAR2(1);
2826: l_rev_impact_impl_flag VARCHAR2(1);
2827: l_partially_impl_flag VARCHAR2(1);
2828: l_agreement_num pa_agreements_all.agreement_num%TYPE;
2829: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
2830: l_call_rep_lines_api VARCHAR2(1):='N';
2831: l_id_before_bl_insertion pa_budget_lines.budget_line_id%TYPE;
2832: l_id_after_bl_insertion pa_budget_lines.budget_line_id%TYPE;

Line 3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;

3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3281: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3282: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;
3283: l_qty_adjusted_flag VARCHAR2(1);

Line 3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3281: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3282: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;
3283: l_qty_adjusted_flag VARCHAR2(1);
3284: --These variables will be used in calling create_ci_impact_fund_lines

Line 8811: pa_agreements_all agr

8807: agr.agreement_currency_code
8808: INTO l_agreement_id,
8809: l_agreement_currency_code
8810: FROM pa_budget_versions cibv,
8811: pa_agreements_all agr
8812: WHERE cibv.budget_version_id = l_src_ver_id_tbl(j)
8813: AND cibv.agreement_id = agr.agreement_id;
8814:
8815: IF l_debug_mode = 'Y' THEN

Line 10373: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

10369: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10370: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10371: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10372: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10373: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10374: ,p_update_agreement_amt_flag IN VARCHAR2
10375: ,p_funding_category IN VARCHAR2
10376: ,x_ci_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10377: ,x_ci_cost_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 10386: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895

10382: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895
10383: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895
10384: ,x_ci_number OUT NOCOPY SYSTEM.pa_varchar2_100_tbl_type --File.Sql.39 bug 4440895
10385: ,x_budget_ci_map_rec_tbl OUT NOCOPY budget_ci_map_rec_tbl_type --File.Sql.39 bug 4440895
10386: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895
10387: ,x_funding_category OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10388: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10389: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10390: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;

10427: l_rev_impl_flag VARCHAR2(1);
10428: l_cost_impact_impl_flag VARCHAR2(1);
10429: l_rev_impact_impl_flag VARCHAR2(1);
10430: l_partially_impl_flag VARCHAR2(1);
10431: l_agreement_num pa_agreements_all.agreement_num%TYPE;
10432: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
10433: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10434: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
10435: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 10440: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

10436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
10437: l_total_amount NUMBER;
10438: l_implemented_amount NUMBER;
10439: l_remaining_amount NUMBER;
10440: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
10441:
10442: CURSOR c_chk_rej_codes (ci_ci_ver_id1 pa_budget_versions.budget_version_id%TYPE,
10443: ci_ci_ver_id2 pa_budget_versions.budget_version_id%TYPE)
10444: IS

Line 11635: FROM pa_agreements_all

11631: IF p_context='PARTIAL_REV' AND px_partial_impl_rev_amt <> 0 THEN
11632:
11633: SELECT agreement_currency_code
11634: INTO l_agr_curr_code
11635: FROM pa_agreements_all
11636: WHERE agreement_id=x_agreement_id;
11637:
11638: px_partial_impl_rev_amt :=Pa_currency.round_trans_currency_amt1(px_partial_impl_rev_amt,
11639: l_agr_curr_code);

Line 11724: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.

11720: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
11721: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
11722: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
11723: ,p_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation
11724: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
11725: ,p_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
11726: ,p_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement
11727: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11728: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 12546: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

12542: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12543: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12544: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
12545: ,p_partial_impl_rev_amt IN NUMBER
12546: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
12547: ,p_update_agreement_amt_flag IN VARCHAR2
12548: ,p_funding_category IN VARCHAR2
12549: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 --IPM Arch Enhancement Bug 4865563
12550: ,p_add_msg_to_stack IN VARCHAR2

Line 12599: l_agreement_id pa_agreements_all.agreement_id%TYPE;

12595: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
12596: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
12597: l_budget_ci_map_rec_tbl budget_ci_map_rec_tbl_type;
12598: l_impl_impact_type_code VARCHAR2(10);
12599: l_agreement_id pa_agreements_all.agreement_id%TYPE;
12600: l_funding_category VARCHAR2(30);
12601: l_partial_impl_rev_amt pa_budget_lines.txn_revenue%TYPE;
12602:
12603: --These two variables will be used for comparing the no. of error messages in the error message stack when the