DBA Data[Home] [Help]

APPS.ARP_RECONCILE dependencies on AR_DISTRIBUTIONS

Line 16: source_type AR_DISTRIBUTIONS.source_type%TYPE,

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,

Line 17: source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%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,

Line 18: source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%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,

Line 19: source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%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,

Line 20: currency_code AR_DISTRIBUTIONS.currency_code%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,

Line 21: currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%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,

Line 22: currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%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,

Line 23: currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%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,

Line 24: third_party_id AR_DISTRIBUTIONS.third_party_id%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,

Line 25: third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%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,

Line 26: reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%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,

Line 27: amount AR_DISTRIBUTIONS.amount_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,

Line 28: acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%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,

Line 29: taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%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,

Line 30: taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%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);

Line 31: location_segment_id AR_DISTRIBUTIONS.location_segment_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:

Line 32: tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%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:
36:

Line 33: tax_code_id AR_DISTRIBUTIONS.tax_code_id%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:
37: /*========================================================================

Line 34: code_combination_id AR_DISTRIBUTIONS.code_combination_id%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: /*========================================================================
38: | PUBLIC PROCEDURE Reconcile_BR_Tax