38: ---------------------------------------------------------------------------
39:
40: TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
41: amount NUMBER := okl_api.g_miss_num,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
43: customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44: customer_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46: receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47: exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48: exchange_rate NUMBER := okl_api.g_miss_num,
49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
50: remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,
52: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
55: receipt_method_id NUMBER := okl_api.g_miss_num,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
56: org_id NUMBER := okl_api.g_miss_num,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
57: gl_date DATE := okl_api.g_miss_date,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
58: dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
59: dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
60: dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
61: dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
62: dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
63: dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
64: dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
65: dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
66: dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
67: dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
68: dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num
69: dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70: dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71: dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72: dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73: dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74: create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num
77: );