4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE asd_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE asd_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
6: ---------------------------------------------------------------------------
7: TYPE asd_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
7: TYPE asd_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
10: tal_id NUMBER := OKC_API.G_MISS_NUM,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
11: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
12: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
13: asset_number OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
14: quantity NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
15: cost NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
16: tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
17: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
18: deprn_method_tax OKL_TXD_ASSETS_B.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
19: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
20: salvage_value NUMBER := OKC_API.G_MISS_NUM,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21: -- added new columns for split asset component
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
22: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
23: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
24: -- end of added new columns for split asset component
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
25: attribute_category OKL_TXD_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
26: attribute1 OKL_TXD_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
27: attribute2 OKL_TXD_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
28: attribute3 OKL_TXD_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
29: attribute4 OKL_TXD_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
30: attribute5 OKL_TXD_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
31: attribute6 OKL_TXD_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
32: attribute7 OKL_TXD_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
33: attribute8 OKL_TXD_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
34: attribute9 OKL_TXD_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: attribute10 OKL_TXD_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: attribute11 OKL_TXD_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: attribute12 OKL_TXD_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
38: attribute13 OKL_TXD_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
39: attribute14 OKL_TXD_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: attribute15 OKL_TXD_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: created_by NUMBER := OKC_API.G_MISS_NUM,
42: creation_date OKL_TXD_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
43: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
50: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
51: -- Multi-Currency Change
44: last_update_date OKL_TXD_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
50: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
51: -- Multi-Currency Change
52:
45: last_update_login NUMBER := OKC_API.G_MISS_NUM,
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
50: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
51: -- Multi-Currency Change
52:
53: g_miss_asd_rec asd_rec_type;
46: -- Multi-Currency Change
47: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
48: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
50: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
51: -- Multi-Currency Change
52:
53: g_miss_asd_rec asd_rec_type;
54: TYPE asd_tbl_type IS TABLE OF asd_rec_type
53: g_miss_asd_rec asd_rec_type;
54: TYPE asd_tbl_type IS TABLE OF asd_rec_type
55: INDEX BY BINARY_INTEGER;
56: TYPE okl_txd_assets_tl_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
54: TYPE asd_tbl_type IS TABLE OF asd_rec_type
55: INDEX BY BINARY_INTEGER;
56: TYPE okl_txd_assets_tl_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
55: INDEX BY BINARY_INTEGER;
56: TYPE okl_txd_assets_tl_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56: TYPE okl_txd_assets_tl_rec_type IS RECORD (
57: id NUMBER := OKC_API.G_MISS_NUM,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57: id NUMBER := OKC_API.G_MISS_NUM,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58: language OKL_TXD_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: source_lang OKL_TXD_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: g_miss_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
60: sfwt_flag OKL_TXD_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: g_miss_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
68: TYPE okl_txd_assets_tl_tbl_type IS TABLE OF okl_txd_assets_tl_rec_type
61: description OKL_TXD_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: g_miss_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
68: TYPE okl_txd_assets_tl_tbl_type IS TABLE OF okl_txd_assets_tl_rec_type
69: INDEX BY BINARY_INTEGER;
62: created_by NUMBER := OKC_API.G_MISS_NUM,
63: creation_date OKL_TXD_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65: last_update_date OKL_TXD_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: g_miss_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
68: TYPE okl_txd_assets_tl_tbl_type IS TABLE OF okl_txd_assets_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE asdv_rec_type IS RECORD (
67: g_miss_okl_txd_assets_tl_rec okl_txd_assets_tl_rec_type;
68: TYPE okl_txd_assets_tl_tbl_type IS TABLE OF okl_txd_assets_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE asdv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
68: TYPE okl_txd_assets_tl_tbl_type IS TABLE OF okl_txd_assets_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE asdv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
69: INDEX BY BINARY_INTEGER;
70: TYPE asdv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
70: TYPE asdv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
74: tal_id NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
75: target_kle_id NUMBER := OKC_API.G_MISS_NUM,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
76: line_detail_number NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
77: asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
78: description OKL_TXD_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
79: quantity NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
80: cost NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
81: tax_book OKL_TXD_ASSETS_V.TAX_BOOK%TYPE := OKC_API.G_MISS_CHAR,
82: life_in_months_tax NUMBER := OKC_API.G_MISS_NUM,
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
83: deprn_method_tax OKL_TXD_ASSETS_V.DEPRN_METHOD_TAX%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
84: deprn_rate_tax NUMBER := OKC_API.G_MISS_NUM,
85: salvage_value NUMBER := OKC_API.G_MISS_NUM,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: -- added new columns for split asset component
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
87: SPLIT_PERCENT NUMBER := OKC_API.G_MISS_NUM,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
88: INVENTORY_ITEM_ID NUMBER := OKC_API.G_MISS_NUM,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
89: -- end of added new columns for split asset component
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
90: attribute_category OKL_TXD_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
91: attribute1 OKL_TXD_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
92: attribute2 OKL_TXD_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
93: attribute3 OKL_TXD_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
94: attribute4 OKL_TXD_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
95: attribute5 OKL_TXD_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
96: attribute6 OKL_TXD_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
97: attribute7 OKL_TXD_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
98: attribute8 OKL_TXD_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
99: attribute9 OKL_TXD_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100: attribute10 OKL_TXD_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
101: attribute11 OKL_TXD_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102: attribute12 OKL_TXD_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
103: attribute13 OKL_TXD_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
104: attribute14 OKL_TXD_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
105: attribute15 OKL_TXD_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: created_by NUMBER := OKC_API.G_MISS_NUM,
107: creation_date OKL_TXD_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
114: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
108: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
114: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
115: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
116: -- Multi-Currency Change
109: last_update_date OKL_TXD_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
114: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
115: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
116: -- Multi-Currency Change
117: g_miss_asdv_rec asdv_rec_type;
110: last_update_login NUMBER := OKC_API.G_MISS_NUM,
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
114: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
115: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
116: -- Multi-Currency Change
117: g_miss_asdv_rec asdv_rec_type;
118: TYPE asdv_tbl_type IS TABLE OF asdv_rec_type
111: -- Multi-Currency Change
112: currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: currency_conversion_type OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
114: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
115: currency_conversion_date OKL_TXD_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE);
116: -- Multi-Currency Change
117: g_miss_asdv_rec asdv_rec_type;
118: TYPE asdv_tbl_type IS TABLE OF asdv_rec_type
119: INDEX BY BINARY_INTEGER;
119: INDEX BY BINARY_INTEGER;
120: ---------------------------------------------------------------------------
121: -- GLOBAL MESSAGE CONSTANTS
122: ---------------------------------------------------------------------------
123: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120: ---------------------------------------------------------------------------
121: -- GLOBAL MESSAGE CONSTANTS
122: ---------------------------------------------------------------------------
123: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
121: -- GLOBAL MESSAGE CONSTANTS
122: ---------------------------------------------------------------------------
123: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
122: ---------------------------------------------------------------------------
123: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
123: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
131: ---------------------------------------------------------------------------
124: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
131: ---------------------------------------------------------------------------
132: -- GLOBAL VARIABLES
125: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
131: ---------------------------------------------------------------------------
132: -- GLOBAL VARIABLES
133: ---------------------------------------------------------------------------
126: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
127: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
128: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
129: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
130: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
131: ---------------------------------------------------------------------------
132: -- GLOBAL VARIABLES
133: ---------------------------------------------------------------------------
134: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASD_PVT';
142: PROCEDURE api_copy;
143: PROCEDURE add_language;
144: PROCEDURE insert_row(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_asdv_rec IN asdv_rec_type,
151: x_asdv_rec OUT NOCOPY asdv_rec_type);
152:
153: PROCEDURE insert_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_asdv_tbl IN asdv_tbl_type,
160: x_asdv_tbl OUT NOCOPY asdv_tbl_type);
161:
162: PROCEDURE lock_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_asdv_rec IN asdv_rec_type);
168: p_asdv_rec IN asdv_rec_type);
169:
170: PROCEDURE lock_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_asdv_tbl IN asdv_tbl_type);
176: p_asdv_tbl IN asdv_tbl_type);
177:
178: PROCEDURE update_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_asdv_rec IN asdv_rec_type,
185: x_asdv_rec OUT NOCOPY asdv_rec_type);
186:
187: PROCEDURE update_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_asdv_tbl IN asdv_tbl_type,
194: x_asdv_tbl OUT NOCOPY asdv_tbl_type);
195:
196: PROCEDURE delete_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_asdv_rec IN asdv_rec_type);
202: p_asdv_rec IN asdv_rec_type);
203:
204: PROCEDURE delete_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_asdv_tbl IN asdv_tbl_type);
210: p_asdv_tbl IN asdv_tbl_type);
211:
212: PROCEDURE validate_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_asdv_rec IN asdv_rec_type);
218: p_asdv_rec IN asdv_rec_type);
219:
220: PROCEDURE validate_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_asdv_tbl IN asdv_tbl_type);