4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE tas_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE tas_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
6: ---------------------------------------------------------------------------
7: TYPE tas_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
7: TYPE tas_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
8: id NUMBER := OKL_API.G_MISS_NUM,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
9: ica_id NUMBER := OKL_API.G_MISS_NUM,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
10: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
11: object_version_number NUMBER := OKL_API.G_MISS_NUM,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
12: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
13: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
14: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
15: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
16: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
17: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
18: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
19: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
20: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
21: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
22: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
23: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
24: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
25: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
26: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
27: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
28: created_by NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
29: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
30: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
31: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
32: last_update_login NUMBER := OKL_API.G_MISS_NUM,
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
33: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
34: try_id NUMBER := OKL_API.G_MISS_NUM,
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
42: --Added by dpsingh for LE uptake
35: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
36: trans_number NUMBER := OKL_API.G_MISS_NUM,
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
42: --Added by dpsingh for LE uptake
43: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
37: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
38: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
42: --Added by dpsingh for LE uptake
43: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
44: ,transaction_date DATE := OKL_API.G_MISS_DATE);
45: g_miss_tas_rec tas_rec_type;
39: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
42: --Added by dpsingh for LE uptake
43: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
44: ,transaction_date DATE := OKL_API.G_MISS_DATE);
45: g_miss_tas_rec tas_rec_type;
46: TYPE tas_tbl_type IS TABLE OF tas_rec_type
47: INDEX BY BINARY_INTEGER;
40: --Bug# 2697681 - 11.5.9 Schema changes
41: org_id NUMBER := OKL_API.G_MISS_NUM,
42: --Added by dpsingh for LE uptake
43: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
44: ,transaction_date DATE := OKL_API.G_MISS_DATE);
45: g_miss_tas_rec tas_rec_type;
46: TYPE tas_tbl_type IS TABLE OF tas_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE tasv_rec_type IS RECORD (
45: g_miss_tas_rec tas_rec_type;
46: TYPE tas_tbl_type IS TABLE OF tas_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE tasv_rec_type IS RECORD (
49: id NUMBER := OKL_API.G_MISS_NUM,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
46: TYPE tas_tbl_type IS TABLE OF tas_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE tasv_rec_type IS RECORD (
49: id NUMBER := OKL_API.G_MISS_NUM,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
47: INDEX BY BINARY_INTEGER;
48: TYPE tasv_rec_type IS RECORD (
49: id NUMBER := OKL_API.G_MISS_NUM,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
48: TYPE tasv_rec_type IS RECORD (
49: id NUMBER := OKL_API.G_MISS_NUM,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
49: id NUMBER := OKL_API.G_MISS_NUM,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
50: object_version_number NUMBER := OKL_API.G_MISS_NUM,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
51: ica_id NUMBER := OKL_API.G_MISS_NUM,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
52: attribute_category OKL_TRX_ASSETS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
53: attribute1 OKL_TRX_ASSETS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
54: attribute2 OKL_TRX_ASSETS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
55: attribute3 OKL_TRX_ASSETS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
56: attribute4 OKL_TRX_ASSETS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
57: attribute5 OKL_TRX_ASSETS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
58: attribute6 OKL_TRX_ASSETS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
59: attribute7 OKL_TRX_ASSETS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
60: attribute8 OKL_TRX_ASSETS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
61: attribute9 OKL_TRX_ASSETS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
62: attribute10 OKL_TRX_ASSETS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
63: attribute11 OKL_TRX_ASSETS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
64: attribute12 OKL_TRX_ASSETS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
65: attribute13 OKL_TRX_ASSETS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
66: attribute14 OKL_TRX_ASSETS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
67: attribute15 OKL_TRX_ASSETS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
68: tas_type OKL_TRX_ASSETS.TAS_TYPE%TYPE := OKL_API.G_MISS_CHAR,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
69: created_by NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
70: creation_date OKL_TRX_ASSETS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
71: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
72: last_update_date OKL_TRX_ASSETS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
73: last_update_login NUMBER := OKL_API.G_MISS_NUM,
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
74: tsu_code OKL_TRX_ASSETS.TSU_CODE%TYPE := OKL_API.G_MISS_CHAR,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
75: try_id NUMBER := OKL_API.G_MISS_NUM,
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
83: --Added by dpsingh for LE uptake
76: date_trans_occurred OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE := OKL_API.G_MISS_DATE,
77: trans_number NUMBER := OKL_API.G_MISS_NUM,
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
83: --Added by dpsingh for LE uptake
84: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
78: comments OKL_TRX_ASSETS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR,
79: req_asset_id NUMBER := OKL_API.G_MISS_NUM,
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
83: --Added by dpsingh for LE uptake
84: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
85: ,transaction_date DATE := OKL_API.G_MISS_DATE);
86: g_miss_tasv_rec tasv_rec_type;
80: total_match_amount NUMBER := OKL_API.G_MISS_NUM,
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
83: --Added by dpsingh for LE uptake
84: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
85: ,transaction_date DATE := OKL_API.G_MISS_DATE);
86: g_miss_tasv_rec tasv_rec_type;
87: TYPE tasv_tbl_type IS TABLE OF tasv_rec_type
88: INDEX BY BINARY_INTEGER;
81: --Bug# 2697681 - 11.5.9 Schema changes
82: org_id NUMBER := OKL_API.G_MISS_NUM,
83: --Added by dpsingh for LE uptake
84: legal_entity_id NUMBER := OKL_API.G_MISS_NUM
85: ,transaction_date DATE := OKL_API.G_MISS_DATE);
86: g_miss_tasv_rec tasv_rec_type;
87: TYPE tasv_tbl_type IS TABLE OF tasv_rec_type
88: INDEX BY BINARY_INTEGER;
89: ---------------------------------------------------------------------------
88: INDEX BY BINARY_INTEGER;
89: ---------------------------------------------------------------------------
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
89: ---------------------------------------------------------------------------
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
90: -- GLOBAL MESSAGE CONSTANTS
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
91: ---------------------------------------------------------------------------
92: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
92: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
93: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
94: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
95: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
96: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
97: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
98: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
99: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAS_PVT';
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAS_PVT';
104: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
105: ---------------------------------------------------------------------------
106: -- Procedures and Functions
107: ---------------------------------------------------------------------------
108:
110: PROCEDURE change_version;
111: PROCEDURE api_copy;
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_tasv_rec IN tasv_rec_type,
119: x_tasv_rec OUT NOCOPY tasv_rec_type);
120:
121: PROCEDURE insert_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_tasv_tbl IN tasv_tbl_type,
128: x_tasv_tbl OUT NOCOPY tasv_tbl_type);
129:
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_tasv_rec IN tasv_rec_type);
136: p_tasv_rec IN tasv_rec_type);
137:
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_tasv_tbl IN tasv_tbl_type);
144: p_tasv_tbl IN tasv_tbl_type);
145:
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_tasv_rec IN tasv_rec_type,
153: x_tasv_rec OUT NOCOPY tasv_rec_type);
154:
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_tasv_tbl IN tasv_tbl_type,
162: x_tasv_tbl OUT NOCOPY tasv_tbl_type);
163:
164: PROCEDURE delete_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_tasv_rec IN tasv_rec_type);
170: p_tasv_rec IN tasv_rec_type);
171:
172: PROCEDURE delete_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_tasv_tbl IN tasv_tbl_type);
178: p_tasv_tbl IN tasv_tbl_type);
179:
180: PROCEDURE validate_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_tasv_rec IN tasv_rec_type);
186: p_tasv_rec IN tasv_rec_type);
187:
188: PROCEDURE validate_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_tasv_tbl IN tasv_tbl_type);