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_VARCHAR2_30_TBL_TYPE

Line 4103: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

4099: -- l_old_model VARCHAR2(1):=null; --3569883
4100:
4101: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
4102: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4103: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
4104: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4105:
4106: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
4107: l_pm_product_code VARCHAR2(30);

Line 5741: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

5737: ,p_spread_curve_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
5738: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
5739: ,p_etc_method_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
5740: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
5741: ,p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
5742: /* Bug 3986129: end*/
5743:
5744: ,px_budget_lines_in IN OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE --File.Sql.39 bug 4440895
5745: /* Bug 3133930- a new output variable is introduced to return the error status */

Line 5749: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895

5745: /* Bug 3133930- a new output variable is introduced to return the error status */
5746: ,x_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE --File.Sql.39 bug 4440895
5747: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5748: ,x_mfc_cost_type_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5749: ,x_etc_method_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
5750: ,x_spread_curve_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type --File.Sql.39 bug 4440895
5751: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5752: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5753: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5940: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

5936: l_mfc_cost_type_id CST_COST_TYPES_V.cost_type_id%TYPE;
5937: l_valid_mfc_cost_type VARCHAR2(1) := 'Y';
5938:
5939: l_webadi_sp_fix_date DATE;
5940: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5941: l_new_error_code pa_lookups.lookup_code%TYPE;
5942: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5943: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5944: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 5944: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

5940: l_webadi_err_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5941: l_new_error_code pa_lookups.lookup_code%TYPE;
5942: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5943: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5944: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5945: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5946: l_webadi_err_prd_flag VARCHAR2(1) := 'N';
5947: l_webadi_cont_proc_flag VARCHAR2(1):= 'Y';
5948:

Line 5945: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

5941: l_new_error_code pa_lookups.lookup_code%TYPE;
5942: l_webadi_err_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5943: l_webadi_err_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5944: l_webadi_err_txn_curr_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5945: l_webadi_err_amt_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5946: l_webadi_err_prd_flag VARCHAR2(1) := 'N';
5947: l_webadi_cont_proc_flag VARCHAR2(1):= 'Y';
5948:
5949: TYPE web_adi_err_code_lookup IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);

Line 6204: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();

6200: END IF;
6201:
6202: -- initializing the out table type parameters
6203: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6204: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6205: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6206:
6207: -- initializing the web adi error code lookup table:
6208: -- this is required to get the validation failure context, so that appropriate lookup code

Line 6242: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();

6238: END IF;
6239:
6240: -- initializing the out table type parameters
6241: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();
6242: x_etc_method_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6243: x_spread_curve_id_tbl := SYSTEM.pa_num_tbl_type();
6244:
6245: Select spread_curve_id
6246: into l_fixed_date_sp_id