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 OKL_TRX_CSH_RECEIPT_V

Line 60: l_receipt_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL;

56: l_api_name CONSTANT VARCHAR2(30) := 'man_receipt_apply';
57:
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;

Line 61: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL;

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

Line 63: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

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;
67:

Line 64: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
67:
68: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

Line 71: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code

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;
74: l_tot_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT 0;
75: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

Line 86: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

82: l_remaining_amt NUMBER DEFAULT NULL;
83:
84: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
85:
86: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
87: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
88:
89: i NUMBER DEFAULT NULL;
90: l_exit_loop NUMBER DEFAULT 0;

Line 87: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

83:
84: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
85:
86: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
87: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
88:
89: i NUMBER DEFAULT NULL;
90: l_exit_loop NUMBER DEFAULT 0;
91:

Line 96: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

92: l_counter NUMBER;
93: l_unapply VARCHAR2(3);
94:
95: l_record_count NUMBER DEFAULT NULL;
96: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
97: l_chk_on_acc_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
98: l_apply_amt_error_flag BOOLEAN := FALSE;
99: -------------------------------------------------------------------------------
100: -- DECLARE Record/Table Types

Line 152: OKL_TRX_CSH_RECEIPT_V RCT

148: , RCT.RECEIPT_TYPE
149: , RCT.AMOUNT
150: , NULL ID
151: FROM
152: OKL_TRX_CSH_RECEIPT_V RCT
153: -- , OKL_EXT_CSH_RCPTS_V XCR
154: WHERE
155: -- XCR.RCT_ID = RCT.ID
156: -- AND XCR.ICR_ID = cp_cash_rcpt_id;

Line 647: l_receipt_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL;

643: l_msg_count NUMBER;
644: l_msg_data VARCHAR2(2000);
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;

Line 648: l_receipt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT NULL;

644: l_msg_data VARCHAR2(2000);
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;

Line 650: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;
654: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code

Line 651: l_receipt_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

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;
654: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
655: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

Line 654: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code

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;
654: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
655: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
656: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
657:
658: l_xcr_id NUMBER;

Line 663: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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;
665: i NUMBER DEFAULT NULL;
666: l_counter NUMBER;
667: l_record_count NUMBER DEFAULT NULL;

Line 664: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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;
665: i NUMBER DEFAULT NULL;
666: l_counter NUMBER;
667: l_record_count NUMBER DEFAULT NULL;
668: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 668: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

664: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
665: i NUMBER DEFAULT NULL;
666: l_counter NUMBER;
667: l_record_count NUMBER DEFAULT NULL;
668: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
669:
670: -------------------------------------------------------------------------------
671: -- DECLARE Record/Table Types
672: -------------------------------------------------------------------------------

Line 693: OKL_TRX_CSH_RECEIPT_V RCT

689: , RCT.AMOUNT
690: , NULL ID
691: ,RCT.CURRENCY_CODE
692: FROM
693: OKL_TRX_CSH_RECEIPT_V RCT
694: -- , OKL_EXT_CSH_RCPTS_V XCR
695: WHERE
696: -- XCR.RCT_ID = RCT.ID
697: -- AND XCR.ICR_ID = cp_cash_rcpt_id;