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 534: PROCEDURE validate_selection ( p_sel_rec IN ar_selection_criteria%rowtype,

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

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

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

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

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

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

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

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

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

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

Line 704: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

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

Line 705: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

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

Line 706: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

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

Line 707: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

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

Line 708: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

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

Line 709: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

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

Line 718: l_sel_rec ar_selection_criteria%rowtype ;

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

Line 719: l_sel_id ar_selection_criteria.selection_criteria_id%type;

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

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

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

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

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

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

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

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

Line 977: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

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

Line 978: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

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

Line 979: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

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

Line 980: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

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

Line 981: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

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

Line 982: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

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

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

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

Line 987: l_sel_rec ar_selection_criteria%rowtype;

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

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

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

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

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

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

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

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

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

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

Line 1371: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

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

Line 1372: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

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

Line 1373: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

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

Line 1374: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

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

Line 1375: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

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

Line 1376: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

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

Line 1377: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE )

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

Line 1381: l_sel_rec ar_selection_criteria%rowtype;

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