APPS.JG_ZZ_RTCE_DT_PKG dependencies on JG_ZZ_VAT_TRX_GT

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

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

Line 239: INSERT INTO jg_zz_vat_trx_gt

235:
236: FOR r_inv_lines in c_generic_ar_inv_lines
237: LOOP
238:
239: INSERT INTO jg_zz_vat_trx_gt
240: ( jg_info_n1
241: , jg_info_n2
242: , jg_info_v1
243: , jg_info_d1

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

278: ,r_inv_lines.cust_trx_line_gl_dist_id
279: );
280: end loop;
281:
282: select count(*) INTO lv_count from jg_zz_vat_trx_gt;
283:
284: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );
285: return (TRUE);
286: EXCEPTION

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

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