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

Line 4096: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4092: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883
4093: -- l_old_model VARCHAR2(1):=null; --3569883
4094:
4095: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
4096: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4097: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
4098: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4099:
4100: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 4098: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4094:
4095: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
4096: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4097: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
4098: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4099:
4100: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
4101: l_pm_product_code VARCHAR2(30);
4102: l_task_id NUMBER;

Line 5712: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

5708: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols
5709: ,p_allow_raw_cost_rate_flag IN VARCHAR2
5710: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5711: ,p_allow_bill_rate_flag IN VARCHAR2
5712: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5713: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5714: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5715: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5716: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 5713: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

5709: ,p_allow_raw_cost_rate_flag IN VARCHAR2
5710: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5711: ,p_allow_bill_rate_flag IN VARCHAR2
5712: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5713: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5714: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5715: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5716: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5717: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 5714: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

5710: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5711: ,p_allow_bill_rate_flag IN VARCHAR2
5712: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5713: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5714: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5715: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5716: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5717: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5718: ,p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()

Line 5723: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

5719: ,p_mfc_cost_type_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
5720: ,p_spread_curve_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
5721: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
5722: ,p_etc_method_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
5723: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
5724: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
5725: /* Bug 3986129: end*/
5726:
5727: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895

Line 5731: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

5727: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
5728: /* Bug 3133930- a new output variable is introduced to return the error status */
5729: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
5730: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5731: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5732: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
5733: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5734: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5735: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5733: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895

5729: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
5730: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5731: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5732: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
5733: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5734: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5735: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5736: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5737: )

Line 5925: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5921:
5922: l_webadi_sp_fix_date DATE;
5923: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5924: l_new_error_code pa_lookups.lookup_code%TYPE;
5925: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5926: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5927: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5928: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5929: l_webadi_err_prd_flag VARCHAR2(1) := 'N';

Line 5926: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

5922: l_webadi_sp_fix_date DATE;
5923: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5924: l_new_error_code pa_lookups.lookup_code%TYPE;
5925: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5926: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5927: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5928: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5929: l_webadi_err_prd_flag VARCHAR2(1) := 'N';
5930: l_webadi_cont_proc_flag VARCHAR2(1):= 'Y';

Line 6176: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

6172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6173: END IF;
6174:
6175: -- initializing the out table type parameters
6176: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6177: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6178: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6179:
6180: -- initializing the web adi error code lookup table:

Line 6178: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();

6174:
6175: -- initializing the out table type parameters
6176: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6177: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6178: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6179:
6180: -- initializing the web adi error code lookup table:
6181: -- this is required to get the validation failure context, so that appropriate lookup code
6182: -- for web adi context can be used to stamp the interface table corresponding the error

Line 6214: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

6210: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6211: END IF;
6212:
6213: -- initializing the out table type parameters
6214: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6215: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6216: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6217:
6218: Select spread_curve_id

Line 6216: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();

6212:
6213: -- initializing the out table type parameters
6214: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6215: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6216: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6217:
6218: Select spread_curve_id
6219: into l_fixed_date_sp_id
6220: from pa_spread_curves_b