APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_BOX_ALLOCS

Line 25: delete from jg_zz_vat_box_allocs

21:
22: begin
23:
24: if nvl(pv_reallocate_flag, 'N') = 'Y' then
25: delete from jg_zz_vat_box_allocs
26: where vat_transaction_id in
27: ( select vat_transaction_id
28: from jg_zz_vat_trx_details a
29: where a.reporting_status_id = pn_reporting_status_id);

Line 180: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;

176: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;
177: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;
178: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;
179: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;
180: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;
181: lv_financial_document_type jg_zz_vat_alloc_rules.financial_document_type%TYPE;
182:
183: lv_fresh_allocation_flag varchar2(1);
184: lv_enable_annual_alloc_flag varchar2(1); /* variable that indicates whether annual allocation is required or not */

Line 188: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;

184: lv_enable_annual_alloc_flag varchar2(1); /* variable that indicates whether annual allocation is required or not */
185: lv_enable_alloc_flag varchar2(1); /* variable that indicates whether allocations is required or not */
186: lv_allocation_errored_flag varchar2(1);
187: lv_allocation_error_code varchar2(100);
188: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;
189: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;
190: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;
191: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;
192: lv_check_alloc_trans number(15);

Line 189: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;

185: lv_enable_alloc_flag varchar2(1); /* variable that indicates whether allocations is required or not */
186: lv_allocation_errored_flag varchar2(1);
187: lv_allocation_error_code varchar2(100);
188: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;
189: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;
190: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;
191: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;
192: lv_check_alloc_trans number(15);
193:

Line 190: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;

186: lv_allocation_errored_flag varchar2(1);
187: lv_allocation_error_code varchar2(100);
188: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;
189: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;
190: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;
191: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;
192: lv_check_alloc_trans number(15);
193:
194: lv_return_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;

Line 191: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;

187: lv_allocation_error_code varchar2(100);
188: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;
189: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;
190: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;
191: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;
192: lv_check_alloc_trans number(15);
193:
194: lv_return_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;
195: lv_return_message VARCHAR2(1996);

Line 860: jg_zz_vat_box_allocs_pkg.insert_row(

856: end if;
857:
858: ln_allocated_cnt := ln_allocated_cnt + 1;
859:
860: jg_zz_vat_box_allocs_pkg.insert_row(
861: xn_vat_box_allocation_id => ln_vat_box_allocation_id,
862: pn_vat_transaction_id => l_trx_rec.vat_transaction_id,
863: pv_period_type => lv_period_type,
864: pn_allocation_rule_id => ln_allocation_rule_id,