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

Line 322: PROCEDURE Check_Mandatory_Data ( p_batch_rec IN ra_batches%ROWTYPE)

318: | |
319: +==============================================================================*/
320:
321:
322: PROCEDURE Check_Mandatory_Data ( p_batch_rec IN ra_batches%ROWTYPE)
323: IS
324: BEGIN
325:
326: IF (p_batch_rec.batch_source_id IS NULL)

Line 403: PROCEDURE validate_batch ( p_batch_rec IN ra_batches%rowtype ) IS

399: | |
400: +===========================================================================*/
401:
402:
403: PROCEDURE validate_batch ( p_batch_rec IN ra_batches%rowtype ) IS
404:
405:
406: BEGIN
407:

Line 476: PROCEDURE validate_delete_batch ( p_batch_id IN ra_batches.batch_id%type ) IS

472: | |
473: +===========================================================================*/
474:
475:
476: PROCEDURE validate_delete_batch ( p_batch_id IN ra_batches.batch_id%type ) IS
477:
478:
479: BEGIN
480:

Line 535: p_issue_date IN ra_batches.issue_date%type ) IS

531: +===========================================================================*/
532:
533:
534: PROCEDURE validate_selection ( p_sel_rec IN ar_selection_criteria%rowtype,
535: p_issue_date IN ra_batches.issue_date%type ) IS
536:
537:
538: BEGIN
539:

Line 671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

667:
668: PROCEDURE insert_batch (
669: p_form_name IN varchar2 ,
670: p_form_version IN number ,
671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 672: p_batch_date IN ra_batches.batch_date%TYPE ,

668: PROCEDURE insert_batch (
669: p_form_name IN varchar2 ,
670: p_form_version IN number ,
671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,

Line 673: p_gl_date IN ra_batches.gl_date%TYPE ,

669: p_form_name IN varchar2 ,
670: p_form_version IN number ,
671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,

Line 674: p_TYPE IN ra_batches.TYPE%TYPE ,

670: p_form_version IN number ,
671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 675: p_currency_code IN ra_batches.currency_code%TYPE ,

671: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 676: p_comments IN ra_batches.comments%TYPE ,

672: p_batch_date IN ra_batches.batch_date%TYPE ,
673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 677: p_attribute_category IN ra_batches.attribute_category%TYPE ,

673: p_gl_date IN ra_batches.gl_date%TYPE ,
674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 678: p_attribute1 IN ra_batches.attribute1%TYPE ,

674: p_TYPE IN ra_batches.TYPE%TYPE ,
675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 679: p_attribute2 IN ra_batches.attribute2%TYPE ,

675: p_currency_code IN ra_batches.currency_code%TYPE ,
676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 680: p_attribute3 IN ra_batches.attribute3%TYPE ,

676: p_comments IN ra_batches.comments%TYPE ,
677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 681: p_attribute4 IN ra_batches.attribute4%TYPE ,

677: p_attribute_category IN ra_batches.attribute_category%TYPE ,
678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 682: p_attribute5 IN ra_batches.attribute5%TYPE ,

678: p_attribute1 IN ra_batches.attribute1%TYPE ,
679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 683: p_attribute6 IN ra_batches.attribute6%TYPE ,

679: p_attribute2 IN ra_batches.attribute2%TYPE ,
680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 684: p_attribute7 IN ra_batches.attribute7%TYPE ,

680: p_attribute3 IN ra_batches.attribute3%TYPE ,
681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 685: p_attribute8 IN ra_batches.attribute8%TYPE ,

681: p_attribute4 IN ra_batches.attribute4%TYPE ,
682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 686: p_attribute9 IN ra_batches.attribute9%TYPE ,

682: p_attribute5 IN ra_batches.attribute5%TYPE ,
683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 687: p_attribute10 IN ra_batches.attribute10%TYPE ,

683: p_attribute6 IN ra_batches.attribute6%TYPE ,
684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 688: p_attribute11 IN ra_batches.attribute11%TYPE ,

684: p_attribute7 IN ra_batches.attribute7%TYPE ,
685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 689: p_attribute12 IN ra_batches.attribute12%TYPE ,

685: p_attribute8 IN ra_batches.attribute8%TYPE ,
686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 690: p_attribute13 IN ra_batches.attribute13%TYPE ,

686: p_attribute9 IN ra_batches.attribute9%TYPE ,
687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 691: p_attribute14 IN ra_batches.attribute14%TYPE ,

687: p_attribute10 IN ra_batches.attribute10%TYPE ,
688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 692: p_attribute15 IN ra_batches.attribute15%TYPE ,

688: p_attribute11 IN ra_batches.attribute11%TYPE ,
689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,
696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 693: p_issue_date IN ra_batches.issue_date%TYPE ,

689: p_attribute12 IN ra_batches.attribute12%TYPE ,
690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,
696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
697: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 694: p_maturity_date IN ra_batches.maturity_date%TYPE ,

690: p_attribute13 IN ra_batches.attribute13%TYPE ,
691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,
696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
697: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
698: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

Line 695: p_special_instructions IN ra_batches.special_instructions%TYPE ,

691: p_attribute14 IN ra_batches.attribute14%TYPE ,
692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,
696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
697: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
698: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
699: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

692: p_attribute15 IN ra_batches.attribute15%TYPE ,
693: p_issue_date IN ra_batches.issue_date%TYPE ,
694: p_maturity_date IN ra_batches.maturity_date%TYPE ,
695: p_special_instructions IN ra_batches.special_instructions%TYPE ,
696: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
697: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
698: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
699: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
700: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

Line 710: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,

706: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
707: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
708: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
709: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
710: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
711: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
712: p_name IN OUT NOCOPY ra_batches.name%TYPE )
713:
714: IS

Line 711: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,

707: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
708: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
709: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
710: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
711: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
712: p_name IN OUT NOCOPY ra_batches.name%TYPE )
713:
714: IS
715: l_batch_rec ra_batches%rowtype ;

Line 712: p_name IN OUT NOCOPY ra_batches.name%TYPE )

708: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
709: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
710: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
711: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
712: p_name IN OUT NOCOPY ra_batches.name%TYPE )
713:
714: IS
715: l_batch_rec ra_batches%rowtype ;
716: l_batch_id ra_batches.batch_id%type ;

Line 715: l_batch_rec ra_batches%rowtype ;

711: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
712: p_name IN OUT NOCOPY ra_batches.name%TYPE )
713:
714: IS
715: l_batch_rec ra_batches%rowtype ;
716: l_batch_id ra_batches.batch_id%type ;
717: l_name ra_batches.name%type ;
718: l_sel_rec ar_selection_criteria%rowtype ;
719: l_sel_id ar_selection_criteria.selection_criteria_id%type;

Line 716: l_batch_id ra_batches.batch_id%type ;

712: p_name IN OUT NOCOPY ra_batches.name%TYPE )
713:
714: IS
715: l_batch_rec ra_batches%rowtype ;
716: l_batch_id ra_batches.batch_id%type ;
717: l_name ra_batches.name%type ;
718: l_sel_rec ar_selection_criteria%rowtype ;
719: l_sel_id ar_selection_criteria.selection_criteria_id%type;
720:

Line 717: l_name ra_batches.name%type ;

713:
714: IS
715: l_batch_rec ra_batches%rowtype ;
716: l_batch_id ra_batches.batch_id%type ;
717: l_name ra_batches.name%type ;
718: l_sel_rec ar_selection_criteria%rowtype ;
719: l_sel_id ar_selection_criteria.selection_criteria_id%type;
720:
721: BEGIN

Line 825: UPDATE RA_BATCHES

821: /*-------------------------------------------------------------+
822: | Update the Batch information with the Selection Criteria ID |
823: +-------------------------------------------------------------*/
824:
825: UPDATE RA_BATCHES
826: SET selection_criteria_id = p_selection_criteria_id
827: WHERE batch_id = p_batch_id;
828:
829:

Line 887: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |

883: | PROCEDURE |
884: | update_batch |
885: | |
886: | DESCRIPTION |
887: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |
888: | to update BR Batch information |
889: | |
890: | SCOPE - PRIVATE |
891: | |

Line 941: p_batch_id IN ra_batches.batch_id%TYPE ,

937:
938: PROCEDURE update_batch (
939: p_form_name IN varchar2 ,
940: p_form_version IN number ,
941: p_batch_id IN ra_batches.batch_id%TYPE ,
942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,

Line 942: p_name IN ra_batches.name%TYPE ,

938: PROCEDURE update_batch (
939: p_form_name IN varchar2 ,
940: p_form_version IN number ,
941: p_batch_id IN ra_batches.batch_id%TYPE ,
942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,

Line 943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

939: p_form_name IN varchar2 ,
940: p_form_version IN number ,
941: p_batch_id IN ra_batches.batch_id%TYPE ,
942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 944: p_batch_date IN ra_batches.batch_date%TYPE ,

940: p_form_version IN number ,
941: p_batch_id IN ra_batches.batch_id%TYPE ,
942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,

Line 945: p_gl_date IN ra_batches.gl_date%TYPE ,

941: p_batch_id IN ra_batches.batch_id%TYPE ,
942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,

Line 946: p_TYPE IN ra_batches.TYPE%TYPE ,

942: p_name IN ra_batches.name%TYPE ,
943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 947: p_currency_code IN ra_batches.currency_code%TYPE ,

943: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 948: p_comments IN ra_batches.comments%TYPE ,

944: p_batch_date IN ra_batches.batch_date%TYPE ,
945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 949: p_attribute_category IN ra_batches.attribute_category%TYPE ,

945: p_gl_date IN ra_batches.gl_date%TYPE ,
946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 950: p_attribute1 IN ra_batches.attribute1%TYPE ,

946: p_TYPE IN ra_batches.TYPE%TYPE ,
947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 951: p_attribute2 IN ra_batches.attribute2%TYPE ,

947: p_currency_code IN ra_batches.currency_code%TYPE ,
948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 952: p_attribute3 IN ra_batches.attribute3%TYPE ,

948: p_comments IN ra_batches.comments%TYPE ,
949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 953: p_attribute4 IN ra_batches.attribute4%TYPE ,

949: p_attribute_category IN ra_batches.attribute_category%TYPE ,
950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 954: p_attribute5 IN ra_batches.attribute5%TYPE ,

950: p_attribute1 IN ra_batches.attribute1%TYPE ,
951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 955: p_attribute6 IN ra_batches.attribute6%TYPE ,

951: p_attribute2 IN ra_batches.attribute2%TYPE ,
952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 956: p_attribute7 IN ra_batches.attribute7%TYPE ,

952: p_attribute3 IN ra_batches.attribute3%TYPE ,
953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 957: p_attribute8 IN ra_batches.attribute8%TYPE ,

953: p_attribute4 IN ra_batches.attribute4%TYPE ,
954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 958: p_attribute9 IN ra_batches.attribute9%TYPE ,

954: p_attribute5 IN ra_batches.attribute5%TYPE ,
955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 959: p_attribute10 IN ra_batches.attribute10%TYPE ,

955: p_attribute6 IN ra_batches.attribute6%TYPE ,
956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 960: p_attribute11 IN ra_batches.attribute11%TYPE ,

956: p_attribute7 IN ra_batches.attribute7%TYPE ,
957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 961: p_attribute12 IN ra_batches.attribute12%TYPE ,

957: p_attribute8 IN ra_batches.attribute8%TYPE ,
958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 962: p_attribute13 IN ra_batches.attribute13%TYPE ,

958: p_attribute9 IN ra_batches.attribute9%TYPE ,
959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 963: p_attribute14 IN ra_batches.attribute14%TYPE ,

959: p_attribute10 IN ra_batches.attribute10%TYPE ,
960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 964: p_attribute15 IN ra_batches.attribute15%TYPE ,

960: p_attribute11 IN ra_batches.attribute11%TYPE ,
961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 965: p_issue_date IN ra_batches.issue_date%TYPE ,

961: p_attribute12 IN ra_batches.attribute12%TYPE ,
962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
969: p_request_id IN ra_batches.request_id%TYPE ,

Line 966: p_maturity_date IN ra_batches.maturity_date%TYPE ,

962: p_attribute13 IN ra_batches.attribute13%TYPE ,
963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
969: p_request_id IN ra_batches.request_id%TYPE ,
970: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 967: p_special_instructions IN ra_batches.special_instructions%TYPE ,

963: p_attribute14 IN ra_batches.attribute14%TYPE ,
964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
969: p_request_id IN ra_batches.request_id%TYPE ,
970: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
971: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

Line 968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

964: p_attribute15 IN ra_batches.attribute15%TYPE ,
965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
969: p_request_id IN ra_batches.request_id%TYPE ,
970: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
971: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
972: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 969: p_request_id IN ra_batches.request_id%TYPE ,

965: p_issue_date IN ra_batches.issue_date%TYPE ,
966: p_maturity_date IN ra_batches.maturity_date%TYPE ,
967: p_special_instructions IN ra_batches.special_instructions%TYPE ,
968: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
969: p_request_id IN ra_batches.request_id%TYPE ,
970: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
971: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
972: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
973: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

Line 986: l_batch_rec ra_batches%rowtype;

982: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
983: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE)
984:
985: IS
986: l_batch_rec ra_batches%rowtype;
987: l_sel_rec ar_selection_criteria%rowtype;
988:
989:
990: BEGIN

Line 1059: UPDATE ra_batches

1055:
1056:
1057: IF (p_request_id IS NOT NULL)
1058: THEN
1059: UPDATE ra_batches
1060: SET request_id = p_request_id
1061: WHERE batch_id = p_batch_id;
1062: END IF;
1063:

Line 1112: UPDATE RA_BATCHES

1108: /*-------------------------------------------------------------+
1109: | Update the Batch information with the Selection Criteria ID |
1110: +-------------------------------------------------------------*/
1111:
1112: UPDATE RA_BATCHES
1113: SET selection_criteria_id = p_selection_criteria_id
1114: WHERE batch_id = p_batch_id;
1115:
1116: ELSE

Line 1188: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |

1184: | delete_batch |
1185: | |
1186: | DESCRIPTION |
1187: | |
1188: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |
1189: | to delete BR Batch information |
1190: | |
1191: | SCOPE - PRIVATE |
1192: | |

Line 1217: p_batch_id IN ra_batches.batch_id%TYPE ,

1213:
1214: PROCEDURE delete_batch (
1215: p_form_name IN varchar2 ,
1216: p_form_version IN number ,
1217: p_batch_id IN ra_batches.batch_id%TYPE ,
1218: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE)
1219:
1220: IS
1221:

Line 1279: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |

1275: | PROCEDURE |
1276: | lock_compare_batch |
1277: | |
1278: | DESCRIPTION |
1279: | Call the table handlers of RA_BATCHES and AR_SELECTION_CRITERIA |
1280: | to lock BR Batch information |
1281: | |
1282: | SCOPE - |
1283: | |

Line 1336: p_batch_id IN ra_batches.batch_id%TYPE ,

1332:
1333: PROCEDURE lock_compare_batch (
1334: p_form_name IN varchar2 ,
1335: p_form_version IN number ,
1336: p_batch_id IN ra_batches.batch_id%TYPE ,
1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,

Line 1337: p_name IN ra_batches.name%TYPE ,

1333: PROCEDURE lock_compare_batch (
1334: p_form_name IN varchar2 ,
1335: p_form_version IN number ,
1336: p_batch_id IN ra_batches.batch_id%TYPE ,
1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,

Line 1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

1334: p_form_name IN varchar2 ,
1335: p_form_version IN number ,
1336: p_batch_id IN ra_batches.batch_id%TYPE ,
1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,

Line 1339: p_batch_date IN ra_batches.batch_date%TYPE ,

1335: p_form_version IN number ,
1336: p_batch_id IN ra_batches.batch_id%TYPE ,
1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,

Line 1340: p_gl_date IN ra_batches.gl_date%TYPE ,

1336: p_batch_id IN ra_batches.batch_id%TYPE ,
1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,

Line 1341: p_TYPE IN ra_batches.TYPE%TYPE ,

1337: p_name IN ra_batches.name%TYPE ,
1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,

Line 1342: p_currency_code IN ra_batches.currency_code%TYPE ,

1338: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,
1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,

Line 1343: p_comments IN ra_batches.comments%TYPE ,

1339: p_batch_date IN ra_batches.batch_date%TYPE ,
1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,

Line 1344: p_attribute_category IN ra_batches.attribute_category%TYPE,

1340: p_gl_date IN ra_batches.gl_date%TYPE ,
1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,

Line 1345: p_attribute1 IN ra_batches.attribute1%TYPE ,

1341: p_TYPE IN ra_batches.TYPE%TYPE ,
1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,

Line 1346: p_attribute2 IN ra_batches.attribute2%TYPE ,

1342: p_currency_code IN ra_batches.currency_code%TYPE ,
1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,

Line 1347: p_attribute3 IN ra_batches.attribute3%TYPE ,

1343: p_comments IN ra_batches.comments%TYPE ,
1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,

Line 1348: p_attribute4 IN ra_batches.attribute4%TYPE ,

1344: p_attribute_category IN ra_batches.attribute_category%TYPE,
1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,

Line 1349: p_attribute5 IN ra_batches.attribute5%TYPE ,

1345: p_attribute1 IN ra_batches.attribute1%TYPE ,
1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,

Line 1350: p_attribute6 IN ra_batches.attribute6%TYPE ,

1346: p_attribute2 IN ra_batches.attribute2%TYPE ,
1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,

Line 1351: p_attribute7 IN ra_batches.attribute7%TYPE ,

1347: p_attribute3 IN ra_batches.attribute3%TYPE ,
1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,

Line 1352: p_attribute8 IN ra_batches.attribute8%TYPE ,

1348: p_attribute4 IN ra_batches.attribute4%TYPE ,
1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,

Line 1353: p_attribute9 IN ra_batches.attribute9%TYPE ,

1349: p_attribute5 IN ra_batches.attribute5%TYPE ,
1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,

Line 1354: p_attribute10 IN ra_batches.attribute10%TYPE ,

1350: p_attribute6 IN ra_batches.attribute6%TYPE ,
1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,

Line 1355: p_attribute11 IN ra_batches.attribute11%TYPE ,

1351: p_attribute7 IN ra_batches.attribute7%TYPE ,
1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,

Line 1356: p_attribute12 IN ra_batches.attribute12%TYPE ,

1352: p_attribute8 IN ra_batches.attribute8%TYPE ,
1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,

Line 1357: p_attribute13 IN ra_batches.attribute13%TYPE ,

1353: p_attribute9 IN ra_batches.attribute9%TYPE ,
1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,

Line 1358: p_attribute14 IN ra_batches.attribute14%TYPE ,

1354: p_attribute10 IN ra_batches.attribute10%TYPE ,
1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,

Line 1359: p_attribute15 IN ra_batches.attribute15%TYPE ,

1355: p_attribute11 IN ra_batches.attribute11%TYPE ,
1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,
1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

Line 1360: p_issue_date IN ra_batches.issue_date%TYPE ,

1356: p_attribute12 IN ra_batches.attribute12%TYPE ,
1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,
1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
1364: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,

Line 1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,

1357: p_attribute13 IN ra_batches.attribute13%TYPE ,
1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,
1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
1364: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
1365: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

Line 1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,

1358: p_attribute14 IN ra_batches.attribute14%TYPE ,
1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,
1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
1364: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
1365: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
1366: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,

Line 1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

1359: p_attribute15 IN ra_batches.attribute15%TYPE ,
1360: p_issue_date IN ra_batches.issue_date%TYPE ,
1361: p_maturity_date IN ra_batches.maturity_date%TYPE ,
1362: p_special_instructions IN ra_batches.special_instructions%TYPE ,
1363: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
1364: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
1365: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
1366: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
1367: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

Line 1380: l_batch_rec ra_batches%rowtype ;

1376: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
1377: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )
1378:
1379: IS
1380: l_batch_rec ra_batches%rowtype ;
1381: l_sel_rec ar_selection_criteria%rowtype;
1382:
1383: BEGIN
1384: IF PG_DEBUG in ('Y', 'C') THEN

Line 1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,

1564: PROCEDURE br_create(
1565: p_call IN NUMBER ,
1566: p_draft_mode IN VARCHAR2 ,
1567: p_print_flag IN VARCHAR2 ,
1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

Line 1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,

1565: p_call IN NUMBER ,
1566: p_draft_mode IN VARCHAR2 ,
1567: p_print_flag IN VARCHAR2 ,
1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

Line 1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,

1566: p_draft_mode IN VARCHAR2 ,
1567: p_print_flag IN VARCHAR2 ,
1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

Line 1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,

1567: p_print_flag IN VARCHAR2 ,
1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,

Line 1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

1568: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

Line 1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

1569: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

Line 1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

1570: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1578: p_attribute1 IN VARCHAR2 ,

Line 1575: p_comments IN RA_BATCHES.comments%TYPE ,

1571: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1578: p_attribute1 IN VARCHAR2 ,
1579: p_attribute2 IN VARCHAR2 ,

Line 1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

1572: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1578: p_attribute1 IN VARCHAR2 ,
1579: p_attribute2 IN VARCHAR2 ,
1580: p_attribute3 IN VARCHAR2 ,

Line 1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

1573: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1574: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1575: p_comments IN RA_BATCHES.comments%TYPE ,
1576: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1577: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1578: p_attribute1 IN VARCHAR2 ,
1579: p_attribute2 IN VARCHAR2 ,
1580: p_attribute3 IN VARCHAR2 ,
1581: p_attribute4 IN VARCHAR2 ,

Line 1610: l_request_id RA_BATCHES.request_id%TYPE ;

1606: p_req_id OUT NOCOPY NUMBER ,
1607: p_batch_process_status OUT NOCOPY VARCHAR2 )
1608:
1609: IS
1610: l_request_id RA_BATCHES.request_id%TYPE ;
1611: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;
1612: l_org_id RA_BATCH_SOURCES_ALL.ORG_ID%TYPE;
1613:
1614: BEGIN

Line 1611: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;

1607: p_batch_process_status OUT NOCOPY VARCHAR2 )
1608:
1609: IS
1610: l_request_id RA_BATCHES.request_id%TYPE ;
1611: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;
1612: l_org_id RA_BATCH_SOURCES_ALL.ORG_ID%TYPE;
1613:
1614: BEGIN
1615: