DBA Data[Home] [Help]

APPS.ARP_PROCESS_BOE dependencies on AR_CASH_RECEIPTS

Line 14: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

10: l_actual_count_total NUMBER;
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,

Line 18: ar_cash_receipts.remit_bank_acct_use_id%type,

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
20: ar_payment_schedules.due_date%TYPE,
21: p_batch_id IN NUMBER );
22:

Line 89: | factor_discount_amount of ar_cash_receipts |

85: | 11/20/1995 - The procedure now calls the conc. request to start |
86: | approval or formatting of a batch if need be |
87: | depending on the p_call_conc_req flag |
88: | 07/11/1996 OSTEINME Changed code to store bank charges in |
89: | factor_discount_amount of ar_cash_receipts |
90: | table instead of cash_receipt_history table. |
91: | (bug 376326) |
92: | |
93: +===========================================================================*/

Line 95: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

91: | (bug 376326) |
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,

Line 99: ar_cash_receipts.selected_remittance_batch_id%TYPE,

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
101: ar_cash_receipts.remit_bank_acct_use_id%type,
102: p_override_remit_account_flag IN
103: ar_cash_receipts.override_remit_account_flag%TYPE,

Line 101: ar_cash_receipts.remit_bank_acct_use_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
101: ar_cash_receipts.remit_bank_acct_use_id%type,
102: p_override_remit_account_flag IN
103: ar_cash_receipts.override_remit_account_flag%TYPE,
104: p_customer_bank_account_id IN
105: ar_cash_receipts.customer_bank_account_id%TYPE,

Line 103: ar_cash_receipts.override_remit_account_flag%TYPE,

99: ar_cash_receipts.selected_remittance_batch_id%TYPE,
100: p_remittance_bank_account_id IN
101: ar_cash_receipts.remit_bank_acct_use_id%type,
102: p_override_remit_account_flag IN
103: ar_cash_receipts.override_remit_account_flag%TYPE,
104: p_customer_bank_account_id IN
105: ar_cash_receipts.customer_bank_account_id%TYPE,
106: p_bank_charges IN
107: ar_cash_receipt_history.factor_discount_amount%TYPE,

Line 105: ar_cash_receipts.customer_bank_account_id%TYPE,

101: ar_cash_receipts.remit_bank_acct_use_id%type,
102: p_override_remit_account_flag IN
103: ar_cash_receipts.override_remit_account_flag%TYPE,
104: p_customer_bank_account_id IN
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,

Line 116: l_cr_rec ar_cash_receipts%ROWTYPE;

112: p_control_amount IN NUMBER,
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: --

Line 280: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

276: | conc. req flag is set to 'Y' |
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,

Line 284: ar_cash_receipts.remit_bank_acct_use_id%type,

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
286: ar_payment_schedules.due_date%TYPE,
287: p_batch_id IN NUMBER ) IS
288:

Line 289: cr_type ar_cash_receipts.type%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:
291: BEGIN
292: IF PG_DEBUG in ('Y', 'C') THEN
293: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_remit_rec() +');

Line 308: SELECT type INTO cr_type FROM ar_cash_receipts WHERE cash_receipt_id = p_cr_id;

304: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
305: APP_EXCEPTION.raise_exception;
306: END IF;
307:
308: SELECT type INTO cr_type FROM ar_cash_receipts WHERE cash_receipt_id = p_cr_id;
309:
310: IF (cr_type = 'CASH' AND p_ps_id is NULL) THEN
311:
312: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 335: p_receipt_date_low IN ar_cash_receipts.receipt_date%TYPE,

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,
339: p_document_number_low IN NUMBER,

Line 336: p_receipt_date_high IN ar_cash_receipts.receipt_date%TYPE,

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,
339: p_document_number_low IN NUMBER,
340: p_document_number_high IN NUMBER,

Line 337: p_receipt_number_low IN ar_cash_receipts.receipt_number%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,
339: p_document_number_low IN NUMBER,
340: p_document_number_high IN NUMBER,
341: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,

Line 338: p_receipt_number_high IN ar_cash_receipts.receipt_number%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,
339: p_document_number_low IN NUMBER,
340: p_document_number_high IN NUMBER,
341: p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
342: p_customer_number_high IN hz_cust_accounts.account_number%TYPE,