4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE tal_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE tal_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
6: ---------------------------------------------------------------------------
7: TYPE tal_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
7: TYPE tal_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id 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: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
10: tas_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
11: ilo_id NUMBER := OKC_API.G_MISS_NUM,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
12: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
13: iay_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
14: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
15: kle_id NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
16: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
17: line_number NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
18: org_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
19: tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
20: asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
22: original_cost NUMBER := OKC_API.G_MISS_NUM,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
23: current_units NUMBER := OKC_API.G_MISS_NUM,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
24: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
25: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
26: supplier_id NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
27: used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
28: tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
29: model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
30: corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
31: date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
32: date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
33: in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41: --Bug# 2981308
34: life_in_months NUMBER := OKC_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41: --Bug# 2981308
42: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
35: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41: --Bug# 2981308
42: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
43: -- Bug 4028371
36: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37: deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39: salvage_value NUMBER := OKC_API.G_MISS_NUM,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41: --Bug# 2981308
42: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
43: -- Bug 4028371
44: fa_trx_date OKL_TXL_ASSETS_B.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
40: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41: --Bug# 2981308
42: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
43: -- Bug 4028371
44: fa_trx_date OKL_TXL_ASSETS_B.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
45: --Bug# 4899328
46: fa_cost NUMBER := OKL_API.G_MISS_NUM,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
43: -- Bug 4028371
44: fa_trx_date OKL_TXL_ASSETS_B.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
45: --Bug# 4899328
46: fa_cost NUMBER := OKL_API.G_MISS_NUM,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
44: fa_trx_date OKL_TXL_ASSETS_B.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
45: --Bug# 4899328
46: fa_cost NUMBER := OKL_API.G_MISS_NUM,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
45: --Bug# 4899328
46: fa_cost NUMBER := OKL_API.G_MISS_NUM,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
46: fa_cost NUMBER := OKL_API.G_MISS_NUM,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
47: attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
48: attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
49: attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
50: attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
51: attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
52: attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
53: attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
54: attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
55: attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
56: attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
61: attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
62: attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
63: created_by NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
64: creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
65: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
66: last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
67: last_update_login NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
68: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
69: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
70: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
71: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
72: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
73: units_retired NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
74: cost_retired NUMBER := OKC_API.G_MISS_NUM,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
76: removal_cost NUMBER := OKC_API.G_MISS_NUM,
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
77: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
79: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
81: match_amount NUMBER := OKC_API.G_MISS_NUM,
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
82: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
90: -- VRS Project - START
83: split_into_units NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
90: -- VRS Project - START
91: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
84: -- Multi-Currency Change
85: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
90: -- VRS Project - START
91: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
92: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
87: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
90: -- VRS Project - START
91: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
92: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
93: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
94: -- VRS Project - END
95: );
88: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89: -- Multi-Currency Change
90: -- VRS Project - START
91: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
92: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
93: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
94: -- VRS Project - END
95: );
96: g_miss_tal_rec tal_rec_type;
89: -- Multi-Currency Change
90: -- VRS Project - START
91: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
92: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
93: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
94: -- VRS Project - END
95: );
96: g_miss_tal_rec tal_rec_type;
97: TYPE tal_tbl_type IS TABLE OF tal_rec_type
96: g_miss_tal_rec tal_rec_type;
97: TYPE tal_tbl_type IS TABLE OF tal_rec_type
98: INDEX BY BINARY_INTEGER;
99: TYPE okl_txl_assets_tl_rec_type IS RECORD (
100: id NUMBER := OKC_API.G_MISS_NUM,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
97: TYPE tal_tbl_type IS TABLE OF tal_rec_type
98: INDEX BY BINARY_INTEGER;
99: TYPE okl_txl_assets_tl_rec_type IS RECORD (
100: id NUMBER := OKC_API.G_MISS_NUM,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
98: INDEX BY BINARY_INTEGER;
99: TYPE okl_txl_assets_tl_rec_type IS RECORD (
100: id NUMBER := OKC_API.G_MISS_NUM,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99: TYPE okl_txl_assets_tl_rec_type IS RECORD (
100: id NUMBER := OKC_API.G_MISS_NUM,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
100: id NUMBER := OKC_API.G_MISS_NUM,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
101: language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
102: source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
103: sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
111: TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
104: description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
111: TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
112: INDEX BY BINARY_INTEGER;
105: created_by NUMBER := OKC_API.G_MISS_NUM,
106: creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108: last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109: last_update_login NUMBER := OKC_API.G_MISS_NUM);
110: g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
111: TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
112: INDEX BY BINARY_INTEGER;
113: TYPE talv_rec_type IS RECORD (
110: g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
111: TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
112: INDEX BY BINARY_INTEGER;
113: TYPE talv_rec_type IS RECORD (
114: id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
111: TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
112: INDEX BY BINARY_INTEGER;
113: TYPE talv_rec_type IS RECORD (
114: id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
112: INDEX BY BINARY_INTEGER;
113: TYPE talv_rec_type IS RECORD (
114: id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
113: TYPE talv_rec_type IS RECORD (
114: id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
114: id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
115: object_version_number NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
116: sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
117: tas_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
118: ilo_id NUMBER := OKC_API.G_MISS_NUM,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
120: iay_id NUMBER := OKC_API.G_MISS_NUM,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
121: iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
122: kle_id NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
123: dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
124: line_number NUMBER := OKC_API.G_MISS_NUM,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
125: org_id NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
126: tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
127: asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
128: description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
129: fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
130: original_cost NUMBER := OKC_API.G_MISS_NUM,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
131: current_units NUMBER := OKC_API.G_MISS_NUM,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
132: manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
133: year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
134: supplier_id NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
135: used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
136: tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
137: model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
138: corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
139: date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
140: date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
141: in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149: --Bug# 2981308
142: life_in_months NUMBER := OKC_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149: --Bug# 2981308
150: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
143: depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149: --Bug# 2981308
150: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
151: -- Bug 4028371
144: depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145: deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146: deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147: salvage_value NUMBER := OKC_API.G_MISS_NUM,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149: --Bug# 2981308
150: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
151: -- Bug 4028371
152: fa_trx_date OKL_TXL_ASSETS_V.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
148: percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149: --Bug# 2981308
150: asset_key_id NUMBER := OKL_API.G_MISS_NUM,
151: -- Bug 4028371
152: fa_trx_date OKL_TXL_ASSETS_V.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
153: --Bug# 4899328
154: fa_cost NUMBER := OKL_API.G_MISS_NUM,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
151: -- Bug 4028371
152: fa_trx_date OKL_TXL_ASSETS_V.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
153: --Bug# 4899328
154: fa_cost NUMBER := OKL_API.G_MISS_NUM,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
152: fa_trx_date OKL_TXL_ASSETS_V.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
153: --Bug# 4899328
154: fa_cost NUMBER := OKL_API.G_MISS_NUM,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
153: --Bug# 4899328
154: fa_cost NUMBER := OKL_API.G_MISS_NUM,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
154: fa_cost NUMBER := OKL_API.G_MISS_NUM,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
155: attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
156: attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
157: attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
158: attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
159: attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
160: attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
161: attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
162: attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
163: attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
164: attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
165: attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
166: attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
167: attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
168: attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
169: attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
170: attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
171: created_by NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
172: creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
173: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
174: last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
175: last_update_login NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
176: depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
177: hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
178: old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
179: new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
180: old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
181: units_retired NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
182: cost_retired NUMBER := OKC_API.G_MISS_NUM,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
183: sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
184: removal_cost NUMBER := OKC_API.G_MISS_NUM,
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
185: dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
186: date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
187: rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188: lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
189: match_amount NUMBER := OKC_API.G_MISS_NUM,
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
190: split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
198: -- VRS Project - START
191: split_into_units NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
198: -- VRS Project - START
199: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
192: -- Multi-Currency Change
193: currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194: currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
198: -- VRS Project - START
199: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
200: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
195: currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
198: -- VRS Project - START
199: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
200: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
201: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
202: -- VRS Project - END
203: );
196: currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197: -- Multi-Currency Change
198: -- VRS Project - START
199: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
200: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
201: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
202: -- VRS Project - END
203: );
204:
197: -- Multi-Currency Change
198: -- VRS Project - START
199: RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
200: RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
201: RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
202: -- VRS Project - END
203: );
204:
205: g_miss_talv_rec talv_rec_type;
207: INDEX BY BINARY_INTEGER;
208: ---------------------------------------------------------------------------
209: -- GLOBAL MESSAGE CONSTANTS
210: ---------------------------------------------------------------------------
211: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
208: ---------------------------------------------------------------------------
209: -- GLOBAL MESSAGE CONSTANTS
210: ---------------------------------------------------------------------------
211: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
209: -- GLOBAL MESSAGE CONSTANTS
210: ---------------------------------------------------------------------------
211: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
210: ---------------------------------------------------------------------------
211: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
211: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
219: ---------------------------------------------------------------------------
212: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
219: ---------------------------------------------------------------------------
220: -- GLOBAL VARIABLES
213: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
219: ---------------------------------------------------------------------------
220: -- GLOBAL VARIABLES
221: ---------------------------------------------------------------------------
214: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
219: ---------------------------------------------------------------------------
220: -- GLOBAL VARIABLES
221: ---------------------------------------------------------------------------
222: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAL_PVT';
230: PROCEDURE api_copy;
231: PROCEDURE add_language;
232: PROCEDURE insert_row(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_talv_rec IN talv_rec_type,
239: x_talv_rec OUT NOCOPY talv_rec_type);
240:
241: PROCEDURE insert_row(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_talv_tbl IN talv_tbl_type,
248: x_talv_tbl OUT NOCOPY talv_tbl_type);
249:
250: PROCEDURE lock_row(
251: p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,
255: x_msg_data OUT NOCOPY VARCHAR2,
256: p_talv_rec IN talv_rec_type);
256: p_talv_rec IN talv_rec_type);
257:
258: PROCEDURE lock_row(
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2,
264: p_talv_tbl IN talv_tbl_type);
264: p_talv_tbl IN talv_tbl_type);
265:
266: PROCEDURE update_row(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_talv_rec IN talv_rec_type,
273: x_talv_rec OUT NOCOPY talv_rec_type);
274:
275: PROCEDURE update_row(
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2,
281: p_talv_tbl IN talv_tbl_type,
282: x_talv_tbl OUT NOCOPY talv_tbl_type);
283:
284: PROCEDURE delete_row(
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: p_talv_rec IN talv_rec_type);
290: p_talv_rec IN talv_rec_type);
291:
292: PROCEDURE delete_row(
293: p_api_version IN NUMBER,
294: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_talv_tbl IN talv_tbl_type);
298: p_talv_tbl IN talv_tbl_type);
299:
300: PROCEDURE validate_row(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_talv_rec IN talv_rec_type);
306: p_talv_rec IN talv_rec_type);
307:
308: PROCEDURE validate_row(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
314: p_talv_tbl IN talv_tbl_type);