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 6850: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895

6846: x_res_class_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type , --File.Sql.39 bug 4440895
6847: x_rate_based_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type , --File.Sql.39 bug 4440895
6848: x_rbs_elem_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895
6849: x_change_reason_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type, --File.Sql.39 bug 4440895
6850: x_description_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type, --File.Sql.39 bug 4440895
6851: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6852: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6853: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6854: )

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

7107: x_res_class_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7108: x_rate_based_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
7109: x_rbs_elem_id_tbl := SYSTEM.pa_num_tbl_type();
7110: x_change_reason_code_tbl := SYSTEM.pa_varchar2_30_tbl_type();
7111: x_description_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
7112:
7113: --DEBUG_NS('p_context :: ' || p_context);
7114:
7115: --log1('----- STAGE 2-------');

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

8158: p_pfunc_rev_rate_date_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8159: p_pfunc_rev_rate_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8160: p_pfunc_rev_rate_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type(),
8161: p_change_reason_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type(),
8162: p_description_tbl IN SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type(),
8163: p_delete_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type(),
8164: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8165: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8166: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

8219: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8220: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8221: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8222: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8223: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8224:
8225:
8226: -- variables to copy the records with delete_flag = Y
8227: l_df_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

8263: l_df_pf_rev_rate_date_typ_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8264: l_df_pf_rev_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8265: l_df_pf_rev_rate_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
8266: l_df_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8267: l_df_description_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8268:
8269: l_total_rec_passed INTEGER := 0;
8270: l_curr_ra_id_seq NUMBER;
8271:

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

8412: l_bls_proccessed_flag VARCHAR2(1);
8413: l_error_msg_code VARCHAR2(2000);
8414: l_dest_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8415: l_chg_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8416: l_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8417:
8418: --bug 5962744
8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8420: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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

8417:
8418: --bug 5962744
8419: l_extra_bl_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
8420: l_ex_chg_rsn_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8421: l_ex_desc_tbl SYSTEM.pa_varchar2_2000_tbl_type := SYSTEM.pa_varchar2_2000_tbl_type();
8422: l_ra_exists VARCHAR2(1);
8423: l_extra_bls_exists VARCHAR2(1);
8424: j INTEGER;
8425: BEGIN

Line 10387: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;

10383: l_pfunc_rev_rate_date_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
10384: l_pfunc_rev_rate_tbl SYSTEM.pa_num_tbl_type;
10385: l_pfunc_rev_rate_date_tbl SYSTEM.pa_date_tbl_type;
10386: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
10387: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type;
10388: l_etc_quantity_tbl SYSTEM.pa_num_tbl_type;
10389: l_etc_raw_cost_tbl SYSTEM.pa_num_tbl_type;
10390: l_etc_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
10391: l_etc_revenue_tbl SYSTEM.pa_num_tbl_type;