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

Line 55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL

51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL

Line 56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL

52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

Line 57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL

Line 58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL

Line 59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL

55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL

Line 60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL

56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL

Line 61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL

57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
59: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

Line 64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL

60: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL

Line 66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL

62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
70: ,p_create_receipt_flag IN VARCHAR2

Line 67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL

63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
70: ,p_create_receipt_flag IN VARCHAR2
71: ) IS

Line 68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL

64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
70: ,p_create_receipt_flag IN VARCHAR2
71: ) IS
72:

Line 77: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_customer_id;

73: ---------------------------
74: -- DECLARE Local Variables
75: ---------------------------
76:
77: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_customer_id;
78: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
79:
80: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT p_cons_bill_id;
81: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT p_cons_bill_num;

Line 90: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;

86: l_contract_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
87: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
88:
89: --
90: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
91: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
92: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
93: --
94:

Line 91: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;

87: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
88:
89: --
90: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
91: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
92: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
93: --
94:
95: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

Line 92: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;

88:
89: --
90: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
91: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;
92: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_currency_conv_rate;
93: --
94:
95: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
96: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

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

94:
95: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
96: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
97: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
98: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;

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

95: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
96: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
97: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
98: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;

Line 100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;

96: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
97: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
98: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;

Line 101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id

97: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
98: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;

98: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);

Line 103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;

99: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;

Line 104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;

100: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code;
101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;

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

101: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_irm_id; -- receipt method id
102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:

Line 106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);

102: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_check_number;
103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:
110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;

103: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:
110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
111: l_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT p_bank_account_id;

Line 111: l_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT p_bank_account_id;

107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:
110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
111: l_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT p_bank_account_id;
112: l_receivables_invoice_num NUMBER DEFAULT NULL;
113:
114: l_over_pay VARCHAR(1) DEFAULT NULL;
115: l_conc_proc VARCHAR(2) DEFAULT p_create_receipt_flag;

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

120: l_same_cash_app_rule VARCHAR(1) DEFAULT NULL;
121: l_same_date VARCHAR(1) DEFAULT NULL;
122:
123:
124: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
125: i NUMBER DEFAULT NULL;
126: d NUMBER DEFAULT NULL;
127: t NUMBER DEFAULT NULL;
128: l_first_prorate_rec NUMBER DEFAULT NULL;

Line 386: FROM OKL_TRX_CSH_RECEIPT_V

382: --,cp_amount IN NUMBER
383: ,cp_receipt_date IN DATE
384: ) IS
385: SELECT '1'
386: FROM OKL_TRX_CSH_RECEIPT_V
387: WHERE ile_id = cp_customer_id
388: AND check_number = cp_check_num
389: -- AND amount = cp_amount
390: AND TRUNC(date_effective) = TRUNC(cp_receipt_date);

Line 400: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

396: ,cp_check_num IN VARCHAR2
397: ,cp_amount IN NUMBER
398: ,cp_cons_bill_id IN NUMBER) IS
399: SELECT a.id, b.id
400: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
401: WHERE a.id = b.rct_id_details
402: AND a.ile_id = cp_customer_id
403: AND a.check_number = cp_check_num
404: AND a.amount = cp_amount

Line 415: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

411: ,cp_check_num IN VARCHAR2
412: ,cp_amount IN NUMBER
413: ,cp_contract_id IN NUMBER) IS
414: SELECT a.id, b.id
415: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
416: WHERE a.id = b.rct_id_details
417: AND a.ile_id = cp_customer_id
418: AND a.check_number = cp_check_num
419: AND a.amount = cp_amount

Line 2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;

2203: ,x_cash_receipt_id OUT NOCOPY NUMBER
2204: ) IS
2205:
2206: l_currency_code okl_k_headers_full_v.currency_code%type;
2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;
2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;
2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;

Line 2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;

2206: l_currency_code okl_k_headers_full_v.currency_code%type;
2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;
2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;
2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;
2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;
2213: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;

Line 2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;

2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;
2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;
2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;
2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;
2213: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;

Line 2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;

2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;
2211: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_rcpt_rec.exchange_date;
2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;
2213: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

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

2212: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT p_rcpt_rec.exchange_rate;
2213: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;

Line 2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;

2213: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

Line 2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;

2214: l_functional_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);

Line 2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;

2215: l_inverse_conversion_rate GL_DAILY_RATES_V.INVERSE_CONVERSION_RATE%TYPE DEFAULT 0;
2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;

Line 2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;

2216: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;

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

2217: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_rcpt_rec.currency_code;
2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
2225: l_dup_rcpt_flag NUMBER DEFAULT NULL;

Line 2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);

2218: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT p_rcpt_rec.receipt_method_id;
2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
2225: l_dup_rcpt_flag NUMBER DEFAULT NULL;
2226: l_api_version NUMBER := 1.0;

Line 2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;

2219: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT p_rcpt_rec.receipt_number;
2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
2225: l_dup_rcpt_flag NUMBER DEFAULT NULL;
2226: l_api_version NUMBER := 1.0;
2227: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

Line 2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;

2220: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_rec.amount;
2221: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
2222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
2223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
2224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
2225: l_dup_rcpt_flag NUMBER DEFAULT NULL;
2226: l_api_version NUMBER := 1.0;
2227: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
2228: l_return_status VARCHAR2(1);