DBA Data[Home] [Help]

APPS.OKL_RECEIPTS_PVT dependencies on AR_CASH_RECEIPTS

Line 42: currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,

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,

Line 45: receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,

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,

Line 46: receipt_date ar_cash_receipts.receipt_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,

Line 47: exchange_rate_type ar_cash_receipts.exchange_rate_type%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,
51: customer_bank_account_id NUMBER := okl_api.g_miss_num,

Line 49: exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,

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,

Line 54: payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,

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,

Line 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,

Line 59: dff_attribute1 ar_cash_receipts.attribute1%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,

Line 60: dff_attribute2 ar_cash_receipts.attribute2%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,

Line 61: dff_attribute3 ar_cash_receipts.attribute3%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,

Line 62: dff_attribute4 ar_cash_receipts.attribute4%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,

Line 63: dff_attribute5 ar_cash_receipts.attribute5%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,

Line 64: dff_attribute6 ar_cash_receipts.attribute6%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,

Line 65: dff_attribute7 ar_cash_receipts.attribute7%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,

Line 66: dff_attribute8 ar_cash_receipts.attribute8%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,

Line 67: dff_attribute9 ar_cash_receipts.attribute9%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,

Line 68: dff_attribute10 ar_cash_receipts.attribute10%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,

Line 69: dff_attribute11 ar_cash_receipts.attribute11%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,

Line 70: dff_attribute12 ar_cash_receipts.attribute12%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'

Line 71: dff_attribute13 ar_cash_receipts.attribute13%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'
75: p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application

Line 72: dff_attribute14 ar_cash_receipts.attribute14%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
76: p_apply_onacc_amount NUMBER := okl_api.g_miss_num

Line 73: dff_attribute15 ar_cash_receipts.attribute15%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
77: );