APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 281: INSERT INTO jg_zz_vat_trx_gt

277: fnd_file.put_line(fnd_file.log,'Error While retrieving Contact information:'||l_legal_entity_id);
278: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
279: END;
280:
281: INSERT INTO jg_zz_vat_trx_gt
282: (
283: jg_info_n1
284: ,jg_info_v1
285: ,jg_info_v2

Line 407: INSERT INTO jg_zz_vat_trx_gt

403: LOOP
404: IF t_loop_amount <= t_value THEN
405: IF t_loop_tax <= t_tax_value THEN
406: l_error_pos := 7;
407: INSERT INTO jg_zz_vat_trx_gt
408: ( jg_info_n1
409: , jg_info_n2
410: , jg_info_v1
411: , jg_info_v2

Line 433: INSERT INTO jg_zz_vat_trx_gt

429: , l_func_curr);
430: EXIT;
431: ELSE
432: l_error_pos := 8;
433: INSERT INTO jg_zz_vat_trx_gt
434: ( jg_info_n1
435: , jg_info_n2
436: , jg_info_v1
437: , jg_info_v2

Line 464: INSERT INTO jg_zz_vat_trx_gt

460: END IF;
461: ELSE
462: IF t_loop_tax <= t_tax_value THEN
463: l_error_pos := 9;
464: INSERT INTO jg_zz_vat_trx_gt
465: ( jg_info_n1
466: , jg_info_n2
467: , jg_info_v1
468: , jg_info_v2

Line 490: INSERT INTO jg_zz_vat_trx_gt

486: , l_func_curr);
487: t_loop_tax := 0;
488: ELSE
489: l_error_pos := 10;
490: INSERT INTO jg_zz_vat_trx_gt
491: ( jg_info_n1
492: , jg_info_n2
493: , jg_info_v1
494: , jg_info_v2

Line 525: INSERT INTO jg_zz_vat_trx_gt

521: END IF;
522:
523: -- Insert into JE_BE_ANNUAL_VAT amounts fetched for amounts or tax with less than 0 */
524: IF t_amount < 0 or t_tax_amount < 0 THEN
525: INSERT INTO jg_zz_vat_trx_gt
526: ( jg_info_n1
527: , jg_info_n2
528: , jg_info_v1
529: , jg_info_v2

Line 581: INSERT INTO jg_zz_vat_trx_gt

577: l_error_pos := 13;
578:
579: -- Trailer information for JEBEVA24
580:
581: INSERT INTO jg_zz_vat_trx_gt
582: ( jg_info_n1
583: , jg_info_v1
584: , jg_info_v2
585: , jg_info_v30

Line 595: INSERT INTO jg_zz_vat_trx_gt

591: ,'JEBEV24-T');
592:
593: -- Header information for JEBEVA24
594:
595: INSERT INTO jg_zz_vat_trx_gt
596: ( jg_info_n1
597: , jg_info_v1
598: , jg_info_v2
599: , jg_info_v3

Line 624: FROM jg_zz_vat_trx_gt

620: END IF;
621:
622: SELECT count(1)
623: INTO l_vat_count
624: FROM jg_zz_vat_trx_gt
625: WHERE jg_info_v30 IS NULL;
626:
627: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);
628:

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

623: INTO l_vat_count
624: FROM jg_zz_vat_trx_gt
625: WHERE jg_info_v30 IS NULL;
626:
627: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);
628:
629: IF l_vat_count = 0 THEN
630: RAISE NO_TRANS_RECORDS;
631: END IF;