APPS.JG_ZZ_RTCE_DT_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;

227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;
228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;
229: END IF ;
230:
231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;
232:
233: FOR r_inv_lines in c_generic_ar_inv_lines
234: LOOP
235:

Line 236: INSERT INTO jg_zz_vat_trx_gt

232:
233: FOR r_inv_lines in c_generic_ar_inv_lines
234: LOOP
235:
236: INSERT INTO jg_zz_vat_trx_gt
237: ( jg_info_n1
238: , jg_info_n2
239: , jg_info_v1
240: , jg_info_d1

Line 277: select count(*) INTO lv_count from jg_zz_vat_trx_gt;

273: ,r_inv_lines.amount
274: );
275: end loop;
276:
277: select count(*) INTO lv_count from jg_zz_vat_trx_gt;
278:
279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );
280: return (TRUE);
281: EXCEPTION

Line 279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );

275: end loop;
276:
277: select count(*) INTO lv_count from jg_zz_vat_trx_gt;
278:
279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );
280: return (TRUE);
281: EXCEPTION
282: WHEN OTHERS THEN
283: fnd_file.put_line(fnd_file.log,'Unexpected error occurred in BeforeReport Trigger. Error : ' || SUBSTR(SQLERRM,1,200));