APPS.OKL_PTQ_PVT dependencies on OKL_PTL_QUALITYS

Line 8: name OKL_PTL_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ptq_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PTL_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

6: TYPE ptq_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PTL_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PTL_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

8: name OKL_PTL_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_PTL_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

10: description OKL_PTL_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
11: from_date OKL_PTL_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_PTL_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_ptq_rec ptq_rec_type;

Line 16: last_update_date OKL_PTL_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

12: to_date OKL_PTL_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKL_PTL_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKL_PTL_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM);
18: g_miss_ptq_rec ptq_rec_type;
19: TYPE ptq_tbl_type IS TABLE OF ptq_rec_type
20: INDEX BY BINARY_INTEGER;

Line 24: name OKL_PTL_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

20: INDEX BY BINARY_INTEGER;
21: TYPE ptqv_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
24: name OKL_PTL_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

21: TYPE ptqv_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
24: name OKL_PTL_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

22: id NUMBER := OKC_API.G_MISS_NUM,
23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
24: name OKL_PTL_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
24: name OKL_PTL_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_PTL_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

25: description OKL_PTL_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
26: from_date OKL_PTL_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_PTL_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_ptqv_rec ptqv_rec_type;

Line 31: last_update_date OKL_PTL_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

27: to_date OKL_PTL_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
28: created_by NUMBER := OKC_API.G_MISS_NUM,
29: creation_date OKL_PTL_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31: last_update_date OKL_PTL_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM);
33: g_miss_ptqv_rec ptqv_rec_type;
34: TYPE ptqv_tbl_type IS TABLE OF ptqv_rec_type
35: INDEX BY BINARY_INTEGER;