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
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:
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: --
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,