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_ALLOC_RULES

Line 8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;

4: gv_debug_flag BOOLEAN; /* added for debug */
5:
6: -- Variables used by allocate_box procedure to allow multiple rules for same transaction
7: gv_hierarchy_level NUMBER(15); /* 1=tax_code; 2=tax_status; 3=tax_rate_code; 4=tax_jurisdiction_code */
8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;
9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;
10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

Line 9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;

5:
6: -- Variables used by allocate_box procedure to allow multiple rules for same transaction
7: gv_hierarchy_level NUMBER(15); /* 1=tax_code; 2=tax_status; 3=tax_rate_code; 4=tax_jurisdiction_code */
8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;
9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;
10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13:

Line 10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;

6: -- Variables used by allocate_box procedure to allow multiple rules for same transaction
7: gv_hierarchy_level NUMBER(15); /* 1=tax_code; 2=tax_status; 3=tax_rate_code; 4=tax_jurisdiction_code */
8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;
9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;
10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13:
14: /* API to flush the data */

Line 11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

7: gv_hierarchy_level NUMBER(15); /* 1=tax_code; 2=tax_status; 3=tax_rate_code; 4=tax_jurisdiction_code */
8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;
9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;
10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13:
14: /* API to flush the data */
15: procedure purge_allocation_data(

Line 12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

8: gv_tax_status jg_zz_vat_alloc_rules.tax_status%TYPE;
9: gv_tax_rate_code jg_zz_vat_alloc_rules.tax_rate_code%TYPE;
10: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
11: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
12: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13:
14: /* API to flush the data */
15: procedure purge_allocation_data(
16: pn_reporting_status_id number, /* Primarykey Indicator for repEntity, tax_calerdar and source */

Line 181: lv_financial_document_type jg_zz_vat_alloc_rules.financial_document_type%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 */
185: lv_enable_alloc_flag varchar2(1); /* variable that indicates whether allocations is required or not */

Line 1026: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

1022:
1023: lv_hierarchy_debug varchar2(30);
1024: lv_statement varchar2(10);
1025:
1026: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1027: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1028: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1029: lv_taxable_box_non_rec jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1030:

Line 1027: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;

1023: lv_hierarchy_debug varchar2(30);
1024: lv_statement varchar2(10);
1025:
1026: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1027: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1028: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1029: lv_taxable_box_non_rec jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1030:
1031: CURSOR c_get_alloc_rules_for_tax(

Line 1028: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;

1024: lv_statement varchar2(10);
1025:
1026: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1027: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1028: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1029: lv_taxable_box_non_rec jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1030:
1031: CURSOR c_get_alloc_rules_for_tax(
1032: cp_period_type VARCHAR2,

Line 1029: lv_taxable_box_non_rec jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;

1025:
1026: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1027: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1028: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1029: lv_taxable_box_non_rec jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1030:
1031: CURSOR c_get_alloc_rules_for_tax(
1032: cp_period_type VARCHAR2,
1033: cp_source VARCHAR2,

Line 1050: FROM jg_zz_vat_alloc_rules a

1046: a.tax_box_recoverable,
1047: a.tax_box_non_recoverable,
1048: a.taxable_box_recoverable,
1049: a.taxable_box_non_recoverable
1050: FROM jg_zz_vat_alloc_rules a
1051: ,jg_zz_vat_rep_entities b
1052: WHERE b.vat_reporting_entity_id = pn_vat_reporting_entity_id
1053: and ((b.entity_type_code = 'ACCOUNTING'
1054: and

Line 1095: FROM jg_zz_vat_alloc_rules

1091: allocation_rule_id,
1092: tax_box_recoverable,
1093: tax_box_non_recoverable,
1094: taxable_box_non_recoverable
1095: FROM jg_zz_vat_alloc_rules
1096: WHERE vat_reporting_entity_id = cp_vat_reporting_entity_id
1097: AND period_type = cp_period_type
1098: AND source = cp_source
1099: AND financial_document_type = cp_financial_document_type

Line 1210: from jg_zz_vat_alloc_rules

1206:
1207: -- Assign the appropriate value to gv_allocation_rule_id variable
1208: select min(allocation_rule_id) - 1
1209: into gv_allocation_rule_id
1210: from jg_zz_vat_alloc_rules
1211: where allocation_rule_id <> lv_allocation_rule_id;
1212:
1213: -- Assign the value to global variables accordingly
1214: gv_tax_status := NULL;

Line 1233: from jg_zz_vat_alloc_rules

1229: gv_appl_alloc_rule_id := lv_allocation_rule_id;
1230: BEGIN
1231: select min(allocation_rule_id) - 1
1232: into gv_allocation_rule_id
1233: from jg_zz_vat_alloc_rules
1234: where allocation_rule_id <> lv_allocation_rule_id;
1235:
1236: EXCEPTION
1237: when others then