3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ALS_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ALS_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE ALS_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
6: TYPE ALS_rec_type IS RECORD (
7: id NUMBER := okl_api.G_MISS_NUM,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
7: id NUMBER := okl_api.G_MISS_NUM,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
8: object_version_number NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
9: org_id NUMBER := okl_api.G_MISS_NUM,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
10: AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18: last_update_login NUMBER := okl_api.G_MISS_NUM);
11: SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18: last_update_login NUMBER := okl_api.G_MISS_NUM);
19: g_miss_ALS_rec ALS_rec_type;
12: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18: last_update_login NUMBER := okl_api.G_MISS_NUM);
19: g_miss_ALS_rec ALS_rec_type;
20: TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
13: SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18: last_update_login NUMBER := okl_api.G_MISS_NUM);
19: g_miss_ALS_rec ALS_rec_type;
20: TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
21: INDEX BY BINARY_INTEGER;
14: created_by NUMBER := okl_api.G_MISS_NUM,
15: creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16: last_updated_by NUMBER := okl_api.G_MISS_NUM,
17: last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18: last_update_login NUMBER := okl_api.G_MISS_NUM);
19: g_miss_ALS_rec ALS_rec_type;
20: TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ALSv_rec_type IS RECORD (
19: g_miss_ALS_rec ALS_rec_type;
20: TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ALSv_rec_type IS RECORD (
23: id NUMBER := okl_api.G_MISS_NUM,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
20: TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE ALSv_rec_type IS RECORD (
23: id NUMBER := okl_api.G_MISS_NUM,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
21: INDEX BY BINARY_INTEGER;
22: TYPE ALSv_rec_type IS RECORD (
23: id NUMBER := okl_api.G_MISS_NUM,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
22: TYPE ALSv_rec_type IS RECORD (
23: id NUMBER := okl_api.G_MISS_NUM,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
23: id NUMBER := okl_api.G_MISS_NUM,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
24: object_version_number NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
25: AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
26: SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
27: PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_ALSv_rec ALSv_rec_type;
28: SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_ALSv_rec ALSv_rec_type;
36: TYPE ALSv_tbl_type IS TABLE OF ALSv_rec_type
29: org_id NUMBER := okl_api.G_MISS_NUM,
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_ALSv_rec ALSv_rec_type;
36: TYPE ALSv_tbl_type IS TABLE OF ALSv_rec_type
37: INDEX BY BINARY_INTEGER;
30: created_by NUMBER := okl_api.G_MISS_NUM,
31: creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32: last_updated_by NUMBER := okl_api.G_MISS_NUM,
33: last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34: last_update_login NUMBER := okl_api.G_MISS_NUM);
35: g_miss_ALSv_rec ALSv_rec_type;
36: TYPE ALSv_tbl_type IS TABLE OF ALSv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
42: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
43: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
45: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
46: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
43: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
45: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
46: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
44: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
45: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
46: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
45: G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
46: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
46: G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
47: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
49: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
50: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
51: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
52: G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ALS_PVT';
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ALS_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
62: ---------------------------------------------------------------------------
63: -- Procedures and Functions
64: ---------------------------------------------------------------------------
65: PROCEDURE qc;
66: PROCEDURE change_version;
67: PROCEDURE api_copy;
68: PROCEDURE insert_row(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_ALSv_rec IN ALSv_rec_type,
74: p_ALSv_rec IN ALSv_rec_type,
75: x_ALSv_rec OUT NOCOPY ALSv_rec_type);
76: PROCEDURE insert_row(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_ALSv_tbl IN ALSv_tbl_type,
82: p_ALSv_tbl IN ALSv_tbl_type,
83: x_ALSv_tbl OUT NOCOPY ALSv_tbl_type);
84: PROCEDURE lock_row(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_ALSv_rec IN ALSv_rec_type);
89: x_msg_data OUT NOCOPY VARCHAR2,
90: p_ALSv_rec IN ALSv_rec_type);
91: PROCEDURE lock_row(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_ALSv_tbl IN ALSv_tbl_type);
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_ALSv_tbl IN ALSv_tbl_type);
98: PROCEDURE update_row(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_ALSv_rec IN ALSv_rec_type,
104: p_ALSv_rec IN ALSv_rec_type,
105: x_ALSv_rec OUT NOCOPY ALSv_rec_type);
106: PROCEDURE update_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_ALSv_tbl IN ALSv_tbl_type,
112: p_ALSv_tbl IN ALSv_tbl_type,
113: x_ALSv_tbl OUT NOCOPY ALSv_tbl_type);
114: PROCEDURE delete_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_ALSv_rec IN ALSv_rec_type);
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_ALSv_rec IN ALSv_rec_type);
121: PROCEDURE delete_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_ALSv_tbl IN ALSv_tbl_type);
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_ALSv_tbl IN ALSv_tbl_type);
128: PROCEDURE validate_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_ALSv_rec IN ALSv_rec_type);
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_ALSv_rec IN ALSv_rec_type);
135: PROCEDURE validate_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_ALSv_tbl IN ALSv_tbl_type);