DBA Data[Home] [Help]

APPS.OKL_CASH_RECEIPT dependencies on AR_CASH_RECEIPTS

Line 34: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

30: l_return_status VARCHAR2(1);
31: l_msg_count NUMBER;
32: l_msg_data VARCHAR2(2000);
33:
34: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
35: l_func_amount_applied_tot NUMBER := 0;
36: l_rcpt_amount_applied_tot NUMBER := 0;
37: l_amount_unapplied NUMBER := 0;
38:

Line 42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;

38:
39: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;

Line 43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;

39: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;

Line 44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;

40: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
41:
42: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
43: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
44: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
45:
46: l_over_pay VARCHAR2(1) DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
48: l_counter NUMBER;

Line 438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

434: l_return_status VARCHAR2(1);
435: l_msg_count NUMBER;
436: l_msg_data VARCHAR2(2000);
437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;

Line 440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;

436: l_msg_data VARCHAR2(2000);
437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:

Line 441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;

437:
438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';

Line 442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;

438: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';
446:

Line 443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;

439:
440: l_exchange_rate AR_CASH_RECEIPTS.EXCHANGE_RATE%TYPE := p_rcpt_rec.exchange_rate;
441: l_exchange_rate_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := p_rcpt_rec.exchange_rate_type;
442: l_exchange_rate_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := p_rcpt_rec.exchange_date;
443: l_functional_currency AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE DEFAULT NULL;
444:
445: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECEIPT';
446:
447: -- BEGIN abindal bug 4316610 --

Line 580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

576: l_return_status VARCHAR2(1);
577: l_msg_count NUMBER;
578: l_msg_data VARCHAR2(2000);
579:
580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
581: l_func_amount_applied_tot NUMBER := 0;
582: l_rcpt_amount_applied_tot NUMBER := 0;
583: l_amount_unapplied NUMBER := 0;
584:

Line 588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;

584:
585: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;

Line 589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;

585: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;

Line 590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;

586: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
587:
588: l_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE DEFAULT NULL;
589: l_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL;
590: l_exchange_rate_date AR_CASH_RECEIPTS_ALL.EXCHANGE_DATE%TYPE DEFAULT NULL;
591:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
594: l_counter NUMBER;