3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qlsv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE qlsv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: TYPE qlsv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
6: TYPE qlsv_rec_type IS RECORD (
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
7: id NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
8: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
9: ,sty_id NUMBER := OKL_API.G_MISS_NUM
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
10: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_MISS_qlsv_rec qlsv_rec_type;
11: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_MISS_qlsv_rec qlsv_rec_type;
19: TYPE qlsv_tbl_type IS TABLE OF qlsv_rec_type
12: ,org_id NUMBER := OKL_API.G_MISS_NUM
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_MISS_qlsv_rec qlsv_rec_type;
19: TYPE qlsv_tbl_type IS TABLE OF qlsv_rec_type
20: INDEX BY BINARY_INTEGER;
13: ,created_by NUMBER := OKL_API.G_MISS_NUM
14: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
16: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
18: G_MISS_qlsv_rec qlsv_rec_type;
19: TYPE qlsv_tbl_type IS TABLE OF qlsv_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE qls_rec_type IS RECORD (
18: G_MISS_qlsv_rec qlsv_rec_type;
19: TYPE qlsv_tbl_type IS TABLE OF qlsv_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE qls_rec_type IS RECORD (
22: id NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
19: TYPE qlsv_tbl_type IS TABLE OF qlsv_rec_type
20: INDEX BY BINARY_INTEGER;
21: TYPE qls_rec_type IS RECORD (
22: id NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
20: INDEX BY BINARY_INTEGER;
21: TYPE qls_rec_type IS RECORD (
22: id NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
21: TYPE qls_rec_type IS RECORD (
22: id NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
22: id NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
23: ,quote_line_type_code OKL_QUOTE_LINE_STRM.QUOTE_LINE_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
24: ,sty_id NUMBER := OKL_API.G_MISS_NUM
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
25: ,invoicable_yn OKL_QUOTE_LINE_STRM.INVOICABLE_YN%TYPE := OKL_API.G_MISS_CHAR
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
33: G_MISS_qls_rec qls_rec_type;
26: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
33: G_MISS_qls_rec qls_rec_type;
34: TYPE qls_tbl_type IS TABLE OF qls_rec_type
27: ,org_id NUMBER := OKL_API.G_MISS_NUM
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
33: G_MISS_qls_rec qls_rec_type;
34: TYPE qls_tbl_type IS TABLE OF qls_rec_type
35: INDEX BY BINARY_INTEGER;
28: ,created_by NUMBER := OKL_API.G_MISS_NUM
29: ,creation_date OKL_QUOTE_LINE_STRM.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
31: ,last_update_date OKL_QUOTE_LINE_STRM.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
33: G_MISS_qls_rec qls_rec_type;
34: TYPE qls_tbl_type IS TABLE OF qls_rec_type
35: INDEX BY BINARY_INTEGER;
36: ---------------------------------------------------------------------------
35: INDEX BY BINARY_INTEGER;
36: ---------------------------------------------------------------------------
37: -- GLOBAL MESSAGE CONSTANTS
38: ---------------------------------------------------------------------------
39: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
36: ---------------------------------------------------------------------------
37: -- GLOBAL MESSAGE CONSTANTS
38: ---------------------------------------------------------------------------
39: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
37: -- GLOBAL MESSAGE CONSTANTS
38: ---------------------------------------------------------------------------
39: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
38: ---------------------------------------------------------------------------
39: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
39: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
40: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
48: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
41: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
48: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
49: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
42: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
48: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
49: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
50: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
43: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
48: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
49: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
50: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
44: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
45: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
46: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
47: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
48: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
49: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
50: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52:
58: ---------------------------------------------------------------------------
59: -- GLOBAL VARIABLES
60: ---------------------------------------------------------------------------
61: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QLS_PVT';
62: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
63: ---------------------------------------------------------------------------
64: -- Procedures and Functions
65: ---------------------------------------------------------------------------
66:
68: PROCEDURE change_version;
69: PROCEDURE api_copy;
70: PROCEDURE insert_row(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_qlsv_rec IN qlsv_rec_type,
76: p_qlsv_rec IN qlsv_rec_type,
77: x_qlsv_rec OUT NOCOPY qlsv_rec_type);
78: PROCEDURE insert_row(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_qlsv_tbl IN qlsv_tbl_type,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_qlsv_tbl IN qlsv_tbl_type,
85: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type,
86: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
87: PROCEDURE insert_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
85: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type,
86: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
87: PROCEDURE insert_row(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_qlsv_tbl IN qlsv_tbl_type,
93: p_qlsv_tbl IN qlsv_tbl_type,
94: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type);
95: PROCEDURE lock_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_qlsv_rec IN qlsv_rec_type);
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_qlsv_rec IN qlsv_rec_type);
102: PROCEDURE lock_row(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_qlsv_tbl IN qlsv_tbl_type,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_qlsv_tbl IN qlsv_tbl_type,
109: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
110: PROCEDURE lock_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
108: p_qlsv_tbl IN qlsv_tbl_type,
109: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
110: PROCEDURE lock_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_qlsv_tbl IN qlsv_tbl_type);
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_qlsv_tbl IN qlsv_tbl_type);
117: PROCEDURE update_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_qlsv_rec IN qlsv_rec_type,
123: p_qlsv_rec IN qlsv_rec_type,
124: x_qlsv_rec OUT NOCOPY qlsv_rec_type);
125: PROCEDURE update_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_qlsv_tbl IN qlsv_tbl_type,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_qlsv_tbl IN qlsv_tbl_type,
132: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type,
133: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
134: PROCEDURE update_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
132: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type,
133: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
134: PROCEDURE update_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_qlsv_tbl IN qlsv_tbl_type,
140: p_qlsv_tbl IN qlsv_tbl_type,
141: x_qlsv_tbl OUT NOCOPY qlsv_tbl_type);
142: PROCEDURE delete_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_qlsv_rec IN qlsv_rec_type);
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_qlsv_rec IN qlsv_rec_type);
149: PROCEDURE delete_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_qlsv_tbl IN qlsv_tbl_type,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_qlsv_tbl IN qlsv_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE delete_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
155: p_qlsv_tbl IN qlsv_tbl_type,
156: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
157: PROCEDURE delete_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_qlsv_tbl IN qlsv_tbl_type);
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_qlsv_tbl IN qlsv_tbl_type);
164: PROCEDURE validate_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_qlsv_rec IN qlsv_rec_type);
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_qlsv_rec IN qlsv_rec_type);
171: PROCEDURE validate_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_qlsv_tbl IN qlsv_tbl_type,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_qlsv_tbl IN qlsv_tbl_type,
178: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
179: PROCEDURE validate_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
177: p_qlsv_tbl IN qlsv_tbl_type,
178: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
179: PROCEDURE validate_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_qlsv_tbl IN qlsv_tbl_type);