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_CAP_ADV_MON_PVT dependencies on OKL_TRX_CSH_RECEIPT_V

Line 39: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT lp_adv_rcpt_rec.customer_id;

35: -- DECLARE Local Variables
36: ---------------------------
37: lp_adv_rcpt_rec adv_rcpt_rec := p_adv_rcpt_rec;
38:
39: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT lp_adv_rcpt_rec.customer_id;
40: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT lp_adv_rcpt_rec.customer_num;
41:
42: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT lp_adv_rcpt_rec.contract_id;
43: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;

Line 48: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_type;

44: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.contract_num;
45: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
46: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
47: --
48: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_type;
49: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_date;
50: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_rate;
51: --
52: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

Line 49: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_date;

45: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
46: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
47: --
48: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_type;
49: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_date;
50: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_rate;
51: --
52: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
53: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

Line 50: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_rate;

46: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
47: --
48: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_type;
49: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_date;
50: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT lp_adv_rcpt_rec.currency_conv_rate;
51: --
52: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
53: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
54: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;

Line 55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

51: --
52: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
53: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
54: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;

Line 56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

52: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
53: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
54: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;

Line 57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;

53: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
54: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;

Line 58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id

54: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;

Line 59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;

55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;

56: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;

Line 61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;

57: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT lp_adv_rcpt_rec.currency_code;
58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;

Line 62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;

58: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT lp_adv_rcpt_rec.irm_id; -- receipt method id
59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;

Line 63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

59: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT lp_adv_rcpt_rec.check_number;
60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;
67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;

Line 64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;

60: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;
67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;
68: l_expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.expired_flag;

Line 65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;

61: l_rcpt_type OKL_TRX_CSH_RECEIPT_V.RECEIPT_TYPE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_type;
62: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT lp_adv_rcpt_rec.rcpt_amount;
63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;
67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;
68: l_expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.expired_flag;
69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;

63: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;
67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;
68: l_expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.expired_flag;
69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
70: l_receivables_invoice_num NUMBER DEFAULT NULL;
71:

Line 68: l_expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.expired_flag;

64: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT lp_adv_rcpt_rec.receipt_date;
65: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT lp_adv_rcpt_rec.gl_date;
66: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT lp_adv_rcpt_rec.comments;
67: l_fully_applied_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.fully_applied_flag;
68: l_expired_flag OKL_TRX_CSH_RECEIPT_V.EXPIRED_FLAG%TYPE DEFAULT lp_adv_rcpt_rec.expired_flag;
69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
70: l_receivables_invoice_num NUMBER DEFAULT NULL;
71:
72: l_over_pay VARCHAR(1) := 'O';

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

74: l_prorate CONSTANT VARCHAR2(3) := 'PRO';
75: l_start_date DATE;
76: l_same_cash_app_rule VARCHAR(1) DEFAULT NULL;
77: l_same_date VARCHAR(1) DEFAULT NULL;
78: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
79:
80: i NUMBER DEFAULT NULL;
81: d NUMBER DEFAULT NULL;
82: t NUMBER DEFAULT NULL;

Line 173: FROM OKL_TRX_CSH_RECEIPT_V

169: ,cp_check_num IN VARCHAR2
170: ,cp_receipt_date IN DATE
171: ) IS
172: SELECT '1'
173: FROM OKL_TRX_CSH_RECEIPT_V
174: WHERE ile_id = cp_customer_id
175: AND check_number = cp_check_num
176: AND TRUNC(date_effective) = TRUNC(cp_receipt_date);
177:

Line 186: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

182: ,cp_check_num IN VARCHAR2
183: ,cp_amount IN NUMBER
184: ,cp_contract_id IN NUMBER) IS
185: SELECT a.id, b.id
186: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
187: WHERE a.id = b.rct_id_details
188: AND a.ile_id = cp_customer_id
189: AND a.check_number = cp_check_num
190: AND a.amount = cp_amount