DBA Data[Home] [Help]

APPS.OKS_TEMPLATE_SET_PVT dependencies on OKS_TEMPLATE_SET_V

Line 6: -- OKS_TEMPLATE_SET_V Record Spec

2: /* $Header: OKSTMPSS.pls 120.3 2006/09/12 23:55:26 gpriya noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM

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

6: -- OKS_TEMPLATE_SET_V Record Spec
7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM

Line 11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

7: TYPE tmsv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM

Line 12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,name OKS_TEMPLATE_SET_V.NAME%TYPE := OKC_API.G_MISS_CHAR
10: ,description OKS_TEMPLATE_SET_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
11: ,start_date OKS_TEMPLATE_SET_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR

12: ,end_date OKS_TEMPLATE_SET_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR

13: ,org_id NUMBER := OKC_API.G_MISS_NUM
14: ,quote_letter NUMBER := OKC_API.G_MISS_NUM
15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

15: ,cover_letter NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_TEMPLATE_SET_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

Line 21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

17: ,template_source OKS_TEMPLATE_SET_V.TEMPLATE_SOURCE%TYPE := OKC_API.G_MISS_CHAR
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_TEMPLATE_SET_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_TEMPLATE_SET_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
24: G_MISS_tmsv_rec tmsv_rec_type;
25: TYPE tmsv_tbl_type IS TABLE OF tmsv_rec_type