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 996: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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

Line 998: ar_payment_schedules.selected_for_receipt_batch_id%TYPE,

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,
1000: p_customer_bank_account_id IN
1001: ra_customer_trx.customer_bank_account_id%TYPE,
1002: p_module_name IN VARCHAR2,

Line 1005: l_ps_rec ar_payment_schedules%ROWTYPE;

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

Line 1093: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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