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 3438: ,P_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.

3434: ,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
3435: ,p_cost_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether cost can be implemented or not.
3436: ,p_rev_impl_flag IN VARCHAR2 -- Can be Y or N. Indicates whether rev can be implemented or not.
3437: ,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.
3438: ,P_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
3439: ,P_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
3440: ,P_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement
3441: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 -- Indicates whether the pa_resource_asgn_curr maintenance api should be called
3442: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 3472: l_agreement_num pa_agreements_all.agreement_num%TYPE;

3468: l_rev_impl_flag VARCHAR2(1);
3469: l_cost_impact_impl_flag VARCHAR2(1);
3470: l_rev_impact_impl_flag VARCHAR2(1);
3471: l_partially_impl_flag VARCHAR2(1);
3472: l_agreement_num pa_agreements_all.agreement_num%TYPE;
3473: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3474: l_call_rep_lines_api VARCHAR2(1):='N';
3475: l_id_before_bl_insertion pa_budget_lines.budget_line_id%TYPE;
3476: l_id_after_bl_insertion pa_budget_lines.budget_line_id%TYPE;

Line 3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;

3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3921: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3922: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;
3923: l_qty_adjusted_flag VARCHAR2(1);

Line 3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3921: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3922: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;
3923: l_qty_adjusted_flag VARCHAR2(1);
3924: --These variables will be used in calling create_ci_impact_fund_lines

Line 9411: pa_agreements_all agr

9407: agr.agreement_currency_code
9408: INTO l_agreement_id,
9409: l_agreement_currency_code
9410: FROM pa_budget_versions cibv,
9411: pa_agreements_all agr
9412: WHERE cibv.budget_version_id = l_src_ver_id_tbl(j)
9413: AND cibv.agreement_id = agr.agreement_id;
9414:
9415: IF l_debug_mode = 'Y' THEN

Line 10967: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

10963: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10964: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10965: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
10966: ,px_partial_impl_rev_amt IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10967: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
10968: ,p_update_agreement_amt_flag IN VARCHAR2
10969: ,p_funding_category IN VARCHAR2
10970: ,x_ci_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
10971: ,x_ci_cost_version_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

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

10976: ,x_fin_plan_type_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type --File.Sql.39 bug 4440895
10977: ,x_submit_version_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type --File.Sql.39 bug 4440895
10978: ,x_ci_number OUT NOCOPY SYSTEM.pa_varchar2_100_tbl_type --File.Sql.39 bug 4440895
10979: ,x_budget_ci_map_rec_tbl OUT NOCOPY budget_ci_map_rec_tbl_type --File.Sql.39 bug 4440895
10980: ,x_agreement_id OUT NOCOPY pa_agreements_all.agreement_id%TYPE --File.Sql.39 bug 4440895
10981: ,x_funding_category OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10982: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10983: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10984: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;

11021: l_rev_impl_flag VARCHAR2(1);
11022: l_cost_impact_impl_flag VARCHAR2(1);
11023: l_rev_impact_impl_flag VARCHAR2(1);
11024: l_partially_impl_flag VARCHAR2(1);
11025: l_agreement_num pa_agreements_all.agreement_num%TYPE;
11026: l_approved_fin_pt_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
11027: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11028: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type;
11029: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 11034: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

11030: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
11031: l_total_amount NUMBER;
11032: l_implemented_amount NUMBER;
11033: l_remaining_amount NUMBER;
11034: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
11035:
11036: CURSOR c_chk_rej_codes (ci_ci_ver_id1 pa_budget_versions.budget_version_id%TYPE,
11037: ci_ci_ver_id2 pa_budget_versions.budget_version_id%TYPE)
11038: IS

Line 12159: FROM pa_agreements_all

12155: IF p_context='PARTIAL_REV' AND px_partial_impl_rev_amt <> 0 THEN
12156:
12157: SELECT agreement_currency_code
12158: INTO l_agr_curr_code
12159: FROM pa_agreements_all
12160: WHERE agreement_id=x_agreement_id;
12161:
12162: px_partial_impl_rev_amt :=Pa_currency.round_trans_currency_amt1(px_partial_impl_rev_amt,
12163: l_agr_curr_code);

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

12244: ,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
12245: ,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
12246: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12247: ,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
12248: ,p_agreement_id IN Pa_agreements_all.agreement_id%TYPE DEFAULT NULL -- The id of the agreement that is linked with the CO.
12249: ,p_update_agreement_amt_flag IN VARCHAR2 DEFAULT NULL -- Indicates whether to update the agreement amt or not. Null is considered as N
12250: ,p_funding_category IN VARCHAR2 DEFAULT NULL -- The funding category for the agreement
12251: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
12252: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 13070: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE

13066: ,p_impl_cost_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13067: ,p_impl_rev_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13068: ,p_submit_version_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
13069: ,p_partial_impl_rev_amt IN NUMBER
13070: ,p_agreement_id IN pa_agreements_all.agreement_id%TYPE
13071: ,p_update_agreement_amt_flag IN VARCHAR2
13072: ,p_funding_category IN VARCHAR2
13073: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 --IPM Arch Enhancement Bug 4865563
13074: ,p_add_msg_to_stack IN VARCHAR2

Line 13123: l_agreement_id pa_agreements_all.agreement_id%TYPE;

13119: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13120: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
13121: l_budget_ci_map_rec_tbl budget_ci_map_rec_tbl_type;
13122: l_impl_impact_type_code VARCHAR2(10);
13123: l_agreement_id pa_agreements_all.agreement_id%TYPE;
13124: l_funding_category VARCHAR2(30);
13125: l_partial_impl_rev_amt pa_budget_lines.txn_revenue%TYPE;
13126:
13127: --These two variables will be used for comparing the no. of error messages in the error message stack when the