12: SUBTYPE ae_rule_rec_type IS ARP_ACCT_MAIN.ae_app_rule_rec_type;
13:
14: TYPE get_recon_rec_type IS RECORD
15: (
16: source_type AR_DISTRIBUTIONS.source_type%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
13:
14: TYPE get_recon_rec_type IS RECORD
15: (
16: source_type AR_DISTRIBUTIONS.source_type%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
14: TYPE get_recon_rec_type IS RECORD
15: (
16: source_type AR_DISTRIBUTIONS.source_type%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
15: (
16: source_type AR_DISTRIBUTIONS.source_type%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
16: source_type AR_DISTRIBUTIONS.source_type%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
20: currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
24: third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
27: amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
35:
28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
35:
36:
29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
35:
36:
37: /*========================================================================
30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31: location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
35:
36:
37: /*========================================================================
38: | PUBLIC PROCEDURE Reconcile_BR_Tax