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 4102: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

4098: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883
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;

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

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);
4108: l_task_id NUMBER;

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

5725: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols
5726: ,p_allow_raw_cost_rate_flag IN VARCHAR2
5727: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5728: ,p_allow_bill_rate_flag IN VARCHAR2
5729: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5730: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5731: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5732: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5733: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

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

5726: ,p_allow_raw_cost_rate_flag IN VARCHAR2
5727: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5728: ,p_allow_bill_rate_flag IN VARCHAR2
5729: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5730: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5731: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5732: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5733: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5734: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

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

5727: ,p_allow_burd_cost_rate_flag IN VARCHAR2
5728: ,p_allow_bill_rate_flag IN VARCHAR2
5729: ,p_raw_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5730: ,p_burd_cost_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5731: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
5732: ,p_uom_tbl IN SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type()
5733: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5734: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
5735: ,p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()

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

5736: ,p_mfc_cost_type_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_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

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

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 */
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

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

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
5754: )

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

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();
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';

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

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();
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';

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

6199: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
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:

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

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
6209: -- for web adi context can be used to stamp the interface table corresponding the error

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

6237: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
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

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

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
6247: from pa_spread_curves_b