4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TXD_QUOTE_LINE_DTLS_V Record Spec
7: TYPE tqdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_TXD_QUOTE_LINE_DTLS_V Record Spec
7: TYPE tqdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKL_TXD_QUOTE_LINE_DTLS_V Record Spec
7: TYPE tqdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE tqdv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,tql_id NUMBER := OKC_API.G_MISS_NUM
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,kle_id NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,request_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
15: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,program_id NUMBER := OKC_API.G_MISS_NUM
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
31: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: G_MISS_tqdv_rec tqdv_rec_type;
32: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: G_MISS_tqdv_rec tqdv_rec_type;
40: TYPE tqdv_tbl_type IS TABLE OF tqdv_rec_type
33: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: G_MISS_tqdv_rec tqdv_rec_type;
40: TYPE tqdv_tbl_type IS TABLE OF tqdv_rec_type
41: INDEX BY BINARY_INTEGER;
34: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39: G_MISS_tqdv_rec tqdv_rec_type;
40: TYPE tqdv_tbl_type IS TABLE OF tqdv_rec_type
41: INDEX BY BINARY_INTEGER;
42: -- OKL_TXD_QUOTE_LINE_DTLS Record Spec
40: TYPE tqdv_tbl_type IS TABLE OF tqdv_rec_type
41: INDEX BY BINARY_INTEGER;
42: -- OKL_TXD_QUOTE_LINE_DTLS Record Spec
43: TYPE tqd_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
41: INDEX BY BINARY_INTEGER;
42: -- OKL_TXD_QUOTE_LINE_DTLS Record Spec
43: TYPE tqd_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
42: -- OKL_TXD_QUOTE_LINE_DTLS Record Spec
43: TYPE tqd_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
43: TYPE tqd_rec_type IS RECORD (
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
44: id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
45: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,number_of_units NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
47: ,kle_id NUMBER := OKC_API.G_MISS_NUM
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,tql_id NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
49: ,org_id NUMBER := OKC_API.G_MISS_NUM
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,request_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
51: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
52: ,program_id NUMBER := OKC_API.G_MISS_NUM
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
53: ,program_update_date OKL_TXD_QUOTE_LINE_DTLS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
54: ,created_by NUMBER := OKC_API.G_MISS_NUM
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
55: ,creation_date OKL_TXD_QUOTE_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
56: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
57: ,last_update_date OKL_TXD_QUOTE_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
58: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute_category OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute1 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute2 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute3 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute4 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute5 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute6 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute7 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
67: ,attribute8 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
75: G_MISS_tqd_rec tqd_rec_type;
68: ,attribute9 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
75: G_MISS_tqd_rec tqd_rec_type;
76: TYPE tqd_tbl_type IS TABLE OF tqd_rec_type
69: ,attribute10 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
75: G_MISS_tqd_rec tqd_rec_type;
76: TYPE tqd_tbl_type IS TABLE OF tqd_rec_type
77: INDEX BY BINARY_INTEGER;
70: ,attribute11 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute12 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute13 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute14 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute15 OKL_TXD_QUOTE_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
75: G_MISS_tqd_rec tqd_rec_type;
76: TYPE tqd_tbl_type IS TABLE OF tqd_rec_type
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
77: INDEX BY BINARY_INTEGER;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
78: ---------------------------------------------------------------------------
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
79: -- GLOBAL MESSAGE CONSTANTS
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
80: ---------------------------------------------------------------------------
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
81: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
82: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
83: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
84: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
85: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
86: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
92: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94:
100: ---------------------------------------------------------------------------
101: -- GLOBAL VARIABLES
102: ---------------------------------------------------------------------------
103: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TQD_PVT';
104: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
105: ---------------------------------------------------------------------------
106: -- Procedures and Functions
107: ---------------------------------------------------------------------------
108:
110: PROCEDURE change_version;
111: PROCEDURE api_copy;
112: PROCEDURE insert_row(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_tqdv_rec IN tqdv_rec_type,
119: x_tqdv_rec OUT NOCOPY tqdv_rec_type);
120:
121: PROCEDURE insert_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_tqdv_tbl IN tqdv_tbl_type,
128: x_tqdv_tbl OUT NOCOPY tqdv_tbl_type);
129:
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_tqdv_rec IN tqdv_rec_type);
136: p_tqdv_rec IN tqdv_rec_type);
137:
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_tqdv_tbl IN tqdv_tbl_type);
144: p_tqdv_tbl IN tqdv_tbl_type);
145:
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tqdv_rec IN tqdv_rec_type,
153: x_tqdv_rec OUT NOCOPY tqdv_rec_type);
154:
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_tqdv_tbl IN tqdv_tbl_type,
162: x_tqdv_tbl OUT NOCOPY tqdv_tbl_type);
163:
164: PROCEDURE delete_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_tqdv_rec IN tqdv_rec_type);
170: p_tqdv_rec IN tqdv_rec_type);
171:
172: PROCEDURE delete_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_tqdv_tbl IN tqdv_tbl_type);
178: p_tqdv_tbl IN tqdv_tbl_type);
179:
180: PROCEDURE validate_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tqdv_rec IN tqdv_rec_type);
186: p_tqdv_rec IN tqdv_rec_type);
187:
188: PROCEDURE validate_row(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tqdv_tbl IN tqdv_tbl_type);