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_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603
11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
12: gv_allocation_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_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603
11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
12: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

Line 10: gv_tax_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603

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_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603
11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
12: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
14:

Line 11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%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_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603
11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
12: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
14:
15: /* API to flush the data */

Line 12: gv_allocation_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_rate_id jg_zz_vat_alloc_rules.tax_rate_id%TYPE; --bug14241603
11: gv_tax_jurisdiction_code jg_zz_vat_alloc_rules.tax_jurisdiction_code%TYPE;
12: gv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
13: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
14:
15: /* API to flush the data */
16: procedure purge_allocation_data(

Line 13: gv_appl_alloc_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

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

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

Line 1089: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;

1085:
1086: lv_hierarchy_debug varchar2(30);
1087: lv_statement varchar2(10);
1088:
1089: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1090: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1091: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1092: lv_taxable_boxes jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1093:

Line 1090: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;

1086: lv_hierarchy_debug varchar2(30);
1087: lv_statement varchar2(10);
1088:
1089: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1090: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1091: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1092: lv_taxable_boxes jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1093:
1094: CURSOR c_get_alloc_rules_for_tax(

Line 1091: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;

1087: lv_statement varchar2(10);
1088:
1089: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1090: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1091: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1092: lv_taxable_boxes jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1093:
1094: CURSOR c_get_alloc_rules_for_tax(
1095: cp_period_type VARCHAR2,

Line 1092: lv_taxable_boxes jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;

1088:
1089: lv_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%TYPE;
1090: lv_tax_box_recoverable jg_zz_vat_alloc_rules.tax_box_recoverable%TYPE;
1091: lv_tax_box_non_rec jg_zz_vat_alloc_rules.tax_box_non_recoverable%TYPE;
1092: lv_taxable_boxes jg_zz_vat_alloc_rules.taxable_box_non_recoverable%TYPE;
1093:
1094: CURSOR c_get_alloc_rules_for_tax(
1095: cp_period_type VARCHAR2,
1096: cp_source VARCHAR2,

Line 1118: FROM jg_zz_vat_alloc_rules a

1114: a.tax_box_recoverable,
1115: a.tax_box_non_recoverable,
1116: a.taxable_box_recoverable,
1117: a.taxable_box_non_recoverable
1118: FROM jg_zz_vat_alloc_rules a
1119: ,jg_zz_vat_rep_entities b
1120: WHERE b.vat_reporting_entity_id = pn_vat_reporting_entity_id
1121: and ((b.entity_type_code = 'ACCOUNTING'
1122: and

Line 1170: FROM jg_zz_vat_alloc_rules a

1166: a.allocation_rule_id,
1167: a.tax_box_recoverable,
1168: a.tax_box_non_recoverable,
1169: nvl(a.taxable_box_recoverable, a.taxable_box_non_recoverable)
1170: FROM jg_zz_vat_alloc_rules a
1171: ,jg_zz_vat_rep_entities b
1172: WHERE b.vat_reporting_entity_id = cp_vat_reporting_entity_id
1173: AND ((b.entity_type_code = 'ACCOUNTING'
1174: and

Line 1207: FROM jg_zz_vat_alloc_rules a

1203: cp_allocation_rule_id NUMBER
1204: ) IS
1205: SELECT
1206: min(a.allocation_rule_id) - 1
1207: FROM jg_zz_vat_alloc_rules a
1208: ,jg_zz_vat_rep_entities b
1209: WHERE b.vat_reporting_entity_id = cp_vat_reporting_entity_id
1210: AND ((b.entity_type_code = 'ACCOUNTING'
1211: and