DBA Data[Home] [Help]

APPS.OKL_PQY_PVT dependencies on OKL_PDT_QUALITYS

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

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

Line 9: location_yn OKL_PDT_QUALITYS.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE pqy_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: name OKL_PDT_QUALITYS.NAME%TYPE := OKC_API.G_MISS_CHAR,
9: location_yn OKL_PDT_QUALITYS.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: description OKL_PDT_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
12: from_date OKL_PDT_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
13: to_date OKL_PDT_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 11: description OKL_PDT_QUALITYS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

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

Line 12: from_date OKL_PDT_QUALITYS.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 13: to_date OKL_PDT_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 15: creation_date OKL_PDT_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 17: last_update_date OKL_PDT_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

13: to_date OKL_PDT_QUALITYS.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKL_PDT_QUALITYS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKL_PDT_QUALITYS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_update_login NUMBER := OKC_API.G_MISS_NUM);
19: g_miss_pqy_rec pqy_rec_type;
20: TYPE pqy_tbl_type IS TABLE OF pqy_rec_type
21: INDEX BY BINARY_INTEGER;

Line 25: name OKL_PDT_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

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

Line 26: description OKL_PDT_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

22: TYPE pqyv_rec_type IS RECORD (
23: id NUMBER := OKC_API.G_MISS_NUM,
24: object_version_number NUMBER := OKC_API.G_MISS_NUM,
25: name OKL_PDT_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
26: description OKL_PDT_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: location_yn OKL_PDT_QUALITYS_V.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_PDT_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_PDT_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 27: location_yn OKL_PDT_QUALITYS_V.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,

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

Line 28: from_date OKL_PDT_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 29: to_date OKL_PDT_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,

25: name OKL_PDT_QUALITYS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
26: description OKL_PDT_QUALITYS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
27: location_yn OKL_PDT_QUALITYS_V.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_PDT_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_PDT_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 31: creation_date OKL_PDT_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

27: location_yn OKL_PDT_QUALITYS_V.LOCATION_YN%TYPE := OKC_API.G_MISS_CHAR,
28: from_date OKL_PDT_QUALITYS_V.FROM_DATE%TYPE := OKC_API.G_MISS_DATE,
29: to_date OKL_PDT_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_pqyv_rec pqyv_rec_type;

Line 33: last_update_date OKL_PDT_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

29: to_date OKL_PDT_QUALITYS_V.TO_DATE%TYPE := OKC_API.G_MISS_DATE,
30: created_by NUMBER := OKC_API.G_MISS_NUM,
31: creation_date OKL_PDT_QUALITYS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
32: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
33: last_update_date OKL_PDT_QUALITYS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
34: last_update_login NUMBER := OKC_API.G_MISS_NUM);
35: g_miss_pqyv_rec pqyv_rec_type;
36: TYPE pqyv_tbl_type IS TABLE OF pqyv_rec_type
37: INDEX BY BINARY_INTEGER;