eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_BOX_ALLOCS

Line 26: delete from jg_zz_vat_box_allocs

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

Line 181: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;

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

Line 189: ln_allocation_rule_id jg_zz_vat_box_allocs.allocation_rule_id%TYPE;

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

Line 190: lv_tax_box jg_zz_vat_box_allocs.tax_box%TYPE;

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

Line 191: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;

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

Line 192: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;

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

Line 915: fnd_file.put_line(fnd_file.log, 'run allocation - Calling jg_zz_vat_box_allocs_pkg.insert_row');

911:
912: ln_allocated_cnt := ln_allocated_cnt + 1;
913:
914: if gv_debug_flag then
915: fnd_file.put_line(fnd_file.log, 'run allocation - Calling jg_zz_vat_box_allocs_pkg.insert_row');
916: fnd_file.put_line(fnd_file.log, 'run allocation - vat box allocation ID'||ln_vat_box_allocation_id);
917: fnd_file.put_line(fnd_file.log, 'run allocation - vat transaction ID'||l_trx_rec.vat_transaction_id);
918: fnd_file.put_line(fnd_file.log, 'run allocation - Allocation Rule ID'||ln_allocation_rule_id);
919:

Line 922: jg_zz_vat_box_allocs_pkg.insert_row(

918: fnd_file.put_line(fnd_file.log, 'run allocation - Allocation Rule ID'||ln_allocation_rule_id);
919:
920: end if;
921:
922: jg_zz_vat_box_allocs_pkg.insert_row(
923: xn_vat_box_allocation_id => ln_vat_box_allocation_id,
924: pn_vat_transaction_id => l_trx_rec.vat_transaction_id,
925: pv_period_type => lv_period_type,
926: pn_allocation_rule_id => ln_allocation_rule_id,