APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_TAXCTG_UPDATES

Line 151: ,p_tax_cat_update_id IN jai_cmn_taxctg_updates.tax_category_update_id%type

147: ,p_process_partial IN CHAR DEFAULT 'N' --17
148: ,p_debug IN CHAR DEFAULT 'N' --18
149: ,p_trace IN CHAR DEFAULT 'N' --19
150: ,p_dbms_output IN CHAR DEFAULT 'N' -- this can be used when developer tests this from backened to get dbms output at important points
151: ,p_tax_cat_update_id IN jai_cmn_taxctg_updates.tax_category_update_id%type
152: )
153: is
154: begin
155: /* For all supported document types do mass tax changes */

Line 167: from jai_cmn_taxctg_updates

163: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);
164:
165: /* For each tax category where invoice mass tax flag is set, call mass tax changes procedure*/
166: for r_tax_cat in (select tax_category_id
167: from jai_cmn_taxctg_updates
168: where tax_category_update_id = p_tax_cat_update_id
169: and invoke_mass_tax_update_flag = 'Y'
170: )
171: loop