APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 251: INSERT INTO jg_zz_vat_trx_gt

247: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
248: END;
249:
250:
251: INSERT INTO jg_zz_vat_trx_gt
252: (
253: jg_info_n1
254: ,jg_info_v1
255: ,jg_info_v2

Line 367: INSERT INTO jg_zz_vat_trx_gt

363: LOOP
364: IF t_loop_amount <= t_value THEN
365: IF t_loop_tax <= t_tax_value THEN
366: l_error_pos := 7;
367: INSERT INTO jg_zz_vat_trx_gt
368: ( jg_info_n1
369: , jg_info_n2
370: , jg_info_v1
371: , jg_info_v2

Line 393: INSERT INTO jg_zz_vat_trx_gt

389: , l_func_curr);
390: EXIT;
391: ELSE
392: l_error_pos := 8;
393: INSERT INTO jg_zz_vat_trx_gt
394: ( jg_info_n1
395: , jg_info_n2
396: , jg_info_v1
397: , jg_info_v2

Line 424: INSERT INTO jg_zz_vat_trx_gt

420: END IF;
421: ELSE
422: IF t_loop_tax <= t_tax_value THEN
423: l_error_pos := 9;
424: INSERT INTO jg_zz_vat_trx_gt
425: ( jg_info_n1
426: , jg_info_n2
427: , jg_info_v1
428: , jg_info_v2

Line 450: INSERT INTO jg_zz_vat_trx_gt

446: , l_func_curr);
447: t_loop_tax := 0;
448: ELSE
449: l_error_pos := 10;
450: INSERT INTO jg_zz_vat_trx_gt
451: ( jg_info_n1
452: , jg_info_n2
453: , jg_info_v1
454: , jg_info_v2

Line 485: INSERT INTO jg_zz_vat_trx_gt

481: END IF;
482:
483: -- Insert into JE_BE_ANNUAL_VAT amounts fetched for amounts or tax with less than 0 */
484: IF t_amount < 0 or t_tax_amount < 0 THEN
485: INSERT INTO jg_zz_vat_trx_gt
486: ( jg_info_n1
487: , jg_info_n2
488: , jg_info_v1
489: , jg_info_v2

Line 541: INSERT INTO jg_zz_vat_trx_gt

537: l_error_pos := 13;
538:
539: -- Trailer information for JEBEVA24
540:
541: INSERT INTO jg_zz_vat_trx_gt
542: ( jg_info_n1
543: , jg_info_v1
544: , jg_info_v2
545: , jg_info_v30

Line 555: INSERT INTO jg_zz_vat_trx_gt

551: ,'JEBEV24-T');
552:
553: -- Header information for JEBEVA24
554:
555: INSERT INTO jg_zz_vat_trx_gt
556: ( jg_info_n1
557: , jg_info_v1
558: , jg_info_v2
559: , jg_info_v3

Line 584: FROM jg_zz_vat_trx_gt

580: END IF;
581:
582: SELECT count(1)
583: INTO l_vat_count
584: FROM jg_zz_vat_trx_gt
585: WHERE jg_info_v30 IS NULL;
586:
587: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);
588:

Line 587: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);

583: INTO l_vat_count
584: FROM jg_zz_vat_trx_gt
585: WHERE jg_info_v30 IS NULL;
586:
587: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);
588:
589: IF l_vat_count = 0 THEN
590: RAISE NO_TRANS_RECORDS;
591: END IF;