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.OKL_RECEIPTS_PVT dependencies on AR_CASH_RECEIPTS

Line 7: receipt_currency_code AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE ,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rcpt_curr_conv_rec_type IS RECORD (
7: receipt_currency_code AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE ,
8: receipt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE ,
9: currency_conv_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE ,
10: currency_conv_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE ,
11: currency_conv_rate NUMBER ,

Line 8: receipt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE ,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rcpt_curr_conv_rec_type IS RECORD (
7: receipt_currency_code AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE ,
8: receipt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE ,
9: currency_conv_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE ,
10: currency_conv_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE ,
11: currency_conv_rate NUMBER ,
12: x_return_status VARCHAR2(1)

Line 9: currency_conv_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE ,

5: ---------------------------------------------------------------------------
6: TYPE rcpt_curr_conv_rec_type IS RECORD (
7: receipt_currency_code AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE ,
8: receipt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE ,
9: currency_conv_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE ,
10: currency_conv_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE ,
11: currency_conv_rate NUMBER ,
12: x_return_status VARCHAR2(1)
13: );

Line 10: currency_conv_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE ,

6: TYPE rcpt_curr_conv_rec_type IS RECORD (
7: receipt_currency_code AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE ,
8: receipt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE ,
9: currency_conv_date AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE ,
10: currency_conv_type AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE ,
11: currency_conv_rate NUMBER ,
12: x_return_status VARCHAR2(1)
13: );
14:

Line 38: FROM ar_Cash_receipts_all cr, ar_cash_receipt_history_all crh

34: cr.currency_code,
35: cr.receipt_number,
36: cr.receipt_date,
37: crh.gl_date
38: FROM ar_Cash_receipts_all cr, ar_cash_receipt_history_all crh
39: where cr.cash_Receipt_id = cp_cash_receipt_id
40: and cr.cash_receipt_id = crh.cash_receipt_id
41: and crh.current_record_flag = 'Y';
42: BEGIN

Line 170: FROM AR_CASH_RECEIPTS_ALL

166: l_cash_receipt_flag NUMBER DEFAULT NULL;
167:
168: CURSOR csr_validate_cash_rcpt_id(l_cash_rcpt_id IN NUMBER) IS
169: SELECT '1'
170: FROM AR_CASH_RECEIPTS_ALL
171: WHERE cash_receipt_id = l_cash_rcpt_id;
172:
173: BEGIN
174: OPEN csr_validate_cash_rcpt_id(p_cash_receipt_id);

Line 325: l_rcpt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE DEFAULT p_curr_conv_rec.receipt_date;

321: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
322: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_curr_conv_rec.receipt_currency_code;
323: x_rcpt_curr_conv_rec rcpt_curr_conv_rec_type;
324: l_return_status VARCHAR2(1);
325: l_rcpt_date AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE DEFAULT p_curr_conv_rec.receipt_date;
326:
327: BEGIN
328: log_debug('validate_currency_conv_params start');
329: l_functional_currency := okl_accounting_util.get_func_curr_code;

Line 537: l_invoice_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;

533: l_rcpt_amount NUMBER DEFAULT 0;
534:
535: -- added by dcshanmu for 6326279. Cross currency conversions begins
536: l_rcpt_date DATE DEFAULT NULL;
537: l_invoice_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
538: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
539: l_conversion_rate NUMBER DEFAULT 0;
540: l_converted_receipt_amount NUMBER DEFAULT 0;
541: l_receipt_amount NUMBER DEFAULT 0;

Line 538: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;

534:
535: -- added by dcshanmu for 6326279. Cross currency conversions begins
536: l_rcpt_date DATE DEFAULT NULL;
537: l_invoice_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
538: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
539: l_conversion_rate NUMBER DEFAULT 0;
540: l_converted_receipt_amount NUMBER DEFAULT 0;
541: l_receipt_amount NUMBER DEFAULT 0;
542:

Line 545: from ar_cash_receipts_all

541: l_receipt_amount NUMBER DEFAULT 0;
542:
543: CURSOR c_fetch_receipt_date(p_cash_rcpt_id IN NUMBER) IS
544: select receipt_date
545: from ar_cash_receipts_all
546: where cash_receipt_id=p_cash_rcpt_id;
547:
548: CURSOR c_fetch_inv_currency(p_customer_trx_line_id IN NUMBER) IS
549: select b.INVOICE_CURRENCY_CODE

Line 557: from ar_cash_receipts_all

553: and a.customer_trx_id = b.customer_trx_id;
554:
555: CURSOR c_fetch_receipt_currency(p_cash_rcpt_id IN NUMBER) IS
556: select currency_code
557: from ar_cash_receipts_all
558: where cash_receipt_id=p_cash_rcpt_id;
559:
560: -- added by dcshanmu for 6326279. Cross currency conversions ends
561:

Line 578: FROM ar_Cash_Receipts_All rcpt_Line

574: AND onAcc_Line.Application_Type = 'CASH';
575:
576: CURSOR c_get_rcpt_amount(p_cash_receipt_id IN NUMBER) IS
577: SELECT Nvl(SUM(rcpt_Line.Amount),0)
578: FROM ar_Cash_Receipts_All rcpt_Line
579: WHERE rcpt_Line.Cash_Receipt_Id = p_cash_receipt_id;
580:
581: CURSOR c_get_orig_freight_amount(p_customer_trx_id IN NUMBER) IS
582: SELECT NVL(SUM(AMOUNT_DUE_ORIGINAL),0)

Line 783: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

779: l_return_status VARCHAR2(1);
780: l_msg_count NUMBER;
781: l_msg_data VARCHAR2(2000);
782: l_api_name CONSTANT VARCHAR2(30) := 'create_unapplied_receipt';
783: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
784: l_rcpt_rec RCPT_REC_TYPE;
785: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
786: BEGIN
787: l_return_status := okl_api.start_activity(l_api_name,

Line 912: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

908: l_return_status VARCHAR2(1);
909: l_msg_count NUMBER;
910: l_msg_data VARCHAR2(2000);
911: l_api_name CONSTANT VARCHAR2(30) := 'create_onaccount_receipt';
912: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
913: l_rcpt_rec RCPT_REC_TYPE;
914: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
915: BEGIN
916: log_debug('create_onaccount_receipt start ');

Line 1022: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id

1018: ,x_return_status OUT NOCOPY VARCHAR2
1019: ,x_msg_count OUT NOCOPY NUMBER
1020: ,x_msg_data OUT NOCOPY VARCHAR2
1021: ,p_customer_trx_id IN NUMBER DEFAULT NULL -- cash receipt id
1022: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
1023: ,p_org_id IN NUMBER
1024: ) IS
1025:
1026: ---------------------------

Line 1038: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;

1034: l_msg_data VARCHAR2(2000);
1035: l_api_name CONSTANT VARCHAR2(30) := 'unapply_receipt';
1036:
1037: l_customer_trx_id NUMBER DEFAULT p_customer_trx_id;
1038: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1039: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1040: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1041: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1042: i NUMBER DEFAULT NULL;

Line 1154: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE

1150: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1151: ,x_return_status OUT NOCOPY VARCHAR2
1152: ,x_msg_count OUT NOCOPY NUMBER
1153: ,x_msg_data OUT NOCOPY VARCHAR2
1154: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE
1155: ,p_customer_trx_id IN NUMBER
1156: ,p_freight_amount IN NUMBER
1157: ,p_charges_amount IN NUMBER
1158: ,p_llca_tbl IN llca_tbl_type

Line 1178: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;

1174: l_msg_data VARCHAR2(2000);
1175: l_api_name CONSTANT VARCHAR2(30) := 'apply_receipt';
1176:
1177: l_customer_trx_id NUMBER DEFAULT p_customer_trx_id;
1178: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1179: l_llca_tbl llca_tbl_type := p_llca_tbl;
1180: l_ar_llca_tbl ar_receipt_api_pub.llca_trx_lines_tbl_type;
1181: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1182: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;

Line 1199: from ar_cash_receipts_all

1195:
1196: -- added by dcshanmu for cross currency conversion as part of 6326279.Begin
1197: CURSOR c_fetch_receipt_date(p_cash_rcpt_id IN NUMBER) IS
1198: select receipt_date
1199: from ar_cash_receipts_all
1200: where cash_receipt_id=p_cash_rcpt_id;
1201:
1202: CURSOR c_fetch_inv_due_date(p_customer_trx_id IN NUMBER) IS
1203: select a.due_date

Line 1429: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE

1425: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1426: ,x_return_status OUT NOCOPY VARCHAR2
1427: ,x_msg_count OUT NOCOPY NUMBER
1428: ,x_msg_data OUT NOCOPY VARCHAR2
1429: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE
1430: ,p_org_id IN NUMBER
1431: ,p_original_onacc_amount IN NUMBER
1432: ,p_apply_onacc_amount IN NUMBER
1433: ,p_receipt_date IN DATE

Line 1448: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;

1444: l_msg_count NUMBER;
1445: l_msg_data VARCHAR2(2000);
1446: l_api_name CONSTANT VARCHAR2(30) := 'handle_onacc_update';
1447:
1448: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1449: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1450: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
1451: l_org_id NUMBER := p_org_id;
1452: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 1610: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;

1606: l_msg_data VARCHAR2(2000);
1607: l_api_name CONSTANT VARCHAR2(30) := 'handle_receipt';
1608: l_onacc_appplication_id NUMBER;
1609:
1610: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;
1611: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;
1612: l_header_count NUMBER;
1613: l_line_counter NUMBER;
1614: l_select_yn VARCHAR2(1);

Line 1611: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;

1607: l_api_name CONSTANT VARCHAR2(30) := 'handle_receipt';
1608: l_onacc_appplication_id NUMBER;
1609:
1610: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;
1611: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT p_rcpt_rec.cash_receipt_id;
1612: l_header_count NUMBER;
1613: l_line_counter NUMBER;
1614: l_select_yn VARCHAR2(1);
1615: l_final_count NUMBER;

Line 1619: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;

1615: l_final_count NUMBER;
1616: l_call_apply BOOLEAN;
1617: l_call_unapply BOOLEAN;
1618:
1619: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;
1620: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1621: l_org_id NUMBER:= p_rcpt_rec.org_id;
1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;

Line 1699: FROM ar_Cash_receipts_all

1695: AND ROWNUM = 1;
1696:
1697: CURSOR get_rcpt_sts(cp_cash_receipt_id IN NUMBER) IS
1698: SELECT status
1699: FROM ar_Cash_receipts_all
1700: WHERE cash_receipt_id = cp_cash_receipt_id;
1701:
1702: CURSOR c_fetch_inv_currency (p_customer_trx_id IN NUMBER) IS
1703: SELECT a.invoice_currency_code