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_WEBADI_PKG dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 6741: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895

6737: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6738: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895
6739: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6740: x_change_reason_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, --File.Sql.39 bug 4440895
6741: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895
6742: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6743: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6744: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6745: )

Line 6988: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();

6984: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6985: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
6986: x_rbs_elem_id_tbl := SYSTEM.pa_num_tbl_type();
6987: x_change_reason_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
6988: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
6989:
6990: --log1('----- STAGE 2-------');
6991: IF p_context = 'WEBADI_PERIODIC' THEN
6992: --log1('----- STAGE 2P-------');

Line 8012: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),

8008: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8009: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8010: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8011: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8012: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),
8013: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8014: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8015: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8016: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8072: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();

8068: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8069: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8070: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8071: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8072: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8073:
8074:
8075: -- variables to copy the records with delete_flag = Y
8076: l_df_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 8115: l_df_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();

8111: l_df_pf_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8112: l_df_pf_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8113: l_df_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8114: l_df_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8115: l_df_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8116:
8117: l_total_rec_passed INTEGER := 0;
8118: l_curr_ra_id_seq NUMBER;
8119:

Line 8263: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();

8259: l_bls_proccessed_flag VARCHAR2(1);
8260: l_error_msg_code VARCHAR2(2000);
8261: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8262: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8263: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8264:
8265: --bug 5962744
8266: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8267: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

Line 8268: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();

8264:
8265: --bug 5962744
8266: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8267: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8268: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8269: l_ra_exists VARCHAR2(1);
8270: l_extra_bls_exists VARCHAR2(1);
8271: j INTEGER;
8272: BEGIN

Line 10208: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;

10204: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10205: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10206: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;
10207: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10208: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;
10209: l_etc_quantity_tbl SYSTEM.pa_num_tbl_type;
10210: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10211: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10212: l_etc_revenue_tbl SYSTEM.pa_num_tbl_type;