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_BPD_MAN_RCT_HANDLE_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 41: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id

37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ,p_xcav_tbl IN xcav_tbl_type
41: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
42: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
43: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
44: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
45: ) IS

Line 42: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE

38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ,p_xcav_tbl IN xcav_tbl_type
41: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
42: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
43: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
44: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
45: ) IS
46:

Line 43: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL

39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ,p_xcav_tbl IN xcav_tbl_type
41: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
42: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
43: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
44: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
45: ) IS
46:
47: ---------------------------

Line 44: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

40: ,p_xcav_tbl IN xcav_tbl_type
41: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
42: ,p_receipt_amount IN AR_CASH_RECEIPTS_ALL.AMOUNT%TYPE
43: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
44: ,p_receipt_currency IN AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
45: ) IS
46:
47: ---------------------------
48: -- DECLARE Local Variables

Line 62: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

58: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
59:
60: l_receipt_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL;
61: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL;
62: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
63: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
64: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
65:
66: l_xcr_id NUMBER;

Line 69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

65:
66: l_xcr_id NUMBER;
67:
68: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
70:
71: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
72:
73: l_init_on_acc_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

Line 145: CURSOR c_get_rcpt_details(cp_cash_rcpt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE) IS

141: where gl_date is not null
142: order by counter;
143: -------------------------------------------------------------------------------
144: -- Get the receipt information
145: CURSOR c_get_rcpt_details(cp_cash_rcpt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE) IS
146: SELECT
147: RCT.CHECK_NUMBER RECEIPT_NUMBER
148: , RCT.RECEIPT_TYPE
149: , RCT.AMOUNT

Line 632: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id

628: ,x_return_status OUT NOCOPY VARCHAR2
629: ,x_msg_count OUT NOCOPY NUMBER
630: ,x_msg_data OUT NOCOPY VARCHAR2
631: ,p_xcav_tbl IN xcav_tbl_type
632: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
633: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
634: ) IS
635:
636: ---------------------------

Line 633: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL

629: ,x_msg_count OUT NOCOPY NUMBER
630: ,x_msg_data OUT NOCOPY VARCHAR2
631: ,p_xcav_tbl IN xcav_tbl_type
632: ,p_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL -- cash receipt id
633: ,p_receipt_date IN AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL
634: ) IS
635:
636: ---------------------------
637: -- DECLARE Local Variables

Line 649: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;

645: l_api_name CONSTANT VARCHAR2(30) := 'man_receipt_unapply';
646:
647: l_receipt_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL;
648: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL;
649: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
650: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
651: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
652: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
653: l_total_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

Line 660: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;

656: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
657:
658: l_xcr_id NUMBER;
659: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
660: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
661:
662: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
663: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
664: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 685: CURSOR c_get_rcpt_details(cp_cash_rcpt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE) IS

681: -------------------------------------------------------------------------------
682: -- DEFINE CURSORS
683: -------------------------------------------------------------------------------
684: -- Get the receipt information
685: CURSOR c_get_rcpt_details(cp_cash_rcpt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE) IS
686: SELECT
687: RCT.CHECK_NUMBER RECEIPT_NUMBER
688: , RCT.RECEIPT_TYPE
689: , RCT.AMOUNT