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 323: PROCEDURE Check_Mandatory_Data ( p_batch_rec IN ra_batches%ROWTYPE)

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

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

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

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

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

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

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

Line 672: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

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

Line 673: p_batch_date IN ra_batches.batch_date%TYPE ,

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

Line 674: p_gl_date IN ra_batches.gl_date%TYPE ,

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

Line 675: p_TYPE IN ra_batches.TYPE%TYPE ,

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

Line 676: p_currency_code IN ra_batches.currency_code%TYPE ,

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

Line 677: p_comments IN ra_batches.comments%TYPE ,

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

Line 678: p_attribute_category IN ra_batches.attribute_category%TYPE ,

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

Line 679: p_attribute1 IN ra_batches.attribute1%TYPE ,

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

Line 680: p_attribute2 IN ra_batches.attribute2%TYPE ,

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

Line 681: p_attribute3 IN ra_batches.attribute3%TYPE ,

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

Line 682: p_attribute4 IN ra_batches.attribute4%TYPE ,

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

Line 683: p_attribute5 IN ra_batches.attribute5%TYPE ,

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

Line 684: p_attribute6 IN ra_batches.attribute6%TYPE ,

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

Line 685: p_attribute7 IN ra_batches.attribute7%TYPE ,

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

Line 686: p_attribute8 IN ra_batches.attribute8%TYPE ,

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

Line 687: p_attribute9 IN ra_batches.attribute9%TYPE ,

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

Line 688: p_attribute10 IN ra_batches.attribute10%TYPE ,

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

Line 689: p_attribute11 IN ra_batches.attribute11%TYPE ,

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

Line 690: p_attribute12 IN ra_batches.attribute12%TYPE ,

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

Line 691: p_attribute13 IN ra_batches.attribute13%TYPE ,

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

Line 692: p_attribute14 IN ra_batches.attribute14%TYPE ,

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

Line 693: p_attribute15 IN ra_batches.attribute15%TYPE ,

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

Line 694: p_issue_date IN ra_batches.issue_date%TYPE ,

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

Line 695: p_maturity_date IN ra_batches.maturity_date%TYPE ,

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

Line 696: p_special_instructions IN ra_batches.special_instructions%TYPE ,

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

Line 697: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

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

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

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

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

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

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

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

Line 716: l_batch_rec ra_batches%rowtype ;

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

Line 717: l_batch_id ra_batches.batch_id%type ;

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

Line 718: l_name ra_batches.name%type ;

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

Line 826: UPDATE RA_BATCHES

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

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

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

Line 942: p_batch_id IN ra_batches.batch_id%TYPE ,

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

Line 943: p_name IN ra_batches.name%TYPE ,

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

Line 944: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

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

Line 945: p_batch_date IN ra_batches.batch_date%TYPE ,

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

Line 946: p_gl_date IN ra_batches.gl_date%TYPE ,

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

Line 947: p_TYPE IN ra_batches.TYPE%TYPE ,

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

Line 948: p_currency_code IN ra_batches.currency_code%TYPE ,

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

Line 949: p_comments IN ra_batches.comments%TYPE ,

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

Line 950: p_attribute_category IN ra_batches.attribute_category%TYPE ,

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

Line 951: p_attribute1 IN ra_batches.attribute1%TYPE ,

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

Line 952: p_attribute2 IN ra_batches.attribute2%TYPE ,

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

Line 953: p_attribute3 IN ra_batches.attribute3%TYPE ,

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

Line 954: p_attribute4 IN ra_batches.attribute4%TYPE ,

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

Line 955: p_attribute5 IN ra_batches.attribute5%TYPE ,

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

Line 956: p_attribute6 IN ra_batches.attribute6%TYPE ,

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

Line 957: p_attribute7 IN ra_batches.attribute7%TYPE ,

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

Line 958: p_attribute8 IN ra_batches.attribute8%TYPE ,

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

Line 959: p_attribute9 IN ra_batches.attribute9%TYPE ,

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

Line 960: p_attribute10 IN ra_batches.attribute10%TYPE ,

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

Line 961: p_attribute11 IN ra_batches.attribute11%TYPE ,

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

Line 962: p_attribute12 IN ra_batches.attribute12%TYPE ,

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

Line 963: p_attribute13 IN ra_batches.attribute13%TYPE ,

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

Line 964: p_attribute14 IN ra_batches.attribute14%TYPE ,

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

Line 965: p_attribute15 IN ra_batches.attribute15%TYPE ,

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

Line 966: p_issue_date IN ra_batches.issue_date%TYPE ,

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

Line 967: p_maturity_date IN ra_batches.maturity_date%TYPE ,

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

Line 968: p_special_instructions IN ra_batches.special_instructions%TYPE ,

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

Line 969: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

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

Line 970: p_request_id IN ra_batches.request_id%TYPE ,

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

Line 987: l_batch_rec ra_batches%rowtype;

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

Line 1060: UPDATE ra_batches

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

Line 1113: UPDATE RA_BATCHES

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

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

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

Line 1218: p_batch_id IN ra_batches.batch_id%TYPE ,

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

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

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

Line 1337: p_batch_id IN ra_batches.batch_id%TYPE ,

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

Line 1338: p_name IN ra_batches.name%TYPE ,

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

Line 1339: p_batch_source_id IN ra_batches.batch_source_id%TYPE ,

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

Line 1340: p_batch_date IN ra_batches.batch_date%TYPE ,

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

Line 1341: p_gl_date IN ra_batches.gl_date%TYPE ,

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

Line 1342: p_TYPE IN ra_batches.TYPE%TYPE ,

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

Line 1343: p_currency_code IN ra_batches.currency_code%TYPE ,

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

Line 1344: p_comments IN ra_batches.comments%TYPE ,

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

Line 1345: p_attribute_category IN ra_batches.attribute_category%TYPE,

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

Line 1346: p_attribute1 IN ra_batches.attribute1%TYPE ,

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

Line 1347: p_attribute2 IN ra_batches.attribute2%TYPE ,

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

Line 1348: p_attribute3 IN ra_batches.attribute3%TYPE ,

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

Line 1349: p_attribute4 IN ra_batches.attribute4%TYPE ,

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

Line 1350: p_attribute5 IN ra_batches.attribute5%TYPE ,

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

Line 1351: p_attribute6 IN ra_batches.attribute6%TYPE ,

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

Line 1352: p_attribute7 IN ra_batches.attribute7%TYPE ,

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

Line 1353: p_attribute8 IN ra_batches.attribute8%TYPE ,

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

Line 1354: p_attribute9 IN ra_batches.attribute9%TYPE ,

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

Line 1355: p_attribute10 IN ra_batches.attribute10%TYPE ,

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

Line 1356: p_attribute11 IN ra_batches.attribute11%TYPE ,

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

Line 1357: p_attribute12 IN ra_batches.attribute12%TYPE ,

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

Line 1358: p_attribute13 IN ra_batches.attribute13%TYPE ,

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

Line 1359: p_attribute14 IN ra_batches.attribute14%TYPE ,

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

Line 1360: p_attribute15 IN ra_batches.attribute15%TYPE ,

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

Line 1361: p_issue_date IN ra_batches.issue_date%TYPE ,

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

Line 1362: p_maturity_date IN ra_batches.maturity_date%TYPE ,

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

Line 1363: p_special_instructions IN ra_batches.special_instructions%TYPE ,

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

Line 1364: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,

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

Line 1381: l_batch_rec ra_batches%rowtype ;

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

Line 1524: select org_id into l_org_id from ra_batches where batch_id=p_br_id;

1520: /* Bug 10388858
1521: Org id of the concurrent request is mot set causing issue in submit of child request. */
1522: begin
1523: If p_br_id is not null then
1524: select org_id into l_org_id from ra_batches where batch_id=p_br_id;
1525: fnd_request.set_org_id(l_org_id);
1526: end if;
1527: exception when others then
1528: null;

Line 1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,

1576: PROCEDURE br_create(
1577: p_call IN NUMBER ,
1578: p_draft_mode IN VARCHAR2 ,
1579: p_print_flag IN VARCHAR2 ,
1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

Line 1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,

1577: p_call IN NUMBER ,
1578: p_draft_mode IN VARCHAR2 ,
1579: p_print_flag IN VARCHAR2 ,
1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

Line 1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,

1578: p_draft_mode IN VARCHAR2 ,
1579: p_print_flag IN VARCHAR2 ,
1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

Line 1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,

1579: p_print_flag IN VARCHAR2 ,
1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,

Line 1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,

1580: p_batch_id IN RA_BATCHES.batch_id%TYPE ,
1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

Line 1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,

1581: p_batch_source_id IN RA_BATCHES.batch_source_id%TYPE ,
1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

Line 1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,

1582: p_batch_date IN RA_BATCHES.batch_date%TYPE ,
1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1590: p_attribute1 IN VARCHAR2 ,

Line 1587: p_comments IN RA_BATCHES.comments%TYPE ,

1583: p_gl_date IN RA_BATCHES.gl_date%TYPE ,
1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1590: p_attribute1 IN VARCHAR2 ,
1591: p_attribute2 IN VARCHAR2 ,

Line 1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,

1584: p_issue_date IN RA_BATCHES.issue_date%TYPE ,
1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1590: p_attribute1 IN VARCHAR2 ,
1591: p_attribute2 IN VARCHAR2 ,
1592: p_attribute3 IN VARCHAR2 ,

Line 1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,

1585: p_maturity_date IN RA_BATCHES.maturity_date%TYPE ,
1586: p_currency_code IN RA_BATCHES.currency_code%TYPE ,
1587: p_comments IN RA_BATCHES.comments%TYPE ,
1588: p_special_instructions IN RA_BATCHES.special_instructions%TYPE ,
1589: p_attribute_category IN RA_BATCHES.attribute_category%TYPE ,
1590: p_attribute1 IN VARCHAR2 ,
1591: p_attribute2 IN VARCHAR2 ,
1592: p_attribute3 IN VARCHAR2 ,
1593: p_attribute4 IN VARCHAR2 ,

Line 1622: l_request_id RA_BATCHES.request_id%TYPE ;

1618: p_req_id OUT NOCOPY NUMBER ,
1619: p_batch_process_status OUT NOCOPY VARCHAR2 )
1620:
1621: IS
1622: l_request_id RA_BATCHES.request_id%TYPE ;
1623: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;
1624: l_org_id RA_BATCH_SOURCES_ALL.ORG_ID%TYPE;
1625:
1626: BEGIN

Line 1623: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;

1619: p_batch_process_status OUT NOCOPY VARCHAR2 )
1620:
1621: IS
1622: l_request_id RA_BATCHES.request_id%TYPE ;
1623: l_batch_process_status RA_BATCHES.batch_process_status%TYPE ;
1624: l_org_id RA_BATCH_SOURCES_ALL.ORG_ID%TYPE;
1625:
1626: BEGIN
1627: