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_PROCESS_BATCH dependencies on RA_BATCHES

Line 49: FROM ra_batches

45:
46: /*Where clause is changed to solve bug 868793 : now batch name should be unique across batch sources */
47: SELECT count(*)
48: INTO l_count
49: FROM ra_batches
50: --WHERE batch_source_id = p_batch_source_id
51: WHERE name = p_name;
52:
53: IF (l_count > 0)

Line 163: PROCEDURE val_insert_batch ( p_batch_rec IN ra_batches%rowtype ) IS

159: | |
160: +===========================================================================*/
161:
162:
163: PROCEDURE val_insert_batch ( p_batch_rec IN ra_batches%rowtype ) IS
164:
165:
166: BEGIN
167:

Line 215: PROCEDURE val_update_batch ( p_batch_rec IN ra_batches%rowtype ) IS

211: | |
212: +===========================================================================*/
213:
214:
215: PROCEDURE val_update_batch ( p_batch_rec IN ra_batches%rowtype ) IS
216:
217:
218: BEGIN
219:

Line 264: PROCEDURE val_delete_batch ( p_batch_rec IN ra_batches%rowtype ) IS

260: | |
261: +===========================================================================*/
262:
263:
264: PROCEDURE val_delete_batch ( p_batch_rec IN ra_batches%rowtype ) IS
265:
266:
267: BEGIN
268:

Line 294: | Inserts a record into ra_batches. |

290: | PROCEDURE |
291: | insert_batch |
292: | |
293: | DESCRIPTION |
294: | Inserts a record into ra_batches. |
295: | |
296: | SCOPE - PRIVATE |
297: | |
298: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 323: p_batch_rec ra_batches%rowtype,

319:
320: PROCEDURE insert_batch(
321: p_form_name IN varchar2,
322: p_form_version IN number,
323: p_batch_rec ra_batches%rowtype,
324: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
325: p_name IN OUT NOCOPY ra_batches.name%type)
326: IS
327:

Line 324: p_batch_id OUT NOCOPY ra_batches.batch_id%type,

320: PROCEDURE insert_batch(
321: p_form_name IN varchar2,
322: p_form_version IN number,
323: p_batch_rec ra_batches%rowtype,
324: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
325: p_name IN OUT NOCOPY ra_batches.name%type)
326: IS
327:
328: BEGIN

Line 325: p_name IN OUT NOCOPY ra_batches.name%type)

321: p_form_name IN varchar2,
322: p_form_version IN number,
323: p_batch_rec ra_batches%rowtype,
324: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
325: p_name IN OUT NOCOPY ra_batches.name%type)
326: IS
327:
328: BEGIN
329:

Line 383: | Updates a ra_batches record |

379: | PROCEDURE |
380: | update_batch |
381: | |
382: | DESCRIPTION |
383: | Updates a ra_batches record |
384: | |
385: | SCOPE - PRIVATE |
386: | |
387: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 410: p_batch_id IN ra_batches.batch_id%type,

406:
407: PROCEDURE update_batch(
408: p_form_name IN varchar2,
409: p_form_version IN number,
410: p_batch_id IN ra_batches.batch_id%type,
411: p_batch_rec IN ra_batches%rowtype ) IS
412:
413:
414:

Line 411: p_batch_rec IN ra_batches%rowtype ) IS

407: PROCEDURE update_batch(
408: p_form_name IN varchar2,
409: p_form_version IN number,
410: p_batch_id IN ra_batches.batch_id%type,
411: p_batch_rec IN ra_batches%rowtype ) IS
412:
413:
414:
415: BEGIN

Line 472: | Deletes records from ra_batches |

468: | PROCEDURE |
469: | delete_batch |
470: | |
471: | DESCRIPTION |
472: | Deletes records from ra_batches |
473: | |
474: | SCOPE - PRIVATE |
475: | |
476: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 498: p_batch_id IN ra_batches.batch_id%type,

494:
495:
496: PROCEDURE delete_batch(p_form_name IN varchar2,
497: p_form_version IN number,
498: p_batch_id IN ra_batches.batch_id%type,
499: p_batch_rec IN ra_batches%rowtype) IS
500:
501: BEGIN
502:

Line 499: p_batch_rec IN ra_batches%rowtype) IS

495:
496: PROCEDURE delete_batch(p_form_name IN varchar2,
497: p_form_version IN number,
498: p_batch_id IN ra_batches.batch_id%type,
499: p_batch_rec IN ra_batches%rowtype) IS
500:
501: BEGIN
502:
503: arp_util.debug('arp_process_batch.delete_batch()+');

Line 597: p_batch_source_id IN ra_batches.batch_source_id%type,

593:
594: PROCEDURE insert_batch_cover(
595: p_form_name IN varchar2,
596: p_form_version IN number,
597: p_batch_source_id IN ra_batches.batch_source_id%type,
598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,

Line 598: p_batch_date IN ra_batches.batch_date%type,

594: PROCEDURE insert_batch_cover(
595: p_form_name IN varchar2,
596: p_form_version IN number,
597: p_batch_source_id IN ra_batches.batch_source_id%type,
598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,

Line 599: p_gl_date IN ra_batches.gl_date%type,

595: p_form_name IN varchar2,
596: p_form_version IN number,
597: p_batch_source_id IN ra_batches.batch_source_id%type,
598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

Line 600: p_status IN ra_batches.status%type,

596: p_form_version IN number,
597: p_batch_source_id IN ra_batches.batch_source_id%type,
598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,

Line 601: p_type IN ra_batches.type%type,

597: p_batch_source_id IN ra_batches.batch_source_id%type,
598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,

Line 602: p_currency_code IN ra_batches.currency_code%type,

598: p_batch_date IN ra_batches.batch_date%type,
599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,

Line 603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

599: p_gl_date IN ra_batches.gl_date%type,
600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,

Line 604: p_exchange_date IN ra_batches.exchange_date%type,

600: p_status IN ra_batches.status%type,
601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,

Line 605: p_exchange_rate IN ra_batches.exchange_rate%type,

601: p_type IN ra_batches.type%type,
602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,

Line 606: p_control_count IN ra_batches.control_count%type,

602: p_currency_code IN ra_batches.currency_code%type,
603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,

Line 607: p_control_amount IN ra_batches.control_amount%type,

603: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,

Line 608: p_comments IN ra_batches.comments%type,

604: p_exchange_date IN ra_batches.exchange_date%type,
605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,

Line 609: p_set_of_books_id IN ra_batches.set_of_books_id%type,

605: p_exchange_rate IN ra_batches.exchange_rate%type,
606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,

Line 610: p_purged_children_flag IN ra_batches.purged_children_flag%type,

606: p_control_count IN ra_batches.control_count%type,
607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,

Line 611: p_attribute_category IN ra_batches.attribute_category%type,

607: p_control_amount IN ra_batches.control_amount%type,
608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,

Line 612: p_attribute1 IN ra_batches.attribute1%type,

608: p_comments IN ra_batches.comments%type,
609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,

Line 613: p_attribute2 IN ra_batches.attribute2%type,

609: p_set_of_books_id IN ra_batches.set_of_books_id%type,
610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,

Line 614: p_attribute3 IN ra_batches.attribute3%type,

610: p_purged_children_flag IN ra_batches.purged_children_flag%type,
611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,

Line 615: p_attribute4 IN ra_batches.attribute4%type,

611: p_attribute_category IN ra_batches.attribute_category%type,
612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,

Line 616: p_attribute5 IN ra_batches.attribute5%type,

612: p_attribute1 IN ra_batches.attribute1%type,
613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,

Line 617: p_attribute6 IN ra_batches.attribute6%type,

613: p_attribute2 IN ra_batches.attribute2%type,
614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,

Line 618: p_attribute7 IN ra_batches.attribute7%type,

614: p_attribute3 IN ra_batches.attribute3%type,
615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,

Line 619: p_attribute8 IN ra_batches.attribute8%type,

615: p_attribute4 IN ra_batches.attribute4%type,
616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,

Line 620: p_attribute9 IN ra_batches.attribute9%type,

616: p_attribute5 IN ra_batches.attribute5%type,
617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,

Line 621: p_attribute10 IN ra_batches.attribute10%type,

617: p_attribute6 IN ra_batches.attribute6%type,
618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,

Line 622: p_attribute11 IN ra_batches.attribute11%type,

618: p_attribute7 IN ra_batches.attribute7%type,
619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,

Line 623: p_attribute12 IN ra_batches.attribute12%type,

619: p_attribute8 IN ra_batches.attribute8%type,
620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,

Line 624: p_attribute13 IN ra_batches.attribute13%type,

620: p_attribute9 IN ra_batches.attribute9%type,
621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)

Line 625: p_attribute14 IN ra_batches.attribute14%type,

621: p_attribute10 IN ra_batches.attribute10%type,
622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS

Line 626: p_attribute15 IN ra_batches.attribute15%type,

622: p_attribute11 IN ra_batches.attribute11%type,
623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;

Line 627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,

623: p_attribute12 IN ra_batches.attribute12%type,
624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;

Line 628: p_name IN OUT NOCOPY ra_batches.name%type)

624: p_attribute13 IN ra_batches.attribute13%type,
625: p_attribute14 IN ra_batches.attribute14%type,
626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;
632: l_name ra_batches.name%type;

Line 630: l_batch_rec ra_batches%rowtype;

626: p_attribute15 IN ra_batches.attribute15%type,
627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;
632: l_name ra_batches.name%type;
633: BEGIN
634: arp_util.debug('arp_process_batch.insert_batch_cover()+');

Line 631: l_batch_id ra_batches.batch_id%type;

627: p_batch_id OUT NOCOPY ra_batches.batch_id%type,
628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;
632: l_name ra_batches.name%type;
633: BEGIN
634: arp_util.debug('arp_process_batch.insert_batch_cover()+');
635:

Line 632: l_name ra_batches.name%type;

628: p_name IN OUT NOCOPY ra_batches.name%type)
629: IS
630: l_batch_rec ra_batches%rowtype;
631: l_batch_id ra_batches.batch_id%type;
632: l_name ra_batches.name%type;
633: BEGIN
634: arp_util.debug('arp_process_batch.insert_batch_cover()+');
635:
636: l_batch_rec.batch_source_id := p_batch_source_id;

Line 766: p_batch_id IN ra_batches.batch_id%type,

762:
763: PROCEDURE update_batch_cover(
764: p_form_name IN varchar2,
765: p_form_version IN number,
766: p_batch_id IN ra_batches.batch_id%type,
767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,

Line 767: p_name IN ra_batches.name%type,

763: PROCEDURE update_batch_cover(
764: p_form_name IN varchar2,
765: p_form_version IN number,
766: p_batch_id IN ra_batches.batch_id%type,
767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,

Line 768: p_batch_source_id IN ra_batches.batch_source_id%type,

764: p_form_name IN varchar2,
765: p_form_version IN number,
766: p_batch_id IN ra_batches.batch_id%type,
767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,

Line 769: p_batch_date IN ra_batches.batch_date%type,

765: p_form_version IN number,
766: p_batch_id IN ra_batches.batch_id%type,
767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,

Line 770: p_gl_date IN ra_batches.gl_date%type,

766: p_batch_id IN ra_batches.batch_id%type,
767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

Line 771: p_status IN ra_batches.status%type,

767: p_name IN ra_batches.name%type,
768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,

Line 772: p_type IN ra_batches.type%type,

768: p_batch_source_id IN ra_batches.batch_source_id%type,
769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,

Line 773: p_currency_code IN ra_batches.currency_code%type,

769: p_batch_date IN ra_batches.batch_date%type,
770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,

Line 774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,

770: p_gl_date IN ra_batches.gl_date%type,
771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,

Line 775: p_exchange_date IN ra_batches.exchange_date%type,

771: p_status IN ra_batches.status%type,
772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,

Line 776: p_exchange_rate IN ra_batches.exchange_rate%type,

772: p_type IN ra_batches.type%type,
773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,

Line 777: p_control_count IN ra_batches.control_count%type,

773: p_currency_code IN ra_batches.currency_code%type,
774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,

Line 778: p_control_amount IN ra_batches.control_amount%type,

774: p_exchange_rate_type IN ra_batches.exchange_rate_type%type,
775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,

Line 779: p_comments IN ra_batches.comments%type,

775: p_exchange_date IN ra_batches.exchange_date%type,
776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,

Line 780: p_set_of_books_id IN ra_batches.set_of_books_id%type,

776: p_exchange_rate IN ra_batches.exchange_rate%type,
777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,

Line 781: p_purged_children_flag IN ra_batches.purged_children_flag%type,

777: p_control_count IN ra_batches.control_count%type,
778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,

Line 782: p_attribute_category IN ra_batches.attribute_category%type,

778: p_control_amount IN ra_batches.control_amount%type,
779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,

Line 783: p_attribute1 IN ra_batches.attribute1%type,

779: p_comments IN ra_batches.comments%type,
780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,

Line 784: p_attribute2 IN ra_batches.attribute2%type,

780: p_set_of_books_id IN ra_batches.set_of_books_id%type,
781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,

Line 785: p_attribute3 IN ra_batches.attribute3%type,

781: p_purged_children_flag IN ra_batches.purged_children_flag%type,
782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,

Line 786: p_attribute4 IN ra_batches.attribute4%type,

782: p_attribute_category IN ra_batches.attribute_category%type,
783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,

Line 787: p_attribute5 IN ra_batches.attribute5%type,

783: p_attribute1 IN ra_batches.attribute1%type,
784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,

Line 788: p_attribute6 IN ra_batches.attribute6%type,

784: p_attribute2 IN ra_batches.attribute2%type,
785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,

Line 789: p_attribute7 IN ra_batches.attribute7%type,

785: p_attribute3 IN ra_batches.attribute3%type,
786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,

Line 790: p_attribute8 IN ra_batches.attribute8%type,

786: p_attribute4 IN ra_batches.attribute4%type,
787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,

Line 791: p_attribute9 IN ra_batches.attribute9%type,

787: p_attribute5 IN ra_batches.attribute5%type,
788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,

Line 792: p_attribute10 IN ra_batches.attribute10%type,

788: p_attribute6 IN ra_batches.attribute6%type,
789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,

Line 793: p_attribute11 IN ra_batches.attribute11%type,

789: p_attribute7 IN ra_batches.attribute7%type,
790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)

Line 794: p_attribute12 IN ra_batches.attribute12%type,

790: p_attribute8 IN ra_batches.attribute8%type,
791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)
798: IS

Line 795: p_attribute13 IN ra_batches.attribute13%type,

791: p_attribute9 IN ra_batches.attribute9%type,
792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)
798: IS
799: l_batch_rec ra_batches%rowtype;

Line 796: p_attribute14 IN ra_batches.attribute14%type,

792: p_attribute10 IN ra_batches.attribute10%type,
793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)
798: IS
799: l_batch_rec ra_batches%rowtype;
800: BEGIN

Line 797: p_attribute15 IN ra_batches.attribute15%type)

793: p_attribute11 IN ra_batches.attribute11%type,
794: p_attribute12 IN ra_batches.attribute12%type,
795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)
798: IS
799: l_batch_rec ra_batches%rowtype;
800: BEGIN
801:

Line 799: l_batch_rec ra_batches%rowtype;

795: p_attribute13 IN ra_batches.attribute13%type,
796: p_attribute14 IN ra_batches.attribute14%type,
797: p_attribute15 IN ra_batches.attribute15%type)
798: IS
799: l_batch_rec ra_batches%rowtype;
800: BEGIN
801:
802: arp_util.debug('arp_process_batch.update_batch_cover()+');
803:

Line 919: p_batch_id IN ra_batches.batch_id%type)

915:
916: PROCEDURE delete_batch_cover(
917: p_form_name IN varchar2,
918: p_form_version IN number,
919: p_batch_id IN ra_batches.batch_id%type)
920: IS
921: l_batch_rec ra_batches%rowtype;
922: BEGIN
923: arp_util.debug('arp_process_batch.delete_batch_cover()+');

Line 921: l_batch_rec ra_batches%rowtype;

917: p_form_name IN varchar2,
918: p_form_version IN number,
919: p_batch_id IN ra_batches.batch_id%type)
920: IS
921: l_batch_rec ra_batches%rowtype;
922: BEGIN
923: arp_util.debug('arp_process_batch.delete_batch_cover()+');
924:
925: arp_tbat_pkg.set_to_dummy(l_batch_rec);