3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE inf_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE inf_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE inf_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
6: TYPE inf_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
8: contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
10: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
11: org_id NUMBER := Okl_Api.G_MISS_NUM,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
13: end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
14: attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
15: attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
16: attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
17: attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
18: attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
19: attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
20: attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
21: attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
22: attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
23: attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
24: attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
25: attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
27: attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: g_miss_inf_rec inf_rec_type;
28: attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: g_miss_inf_rec inf_rec_type;
36: TYPE inf_tbl_type IS TABLE OF inf_rec_type
29: attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: g_miss_inf_rec inf_rec_type;
36: TYPE inf_tbl_type IS TABLE OF inf_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := Okl_Api.G_MISS_NUM,
31: creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33: last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35: g_miss_inf_rec inf_rec_type;
36: TYPE inf_tbl_type IS TABLE OF inf_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE OklInvoiceFormatsTlRecType IS RECORD (
35: g_miss_inf_rec inf_rec_type;
36: TYPE inf_tbl_type IS TABLE OF inf_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE OklInvoiceFormatsTlRecType IS RECORD (
39: id NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
36: TYPE inf_tbl_type IS TABLE OF inf_rec_type
37: INDEX BY BINARY_INTEGER;
38: TYPE OklInvoiceFormatsTlRecType IS RECORD (
39: id NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
37: INDEX BY BINARY_INTEGER;
38: TYPE OklInvoiceFormatsTlRecType IS RECORD (
39: id NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
38: TYPE OklInvoiceFormatsTlRecType IS RECORD (
39: id NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
39: id NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
40: LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
41: source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
42: sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
50: GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
43: name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
50: GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
51: TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
44: description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
50: GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
51: TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
52: INDEX BY BINARY_INTEGER;
45: created_by NUMBER := Okl_Api.G_MISS_NUM,
46: creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48: last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
50: GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
51: TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
52: INDEX BY BINARY_INTEGER;
53: TYPE infv_rec_type IS RECORD (
50: GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
51: TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
52: INDEX BY BINARY_INTEGER;
53: TYPE infv_rec_type IS RECORD (
54: id NUMBER := Okl_Api.G_MISS_NUM,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
51: TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
52: INDEX BY BINARY_INTEGER;
53: TYPE infv_rec_type IS RECORD (
54: id NUMBER := Okl_Api.G_MISS_NUM,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
52: INDEX BY BINARY_INTEGER;
53: TYPE infv_rec_type IS RECORD (
54: id NUMBER := Okl_Api.G_MISS_NUM,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
53: TYPE infv_rec_type IS RECORD (
54: id NUMBER := Okl_Api.G_MISS_NUM,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
54: id NUMBER := Okl_Api.G_MISS_NUM,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
56: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
57: org_id NUMBER := Okl_Api.G_MISS_NUM,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
58: sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
59: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
60: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
61: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
62: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
63: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
64: attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
65: attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
66: attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
67: attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
68: attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
69: attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
70: attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
71: attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
72: attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
73: attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
74: attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
75: attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
76: attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
77: attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_infv_rec infv_rec_type;
78: attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_infv_rec infv_rec_type;
86: TYPE infv_tbl_type IS TABLE OF infv_rec_type
79: attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_infv_rec infv_rec_type;
86: TYPE infv_tbl_type IS TABLE OF infv_rec_type
87: INDEX BY BINARY_INTEGER;
80: created_by NUMBER := okl_api.G_MISS_NUM,
81: creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82: last_updated_by NUMBER := okl_api.G_MISS_NUM,
83: last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84: last_update_login NUMBER := okl_api.G_MISS_NUM);
85: g_miss_infv_rec infv_rec_type;
86: TYPE infv_tbl_type IS TABLE OF infv_rec_type
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
87: INDEX BY BINARY_INTEGER;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97:
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97:
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
91: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97:
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99:
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97:
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99:
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
96: -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97:
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99:
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
104:
97:
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99:
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
104:
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99:
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
104:
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
99:
100: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
101: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
102: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
103: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
104:
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
110: ---------------------------------------------------------------------------
111: -- GLOBAL VARIABLES
112: ---------------------------------------------------------------------------
113: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INF_PVT';
114: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
115:
116: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INVOICE_FORMATS_V';
117: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
118:
126: PROCEDURE api_copy;
127: PROCEDURE add_language;
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_infv_rec IN infv_rec_type,
135: x_infv_rec OUT NOCOPY infv_rec_type);
136:
137: PROCEDURE insert_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_infv_tbl IN infv_tbl_type,
144: x_infv_tbl OUT NOCOPY infv_tbl_type);
145:
146: PROCEDURE lock_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_infv_rec IN infv_rec_type);
152: p_infv_rec IN infv_rec_type);
153:
154: PROCEDURE lock_row(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_infv_tbl IN infv_tbl_type);
160: p_infv_tbl IN infv_tbl_type);
161:
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_infv_rec IN infv_rec_type,
169: x_infv_rec OUT NOCOPY infv_rec_type);
170:
171: PROCEDURE update_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_infv_tbl IN infv_tbl_type,
178: x_infv_tbl OUT NOCOPY infv_tbl_type);
179:
180: PROCEDURE delete_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_infv_rec IN infv_rec_type);
186: p_infv_rec IN infv_rec_type);
187:
188: PROCEDURE delete_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_infv_tbl IN infv_tbl_type);
194: p_infv_tbl IN infv_tbl_type);
195:
196: PROCEDURE validate_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_infv_rec IN infv_rec_type);
202: p_infv_rec IN infv_rec_type);
203:
204: PROCEDURE validate_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_infv_tbl IN infv_tbl_type);