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_ALL

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 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 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 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