DBA Data[Home] [Help]

APPS.OKC_TCU_PVT dependencies on OKC_API

Line 16: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: --G_UNQS CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
14: G_UNQS1 CONSTANT VARCHAR2(200) := 'OKC_TCE_UOM_CODE_NOT_UNIQUE';
15: G_UNQS2 CONSTANT VARCHAR2(200) := 'OKC_QTY_UOM_CODE_NOT_UNIQUE';
16: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (

Line 18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;

14: G_UNQS1 CONSTANT VARCHAR2(200) := 'OKC_TCE_UOM_CODE_NOT_UNIQUE';
15: G_UNQS2 CONSTANT VARCHAR2(200) := 'OKC_QTY_UOM_CODE_NOT_UNIQUE';
16: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,

Line 19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;

15: G_UNQS2 CONSTANT VARCHAR2(200) := 'OKC_QTY_UOM_CODE_NOT_UNIQUE';
16: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,

Line 21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,

17: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,

18: G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 23: quantity NUMBER := OKC_API.G_MISS_NUM,

19: G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,

20: TYPE tcu_rec_type IS RECORD (
21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 25: object_version_number NUMBER := OKC_API.G_MISS_NUM,

21: tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 26: created_by NUMBER := OKC_API.G_MISS_NUM,

22: uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

23: quantity NUMBER := OKC_API.G_MISS_NUM,
24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

24: active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 30: last_update_login NUMBER := OKC_API.G_MISS_NUM,

26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

27: creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

29: last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

30: last_update_login NUMBER := OKC_API.G_MISS_NUM,
31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

31: attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

32: attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

33: attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

34: attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

35: attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

36: attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

37: attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

38: attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

Line 43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

39: attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
47: g_miss_tcu_rec tcu_rec_type;

Line 44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

40: attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
47: g_miss_tcu_rec tcu_rec_type;
48: TYPE tcu_tbl_type IS TABLE OF tcu_rec_type

Line 45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

41: attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
47: g_miss_tcu_rec tcu_rec_type;
48: TYPE tcu_tbl_type IS TABLE OF tcu_rec_type
49: INDEX BY BINARY_INTEGER;

Line 46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);

42: attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43: attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44: attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45: attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46: attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
47: g_miss_tcu_rec tcu_rec_type;
48: TYPE tcu_tbl_type IS TABLE OF tcu_rec_type
49: INDEX BY BINARY_INTEGER;
50: TYPE OkcTimeCodeUnitsTlRecType IS RECORD (

Line 51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,

47: g_miss_tcu_rec tcu_rec_type;
48: TYPE tcu_tbl_type IS TABLE OF tcu_rec_type
49: INDEX BY BINARY_INTEGER;
50: TYPE OkcTimeCodeUnitsTlRecType IS RECORD (
51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,

48: TYPE tcu_tbl_type IS TABLE OF tcu_rec_type
49: INDEX BY BINARY_INTEGER;
50: TYPE OkcTimeCodeUnitsTlRecType IS RECORD (
51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,

49: INDEX BY BINARY_INTEGER;
50: TYPE OkcTimeCodeUnitsTlRecType IS RECORD (
51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,

50: TYPE OkcTimeCodeUnitsTlRecType IS RECORD (
51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

51: uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

52: tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

53: language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

54: source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 59: created_by NUMBER := OKC_API.G_MISS_NUM,

55: sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

56: short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: last_update_login NUMBER := OKC_API.G_MISS_NUM);
64: GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;

Line 61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

57: description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: last_update_login NUMBER := OKC_API.G_MISS_NUM);
64: GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;
65: TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType

Line 62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

58: comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: last_update_login NUMBER := OKC_API.G_MISS_NUM);
64: GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;
65: TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType
66: INDEX BY BINARY_INTEGER;

Line 63: last_update_login NUMBER := OKC_API.G_MISS_NUM);

59: created_by NUMBER := OKC_API.G_MISS_NUM,
60: creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62: last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63: last_update_login NUMBER := OKC_API.G_MISS_NUM);
64: GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;
65: TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType
66: INDEX BY BINARY_INTEGER;
67: TYPE tcuv_rec_type IS RECORD (

Line 68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,

64: GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;
65: TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType
66: INDEX BY BINARY_INTEGER;
67: TYPE tcuv_rec_type IS RECORD (
68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,

Line 69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,

65: TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType
66: INDEX BY BINARY_INTEGER;
67: TYPE tcuv_rec_type IS RECORD (
68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 70: object_version_number NUMBER := OKC_API.G_MISS_NUM,

66: INDEX BY BINARY_INTEGER;
67: TYPE tcuv_rec_type IS RECORD (
68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

67: TYPE tcuv_rec_type IS RECORD (
68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 72: quantity NUMBER := OKC_API.G_MISS_NUM,

68: uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

Line 73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,

69: tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

70: object_version_number NUMBER := OKC_API.G_MISS_NUM,
71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

71: sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,

72: quantity NUMBER := OKC_API.G_MISS_NUM,
73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

73: active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

74: short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

75: description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

76: comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

77: attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

78: attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

79: attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

80: attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

81: attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

82: attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

83: attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

84: attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

85: attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

86: attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

87: attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

88: attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 93: created_by NUMBER := OKC_API.G_MISS_NUM,

89: attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

90: attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: g_miss_tcuv_rec tcuv_rec_type;

Line 95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

91: attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: g_miss_tcuv_rec tcuv_rec_type;
99: TYPE tcuv_tbl_type IS TABLE OF tcuv_rec_type

Line 96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

92: attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: g_miss_tcuv_rec tcuv_rec_type;
99: TYPE tcuv_tbl_type IS TABLE OF tcuv_rec_type
100: INDEX BY BINARY_INTEGER;

Line 97: last_update_login NUMBER := OKC_API.G_MISS_NUM);

93: created_by NUMBER := OKC_API.G_MISS_NUM,
94: creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96: last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97: last_update_login NUMBER := OKC_API.G_MISS_NUM);
98: g_miss_tcuv_rec tcuv_rec_type;
99: TYPE tcuv_tbl_type IS TABLE OF tcuv_rec_type
100: INDEX BY BINARY_INTEGER;
101: ---------------------------------------------------------------------------

Line 104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

100: INDEX BY BINARY_INTEGER;
101: ---------------------------------------------------------------------------
102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

101: ---------------------------------------------------------------------------
102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

102: -- GLOBAL MESSAGE CONSTANTS
103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

103: ---------------------------------------------------------------------------
104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

104: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';

Line 109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

105: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113: G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';

Line 110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

106: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113: G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

107: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113: G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

110: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113: G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
118: ---------------------------------------------------------------------------

Line 115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

111: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112: G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113: G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
114: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
118: ---------------------------------------------------------------------------
119: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TCU_PVT';

Line 120: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

116: ---------------------------------------------------------------------------
117: -- GLOBAL VARIABLES
118: ---------------------------------------------------------------------------
119: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TCU_PVT';
120: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
121: ---------------------------------------------------------------------------
122: -- Procedures and Functions
123: ---------------------------------------------------------------------------
124:

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: PROCEDURE api_copy;
128: PROCEDURE add_language;
129: PROCEDURE insert_row(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_tcuv_rec IN tcuv_rec_type,

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

136: x_tcuv_rec OUT NOCOPY tcuv_rec_type);
137:
138: PROCEDURE insert_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_tcuv_tbl IN tcuv_tbl_type,

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145: x_tcuv_tbl OUT NOCOPY tcuv_tbl_type);
146:
147: PROCEDURE lock_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_tcuv_rec IN tcuv_rec_type);

Line 157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

153: p_tcuv_rec IN tcuv_rec_type);
154:
155: PROCEDURE lock_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_tcuv_tbl IN tcuv_tbl_type);

Line 165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

161: p_tcuv_tbl IN tcuv_tbl_type);
162:
163: PROCEDURE update_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_tcuv_rec IN tcuv_rec_type,

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: x_tcuv_rec OUT NOCOPY tcuv_rec_type);
171:
172: PROCEDURE update_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_tcuv_tbl IN tcuv_tbl_type,

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

179: x_tcuv_tbl OUT NOCOPY tcuv_tbl_type);
180:
181: PROCEDURE delete_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_tcuv_rec IN tcuv_rec_type);

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: p_tcuv_rec IN tcuv_rec_type);
188:
189: PROCEDURE delete_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_tcuv_tbl IN tcuv_tbl_type);

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

195: p_tcuv_tbl IN tcuv_tbl_type);
196:
197: PROCEDURE validate_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_tcuv_rec IN tcuv_rec_type);

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

203: p_tcuv_rec IN tcuv_rec_type);
204:
205: PROCEDURE validate_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_tcuv_tbl IN tcuv_tbl_type);