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_BOE dependencies on RA_CUSTOMER_TRX

Line 24: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

20: ar_payment_schedules.due_date%TYPE,
21: p_batch_id IN NUMBER );
22:
23: PROCEDURE val_args_add_or_rm_txn_rec(
24: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
26: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
27: p_customer_bank_account_id IN
28: ra_customer_trx.customer_bank_account_id%TYPE );

Line 26: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

22:
23: PROCEDURE val_args_add_or_rm_txn_rec(
24: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
26: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
27: p_customer_bank_account_id IN
28: ra_customer_trx.customer_bank_account_id%TYPE );
29:
30: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE);

Line 28: ra_customer_trx.customer_bank_account_id%TYPE );

24: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
26: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
27: p_customer_bank_account_id IN
28: ra_customer_trx.customer_bank_account_id%TYPE );
29:
30: PROCEDURE Val_Create_Auto_Batch_Submit(p_batch_id ar_batches.batch_id%TYPE);
31:
32: /* ---------------------- Public functions -------------------------------- */

Line 742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,

738: p_format_flag IN VARCHAR2,
739: p_batch_id IN ar_batches.batch_id%TYPE,
740: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
744: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
745: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
746: p_document_number_low IN NUMBER,

Line 743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,

739: p_batch_id IN ar_batches.batch_id%TYPE,
740: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
744: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
745: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
746: p_document_number_low IN NUMBER,
747: p_document_number_high IN NUMBER,

Line 744: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,

740: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
744: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
745: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
746: p_document_number_low IN NUMBER,
747: p_document_number_high IN NUMBER,
748: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,

Line 745: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,

741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
742: p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
743: p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
744: p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
745: p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
746: p_document_number_low IN NUMBER,
747: p_document_number_high IN NUMBER,
748: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
749: p_customer_number_high IN hz_cust_accounts.account_number%TYPE,

Line 915: ra_customer_trx ct,

911: WHERE cash_receipt_id IN (
912: SELECT crh.cash_receipt_id
913: FROM ar_cash_receipt_history crh,
914: ar_receivable_applications ra,
915: ra_customer_trx ct,
916: iby_fndcpt_tx_extensions ext
917: WHERE crh.batch_id = p_batch_id
918: AND crh.current_record_flag = 'Y'
919: AND crh.status = 'CONFIRMED'

Line 962: | p_customer_bank_account_id in RA_CUSTOMER_TRX |

958: | SCOPE - PUBLIC |
959: | |
960: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
961: | arp_ct_pkg.update_p - Updates paying_customer_id and |
962: | p_customer_bank_account_id in RA_CUSTOMER_TRX |
963: | arp_ps_pkg.update_p - Updates selected_for_receipt_batch_id in PS tab.|
964: | arp_util.debug |
965: | |
966: | ARGUMENTS : IN: |

Line 972: | used to update the PS table and the RA_CUSTOMER_TRX |

968: | p_ps_id - Payment Schedule ID |
969: | p_selected_for_rec_batch_id - This field indicates if an |
970: | invoice has been selected to be paid by a receipt e |
971: | belonging to an automatic batch. Note: This field is |
972: | used to update the PS table and the RA_CUSTOMER_TRX |
973: | table. |
974: | p_paying_customer_id - Paying customer of the invoice. |
975: | p_customer_bank_account_id - Custome bank account ID of the|
976: | invoice. |

Line 995: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

991: | depending on the p_call_conc_req flag |
992: | |
993: +===========================================================================*/
994: PROCEDURE add_or_rm_txn_from_auto_batch(
995: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
996: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
997: p_selected_for_rec_batch_id IN
998: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
999: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

Line 999: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

995: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
996: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
997: p_selected_for_rec_batch_id IN
998: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
999: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1000: p_customer_bank_account_id IN
1001: ra_customer_trx.customer_bank_account_id%TYPE,
1002: p_module_name IN VARCHAR2,
1003: p_module_version IN VARCHAR2 ) IS

Line 1001: ra_customer_trx.customer_bank_account_id%TYPE,

997: p_selected_for_rec_batch_id IN
998: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
999: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1000: p_customer_bank_account_id IN
1001: ra_customer_trx.customer_bank_account_id%TYPE,
1002: p_module_name IN VARCHAR2,
1003: p_module_version IN VARCHAR2 ) IS
1004: l_ct_rec ra_customer_trx%ROWTYPE;
1005: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 1004: l_ct_rec ra_customer_trx%ROWTYPE;

1000: p_customer_bank_account_id IN
1001: ra_customer_trx.customer_bank_account_id%TYPE,
1002: p_module_name IN VARCHAR2,
1003: p_module_version IN VARCHAR2 ) IS
1004: l_ct_rec ra_customer_trx%ROWTYPE;
1005: l_ps_rec ar_payment_schedules%ROWTYPE;
1006: --
1007: l_approve_flag VARCHAR2(1) DEFAULT 'N';
1008: l_format_flag VARCHAR2(1) DEFAULT 'N';

Line 1092: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

1088: | conc. req flag is set to 'Y' |
1089: | |
1090: +===========================================================================*/
1091: PROCEDURE val_args_add_or_rm_txn_rec(
1092: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1093: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1094: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1095: p_customer_bank_account_id IN
1096: ra_customer_trx.customer_bank_account_id%TYPE ) IS

Line 1094: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

1090: +===========================================================================*/
1091: PROCEDURE val_args_add_or_rm_txn_rec(
1092: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1093: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1094: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1095: p_customer_bank_account_id IN
1096: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1097: BEGIN
1098: IF PG_DEBUG in ('Y', 'C') THEN

Line 1096: ra_customer_trx.customer_bank_account_id%TYPE ) IS

1092: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1093: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1094: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1095: p_customer_bank_account_id IN
1096: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1097: BEGIN
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() +');
1100: END IF;