3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ity_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ity_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE ity_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
6: TYPE ity_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
7: id NUMBER := okl_api.G_MISS_NUM,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
8: inf_id NUMBER := okl_api.G_MISS_NUM,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
9: group_asset_yn OKL_INVOICE_TYPES_B.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
10: group_by_contract_yn OKL_INVOICE_TYPES_B.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
11: object_version_number NUMBER := okl_api.G_MISS_NUM,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
12: attribute_category OKL_INVOICE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
13: attribute1 OKL_INVOICE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
14: attribute2 OKL_INVOICE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
15: attribute3 OKL_INVOICE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
16: attribute4 OKL_INVOICE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
17: attribute5 OKL_INVOICE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
18: attribute6 OKL_INVOICE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
19: attribute7 OKL_INVOICE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
20: attribute8 OKL_INVOICE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
21: attribute9 OKL_INVOICE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
22: attribute10 OKL_INVOICE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
23: attribute11 OKL_INVOICE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
24: attribute12 OKL_INVOICE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
25: attribute13 OKL_INVOICE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_ity_rec ity_rec_type;
26: attribute14 OKL_INVOICE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_ity_rec ity_rec_type;
34: TYPE ity_tbl_type IS TABLE OF ity_rec_type
27: attribute15 OKL_INVOICE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_ity_rec ity_rec_type;
34: TYPE ity_tbl_type IS TABLE OF ity_rec_type
35: INDEX BY BINARY_INTEGER;
28: created_by NUMBER := okl_api.G_MISS_NUM,
29: creation_date OKL_INVOICE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30: last_updated_by NUMBER := okl_api.G_MISS_NUM,
31: last_update_date OKL_INVOICE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_update_login NUMBER := okl_api.G_MISS_NUM);
33: g_miss_ity_rec ity_rec_type;
34: TYPE ity_tbl_type IS TABLE OF ity_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okl_invoice_types_tl_rec_type IS RECORD (
33: g_miss_ity_rec ity_rec_type;
34: TYPE ity_tbl_type IS TABLE OF ity_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okl_invoice_types_tl_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
34: TYPE ity_tbl_type IS TABLE OF ity_rec_type
35: INDEX BY BINARY_INTEGER;
36: TYPE okl_invoice_types_tl_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
35: INDEX BY BINARY_INTEGER;
36: TYPE okl_invoice_types_tl_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
36: TYPE okl_invoice_types_tl_rec_type IS RECORD (
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
37: id NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
38: LANGUAGE OKL_INVOICE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
39: source_lang OKL_INVOICE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_update_login NUMBER := okl_api.G_MISS_NUM);
40: sfwt_flag OKL_INVOICE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_update_login NUMBER := okl_api.G_MISS_NUM);
48: GMissOklInvoiceTypesTlRec okl_invoice_types_tl_rec_type;
41: name OKL_INVOICE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_update_login NUMBER := okl_api.G_MISS_NUM);
48: GMissOklInvoiceTypesTlRec okl_invoice_types_tl_rec_type;
49: TYPE okl_invoice_types_tl_tbl_type IS TABLE OF okl_invoice_types_tl_rec_type
42: description OKL_INVOICE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_update_login NUMBER := okl_api.G_MISS_NUM);
48: GMissOklInvoiceTypesTlRec okl_invoice_types_tl_rec_type;
49: TYPE okl_invoice_types_tl_tbl_type IS TABLE OF okl_invoice_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
43: created_by NUMBER := okl_api.G_MISS_NUM,
44: creation_date OKL_INVOICE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
45: last_updated_by NUMBER := okl_api.G_MISS_NUM,
46: last_update_date OKL_INVOICE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
47: last_update_login NUMBER := okl_api.G_MISS_NUM);
48: GMissOklInvoiceTypesTlRec okl_invoice_types_tl_rec_type;
49: TYPE okl_invoice_types_tl_tbl_type IS TABLE OF okl_invoice_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE ityv_rec_type IS RECORD (
48: GMissOklInvoiceTypesTlRec okl_invoice_types_tl_rec_type;
49: TYPE okl_invoice_types_tl_tbl_type IS TABLE OF okl_invoice_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE ityv_rec_type IS RECORD (
52: id NUMBER := okl_api.G_MISS_NUM,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
49: TYPE okl_invoice_types_tl_tbl_type IS TABLE OF okl_invoice_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE ityv_rec_type IS RECORD (
52: id NUMBER := okl_api.G_MISS_NUM,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
50: INDEX BY BINARY_INTEGER;
51: TYPE ityv_rec_type IS RECORD (
52: id NUMBER := okl_api.G_MISS_NUM,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
51: TYPE ityv_rec_type IS RECORD (
52: id NUMBER := okl_api.G_MISS_NUM,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
52: id NUMBER := okl_api.G_MISS_NUM,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
53: object_version_number NUMBER := okl_api.G_MISS_NUM,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
54: sfwt_flag OKL_INVOICE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
55: inf_id NUMBER := okl_api.G_MISS_NUM,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
56: name OKL_INVOICE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
57: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
58: group_asset_yn OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
59: group_by_contract_yn OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
60: attribute_category OKL_INVOICE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
61: attribute1 OKL_INVOICE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
62: attribute2 OKL_INVOICE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
63: attribute3 OKL_INVOICE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
64: attribute4 OKL_INVOICE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
65: attribute5 OKL_INVOICE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
66: attribute6 OKL_INVOICE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
67: attribute7 OKL_INVOICE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
68: attribute8 OKL_INVOICE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
69: attribute9 OKL_INVOICE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
70: attribute10 OKL_INVOICE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
71: attribute11 OKL_INVOICE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
72: attribute12 OKL_INVOICE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80: last_update_login NUMBER := okl_api.G_MISS_NUM);
73: attribute13 OKL_INVOICE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80: last_update_login NUMBER := okl_api.G_MISS_NUM);
81: g_miss_ityv_rec ityv_rec_type;
74: attribute14 OKL_INVOICE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80: last_update_login NUMBER := okl_api.G_MISS_NUM);
81: g_miss_ityv_rec ityv_rec_type;
82: TYPE ityv_tbl_type IS TABLE OF ityv_rec_type
75: attribute15 OKL_INVOICE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80: last_update_login NUMBER := okl_api.G_MISS_NUM);
81: g_miss_ityv_rec ityv_rec_type;
82: TYPE ityv_tbl_type IS TABLE OF ityv_rec_type
83: INDEX BY BINARY_INTEGER;
76: created_by NUMBER := okl_api.G_MISS_NUM,
77: creation_date OKL_INVOICE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
78: last_updated_by NUMBER := okl_api.G_MISS_NUM,
79: last_update_date OKL_INVOICE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
80: last_update_login NUMBER := okl_api.G_MISS_NUM);
81: g_miss_ityv_rec ityv_rec_type;
82: TYPE ityv_tbl_type IS TABLE OF ityv_rec_type
83: INDEX BY BINARY_INTEGER;
84: ---------------------------------------------------------------------------
83: INDEX BY BINARY_INTEGER;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
87: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
98:
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
98:
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
92:
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
98:
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
100: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
93: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
94: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
95: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
96: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
97: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
98:
99: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
100: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
101: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
104: ---------------------------------------------------------------------------
105: -- GLOBAL VARIABLES
106: ---------------------------------------------------------------------------
107: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ITY_PVT';
108: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
109:
110: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
111: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
112:
120: PROCEDURE api_copy;
121: PROCEDURE add_language;
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_ityv_rec IN ityv_rec_type,
129: x_ityv_rec OUT NOCOPY ityv_rec_type);
130:
131: PROCEDURE insert_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_ityv_tbl IN ityv_tbl_type,
138: x_ityv_tbl OUT NOCOPY ityv_tbl_type);
139:
140: PROCEDURE lock_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_ityv_rec IN ityv_rec_type);
146: p_ityv_rec IN ityv_rec_type);
147:
148: PROCEDURE lock_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_ityv_tbl IN ityv_tbl_type);
154: p_ityv_tbl IN ityv_tbl_type);
155:
156: PROCEDURE update_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_ityv_rec IN ityv_rec_type,
163: x_ityv_rec OUT NOCOPY ityv_rec_type);
164:
165: PROCEDURE update_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ityv_tbl IN ityv_tbl_type,
172: x_ityv_tbl OUT NOCOPY ityv_tbl_type);
173:
174: PROCEDURE delete_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_ityv_rec IN ityv_rec_type);
180: p_ityv_rec IN ityv_rec_type);
181:
182: PROCEDURE delete_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_ityv_tbl IN ityv_tbl_type);
188: p_ityv_tbl IN ityv_tbl_type);
189:
190: PROCEDURE validate_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_ityv_rec IN ityv_rec_type);
196: p_ityv_rec IN ityv_rec_type);
197:
198: PROCEDURE validate_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_ityv_tbl IN ityv_tbl_type);