1: PACKAGE BODY JL_ZZ_AP_EXT_AWT_UTIL AS
2: /*$Header: jlzzpwub.pls 120.3 2006/08/03 06:33:27 dbetanco ship $ */
3:
4: pg_file_name VARCHAR2(100) := NULL ;
5: pg_path_name VARCHAR2(100) := NULL ;
104:
105:
106: BEGIN
107: IF tab.count > 0 THEN
108: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** Data From a Tab Withholding ***');
110:
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
105:
106: BEGIN
107: IF tab.count > 0 THEN
108: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** Data From a Tab Withholding ***');
110:
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
108: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** Data From a Tab Withholding ***');
110:
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
109: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** Data From a Tab Withholding ***');
110:
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
110:
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
111: FOR pos IN 1 .. tab.COUNT LOOP
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
112: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
113: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
114: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
115: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
116: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
117: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax ID: ' || to_char(tab(pos).tax_id));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
118: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Name: ' || tab(pos).tax_name);
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
119: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Code Comb. ID: ' || to_char(tab(pos).tax_code_combination_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
120: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Period Type: ' || tab(pos).awt_period_type);
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
121: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax Rate ID: ' || to_char(tab(pos).rate_id));
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
122: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Line Amount: ' || to_char(tab(pos).line_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
123: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable Base Amount: ' || to_char(tab(pos).taxable_base_amount));
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
124: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Revised Base Amount: ' || to_char(tab(pos).revised_tax_base_amount));
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
125: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Withheld Amount: ' || to_char(tab(pos).withheld_amount));
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
133: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** END Tab Withholding ***');
126: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
133: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** END Tab Withholding ***');
134: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
127: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_Pay_Id : ' || to_char(tab(pos).invoice_payment_id));
128: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_Num : ' || to_char(tab(pos).payment_num));
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
133: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** END Tab Withholding ***');
134: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
135: END IF;
129: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Applicable Flag: ' || tab(pos).applicable_flag);
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
133: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** END Tab Withholding ***');
134: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
135: END IF;
136: END Print_Tax_Names;
137:
130: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Exemption Amount: ' || to_char(tab(pos).exemption_amount));
131: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
132: END LOOP;
133: JL_ZZ_AP_EXT_AWT_UTIL.Debug('*** END Tab Withholding ***');
134: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
135: END IF;
136: END Print_Tax_Names;
137:
138: /**************************************************************************
150:
151:
152: BEGIN
153: IF tab.count > 0 THEN
154: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
155: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* Data From a Tab ALL Withholding * ');
156:
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
151:
152: BEGIN
153: IF tab.count > 0 THEN
154: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
155: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* Data From a Tab ALL Withholding * ');
156:
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
154: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
155: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* Data From a Tab ALL Withholding * ');
156:
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
155: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* Data From a Tab ALL Withholding * ');
156:
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
156:
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
157: FOR pos IN 1 .. tab.COUNT LOOP
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
158: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
166:
159: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
166:
167: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* END Tab ALL Withholding * ');
160: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
161: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AWT Type Code: ' || tab(pos).awt_type_code);
162: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Jurisdiction: ' || tab(pos).jurisdiction_type);
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
166:
167: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* END Tab ALL Withholding * ');
168: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
163: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated Amount: ' || to_char(tab(pos).prorated_amount));
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
166:
167: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* END Tab ALL Withholding * ');
168: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
169:
170: END IF;
171:
164: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
165: END LOOP;
166:
167: JL_ZZ_AP_EXT_AWT_UTIL.Debug('* END Tab ALL Withholding * ');
168: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
169:
170: END IF;
171:
172: END Print_tab_all_wh;
187:
188:
189: BEGIN
190: IF tab.count > 0 THEN
191: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
192: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** Data From a Tab Amounts **');
193:
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
188:
189: BEGIN
190: IF tab.count > 0 THEN
191: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
192: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** Data From a Tab Amounts **');
193:
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
191: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
192: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** Data From a Tab Amounts **');
193:
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
192: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** Data From a Tab Amounts **');
193:
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
193:
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
194: FOR pos IN 1 .. tab.COUNT LOOP
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
195: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' POSITION = ' || to_char(pos));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
196: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice ID: ' || to_char(tab(pos).invoice_id));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
197: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Distr.Line: ' || to_char(tab(pos).invoice_distribution_id));
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
198: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Amount: ' || to_char(tab(pos).amount));
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
199: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Tax_inclusive_amount: '|| to_char(tab(pos).tax_inclusive_amount));
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
207:
200: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Payment_amount: ' || to_char(tab(pos).payment_amount));
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
207:
208: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** END Tab Amounts **');
201: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Taxable_base_amount: ' || to_char(tab(pos).taxable_base_amount));
202: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Prorated_tax_incl_amt: ' || to_char(tab(pos).prorated_tax_incl_amt));
203: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_id: ' || to_char(tab(pos).invoice_payment_id));
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
207:
208: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** END Tab Amounts **');
209: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
204: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_payment_num: ' || to_char(tab(pos).invoice_payment_num));
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
207:
208: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** END Tab Amounts **');
209: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
210:
211: END IF;
212:
205: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
206: END LOOP;
207:
208: JL_ZZ_AP_EXT_AWT_UTIL.Debug('** END Tab Amounts **');
209: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' ');
210:
211: END IF;
212:
213: END Print_tab_amounts;
284: BEGIN
285:
286: initialize;
287:
288: END JL_ZZ_AP_EXT_AWT_UTIL ;