6: PROCEDURE INSERT_ADJUST_COVER(
7: p_form_name IN varchar2,
8: p_form_version IN number,
9: p_acctd_amount IN
10: ar_adjustments.acctd_amount%type,
11: p_adjustment_id IN
12: ar_adjustments.adjustment_id%type,
13: p_adjustment_number IN
14: ar_adjustments.adjustment_number%type,
8: p_form_version IN number,
9: p_acctd_amount IN
10: ar_adjustments.acctd_amount%type,
11: p_adjustment_id IN
12: ar_adjustments.adjustment_id%type,
13: p_adjustment_number IN
14: ar_adjustments.adjustment_number%type,
15: p_adjustment_type IN
16: ar_adjustments.adjustment_type%type,
10: ar_adjustments.acctd_amount%type,
11: p_adjustment_id IN
12: ar_adjustments.adjustment_id%type,
13: p_adjustment_number IN
14: ar_adjustments.adjustment_number%type,
15: p_adjustment_type IN
16: ar_adjustments.adjustment_type%type,
17: p_amount IN
18: ar_adjustments.amount%type,
12: ar_adjustments.adjustment_id%type,
13: p_adjustment_number IN
14: ar_adjustments.adjustment_number%type,
15: p_adjustment_type IN
16: ar_adjustments.adjustment_type%type,
17: p_amount IN
18: ar_adjustments.amount%type,
19: p_apply_date IN
20: ar_adjustments.apply_date%type,
14: ar_adjustments.adjustment_number%type,
15: p_adjustment_type IN
16: ar_adjustments.adjustment_type%type,
17: p_amount IN
18: ar_adjustments.amount%type,
19: p_apply_date IN
20: ar_adjustments.apply_date%type,
21: p_approved_by IN
22: ar_adjustments.approved_by%type,
16: ar_adjustments.adjustment_type%type,
17: p_amount IN
18: ar_adjustments.amount%type,
19: p_apply_date IN
20: ar_adjustments.apply_date%type,
21: p_approved_by IN
22: ar_adjustments.approved_by%type,
23: p_associated_application_id IN
24: ar_adjustments.associated_application_id%type,
18: ar_adjustments.amount%type,
19: p_apply_date IN
20: ar_adjustments.apply_date%type,
21: p_approved_by IN
22: ar_adjustments.approved_by%type,
23: p_associated_application_id IN
24: ar_adjustments.associated_application_id%type,
25: p_associated_cash_receipt_id IN
26: ar_adjustments.associated_cash_receipt_id%type,
20: ar_adjustments.apply_date%type,
21: p_approved_by IN
22: ar_adjustments.approved_by%type,
23: p_associated_application_id IN
24: ar_adjustments.associated_application_id%type,
25: p_associated_cash_receipt_id IN
26: ar_adjustments.associated_cash_receipt_id%type,
27: p_attribute1 IN
28: ar_adjustments.attribute1%type,
22: ar_adjustments.approved_by%type,
23: p_associated_application_id IN
24: ar_adjustments.associated_application_id%type,
25: p_associated_cash_receipt_id IN
26: ar_adjustments.associated_cash_receipt_id%type,
27: p_attribute1 IN
28: ar_adjustments.attribute1%type,
29: p_attribute10 IN
30: ar_adjustments.attribute10%type,
24: ar_adjustments.associated_application_id%type,
25: p_associated_cash_receipt_id IN
26: ar_adjustments.associated_cash_receipt_id%type,
27: p_attribute1 IN
28: ar_adjustments.attribute1%type,
29: p_attribute10 IN
30: ar_adjustments.attribute10%type,
31: p_attribute11 IN
32: ar_adjustments.attribute11%type,
26: ar_adjustments.associated_cash_receipt_id%type,
27: p_attribute1 IN
28: ar_adjustments.attribute1%type,
29: p_attribute10 IN
30: ar_adjustments.attribute10%type,
31: p_attribute11 IN
32: ar_adjustments.attribute11%type,
33: p_attribute12 IN
34: ar_adjustments.attribute12%type,
28: ar_adjustments.attribute1%type,
29: p_attribute10 IN
30: ar_adjustments.attribute10%type,
31: p_attribute11 IN
32: ar_adjustments.attribute11%type,
33: p_attribute12 IN
34: ar_adjustments.attribute12%type,
35: p_attribute13 IN
36: ar_adjustments.attribute13%type,
30: ar_adjustments.attribute10%type,
31: p_attribute11 IN
32: ar_adjustments.attribute11%type,
33: p_attribute12 IN
34: ar_adjustments.attribute12%type,
35: p_attribute13 IN
36: ar_adjustments.attribute13%type,
37: p_attribute14 IN
38: ar_adjustments.attribute14%type,
32: ar_adjustments.attribute11%type,
33: p_attribute12 IN
34: ar_adjustments.attribute12%type,
35: p_attribute13 IN
36: ar_adjustments.attribute13%type,
37: p_attribute14 IN
38: ar_adjustments.attribute14%type,
39: p_attribute15 IN
40: ar_adjustments.attribute15%type,
34: ar_adjustments.attribute12%type,
35: p_attribute13 IN
36: ar_adjustments.attribute13%type,
37: p_attribute14 IN
38: ar_adjustments.attribute14%type,
39: p_attribute15 IN
40: ar_adjustments.attribute15%type,
41: p_attribute2 IN
42: ar_adjustments.attribute2%type,
36: ar_adjustments.attribute13%type,
37: p_attribute14 IN
38: ar_adjustments.attribute14%type,
39: p_attribute15 IN
40: ar_adjustments.attribute15%type,
41: p_attribute2 IN
42: ar_adjustments.attribute2%type,
43: p_attribute3 IN
44: ar_adjustments.attribute3%type,
38: ar_adjustments.attribute14%type,
39: p_attribute15 IN
40: ar_adjustments.attribute15%type,
41: p_attribute2 IN
42: ar_adjustments.attribute2%type,
43: p_attribute3 IN
44: ar_adjustments.attribute3%type,
45: p_attribute4 IN
46: ar_adjustments.attribute4%type,
40: ar_adjustments.attribute15%type,
41: p_attribute2 IN
42: ar_adjustments.attribute2%type,
43: p_attribute3 IN
44: ar_adjustments.attribute3%type,
45: p_attribute4 IN
46: ar_adjustments.attribute4%type,
47: p_attribute5 IN
48: ar_adjustments.attribute5%type,
42: ar_adjustments.attribute2%type,
43: p_attribute3 IN
44: ar_adjustments.attribute3%type,
45: p_attribute4 IN
46: ar_adjustments.attribute4%type,
47: p_attribute5 IN
48: ar_adjustments.attribute5%type,
49: p_attribute6 IN
50: ar_adjustments.attribute6%type,
44: ar_adjustments.attribute3%type,
45: p_attribute4 IN
46: ar_adjustments.attribute4%type,
47: p_attribute5 IN
48: ar_adjustments.attribute5%type,
49: p_attribute6 IN
50: ar_adjustments.attribute6%type,
51: p_attribute7 IN
52: ar_adjustments.attribute7%type,
46: ar_adjustments.attribute4%type,
47: p_attribute5 IN
48: ar_adjustments.attribute5%type,
49: p_attribute6 IN
50: ar_adjustments.attribute6%type,
51: p_attribute7 IN
52: ar_adjustments.attribute7%type,
53: p_attribute8 IN
54: ar_adjustments.attribute8%type,
48: ar_adjustments.attribute5%type,
49: p_attribute6 IN
50: ar_adjustments.attribute6%type,
51: p_attribute7 IN
52: ar_adjustments.attribute7%type,
53: p_attribute8 IN
54: ar_adjustments.attribute8%type,
55: p_attribute9 IN
56: ar_adjustments.attribute9%type,
50: ar_adjustments.attribute6%type,
51: p_attribute7 IN
52: ar_adjustments.attribute7%type,
53: p_attribute8 IN
54: ar_adjustments.attribute8%type,
55: p_attribute9 IN
56: ar_adjustments.attribute9%type,
57: p_attribute_category IN
58: ar_adjustments.attribute_category%type,
52: ar_adjustments.attribute7%type,
53: p_attribute8 IN
54: ar_adjustments.attribute8%type,
55: p_attribute9 IN
56: ar_adjustments.attribute9%type,
57: p_attribute_category IN
58: ar_adjustments.attribute_category%type,
59: p_automatically_generated IN
60: ar_adjustments.automatically_generated%type,
54: ar_adjustments.attribute8%type,
55: p_attribute9 IN
56: ar_adjustments.attribute9%type,
57: p_attribute_category IN
58: ar_adjustments.attribute_category%type,
59: p_automatically_generated IN
60: ar_adjustments.automatically_generated%type,
61: p_batch_id IN
62: ar_adjustments.batch_id%type,
56: ar_adjustments.attribute9%type,
57: p_attribute_category IN
58: ar_adjustments.attribute_category%type,
59: p_automatically_generated IN
60: ar_adjustments.automatically_generated%type,
61: p_batch_id IN
62: ar_adjustments.batch_id%type,
63: p_chargeback_customer_trx_id IN
64: ar_adjustments.chargeback_customer_trx_id%type,
58: ar_adjustments.attribute_category%type,
59: p_automatically_generated IN
60: ar_adjustments.automatically_generated%type,
61: p_batch_id IN
62: ar_adjustments.batch_id%type,
63: p_chargeback_customer_trx_id IN
64: ar_adjustments.chargeback_customer_trx_id%type,
65: p_code_combination_id IN
66: ar_adjustments.code_combination_id%type,
60: ar_adjustments.automatically_generated%type,
61: p_batch_id IN
62: ar_adjustments.batch_id%type,
63: p_chargeback_customer_trx_id IN
64: ar_adjustments.chargeback_customer_trx_id%type,
65: p_code_combination_id IN
66: ar_adjustments.code_combination_id%type,
67: p_comments IN
68: ar_adjustments.comments%type,
62: ar_adjustments.batch_id%type,
63: p_chargeback_customer_trx_id IN
64: ar_adjustments.chargeback_customer_trx_id%type,
65: p_code_combination_id IN
66: ar_adjustments.code_combination_id%type,
67: p_comments IN
68: ar_adjustments.comments%type,
69: p_created_by IN
70: ar_adjustments.created_by%type,
64: ar_adjustments.chargeback_customer_trx_id%type,
65: p_code_combination_id IN
66: ar_adjustments.code_combination_id%type,
67: p_comments IN
68: ar_adjustments.comments%type,
69: p_created_by IN
70: ar_adjustments.created_by%type,
71: p_created_from IN
72: ar_adjustments.created_from%type,
66: ar_adjustments.code_combination_id%type,
67: p_comments IN
68: ar_adjustments.comments%type,
69: p_created_by IN
70: ar_adjustments.created_by%type,
71: p_created_from IN
72: ar_adjustments.created_from%type,
73: p_creation_date IN
74: ar_adjustments.creation_date%type,
68: ar_adjustments.comments%type,
69: p_created_by IN
70: ar_adjustments.created_by%type,
71: p_created_from IN
72: ar_adjustments.created_from%type,
73: p_creation_date IN
74: ar_adjustments.creation_date%type,
75: p_customer_trx_id IN
76: ar_adjustments.customer_trx_id%type,
70: ar_adjustments.created_by%type,
71: p_created_from IN
72: ar_adjustments.created_from%type,
73: p_creation_date IN
74: ar_adjustments.creation_date%type,
75: p_customer_trx_id IN
76: ar_adjustments.customer_trx_id%type,
77: p_customer_trx_line_id IN
78: ar_adjustments.customer_trx_line_id%type,
72: ar_adjustments.created_from%type,
73: p_creation_date IN
74: ar_adjustments.creation_date%type,
75: p_customer_trx_id IN
76: ar_adjustments.customer_trx_id%type,
77: p_customer_trx_line_id IN
78: ar_adjustments.customer_trx_line_id%type,
79: p_distribution_set_id IN
80: ar_adjustments.distribution_set_id%type,
74: ar_adjustments.creation_date%type,
75: p_customer_trx_id IN
76: ar_adjustments.customer_trx_id%type,
77: p_customer_trx_line_id IN
78: ar_adjustments.customer_trx_line_id%type,
79: p_distribution_set_id IN
80: ar_adjustments.distribution_set_id%type,
81: p_doc_sequence_id IN
82: ar_adjustments.doc_sequence_id%type,
76: ar_adjustments.customer_trx_id%type,
77: p_customer_trx_line_id IN
78: ar_adjustments.customer_trx_line_id%type,
79: p_distribution_set_id IN
80: ar_adjustments.distribution_set_id%type,
81: p_doc_sequence_id IN
82: ar_adjustments.doc_sequence_id%type,
83: p_doc_sequence_value IN
84: ar_adjustments.doc_sequence_value%type,
78: ar_adjustments.customer_trx_line_id%type,
79: p_distribution_set_id IN
80: ar_adjustments.distribution_set_id%type,
81: p_doc_sequence_id IN
82: ar_adjustments.doc_sequence_id%type,
83: p_doc_sequence_value IN
84: ar_adjustments.doc_sequence_value%type,
85: p_freight_adjusted IN
86: ar_adjustments.freight_adjusted%type,
80: ar_adjustments.distribution_set_id%type,
81: p_doc_sequence_id IN
82: ar_adjustments.doc_sequence_id%type,
83: p_doc_sequence_value IN
84: ar_adjustments.doc_sequence_value%type,
85: p_freight_adjusted IN
86: ar_adjustments.freight_adjusted%type,
87: p_gl_date IN
88: ar_adjustments.gl_date%type,
82: ar_adjustments.doc_sequence_id%type,
83: p_doc_sequence_value IN
84: ar_adjustments.doc_sequence_value%type,
85: p_freight_adjusted IN
86: ar_adjustments.freight_adjusted%type,
87: p_gl_date IN
88: ar_adjustments.gl_date%type,
89: p_gl_posted_date IN
90: ar_adjustments.gl_posted_date%type,
84: ar_adjustments.doc_sequence_value%type,
85: p_freight_adjusted IN
86: ar_adjustments.freight_adjusted%type,
87: p_gl_date IN
88: ar_adjustments.gl_date%type,
89: p_gl_posted_date IN
90: ar_adjustments.gl_posted_date%type,
91: p_last_updated_by IN
92: ar_adjustments.last_updated_by%type,
86: ar_adjustments.freight_adjusted%type,
87: p_gl_date IN
88: ar_adjustments.gl_date%type,
89: p_gl_posted_date IN
90: ar_adjustments.gl_posted_date%type,
91: p_last_updated_by IN
92: ar_adjustments.last_updated_by%type,
93: p_last_update_date IN
94: ar_adjustments.last_update_date%type,
88: ar_adjustments.gl_date%type,
89: p_gl_posted_date IN
90: ar_adjustments.gl_posted_date%type,
91: p_last_updated_by IN
92: ar_adjustments.last_updated_by%type,
93: p_last_update_date IN
94: ar_adjustments.last_update_date%type,
95: p_last_update_login IN
96: ar_adjustments.last_update_login%type,
90: ar_adjustments.gl_posted_date%type,
91: p_last_updated_by IN
92: ar_adjustments.last_updated_by%type,
93: p_last_update_date IN
94: ar_adjustments.last_update_date%type,
95: p_last_update_login IN
96: ar_adjustments.last_update_login%type,
97: p_line_adjusted IN
98: ar_adjustments.line_adjusted%type,
92: ar_adjustments.last_updated_by%type,
93: p_last_update_date IN
94: ar_adjustments.last_update_date%type,
95: p_last_update_login IN
96: ar_adjustments.last_update_login%type,
97: p_line_adjusted IN
98: ar_adjustments.line_adjusted%type,
99: p_org_id IN
100: ar_adjustments.org_id%type,
94: ar_adjustments.last_update_date%type,
95: p_last_update_login IN
96: ar_adjustments.last_update_login%type,
97: p_line_adjusted IN
98: ar_adjustments.line_adjusted%type,
99: p_org_id IN
100: ar_adjustments.org_id%type,
101: p_payment_schedule_id IN
102: ar_adjustments.payment_schedule_id%type,
96: ar_adjustments.last_update_login%type,
97: p_line_adjusted IN
98: ar_adjustments.line_adjusted%type,
99: p_org_id IN
100: ar_adjustments.org_id%type,
101: p_payment_schedule_id IN
102: ar_adjustments.payment_schedule_id%type,
103: p_postable IN
104: ar_adjustments.postable%type,
98: ar_adjustments.line_adjusted%type,
99: p_org_id IN
100: ar_adjustments.org_id%type,
101: p_payment_schedule_id IN
102: ar_adjustments.payment_schedule_id%type,
103: p_postable IN
104: ar_adjustments.postable%type,
105: p_posting_control_id IN
106: ar_adjustments.posting_control_id%type,
100: ar_adjustments.org_id%type,
101: p_payment_schedule_id IN
102: ar_adjustments.payment_schedule_id%type,
103: p_postable IN
104: ar_adjustments.postable%type,
105: p_posting_control_id IN
106: ar_adjustments.posting_control_id%type,
107: p_program_application_id IN
108: ar_adjustments.program_application_id%type,
102: ar_adjustments.payment_schedule_id%type,
103: p_postable IN
104: ar_adjustments.postable%type,
105: p_posting_control_id IN
106: ar_adjustments.posting_control_id%type,
107: p_program_application_id IN
108: ar_adjustments.program_application_id%type,
109: p_program_id IN
110: ar_adjustments.program_id%type,
104: ar_adjustments.postable%type,
105: p_posting_control_id IN
106: ar_adjustments.posting_control_id%type,
107: p_program_application_id IN
108: ar_adjustments.program_application_id%type,
109: p_program_id IN
110: ar_adjustments.program_id%type,
111: p_program_update_date IN
112: ar_adjustments.program_update_date%type,
106: ar_adjustments.posting_control_id%type,
107: p_program_application_id IN
108: ar_adjustments.program_application_id%type,
109: p_program_id IN
110: ar_adjustments.program_id%type,
111: p_program_update_date IN
112: ar_adjustments.program_update_date%type,
113: p_reason_code IN
114: ar_adjustments.reason_code%type,
108: ar_adjustments.program_application_id%type,
109: p_program_id IN
110: ar_adjustments.program_id%type,
111: p_program_update_date IN
112: ar_adjustments.program_update_date%type,
113: p_reason_code IN
114: ar_adjustments.reason_code%type,
115: p_receivables_charges_adjusted IN
116: ar_adjustments.receivables_charges_adjusted%type,
110: ar_adjustments.program_id%type,
111: p_program_update_date IN
112: ar_adjustments.program_update_date%type,
113: p_reason_code IN
114: ar_adjustments.reason_code%type,
115: p_receivables_charges_adjusted IN
116: ar_adjustments.receivables_charges_adjusted%type,
117: p_receivables_trx_id IN
118: ar_adjustments.receivables_trx_id%type,
112: ar_adjustments.program_update_date%type,
113: p_reason_code IN
114: ar_adjustments.reason_code%type,
115: p_receivables_charges_adjusted IN
116: ar_adjustments.receivables_charges_adjusted%type,
117: p_receivables_trx_id IN
118: ar_adjustments.receivables_trx_id%type,
119: p_request_id IN
120: ar_adjustments.request_id%type,
114: ar_adjustments.reason_code%type,
115: p_receivables_charges_adjusted IN
116: ar_adjustments.receivables_charges_adjusted%type,
117: p_receivables_trx_id IN
118: ar_adjustments.receivables_trx_id%type,
119: p_request_id IN
120: ar_adjustments.request_id%type,
121: p_set_of_books_id IN
122: ar_adjustments.set_of_books_id%type,
116: ar_adjustments.receivables_charges_adjusted%type,
117: p_receivables_trx_id IN
118: ar_adjustments.receivables_trx_id%type,
119: p_request_id IN
120: ar_adjustments.request_id%type,
121: p_set_of_books_id IN
122: ar_adjustments.set_of_books_id%type,
123: p_status IN
124: ar_adjustments.status%type,
118: ar_adjustments.receivables_trx_id%type,
119: p_request_id IN
120: ar_adjustments.request_id%type,
121: p_set_of_books_id IN
122: ar_adjustments.set_of_books_id%type,
123: p_status IN
124: ar_adjustments.status%type,
125: p_subsequent_trx_id IN
126: ar_adjustments.subsequent_trx_id%type,
120: ar_adjustments.request_id%type,
121: p_set_of_books_id IN
122: ar_adjustments.set_of_books_id%type,
123: p_status IN
124: ar_adjustments.status%type,
125: p_subsequent_trx_id IN
126: ar_adjustments.subsequent_trx_id%type,
127: p_tax_adjusted IN
128: ar_adjustments.tax_adjusted%type,
122: ar_adjustments.set_of_books_id%type,
123: p_status IN
124: ar_adjustments.status%type,
125: p_subsequent_trx_id IN
126: ar_adjustments.subsequent_trx_id%type,
127: p_tax_adjusted IN
128: ar_adjustments.tax_adjusted%type,
129: p_type IN
130: ar_adjustments.type%type,
124: ar_adjustments.status%type,
125: p_subsequent_trx_id IN
126: ar_adjustments.subsequent_trx_id%type,
127: p_tax_adjusted IN
128: ar_adjustments.tax_adjusted%type,
129: p_type IN
130: ar_adjustments.type%type,
131: p_ussgl_transaction_code IN
132: ar_adjustments.ussgl_transaction_code%type,
126: ar_adjustments.subsequent_trx_id%type,
127: p_tax_adjusted IN
128: ar_adjustments.tax_adjusted%type,
129: p_type IN
130: ar_adjustments.type%type,
131: p_ussgl_transaction_code IN
132: ar_adjustments.ussgl_transaction_code%type,
133: p_ussgl_transaction_code_conte IN
134: ar_adjustments.ussgl_transaction_code_context%type,
128: ar_adjustments.tax_adjusted%type,
129: p_type IN
130: ar_adjustments.type%type,
131: p_ussgl_transaction_code IN
132: ar_adjustments.ussgl_transaction_code%type,
133: p_ussgl_transaction_code_conte IN
134: ar_adjustments.ussgl_transaction_code_context%type,
135: p_override_flag IN
136: varchar2 DEFAULT NULL,
130: ar_adjustments.type%type,
131: p_ussgl_transaction_code IN
132: ar_adjustments.ussgl_transaction_code%type,
133: p_ussgl_transaction_code_conte IN
134: ar_adjustments.ussgl_transaction_code_context%type,
135: p_override_flag IN
136: varchar2 DEFAULT NULL,
137: p_adjustment_number_o OUT NOCOPY
138: ar_adjustments.adjustment_number%type,
134: ar_adjustments.ussgl_transaction_code_context%type,
135: p_override_flag IN
136: varchar2 DEFAULT NULL,
137: p_adjustment_number_o OUT NOCOPY
138: ar_adjustments.adjustment_number%type,
139: p_adjustment_id_o OUT NOCOPY
140: ar_adjustments.adjustment_id%type,
141: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION')
142: IS
136: varchar2 DEFAULT NULL,
137: p_adjustment_number_o OUT NOCOPY
138: ar_adjustments.adjustment_number%type,
139: p_adjustment_id_o OUT NOCOPY
140: ar_adjustments.adjustment_id%type,
141: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION')
142: IS
143: l_adj_rec ar_adjustments%rowtype ;
144: l_app_level VARCHAR2(30) := 'TRANSACTION';
139: p_adjustment_id_o OUT NOCOPY
140: ar_adjustments.adjustment_id%type,
141: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION')
142: IS
143: l_adj_rec ar_adjustments%rowtype ;
144: l_app_level VARCHAR2(30) := 'TRANSACTION';
145:
146: BEGIN
147: