DBA Data[Home] [Help]

APPS.ARP_ACCT_MAIN dependencies on AR_DISTRIBUTIONS

Line 15: source_table ar_distributions.source_table%TYPE, -- E.g. RA(ar_receivable_applications)

11: TYPE ae_doc_rec_type IS RECORD (
12: document_type varchar2(30) , -- E.g. INVOICE, RECEIPT, ADJUSTMENT
13: document_id number , -- E.g. Invoice Id, Receipt Id
14: accounting_entity_level varchar2(30) , -- ALL or ONE entity.
15: source_table ar_distributions.source_table%TYPE, -- E.g. RA(ar_receivable_applications)
16: source_id NUMBER , -- E.g. receivable_application_id
17: source_id_old NUMBER , -- E.g. Old receivable_application_id
18: -- for Reversals or source_id_secondary
19: -- UNAPP, and override of ccid for adjustments

Line 44: override_source_type ar_distributions.source_type%TYPE ,

40: pay_sched_upd_yn VARCHAR2(1), --A "Y" indicates that the payment schedule has been updated
41: --before the call to the accounting engine
42: pay_sched_upd_cm_yn VARCHAR2(1), --A "Y" indicates that the payment schedule has been updated
43: --before the call to the accounting engine
44: override_source_type ar_distributions.source_type%TYPE ,
45: gl_tax_acct ar_distributions.code_combination_id%TYPE, /* Bug fix 2300268 */
46: inv_cm_app_mode VARCHAR2(1)
47: );
48:

Line 45: gl_tax_acct ar_distributions.code_combination_id%TYPE, /* Bug fix 2300268 */

41: --before the call to the accounting engine
42: pay_sched_upd_cm_yn VARCHAR2(1), --A "Y" indicates that the payment schedule has been updated
43: --before the call to the accounting engine
44: override_source_type ar_distributions.source_type%TYPE ,
45: gl_tax_acct ar_distributions.code_combination_id%TYPE, /* Bug fix 2300268 */
46: inv_cm_app_mode VARCHAR2(1)
47: );
48:
49: --

Line 79: ae_line_type ar_distributions.source_type%TYPE,

75: --
76:
77: TYPE ae_line_rec_type IS RECORD
78: (
79: ae_line_type ar_distributions.source_type%TYPE,
80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,
81: source_id ar_distributions.source_id%TYPE,
82: source_table ar_distributions.source_table%TYPE,
83: account ar_distributions.code_combination_id%TYPE,

Line 80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,

76:
77: TYPE ae_line_rec_type IS RECORD
78: (
79: ae_line_type ar_distributions.source_type%TYPE,
80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,
81: source_id ar_distributions.source_id%TYPE,
82: source_table ar_distributions.source_table%TYPE,
83: account ar_distributions.code_combination_id%TYPE,
84: entered_dr NUMBER,

Line 81: source_id ar_distributions.source_id%TYPE,

77: TYPE ae_line_rec_type IS RECORD
78: (
79: ae_line_type ar_distributions.source_type%TYPE,
80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,
81: source_id ar_distributions.source_id%TYPE,
82: source_table ar_distributions.source_table%TYPE,
83: account ar_distributions.code_combination_id%TYPE,
84: entered_dr NUMBER,
85: entered_cr NUMBER,

Line 82: source_table ar_distributions.source_table%TYPE,

78: (
79: ae_line_type ar_distributions.source_type%TYPE,
80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,
81: source_id ar_distributions.source_id%TYPE,
82: source_table ar_distributions.source_table%TYPE,
83: account ar_distributions.code_combination_id%TYPE,
84: entered_dr NUMBER,
85: entered_cr NUMBER,
86: accounted_dr NUMBER,

Line 83: account ar_distributions.code_combination_id%TYPE,

79: ae_line_type ar_distributions.source_type%TYPE,
80: ae_line_type_secondary ar_distributions.source_type_secondary%TYPE,
81: source_id ar_distributions.source_id%TYPE,
82: source_table ar_distributions.source_table%TYPE,
83: account ar_distributions.code_combination_id%TYPE,
84: entered_dr NUMBER,
85: entered_cr NUMBER,
86: accounted_dr NUMBER,
87: accounted_cr NUMBER,

Line 88: source_id_secondary ar_distributions.source_id_secondary%TYPE,

84: entered_dr NUMBER,
85: entered_cr NUMBER,
86: accounted_dr NUMBER,
87: accounted_cr NUMBER,
88: source_id_secondary ar_distributions.source_id_secondary%TYPE,
89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,

Line 89: source_table_secondary ar_distributions.source_table_secondary%TYPE,

85: entered_cr NUMBER,
86: accounted_dr NUMBER,
87: accounted_cr NUMBER,
88: source_id_secondary ar_distributions.source_id_secondary%TYPE,
89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,

Line 90: currency_code ar_distributions.currency_code%TYPE,

86: accounted_dr NUMBER,
87: accounted_cr NUMBER,
88: source_id_secondary ar_distributions.source_id_secondary%TYPE,
89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,

Line 91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,

87: accounted_cr NUMBER,
88: source_id_secondary ar_distributions.source_id_secondary%TYPE,
89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,

Line 92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,

88: source_id_secondary ar_distributions.source_id_secondary%TYPE,
89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,

Line 93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,

89: source_table_secondary ar_distributions.source_table_secondary%TYPE,
90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,

Line 94: third_party_id ar_distributions.third_party_id%TYPE,

90: currency_code ar_distributions.currency_code%TYPE,
91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,
98: location_segment_id ar_distributions.location_segment_id%TYPE,

Line 95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,

91: currency_conversion_rate ar_distributions.currency_conversion_rate%TYPE,
92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,
98: location_segment_id ar_distributions.location_segment_id%TYPE,
99: taxable_entered_dr NUMBER,

Line 96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,

92: currency_conversion_type ar_distributions.currency_conversion_type%TYPE,
93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,
98: location_segment_id ar_distributions.location_segment_id%TYPE,
99: taxable_entered_dr NUMBER,
100: taxable_entered_cr NUMBER,

Line 97: tax_code_id ar_distributions.tax_code_id%TYPE,

93: currency_conversion_date ar_distributions.currency_conversion_date%TYPE,
94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,
98: location_segment_id ar_distributions.location_segment_id%TYPE,
99: taxable_entered_dr NUMBER,
100: taxable_entered_cr NUMBER,
101: taxable_accounted_dr NUMBER,

Line 98: location_segment_id ar_distributions.location_segment_id%TYPE,

94: third_party_id ar_distributions.third_party_id%TYPE,
95: third_party_sub_id ar_distributions.third_party_sub_id%TYPE,
96: tax_group_code_id ar_distributions.tax_group_code_id%TYPE,
97: tax_code_id ar_distributions.tax_code_id%TYPE,
98: location_segment_id ar_distributions.location_segment_id%TYPE,
99: taxable_entered_dr NUMBER,
100: taxable_entered_cr NUMBER,
101: taxable_accounted_dr NUMBER,
102: taxable_accounted_cr NUMBER,

Line 103: tax_link_id ar_distributions.tax_link_id%TYPE,

99: taxable_entered_dr NUMBER,
100: taxable_entered_cr NUMBER,
101: taxable_accounted_dr NUMBER,
102: taxable_accounted_cr NUMBER,
103: tax_link_id ar_distributions.tax_link_id%TYPE,
104: applied_from_doc_table VARCHAR2(30),
105: applied_from_doc_id NUMBER,
106: applied_to_doc_table VARCHAR2(30),
107: applied_to_doc_id NUMBER,

Line 108: reversed_source_id ar_distributions.reversed_source_id%TYPE,

104: applied_from_doc_table VARCHAR2(30),
105: applied_from_doc_id NUMBER,
106: applied_to_doc_table VARCHAR2(30),
107: applied_to_doc_id NUMBER,
108: reversed_source_id ar_distributions.reversed_source_id%TYPE,
109: summarize_flag VARCHAR2(1),
110: ae_neg_ind NUMBER,
111: --{BUG#2979254
112: ref_customer_trx_line_id NUMBER,