DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_TAXCTG_UPDATES

Line 144: ,p_tax_cat_update_id IN jai_cmn_taxctg_updates.tax_category_update_id%type

140: ,p_process_partial IN CHAR DEFAULT 'N' --17
141: ,p_debug IN CHAR DEFAULT 'N' --18
142: ,p_trace IN CHAR DEFAULT 'N' --19
143: ,p_dbms_output IN CHAR DEFAULT 'N' -- this can be used when developer tests this from backened to get dbms output at important points
144: ,p_tax_cat_update_id IN jai_cmn_taxctg_updates.tax_category_update_id%type
145: )
146: is
147: begin
148: /* For all supported document types do mass tax changes */

Line 160: from jai_cmn_taxctg_updates

156: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);
157:
158: /* For each tax category where invoice mass tax flag is set, call mass tax changes procedure*/
159: for r_tax_cat in (select tax_category_id
160: from jai_cmn_taxctg_updates
161: where tax_category_update_id = p_tax_cat_update_id
162: and invoke_mass_tax_update_flag = 'Y'
163: )
164: loop