78: PROCEDURE delete_dist_cover(
79: p_form_name IN varchar2,
80: p_form_version IN number,
81: p_cust_trx_line_gl_dist_id IN
82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
80: p_form_version IN number,
81: p_cust_trx_line_gl_dist_id IN
82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
82: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
83: p_customer_trx_id IN
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
84: ra_cust_trx_line_gl_dist.customer_trx_id%type,
85: p_customer_trx_line_id IN
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
86: ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
87: p_cust_trx_line_salesrep_id IN
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
88: ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
89: p_account_class IN
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
90: ra_cust_trx_line_gl_dist.account_class%type,
91: p_percent IN
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
92: ra_cust_trx_line_gl_dist.percent%type,
93: p_amount IN
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
94: ra_cust_trx_line_gl_dist.amount%type,
95: p_gl_date IN
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
96: ra_cust_trx_line_gl_dist.gl_date%type,
97: p_original_gl_date IN
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
98: ra_cust_trx_line_gl_dist.original_gl_date%type,
99: p_gl_posted_date IN
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
100: ra_cust_trx_line_gl_dist.gl_posted_date%type,
101: p_code_combination_id IN
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
102: ra_cust_trx_line_gl_dist.code_combination_id%type,
103: p_concatenated_segments IN
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
104: ra_cust_trx_line_gl_dist.concatenated_segments%type,
105: p_collected_tax_ccid IN
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
106: ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
107: p_collected_tax_concat_seg IN
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
108: ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
109: p_comments IN
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
110: ra_cust_trx_line_gl_dist.comments%type,
111: p_account_set_flag IN
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
112: ra_cust_trx_line_gl_dist.account_set_flag%type,
113: p_latest_rec_flag IN
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
114: ra_cust_trx_line_gl_dist.latest_rec_flag%type,
115: p_ussgl_transaction_code IN
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
116: ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
117: p_ussgl_trx_code_context IN
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
118: ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
119: p_attribute_category IN
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
120: ra_cust_trx_line_gl_dist.attribute_category%type,
121: p_attribute1 IN
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
122: ra_cust_trx_line_gl_dist.attribute1%type,
123: p_attribute2 IN
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
124: ra_cust_trx_line_gl_dist.attribute2%type,
125: p_attribute3 IN
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
126: ra_cust_trx_line_gl_dist.attribute3%type,
127: p_attribute4 IN
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
128: ra_cust_trx_line_gl_dist.attribute4%type,
129: p_attribute5 IN
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
130: ra_cust_trx_line_gl_dist.attribute5%type,
131: p_attribute6 IN
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
132: ra_cust_trx_line_gl_dist.attribute6%type,
133: p_attribute7 IN
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
134: ra_cust_trx_line_gl_dist.attribute7%type,
135: p_attribute8 IN
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
136: ra_cust_trx_line_gl_dist.attribute8%type,
137: p_attribute9 IN
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
138: ra_cust_trx_line_gl_dist.attribute9%type,
139: p_attribute10 IN
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
140: ra_cust_trx_line_gl_dist.attribute10%type,
141: p_attribute11 IN
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
142: ra_cust_trx_line_gl_dist.attribute11%type,
143: p_attribute12 IN
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
144: ra_cust_trx_line_gl_dist.attribute12%type,
145: p_attribute13 IN
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
146: ra_cust_trx_line_gl_dist.attribute13%type,
147: p_attribute14 IN
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:
148: ra_cust_trx_line_gl_dist.attribute14%type,
149: p_attribute15 IN
150: ra_cust_trx_line_gl_dist.attribute15%type,
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:
155: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
156:
151: p_posting_control_id IN
152: ra_cust_trx_line_gl_dist.posting_control_id%type )
153: IS
154:
155: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
156:
157: BEGIN
158:
159: IF PG_DEBUG in ('Y', 'C') THEN