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 929: | p_customer_bank_account_id in RA_CUSTOMER_TRX |

925: | SCOPE - PUBLIC |
926: | |
927: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
928: | arp_ct_pkg.update_p - Updates paying_customer_id and |
929: | p_customer_bank_account_id in RA_CUSTOMER_TRX |
930: | arp_ps_pkg.update_p - Updates selected_for_receipt_batch_id in PS tab.|
931: | arp_util.debug |
932: | |
933: | ARGUMENTS : IN: |

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

935: | p_ps_id - Payment Schedule ID |
936: | p_selected_for_rec_batch_id - This field indicates if an |
937: | invoice has been selected to be paid by a receipt e |
938: | belonging to an automatic batch. Note: This field is |
939: | used to update the PS table and the RA_CUSTOMER_TRX |
940: | table. |
941: | p_paying_customer_id - Paying customer of the invoice. |
942: | p_customer_bank_account_id - Custome bank account ID of the|
943: | invoice. |

Line 962: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

958: | depending on the p_call_conc_req flag |
959: | |
960: +===========================================================================*/
961: PROCEDURE add_or_rm_txn_from_auto_batch(
962: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
963: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
964: p_selected_for_rec_batch_id IN
965: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
966: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

Line 966: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

962: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
963: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
964: p_selected_for_rec_batch_id IN
965: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
966: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
967: p_customer_bank_account_id IN
968: ra_customer_trx.customer_bank_account_id%TYPE,
969: p_module_name IN VARCHAR2,
970: p_module_version IN VARCHAR2 ) IS

Line 968: ra_customer_trx.customer_bank_account_id%TYPE,

964: p_selected_for_rec_batch_id IN
965: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
966: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
967: p_customer_bank_account_id IN
968: ra_customer_trx.customer_bank_account_id%TYPE,
969: p_module_name IN VARCHAR2,
970: p_module_version IN VARCHAR2 ) IS
971: l_ct_rec ra_customer_trx%ROWTYPE;
972: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 971: l_ct_rec ra_customer_trx%ROWTYPE;

967: p_customer_bank_account_id IN
968: ra_customer_trx.customer_bank_account_id%TYPE,
969: p_module_name IN VARCHAR2,
970: p_module_version IN VARCHAR2 ) IS
971: l_ct_rec ra_customer_trx%ROWTYPE;
972: l_ps_rec ar_payment_schedules%ROWTYPE;
973: --
974: l_approve_flag VARCHAR2(1) DEFAULT 'N';
975: l_format_flag VARCHAR2(1) DEFAULT 'N';

Line 1059: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,

1055: | conc. req flag is set to 'Y' |
1056: | |
1057: +===========================================================================*/
1058: PROCEDURE val_args_add_or_rm_txn_rec(
1059: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1060: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1061: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1062: p_customer_bank_account_id IN
1063: ra_customer_trx.customer_bank_account_id%TYPE ) IS

Line 1061: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,

1057: +===========================================================================*/
1058: PROCEDURE val_args_add_or_rm_txn_rec(
1059: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1060: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1061: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1062: p_customer_bank_account_id IN
1063: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1064: BEGIN
1065: IF PG_DEBUG in ('Y', 'C') THEN

Line 1063: ra_customer_trx.customer_bank_account_id%TYPE ) IS

1059: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
1060: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1061: p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
1062: p_customer_bank_account_id IN
1063: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1064: BEGIN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() +');
1067: END IF;