DBA Data[Home] [Help]

APPS.ARP_PROCESS_BOE dependencies on AR_PAYMENT_SCHEDULES

Line 15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

11: l_batch_id NUMBER;
12:
13: PROCEDURE val_args_add_or_rm_remit_rec(
14: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
17: p_remittance_bank_account_id IN
18: ar_cash_receipts.remit_bank_acct_use_id%type,
19: p_maturity_date IN

Line 20: ar_payment_schedules.due_date%TYPE,

16: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
17: p_remittance_bank_account_id IN
18: ar_cash_receipts.remit_bank_acct_use_id%type,
19: p_maturity_date IN
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,

Line 25: p_ps_id IN ar_payment_schedules.payment_schedule_id%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 );
29:

Line 96: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

92: | |
93: +===========================================================================*/
94: PROCEDURE add_or_rm_remit_rec_to_batch (
95: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
96: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
97: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
98: p_selected_remittance_batch_id IN
99: ar_cash_receipts.selected_remittance_batch_id%TYPE,
100: p_remittance_bank_account_id IN

Line 109: ar_payment_schedules.due_date%TYPE,

105: ar_cash_receipts.customer_bank_account_id%TYPE,
106: p_bank_charges IN
107: ar_cash_receipt_history.factor_discount_amount%TYPE,
108: p_maturity_date IN
109: ar_payment_schedules.due_date%TYPE,
110: p_batch_id IN NUMBER,
111: p_control_count IN NUMBER,
112: p_control_amount IN NUMBER,
113: p_module_name IN VARCHAR2,

Line 117: l_ps_rec ar_payment_schedules%ROWTYPE;

113: p_module_name IN VARCHAR2,
114: p_module_version IN VARCHAR2 ) IS
115: --
116: l_cr_rec ar_cash_receipts%ROWTYPE;
117: l_ps_rec ar_payment_schedules%ROWTYPE;
118: l_crh_rec ar_cash_receipt_history%ROWTYPE;
119: l_batch_rec ar_batches%ROWTYPE;
120: --
121: l_approve_flag VARCHAR2(1) DEFAULT 'N';

Line 281: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

277: | |
278: +===========================================================================*/
279: PROCEDURE val_args_add_or_rm_remit_rec(
280: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
281: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
282: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
283: p_remittance_bank_account_id IN
284: ar_cash_receipts.remit_bank_acct_use_id%type,
285: p_maturity_date IN

Line 286: ar_payment_schedules.due_date%TYPE,

282: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
283: p_remittance_bank_account_id IN
284: ar_cash_receipts.remit_bank_acct_use_id%type,
285: p_maturity_date IN
286: ar_payment_schedules.due_date%TYPE,
287: p_batch_id IN NUMBER ) IS
288:
289: cr_type ar_cash_receipts.type%TYPE;
290:

Line 333: p_due_date_low IN ar_payment_schedules.due_date%TYPE,

329: PROCEDURE create_remit_batch_conc_req( p_create_flag IN VARCHAR2,
330: p_approve_flag IN VARCHAR2,
331: p_format_flag IN VARCHAR2,
332: p_batch_id IN ar_batches.batch_id%TYPE,
333: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
334: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
335: p_receipt_date_low IN ar_cash_receipts.receipt_date%TYPE,
336: p_receipt_date_high IN ar_cash_receipts.receipt_date%TYPE,
337: p_receipt_number_low IN ar_cash_receipts.receipt_number%TYPE,

Line 334: p_due_date_high IN ar_payment_schedules.due_date%TYPE,

330: p_approve_flag IN VARCHAR2,
331: p_format_flag IN VARCHAR2,
332: p_batch_id IN ar_batches.batch_id%TYPE,
333: p_due_date_low IN ar_payment_schedules.due_date%TYPE,
334: p_due_date_high IN ar_payment_schedules.due_date%TYPE,
335: p_receipt_date_low IN ar_cash_receipts.receipt_date%TYPE,
336: p_receipt_date_high IN ar_cash_receipts.receipt_date%TYPE,
337: p_receipt_number_low IN ar_cash_receipts.receipt_number%TYPE,
338: p_receipt_number_high IN ar_cash_receipts.receipt_number%TYPE,

Line 740: p_due_date_low IN ar_payment_schedules.due_date%TYPE,

736: PROCEDURE create_auto_batch_conc_req( p_create_flag IN VARCHAR2,
737: p_approve_flag IN VARCHAR2,
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,

Line 741: p_due_date_high IN ar_payment_schedules.due_date%TYPE,

737: p_approve_flag IN VARCHAR2,
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,

Line 963: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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,
967: p_customer_bank_account_id IN

Line 965: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,

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,
967: p_customer_bank_account_id IN
968: ra_customer_trx.customer_bank_account_id%TYPE,
969: p_module_name IN VARCHAR2,

Line 972: l_ps_rec ar_payment_schedules%ROWTYPE;

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';
976: --

Line 1060: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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