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_UPGRADE_PKG dependencies on PA_NUM_TBL_TYPE

Line 20: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE;

16:
17: TYPE rtx_ra_id_tbl_type IS TABLE OF
18: pa_resource_asgn_curr.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;
19:
20: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE;
21: l_res_list_tbl res_list_tbl;
22: l_bud_typ_code_tbl bud_typ_code_tbl;
23: l_ra_id_tbl ra_id_tbl_type;
24: l_rtx_ra_id_tbl rtx_ra_id_tbl_type;

Line 2089: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2085: -- Bug 3673111, 07-JUN-04, jwhite -----------------------------------------------
2086:
2087:
2088: l_migration_code varchar2(1) := null;
2089: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2090:
2091: -- End Bug 3673111 --------------------------------------------------------------
2092: -- Added for Bug# 7187487
2093: l_budget_status_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

Line 2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2093: l_budget_status_code_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2094:
2095:
2096: --Bug 4300363
2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2094:
2095:
2096: --Bug 4300363
2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2095:
2096: --Bug 4300363
2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2096: --Bug 4300363
2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2097: l_upg_bl_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2098: l_upg_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682

Line 2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2099: l_upg_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

Line 2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2100: l_upg_quantity_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2101: l_upg_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682

2102: l_upg_txn_raw_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2103: l_upg_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2104: l_upg_txn_burdened_cost_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2105: l_upg_txn_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2113:

Line 2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2106: l_upg_txn_revenue_tbl_in SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type(); --Bug 5676682
2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2113:
2114: -- bug 4865563: added the followings

Line 2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2107: l_upg_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2113:
2114: -- bug 4865563: added the followings
2115: l_fp_cols_rec_var PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 2696: l_budget_ver_tbl2 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2692:
2693: --Below code is added for bug 7187487
2694: --This is to create performance reporting data for the bv's.
2695: DECLARE
2696: l_budget_ver_tbl2 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2697: l_budget_ver_tbl3 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2698: i number;
2699: j number;
2700: k number;

Line 2697: l_budget_ver_tbl3 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2693: --Below code is added for bug 7187487
2694: --This is to create performance reporting data for the bv's.
2695: DECLARE
2696: l_budget_ver_tbl2 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2697: l_budget_ver_tbl3 SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2698: i number;
2699: j number;
2700: k number;
2701: BEGIN

Line 3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

3773: --1.Input is ordered by resource assignment id ,quantities with NULLS coming first
3774: --2.0(Zero)s are passed as input for amounts instead of NULL.
3775: PROCEDURE Apply_Calculate_FPM_Rules
3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type

3775: PROCEDURE Apply_Calculate_FPM_Rules
3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734

Line 3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type

3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3781: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3782: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3783: ,p_calling_module IN VARCHAR2 -- bug 5007734
3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

Line 3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3784: ,x_quantity_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3792: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3785: ,x_txn_raw_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3792: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3793: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3786: ,x_txn_burdened_cost_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3792: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3793: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3794: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

3787: ,x_txn_revenue_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3788: ,x_raw_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3789: ,x_burd_cost_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3790: ,x_bill_override_rate_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3791: ,x_non_rb_ra_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
3792: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3793: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3794: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3795: IS

Line 3810: l_quantity_tab SYSTEM.pa_num_tbl_type;

3806: --Stores previous non rate based resource assignment id
3807: l_prev_non_rb_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3808:
3809: --Processing will be done in the following local variables
3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;

Line 3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;

3807: l_prev_non_rb_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3808:
3809: --Processing will be done in the following local variables
3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;

Line 3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;

3808:
3809: --Processing will be done in the following local variables
3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;
3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;

Line 3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;

3809: --Processing will be done in the following local variables
3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;
3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;
3817:

Line 3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;

3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;
3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;
3817:
3818: l_stage VARCHAR2(100);

Line 3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;

3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;
3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;
3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;
3817:
3818: l_stage VARCHAR2(100);
3819:

Line 3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;

3812: l_txn_burdened_cost_tab SYSTEM.pa_num_tbl_type;
3813: l_txn_revenue_tab SYSTEM.pa_num_tbl_type;
3814: l_cost_rate_override_tab SYSTEM.pa_num_tbl_type;
3815: l_burden_rate_override_tab SYSTEM.pa_num_tbl_type;
3816: l_bill_rate_override_tab SYSTEM.pa_num_tbl_type;
3817:
3818: l_stage VARCHAR2(100);
3819:
3820: BEGIN

Line 3885: l_cost_rate_override_tab := SYSTEM.pa_num_tbl_type();

3881: l_quantity_tab := p_quantity_tbl;
3882: l_txn_raw_cost_tab := p_txn_raw_cost_tbl;
3883: l_txn_burdened_cost_tab := p_txn_burdened_cost_tbl;
3884: l_txn_revenue_tab := p_txn_revenue_tbl;
3885: l_cost_rate_override_tab := SYSTEM.pa_num_tbl_type();
3886: l_burden_rate_override_tab := SYSTEM.pa_num_tbl_type();
3887: l_bill_rate_override_tab := SYSTEM.pa_num_tbl_type();
3888: l_cost_rate_override_tab.extend(p_quantity_tbl.COUNT);
3889: l_burden_rate_override_tab.extend(p_quantity_tbl.COUNT);

Line 3886: l_burden_rate_override_tab := SYSTEM.pa_num_tbl_type();

3882: l_txn_raw_cost_tab := p_txn_raw_cost_tbl;
3883: l_txn_burdened_cost_tab := p_txn_burdened_cost_tbl;
3884: l_txn_revenue_tab := p_txn_revenue_tbl;
3885: l_cost_rate_override_tab := SYSTEM.pa_num_tbl_type();
3886: l_burden_rate_override_tab := SYSTEM.pa_num_tbl_type();
3887: l_bill_rate_override_tab := SYSTEM.pa_num_tbl_type();
3888: l_cost_rate_override_tab.extend(p_quantity_tbl.COUNT);
3889: l_burden_rate_override_tab.extend(p_quantity_tbl.COUNT);
3890: l_bill_rate_override_tab.extend(p_quantity_tbl.COUNT);

Line 3887: l_bill_rate_override_tab := SYSTEM.pa_num_tbl_type();

3883: l_txn_burdened_cost_tab := p_txn_burdened_cost_tbl;
3884: l_txn_revenue_tab := p_txn_revenue_tbl;
3885: l_cost_rate_override_tab := SYSTEM.pa_num_tbl_type();
3886: l_burden_rate_override_tab := SYSTEM.pa_num_tbl_type();
3887: l_bill_rate_override_tab := SYSTEM.pa_num_tbl_type();
3888: l_cost_rate_override_tab.extend(p_quantity_tbl.COUNT);
3889: l_burden_rate_override_tab.extend(p_quantity_tbl.COUNT);
3890: l_bill_rate_override_tab.extend(p_quantity_tbl.COUNT);
3891:

Line 3893: x_non_rb_ra_id_tbl := SYSTEM.pa_num_tbl_type();

3889: l_burden_rate_override_tab.extend(p_quantity_tbl.COUNT);
3890: l_bill_rate_override_tab.extend(p_quantity_tbl.COUNT);
3891:
3892: --Prepare the tbl that holds the RAs for which rate based flag should be changed.
3893: x_non_rb_ra_id_tbl := SYSTEM.pa_num_tbl_type();
3894:
3895:
3896: FOR i IN l_quantity_tab.first .. l_quantity_tab.last LOOP
3897:

Line 4367: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

4363: l_date date := sysdate;
4364: l_login_id NUMBER := fnd_global.login_id;
4365: l_user_id NUMBER := fnd_global.user_id;
4366:
4367: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
4368:
4369: l_fp_cols_rec_var PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --/* Bug 5098818 */
4370:
4371: record_locked EXCEPTION;