4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: /* -- history tables not supported -- 04 APR 2002
8: TYPE okl_cash_allctn_rls_h_rec_type IS RECORD (
9: id NUMBER := Okl_Api.G_MISS_NUM,
10: major_version NUMBER := Okl_Api.G_MISS_NUM,
11: name OKL_CASH_ALLCTN_RLS_H.NAME%TYPE := Okl_Api.G_MISS_CHAR,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
7: /* -- history tables not supported -- 04 APR 2002
8: TYPE okl_cash_allctn_rls_h_rec_type IS RECORD (
9: id NUMBER := Okl_Api.G_MISS_NUM,
10: major_version NUMBER := Okl_Api.G_MISS_NUM,
11: name OKL_CASH_ALLCTN_RLS_H.NAME%TYPE := Okl_Api.G_MISS_CHAR,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: description OKL_CASH_ALLCTN_RLS_H.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
14: amount_tolerance_percent NUMBER, -- := Okl_Api.G_MISS_NUM,
15: days_past_quote_valid_toleranc NUMBER, -- := Okl_Api.G_MISS_NUM,
9: id NUMBER := Okl_Api.G_MISS_NUM,
10: major_version NUMBER := Okl_Api.G_MISS_NUM,
11: name OKL_CASH_ALLCTN_RLS_H.NAME%TYPE := Okl_Api.G_MISS_CHAR,
12: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
13: description OKL_CASH_ALLCTN_RLS_H.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
14: amount_tolerance_percent NUMBER, -- := Okl_Api.G_MISS_NUM,
15: days_past_quote_valid_toleranc NUMBER, -- := Okl_Api.G_MISS_NUM,
16: months_to_bill_ahead NUMBER, -- := Okl_Api.G_MISS_NUM,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
13: description OKL_CASH_ALLCTN_RLS_H.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
14: amount_tolerance_percent NUMBER, -- := Okl_Api.G_MISS_NUM,
15: days_past_quote_valid_toleranc NUMBER, -- := Okl_Api.G_MISS_NUM,
16: months_to_bill_ahead NUMBER, -- := Okl_Api.G_MISS_NUM,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14: amount_tolerance_percent NUMBER, -- := Okl_Api.G_MISS_NUM,
15: days_past_quote_valid_toleranc NUMBER, -- := Okl_Api.G_MISS_NUM,
16: months_to_bill_ahead NUMBER, -- := Okl_Api.G_MISS_NUM,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15: days_past_quote_valid_toleranc NUMBER, -- := Okl_Api.G_MISS_NUM,
16: months_to_bill_ahead NUMBER, -- := Okl_Api.G_MISS_NUM,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16: months_to_bill_ahead NUMBER, -- := Okl_Api.G_MISS_NUM,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17: under_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18: over_payment_allocation_code OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute_category OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute1 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute2 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute3 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute4 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute5 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute6 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute7 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute8 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
29: attribute9 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30: attribute10 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31: attribute11 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32: attribute12 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
39: last_update_date OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
33: attribute13 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34: attribute14 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
39: last_update_date OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
41: GMissOklCashAllctnRlsHRec okl_cash_allctn_rls_h_rec_type;
35: attribute15 OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36: created_by NUMBER := Okl_Api.G_MISS_NUM,
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
39: last_update_date OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
41: GMissOklCashAllctnRlsHRec okl_cash_allctn_rls_h_rec_type;
42: TYPE okl_cash_allctn_rls_h_tbl_type IS TABLE OF okl_cash_allctn_rls_h_rec_type
43: INDEX BY BINARY_INTEGER;
37: creation_date OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
39: last_update_date OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
41: GMissOklCashAllctnRlsHRec okl_cash_allctn_rls_h_rec_type;
42: TYPE okl_cash_allctn_rls_h_tbl_type IS TABLE OF okl_cash_allctn_rls_h_rec_type
43: INDEX BY BINARY_INTEGER;
44: */
45: TYPE cat_rec_type IS RECORD (
38: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
39: last_update_date OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
40: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
41: GMissOklCashAllctnRlsHRec okl_cash_allctn_rls_h_rec_type;
42: TYPE okl_cash_allctn_rls_h_tbl_type IS TABLE OF okl_cash_allctn_rls_h_rec_type
43: INDEX BY BINARY_INTEGER;
44: */
45: TYPE cat_rec_type IS RECORD (
46: id NUMBER := Okl_Api.G_MISS_NUM,
43: INDEX BY BINARY_INTEGER;
44: */
45: TYPE cat_rec_type IS RECORD (
46: id NUMBER := Okl_Api.G_MISS_NUM,
47: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
48: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
49: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
50: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
45: TYPE cat_rec_type IS RECORD (
46: id NUMBER := Okl_Api.G_MISS_NUM,
47: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
48: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
49: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
50: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
52: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
46: id NUMBER := Okl_Api.G_MISS_NUM,
47: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
48: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
49: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
50: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
52: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
47: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
48: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
49: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
50: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
52: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
51: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
52: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
52: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
53: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
54: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
55: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
56: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
57: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
58: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
59: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
60: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
61: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
62: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
63: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
68: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
69: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
77: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
70: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
77: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
78: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
71: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
77: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
78: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
79: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
77: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
78: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
79: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
80: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
81: CAU_ID NUMBER := Okl_Api.G_MISS_NUM,
75: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76: created_by NUMBER := Okl_Api.G_MISS_NUM,
77: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
78: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
79: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
80: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
81: CAU_ID NUMBER := Okl_Api.G_MISS_NUM,
82: -- new column to hold number of days to reserve advanced payment for contract.
83: num_days_hold_adv_pay NUMBER := Okl_Api.G_MISS_NUM );
86: INDEX BY BINARY_INTEGER;
87: TYPE catv_rec_type IS RECORD (
88: id NUMBER := Okl_Api.G_MISS_NUM,
89: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
90: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
91: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
87: TYPE catv_rec_type IS RECORD (
88: id NUMBER := Okl_Api.G_MISS_NUM,
89: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
90: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
91: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
88: id NUMBER := Okl_Api.G_MISS_NUM,
89: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
90: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
91: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
89: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
90: name OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
91: description OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92: start_date OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
93: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: end_date OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
94: amount_tolerance_percent NUMBER := Okl_Api.G_MISS_NUM,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
95: days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
96: months_to_bill_ahead NUMBER := Okl_Api.G_MISS_NUM,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
97: under_payment_allocation_code OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
98: over_payment_allocation_code OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
99: receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
100: default_rule OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
101: attribute_category OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
102: attribute1 OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
103: attribute2 OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
104: attribute3 OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
105: attribute4 OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
106: attribute5 OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
107: attribute6 OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
108: attribute7 OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
109: attribute8 OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
110: attribute9 OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
111: attribute10 OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
112: attribute11 OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
113: attribute12 OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute13 OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
115: attribute14 OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute15 OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
123: CAU_ID NUMBER := Okl_Api.G_MISS_NUM,
117: org_id OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118: created_by NUMBER := Okl_Api.G_MISS_NUM,
119: creation_date OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121: last_update_date OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
123: CAU_ID NUMBER := Okl_Api.G_MISS_NUM,
124: -- new column to hold number of days to reserve advanced payment for contract.
125: num_days_hold_adv_pay NUMBER := Okl_Api.G_MISS_NUM );
159: ---------------------------------------------------------------------------
160: ---------------------------------------------------------------------------
161: -- GLOBAL VARIABLES
162: ---------------------------------------------------------------------------
163: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CASH_ALLCTN_RLS';
164: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CAT_PVT';
165: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
166: ---------------------------------------------------------------------------
167: -- Procedures and Functions