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 AR_SELECTION_CRITERIA

Line 535: PROCEDURE validate_selection ( p_sel_rec IN ar_selection_criteria%rowtype,

531: | |
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

Line 574: FUNCTION Is_Selection_Entered (p_sel_rec IN ar_selection_criteria%rowtype ) RETURN BOOLEAN IS

570: | This function determines if Selection Criteria have been entered or not|
571: | |
572: +===========================================================================*/
573:
574: FUNCTION Is_Selection_Entered (p_sel_rec IN ar_selection_criteria%rowtype ) RETURN BOOLEAN IS
575: BEGIN
576:
577: IF PG_DEBUG in ('Y', 'C') THEN
578: arp_util.debug('ARP_PROCESS_BR_BATCHES.Is_Selection_Entered()');

Line 698: p_due_date_low IN ar_selection_criteria.due_date_low%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 699: p_due_date_high IN ar_selection_criteria.due_date_high%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 700: p_trx_date_low IN ar_selection_criteria.trx_date_low%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 701: p_trx_date_high IN ar_selection_criteria.trx_date_high%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
707: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%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,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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,

Line 705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

701: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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 ,

Line 706: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

702: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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 ,

Line 707: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

703: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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 ,

Line 708: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

704: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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 ,

Line 709: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

705: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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 )

Line 710: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

706: p_trx_number_high IN ar_selection_criteria.trx_number_high%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:

Line 719: l_sel_rec ar_selection_criteria%rowtype ;

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
723:

Line 720: l_sel_id ar_selection_criteria.selection_criteria_id%type;

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
723:
724: arp_util.debug('arp_process_br_batch.insert_batch()+');

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 971: p_due_date_low IN ar_selection_criteria.due_date_low%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 972: p_due_date_high IN ar_selection_criteria.due_date_high%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 973: p_trx_date_low IN ar_selection_criteria.trx_date_low%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 974: p_trx_date_high IN ar_selection_criteria.trx_date_high%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%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,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

Line 978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

974: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

Line 979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

975: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
983: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

Line 980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

976: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
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)

Line 981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

977: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
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:

Line 982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

978: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
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

Line 983: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

979: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
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;

Line 984: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE)

980: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
981: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
982: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
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;

Line 988: l_sel_rec ar_selection_criteria%rowtype;

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
992: IF PG_DEBUG in ('Y', 'C') THEN

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 1219: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE)

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:
1223: BEGIN

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 1365: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,

Line 1366: p_due_date_low IN ar_selection_criteria.due_date_low%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 1367: p_due_date_high IN ar_selection_criteria.due_date_high%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 1368: p_trx_date_low IN ar_selection_criteria.trx_date_low%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%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 ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

1368: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

Line 1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

1369: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
1377: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

Line 1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

1370: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
1377: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
1378: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )

Line 1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

1371: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
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:

Line 1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

1372: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
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

Line 1377: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

1373: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
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 ;

Line 1378: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )

1374: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
1375: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
1376: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
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;

Line 1382: l_sel_rec ar_selection_criteria%rowtype;

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
1386: arp_util.debug('ARP_PROCESS_BR_BATCHES.lock_compare_batch ()+');