eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_MISC_CASH_DIST dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 13: TYPE mcd_tbl_type IS TABLE of ar_misc_cash_distributions%ROWTYPE

9: TYPE ard_tbl_type IS TABLE of ar_distributions%ROWTYPE
10: INDEX BY BINARY_INTEGER;
11: ard_tbl_tbl ard_tbl_type; --for 1543658
12:
13: TYPE mcd_tbl_type IS TABLE of ar_misc_cash_distributions%ROWTYPE
14: INDEX BY BINARY_INTEGER;
15: mcd_tbl_tbl mcd_tbl_type; --for 1543658
16:
17:

Line 27: | ar_misc_cash_distributions. |

23: | delete_mcd_rec |
24: | |
25: | DESCRIPTION |
26: | Deletes a miscellaneous distribution record from |
27: | ar_misc_cash_distributions. |
28: | |
29: | SCOPE - PRIVATE |
30: | |
31: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 54: ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

50: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
51:
52: PROCEDURE delete_mcd_rec(
53: p_mcd_id IN
54: ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
55: p_form_name IN varchar2,
56: p_form_version IN varchar2
57: ) IS
58: l_ard_line_id ar_distributions.line_id%TYPE;-- for 1543658

Line 70: -- Call table handler for ar_misc_cash_distributions to delete record.

66: END IF;
67:
68: -- check if calling form is compatible with entity handler
69:
70: -- Call table handler for ar_misc_cash_distributions to delete record.
71: -- for 1543658 new block is written,
72: -- when a MCD record is deleted, the line for AR DISTRIBUTION is also
73: -- deleted, but the TAX line in AR DISTRIBUTION is untouched
74: -- we insure that line is not a TAX line by source_type ='MISCCASH'

Line 96: from ar_misc_cash_distributions

92: WHERE source_id = p_mcd_id AND
93: source_table = 'MCD' AND
94: source_type ='TAX' AND
95: source_id in (select misc_cash_distribution_id
96: from ar_misc_cash_distributions
97: where cash_receipt_id = ar_distributions.source_id_secondary
98: and reversal_gl_date is null);
99:
100: select nvl(min(source_id),0) into l_ard_tax_source_id

Line 105: from ar_misc_cash_distributions

101: FROM ar_distributions
102: WHERE source_table = 'MCD' AND
103: source_type ='MISCCASH' AND
104: source_id in (select misc_cash_distribution_id
105: from ar_misc_cash_distributions
106: where cash_receipt_id = l_ard_rec.source_id_secondary
107: and reversal_gl_date is null);
108: l_ard_rec.source_id := l_ard_tax_source_id;
109: ARP_DISTRIBUTIONS_PKG.update_p(l_ard_rec);

Line 147: | Inserts a misc cash distribution record into ar_misc_cash_distributions|

143: | PROCEDURE |
144: | insert_mcd_rec |
145: | |
146: | DESCRIPTION |
147: | Inserts a misc cash distribution record into ar_misc_cash_distributions|
148: | |
149: | SCOPE - PRIVATE |
150: | |
151: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

166: +===========================================================================*/
167:
168: PROCEDURE insert_mcd_rec(
169: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,

Line 171: p_percent IN ar_misc_cash_distributions.percent%TYPE,

167:
168: PROCEDURE insert_mcd_rec(
169: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,

Line 172: p_amount IN ar_misc_cash_distributions.amount%TYPE,

168: PROCEDURE insert_mcd_rec(
169: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

Line 173: p_comments IN ar_misc_cash_distributions.comments%TYPE,

169: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

Line 174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,

170: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

Line 175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,

171: p_percent IN ar_misc_cash_distributions.percent%TYPE,
172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

Line 176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

172: p_amount IN ar_misc_cash_distributions.amount%TYPE,
173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

Line 177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

173: p_comments IN ar_misc_cash_distributions.comments%TYPE,
174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

Line 178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

174: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

Line 179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

175: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

Line 180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

176: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

Line 181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

177: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

Line 182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

178: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

Line 183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

179: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

Line 184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

180: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

Line 185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

181: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

Line 186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

182: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

Line 187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

183: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

Line 188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

184: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,

Line 189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

185: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

Line 190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

186: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

Line 191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

187: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,

Line 192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,

188: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,
196: p_form_version IN varchar2,

Line 193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

189: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,
196: p_form_version IN varchar2,
197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658

Line 194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

190: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
191: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
192: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,
196: p_form_version IN varchar2,
197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658

Line 200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

196: p_form_version IN varchar2,
197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
199: ) IS
200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;
203: l_ard_line_id ar_distributions.line_id%TYPE;
204: l_ard_rec ar_distributions%ROWTYPE;

Line 201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
199: ) IS
200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;
203: l_ard_line_id ar_distributions.line_id%TYPE;
204: l_ard_rec ar_distributions%ROWTYPE;
205: l_ard_tax_rec ar_distributions%ROWTYPE;

Line 218: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

214: -- this cursor stores all AR Distributions lines except the one
215: -- which is processed presently
216: -- and which is not a Tax line for the present receipt
217: CURSOR cr_ard_cur
218: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
219: p_cash_receipt_id in ar_cash_receipts.cash_receipt_id%TYPE)
220: IS
221: SELECT *
222: FROM ar_distributions

Line 226: from ar_misc_cash_distributions

222: FROM ar_distributions
223: WHERE source_table = 'MCD' AND
224: source_type ='MISCCASH' and
225: source_id in (select misc_cash_distribution_id
226: from ar_misc_cash_distributions
227: where cash_receipt_id = p_cash_receipt_id and
228: misc_cash_distribution_id <> p_mcd_id
229: and reversal_gl_date is null );
230:

Line 333: FROM ar_misc_cash_distributions

329: /* Bug fix 2827019 */
330: arp_standard.debug('p_percent = '||to_char(p_percent));
331: SELECT sum(amount), sum(percent)
332: INTO l_amount_total, l_percent_total
333: FROM ar_misc_cash_distributions
334: WHERE cash_receipt_id = p_cash_receipt_id
335: AND reversal_gl_date IS NULL;
336: arp_standard.debug('l_amount_total = '||to_char(l_amount_total));
337: arp_standard.debug('l_percent_total = '||to_char(l_percent_total));

Line 382: -- Call table handler for ar_misc_cash_distributions to insert record.

378: l_mcd_rec.code_combination_id := p_code_combination_id;
379: l_mcd_rec.created_from := 'ARRERCT';
380:
381:
382: -- Call table handler for ar_misc_cash_distributions to insert record.
383:
384: arp_misc_cash_dist_pkg.insert_p(l_mcd_rec, l_mcd_id);
385:
386:

Line 480: from ar_misc_cash_distributions

476: where source_type ='TAX' and
477: source_table ='MCD' and
478: source_type_secondary = 'MISCCASH' and
479: source_id in (select misc_cash_distribution_id
480: from ar_misc_cash_distributions
481: where cash_receipt_id = l_cr_rec.cash_receipt_id
482: and reversal_gl_date is null
483: UNION
484: select 0 from dual);

Line 560: from ar_misc_cash_distributions

556: FROM ar_distributions
557: WHERE source_table = 'MCD' AND
558: source_type ='MISCCASH' and
559: source_id in (select misc_cash_distribution_id
560: from ar_misc_cash_distributions
561: where cash_receipt_id = l_cr_rec.cash_receipt_id
562: and reversal_gl_date is null );
563:
564: -- delete all AR Distribution Entery

Line 654: -- Call table handler for ar_misc_cash_distributions to insert record.

650: l_mcd_rec.code_combination_id := p_code_combination_id;
651: l_mcd_rec.created_from := 'ARRERCT';
652:
653:
654: -- Call table handler for ar_misc_cash_distributions to insert record.
655:
656: arp_misc_cash_dist_pkg.insert_p(l_mcd_rec, l_mcd_id);
657:
658: -- populate return variable:

Line 688: | updates a record in ar_misc_cash_distributions |

684: | PROCEDURE |
685: | update_mcd_rec |
686: | |
687: | DESCRIPTION |
688: | updates a record in ar_misc_cash_distributions |
689: | |
690: | SCOPE - PRIVATE |
691: | |
692: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 712: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

708: +===========================================================================*/
709:
710: PROCEDURE update_mcd_rec(
711: p_misc_cash_distribution_id
712: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
713: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,

Line 714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

710: PROCEDURE update_mcd_rec(
711: p_misc_cash_distribution_id
712: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
713: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,

Line 715: p_percent IN ar_misc_cash_distributions.percent%TYPE,

711: p_misc_cash_distribution_id
712: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
713: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,

Line 716: p_amount IN ar_misc_cash_distributions.amount%TYPE,

712: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
713: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

Line 717: p_comments IN ar_misc_cash_distributions.comments%TYPE,

713: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

Line 718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,

714: p_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

Line 719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,

715: p_percent IN ar_misc_cash_distributions.percent%TYPE,
716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

Line 720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

716: p_amount IN ar_misc_cash_distributions.amount%TYPE,
717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

Line 721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

717: p_comments IN ar_misc_cash_distributions.comments%TYPE,
718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

Line 722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

718: p_apply_date IN ar_misc_cash_distributions.apply_date%TYPE,
719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

Line 723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

719: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

Line 724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

720: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

Line 725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

721: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

Line 726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

722: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

Line 727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

723: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

Line 728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

724: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

Line 729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

725: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

Line 730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

726: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

Line 731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

727: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

Line 732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

728: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,

Line 733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

729: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

Line 734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

730: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,

Line 735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

731: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,
739: p_form_version IN varchar2,

Line 736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,

732: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,
739: p_form_version IN varchar2,
740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658

Line 737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

733: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
734: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
735: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,
739: p_form_version IN varchar2,
740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658

Line 744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
742: ) IS
743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
745: l_ard_line_id ar_distributions.line_id%TYPE;
746: l_ard_rec ar_distributions%ROWTYPE;
747: l_ard_tax_rec ar_distributions%ROWTYPE;
748: l_ard_tax_rec_flag char(1);

Line 761: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

757: -- which is processed presently
758: -- and which is not a Tax line for the present receipt
759:
760: CURSOR cr_ard_cur
761: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
762: p_cash_receipt_id in ar_cash_receipts.cash_receipt_id%TYPE)
763: IS
764: SELECT *
765: FROM ar_distributions

Line 769: from ar_misc_cash_distributions

765: FROM ar_distributions
766: WHERE source_table = 'MCD' AND
767: source_type ='MISCCASH' and
768: source_id in (select misc_cash_distribution_id
769: from ar_misc_cash_distributions
770: where cash_receipt_id = p_cash_receipt_id and
771: misc_cash_distribution_id <> p_mcd_id
772: and reversal_gl_date is null);
773:

Line 876: FROM ar_misc_cash_distributions

872:
873: /* Bug fix 2827019 */
874: SELECT sum(amount), sum(percent)
875: INTO l_amount_total, l_percent_total
876: FROM ar_misc_cash_distributions
877: WHERE cash_receipt_id = p_cash_receipt_id
878: AND reversal_gl_date IS NULL;
879:
880: SELECT amount,percent

Line 882: FROM ar_misc_cash_distributions

878: AND reversal_gl_date IS NULL;
879:
880: SELECT amount,percent
881: INTO l_amount_current, l_percent_current
882: FROM ar_misc_cash_distributions
883: WHERE misc_cash_distribution_id = p_misc_cash_distribution_id;
884:
885: arp_standard.debug('l_amount_total = '||to_char(l_amount_total));
886: arp_standard.debug('l_percent_total = '||to_char(l_percent_total));

Line 947: -- Call table handler for ar_misc_cash_distributions to update record.

943: IF PG_DEBUG in ('Y', 'C') THEN
944: arp_util.debug('MCD amount ' || TO_CHAR(l_mcd_rec.amount));
945: END IF;
946:
947: -- Call table handler for ar_misc_cash_distributions to update record.
948:
949: arp_misc_cash_dist_pkg.update_p(l_mcd_rec);
950:
951: /*-------------------------------------------------------------------------+

Line 1048: from ar_misc_cash_distributions

1044: where source_type ='TAX' and
1045: source_table ='MCD' and
1046: source_type_secondary = 'MISCCASH' and
1047: source_id in (select misc_cash_distribution_id
1048: from ar_misc_cash_distributions
1049: where cash_receipt_id = l_mcd_rec.cash_receipt_id
1050: and reversal_gl_date is null
1051: UNION
1052: select 0 from dual);

Line 1116: from ar_misc_cash_distributions

1112: FROM ar_distributions
1113: WHERE source_table = 'MCD' AND
1114: source_type ='MISCCASH' and
1115: source_id in ( select misc_cash_distribution_id
1116: from ar_misc_cash_distributions
1117: where cash_receipt_id = l_cr_rec.cash_receipt_id
1118: and reversal_gl_date is null );
1119:
1120: IF l_ard_cnt >0 THEN

Line 1221: -- Call table handler for ar_misc_cash_distributions to update record.

1217: l_mcd_rec.set_of_books_id := arp_global.set_of_books_id;
1218: l_mcd_rec.code_combination_id := p_code_combination_id;
1219: l_mcd_rec.created_from := 'ARRERCT';
1220:
1221: -- Call table handler for ar_misc_cash_distributions to update record.
1222:
1223: arp_misc_cash_dist_pkg.update_p(l_mcd_rec);
1224:
1225:

Line 1257: | locks a record in ar_misc_cash_distributions and the corresponding |

1253: | PROCEDURE |
1254: | lock_mcd_rec |
1255: | |
1256: | DESCRIPTION |
1257: | locks a record in ar_misc_cash_distributions and the corresponding |
1258: | cash receipt record. |
1259: | |
1260: | SCOPE - PRIVATE |
1261: | |

Line 1277: | ar_misc_cash_distributions table |

1273: | |
1274: | 05-OCT-95 OSTEINME created |
1275: | 09-SEP-99 GJWANG 941243: when distribution amount change, lock|
1276: | amount from ar_distributions table isntead of|
1277: | ar_misc_cash_distributions table |
1278: | 30-DEC-02 MRAMANAT Bugfix 2626083. Added code to compare |
1279: | gl_posted_date. |
1280: | |
1281: +===========================================================================*/

Line 1285: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

1281: +===========================================================================*/
1282:
1283: PROCEDURE lock_mcd_rec(
1284: p_misc_cash_distribution_id
1285: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
1286: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,

Line 1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,

1283: PROCEDURE lock_mcd_rec(
1284: p_misc_cash_distribution_id
1285: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
1286: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

Line 1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,

1284: p_misc_cash_distribution_id
1285: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
1286: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

Line 1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,

1285: IN ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
1286: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

Line 1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,

1286: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

Line 1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,

1287: p_percent IN ar_misc_cash_distributions.percent%TYPE,
1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

Line 1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,

1288: p_amount IN ar_misc_cash_distributions.amount%TYPE,
1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

Line 1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,

1289: p_comments IN ar_misc_cash_distributions.comments%TYPE,
1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

Line 1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,

1290: p_code_combination_id IN ar_misc_cash_distributions.code_combination_id%TYPE,
1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

Line 1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,

1291: p_attribute_category IN ar_misc_cash_distributions.attribute_category%TYPE,
1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

Line 1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,

1292: p_attribute1 IN ar_misc_cash_distributions.attribute1%TYPE,
1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

Line 1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,

1293: p_attribute2 IN ar_misc_cash_distributions.attribute2%TYPE,
1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

Line 1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,

1294: p_attribute3 IN ar_misc_cash_distributions.attribute3%TYPE,
1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

Line 1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,

1295: p_attribute4 IN ar_misc_cash_distributions.attribute4%TYPE,
1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

Line 1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,

1296: p_attribute5 IN ar_misc_cash_distributions.attribute5%TYPE,
1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

Line 1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,

1297: p_attribute6 IN ar_misc_cash_distributions.attribute6%TYPE,
1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

Line 1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,

1298: p_attribute7 IN ar_misc_cash_distributions.attribute7%TYPE,
1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

Line 1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,

1299: p_attribute8 IN ar_misc_cash_distributions.attribute8%TYPE,
1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

Line 1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,

1300: p_attribute9 IN ar_misc_cash_distributions.attribute9%TYPE,
1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
1308: p_form_name IN varchar2,

Line 1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,

1301: p_attribute10 IN ar_misc_cash_distributions.attribute10%TYPE,
1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
1308: p_form_name IN varchar2,
1309: p_form_version IN varchar2,

Line 1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,

1302: p_attribute11 IN ar_misc_cash_distributions.attribute11%TYPE,
1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
1308: p_form_name IN varchar2,
1309: p_form_version IN varchar2,
1310: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,

Line 1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,

1303: p_attribute12 IN ar_misc_cash_distributions.attribute12%TYPE,
1304: p_attribute13 IN ar_misc_cash_distributions.attribute13%TYPE,
1305: p_attribute14 IN ar_misc_cash_distributions.attribute14%TYPE,
1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
1308: p_form_name IN varchar2,
1309: p_form_version IN varchar2,
1310: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
1311: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /* Bug fix 3032059 */

Line 1310: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,

1306: p_attribute15 IN ar_misc_cash_distributions.attribute15%TYPE,
1307: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
1308: p_form_name IN varchar2,
1309: p_form_version IN varchar2,
1310: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
1311: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /* Bug fix 3032059 */
1312: ) IS
1313:
1314: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

Line 1314: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

1310: p_gl_posted_date IN ar_misc_cash_distributions.gl_posted_date%TYPE,
1311: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE /* Bug fix 3032059 */
1312: ) IS
1313:
1314: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
1315: l_dist_rec_amt NUMBER;
1316: l_dist_rec ar_distributions%ROWTYPE;
1317: l_ard_cnt NUMBER := 0 ;
1318: BEGIN

Line 1467: -- FND_MESSAGE.set_token( 'TABLE', 'AR_MISC_CASH_DISTRIBUTIONS');

1463: -- APP_EXCEPTION.Raise_Exception;
1464: -- WHEN OTHERS THEN
1465: -- IF (SQLCODE = -54) THEN
1466: -- FND_MESSAGE.Set_Name('FND', 'FORM-CANNOT LOCK');
1467: -- FND_MESSAGE.set_token( 'TABLE', 'AR_MISC_CASH_DISTRIBUTIONS');
1468: -- APP_EXCEPTION.Raise_Exception;
1469: -- ELSE
1470: -- arp_util.debug( SQLERRM );
1471: -- RAISE;

Line 1485: | record from ar_misc_cash_distributions lines to 1st line. |

1481: | round_correction_mcd_rec |
1482: | |
1483: | DESCRIPTION |
1484: | Correct the rounding correctiopn in a miscellaneous distribution |
1485: | record from ar_misc_cash_distributions lines to 1st line. |
1486: | we don't take care of rounding while insert or updation new MCD |
1487: | in Distribution window |
1488: | |
1489: | SCOPE - PRIVATE |

Line 1534: from ar_misc_cash_distributions

1530: CURSOR mcd_cur
1531: ( l_cash_receipt_id in ar_cash_receipts.cash_receipt_id%TYPE)
1532: IS
1533: SELECT *
1534: from ar_misc_cash_distributions
1535: where cash_receipt_id = l_cash_receipt_id
1536: and reversal_gl_date is null;
1537: tbl_ctr number;
1538: update_flag Char(1);

Line 1643: FROM ar_misc_cash_distributions

1639: NVL(SUM(acctd_amount),0)
1640:
1641: INTO l_rounding_diff,
1642: l_acctd_rounding_diff
1643: FROM ar_misc_cash_distributions
1644: WHERE cash_receipt_id = p_cash_receipt_id
1645: and reversal_gl_date is null;
1646:
1647: IF PG_DEBUG in ('Y', 'C') THEN

Line 1654: UPDATE ar_misc_cash_distributions

1650: END IF;
1651:
1652: IF (l_acctd_rounding_diff <> 0 OR l_rounding_diff <>0) THEN
1653:
1654: UPDATE ar_misc_cash_distributions
1655: SET amount = amount + l_rounding_diff,
1656: acctd_amount = acctd_amount + l_acctd_rounding_diff
1657:
1658: WHERE cash_receipt_id = p_cash_receipt_id

Line 1676: from ar_misc_cash_distributions

1672: INTO l_ard_acctd_cr,
1673: l_ard_acctd_dr
1674: FROM ar_distributions
1675: where source_id in (select misc_cash_distribution_id
1676: from ar_misc_cash_distributions
1677: where cash_receipt_id = p_cash_receipt_id
1678: and reversal_gl_date is null ) and
1679: source_table = 'MCD' ;
1680:

Line 1699: from ar_misc_cash_distributions

1695: UPDATE ar_distributions
1696: SET acctd_amount_dr = acctd_amount_dr + l_ard_acctd_dr_rounding_diff
1697:
1698: WHERE source_id in (select misc_cash_distribution_id
1699: from ar_misc_cash_distributions
1700: where cash_receipt_id = p_cash_receipt_id
1701: and reversal_gl_date is null )
1702: AND ROWNUM = 1
1703: AND source_table = 'MCD'

Line 1713: from ar_misc_cash_distributions

1709:
1710: UPDATE ar_distributions
1711: SET acctd_amount_cr = acctd_amount_cr + l_ard_acctd_cr_rounding_diff
1712: WHERE source_id in (select misc_cash_distribution_id
1713: from ar_misc_cash_distributions
1714: where cash_receipt_id = p_cash_receipt_id
1715: and reversal_gl_date is null)
1716: AND ROWNUM = 1
1717: AND source_table = 'MCD'

Line 1749: from ar_misc_cash_distributions

1745: BEGIN
1746: select code_combination_id into return_value
1747: from ar_distributions
1748: where source_id in (select MIN(misc_cash_distribution_id)
1749: from ar_misc_cash_distributions
1750: where cash_receipt_id=p_cash_receipt_id)
1751: and SOURCE_TABLE ='MCD'
1752: and SOURCE_TYPE = 'TAX';
1753: EXCEPTION