[Home] [Help]
PACKAGE: APPS.OKL_GTT_PVT
Source
1 PACKAGE OKL_GTT_PVT AS
2 /* $Header: OKLSGTTS.pls 120.2 2006/07/11 10:20:25 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 TYPE gtt_rec_type IS RECORD (
8 id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
9 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10 ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11 ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12 ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
13 ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14 ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15 ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16 ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17 ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18 ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19 ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
20 ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
21 ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22 ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23 ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24 ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25 ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26 ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
27 ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
28 ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29 ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30 ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33 ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
34 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
35 ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
36 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
37 );
38
39
40 G_MISS_GTT_REC gtt_rec_type;
41 TYPE gtt_tbl_type IS TABLE OF gtt_rec_type
42 INDEX BY BINARY_INTEGER;
43
44 TYPE gttv_rec_type IS RECORD (
45 id OKL_ST_GEN_TEMPLATES.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
46 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
47 ,gts_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
48 ,version OKL_ST_GEN_TEMPLATES.VERSION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49 ,start_date OKL_ST_GEN_TEMPLATES.START_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
50 ,end_date OKL_ST_GEN_TEMPLATES.END_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
51 ,tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE DEFAULT Okl_Api.G_MISS_CHAR
52 ,attribute_category OKL_ST_GEN_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE DEFAULT Okl_Api.G_MISS_CHAR
53 ,attribute1 OKL_ST_GEN_TEMPLATES.ATTRIBUTE1%TYPE DEFAULT Okl_Api.G_MISS_CHAR
54 ,attribute2 OKL_ST_GEN_TEMPLATES.ATTRIBUTE2%TYPE DEFAULT Okl_Api.G_MISS_CHAR
55 ,attribute3 OKL_ST_GEN_TEMPLATES.ATTRIBUTE3%TYPE DEFAULT Okl_Api.G_MISS_CHAR
56 ,attribute4 OKL_ST_GEN_TEMPLATES.ATTRIBUTE4%TYPE DEFAULT Okl_Api.G_MISS_CHAR
57 ,attribute5 OKL_ST_GEN_TEMPLATES.ATTRIBUTE5%TYPE DEFAULT Okl_Api.G_MISS_CHAR
58 ,attribute6 OKL_ST_GEN_TEMPLATES.ATTRIBUTE6%TYPE DEFAULT Okl_Api.G_MISS_CHAR
59 ,attribute7 OKL_ST_GEN_TEMPLATES.ATTRIBUTE7%TYPE DEFAULT Okl_Api.G_MISS_CHAR
60 ,attribute8 OKL_ST_GEN_TEMPLATES.ATTRIBUTE8%TYPE DEFAULT Okl_Api.G_MISS_CHAR
61 ,attribute9 OKL_ST_GEN_TEMPLATES.ATTRIBUTE9%TYPE DEFAULT Okl_Api.G_MISS_CHAR
62 ,attribute10 OKL_ST_GEN_TEMPLATES.ATTRIBUTE10%TYPE DEFAULT Okl_Api.G_MISS_CHAR
63 ,attribute11 OKL_ST_GEN_TEMPLATES.ATTRIBUTE11%TYPE DEFAULT Okl_Api.G_MISS_CHAR
64 ,attribute12 OKL_ST_GEN_TEMPLATES.ATTRIBUTE12%TYPE DEFAULT Okl_Api.G_MISS_CHAR
65 ,attribute13 OKL_ST_GEN_TEMPLATES.ATTRIBUTE13%TYPE DEFAULT Okl_Api.G_MISS_CHAR
66 ,attribute14 OKL_ST_GEN_TEMPLATES.ATTRIBUTE14%TYPE DEFAULT Okl_Api.G_MISS_CHAR
67 ,attribute15 OKL_ST_GEN_TEMPLATES.ATTRIBUTE15%TYPE DEFAULT Okl_Api.G_MISS_CHAR
68 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
69 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
70 ,creation_date OKL_ST_GEN_TEMPLATES.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
71 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
72 ,last_update_date OKL_ST_GEN_TEMPLATES.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
73 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
74 );
75
76
77 G_MISS_GTTV_REC gttv_rec_type;
78 TYPE gttv_tbl_type IS TABLE OF gttv_rec_type
79 INDEX BY BINARY_INTEGER;
80
81 ---------------------------------------------------------------------------
82 -- GLOBAL VARIABLES
83 ---------------------------------------------------------------------------
84 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTT_PVT';
85 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
86 --------------------------------------------------------------------------------
87 -- ERRORS AND EXCEPTIONS
88 --------------------------------------------------------------------------------
89 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
90 ---------------------------------------------------------------------------
91 -- GLOBAL MESSAGE CONSTANTS
92 ---------------------------------------------------------------------------
93 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
94 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
97 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
98 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
99 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
100 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATE';
101
102 ---------------------------------------------------------------------------
103 -- Procedures and Functions
104 ---------------------------------------------------------------------------
105 PROCEDURE qc;
106 PROCEDURE change_version;
107 PROCEDURE api_copy;
108
109 PROCEDURE insert_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_gttv_rec IN gttv_rec_type,
116 x_gttv_rec OUT NOCOPY gttv_rec_type );
117
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_gttv_tbl IN gttv_tbl_type,
125 x_gttv_tbl OUT NOCOPY gttv_tbl_type);
126
127 PROCEDURE update_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_gttv_rec IN gttv_rec_type,
134 x_gttv_rec OUT NOCOPY gttv_rec_type);
135
136 PROCEDURE update_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_gttv_tbl IN gttv_tbl_type,
143 x_gttv_tbl OUT NOCOPY gttv_tbl_type);
144
145 PROCEDURE delete_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_gttv_rec IN gttv_rec_type);
152
153 PROCEDURE delete_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_gttv_tbl IN gttv_tbl_type);
160
161 END okl_gtt_pvt;