[Home] [Help]
PACKAGE: APPS.OKL_PTM_PVT
Source
1 PACKAGE Okl_Ptm_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSPTMS.pls 120.3 2007/01/30 14:08:42 ansethur noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ptm_rec_type IS RECORD (
7 id NUMBER := OKL_API.G_MISS_NUM,
8 org_id NUMBER := OKL_API.G_MISS_NUM,
9 ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
10 /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
11 -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
12 jtf_amv_item_id NUMBER := -1,
13 /* END Changes */
14 start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
15 end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
16 object_version_number NUMBER := OKL_API.G_MISS_NUM,
17 attribute_category OKL_PROCESS_TMPLTS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
18 attribute1 OKL_PROCESS_TMPLTS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
19 attribute2 OKL_PROCESS_TMPLTS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
20 attribute3 OKL_PROCESS_TMPLTS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
21 attribute4 OKL_PROCESS_TMPLTS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
22 attribute5 OKL_PROCESS_TMPLTS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
23 attribute6 OKL_PROCESS_TMPLTS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
24 attribute7 OKL_PROCESS_TMPLTS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
25 attribute8 OKL_PROCESS_TMPLTS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
26 attribute9 OKL_PROCESS_TMPLTS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
27 attribute10 OKL_PROCESS_TMPLTS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
28 attribute11 OKL_PROCESS_TMPLTS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
29 attribute12 OKL_PROCESS_TMPLTS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
30 attribute13 OKL_PROCESS_TMPLTS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
31 attribute14 OKL_PROCESS_TMPLTS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
32 attribute15 OKL_PROCESS_TMPLTS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
33 created_by NUMBER := OKL_API.G_MISS_NUM,
34 creation_date OKL_PROCESS_TMPLTS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
35 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
36 last_update_date OKL_PROCESS_TMPLTS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
37 last_update_login NUMBER := OKL_API.G_MISS_NUM,
38 /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
39 recipient_type_code OKL_PROCESS_TMPLTS_B.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
40 xml_tmplt_code OKL_PROCESS_TMPLTS_B.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
41 /* End Changes : R12 B */
42 g_miss_ptm_rec ptm_rec_type;
43
44 TYPE ptm_tbl_type IS TABLE OF ptm_rec_type
45 INDEX BY BINARY_INTEGER;
46
47 TYPE okl_process_tmplts_tl_rec_type IS RECORD (
48 id NUMBER := OKL_API.G_MISS_NUM,
49 language OKL_PROCESS_TMPLTS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
50 source_lang OKL_PROCESS_TMPLTS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
51 sfwt_flag OKL_PROCESS_TMPLTS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
52 email_subject_line OKL_PROCESS_TMPLTS_TL.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
53 created_by NUMBER := OKL_API.G_MISS_NUM,
54 creation_date OKL_PROCESS_TMPLTS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
55 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
56 last_update_date OKL_PROCESS_TMPLTS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
57 last_update_login NUMBER := OKL_API.G_MISS_NUM);
58
59 GMissOklProcessTmpltsTlRec okl_process_tmplts_tl_rec_type;
60
61 TYPE okl_process_tmplts_tl_tbl_type IS TABLE OF okl_process_tmplts_tl_rec_type
62 INDEX BY BINARY_INTEGER;
63
64
65 TYPE ptmv_rec_type IS RECORD (
66 id NUMBER := OKL_API.G_MISS_NUM,
67 org_id NUMBER := OKL_API.G_MISS_NUM,
68 ptm_code OKL_PROCESS_TMPLTS_B.PTM_CODE%TYPE := OKL_API.G_MISS_CHAR,
69 /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
70 -- jtf_amv_item_id NUMBER := OKL_API.G_MISS_NUM,
71 jtf_amv_item_id NUMBER := -1,
72 /* End Changes : R12 B */
73 sfwt_flag OKL_PROCESS_TMPLTS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
74 email_subject_line OKL_PROCESS_TMPLTS_V.EMAIL_SUBJECT_LINE%TYPE := OKL_API.G_MISS_CHAR,
75 start_date OKL_PROCESS_TMPLTS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE,
76 end_date OKL_PROCESS_TMPLTS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE,
77 object_version_number NUMBER := OKL_API.G_MISS_NUM,
78 attribute_category OKL_PROCESS_TMPLTS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
79 attribute1 OKL_PROCESS_TMPLTS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
80 attribute2 OKL_PROCESS_TMPLTS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
81 attribute3 OKL_PROCESS_TMPLTS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
82 attribute4 OKL_PROCESS_TMPLTS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
83 attribute5 OKL_PROCESS_TMPLTS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
84 attribute6 OKL_PROCESS_TMPLTS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
85 attribute7 OKL_PROCESS_TMPLTS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
86 attribute8 OKL_PROCESS_TMPLTS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
87 attribute9 OKL_PROCESS_TMPLTS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
88 attribute10 OKL_PROCESS_TMPLTS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
89 attribute11 OKL_PROCESS_TMPLTS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
90 attribute12 OKL_PROCESS_TMPLTS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
91 attribute13 OKL_PROCESS_TMPLTS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
92 attribute14 OKL_PROCESS_TMPLTS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
93 attribute15 OKL_PROCESS_TMPLTS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
94 created_by NUMBER := OKL_API.G_MISS_NUM,
95 creation_date OKL_PROCESS_TMPLTS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
96 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
97 last_update_date OKL_PROCESS_TMPLTS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
98 last_update_login NUMBER := OKL_API.G_MISS_NUM,
99 /* 13-OCT-2006 ANSETHUR BUILD: R12 B Start Changes */
100 recipient_type_code OKL_PROCESS_TMPLTS_V.RECIPIENT_TYPE_CODE%TYPE :=OKL_API.G_MISS_CHAR,
101 xml_tmplt_code OKL_PROCESS_TMPLTS_V.XML_TMPLT_CODE%TYPE :=OKL_API.G_MISS_CHAR);
102 /* End Changes : R12 B */
103
104 g_miss_ptmv_rec ptmv_rec_type;
105
106 TYPE ptmv_tbl_type IS TABLE OF ptmv_rec_type
107 INDEX BY BINARY_INTEGER;
108
109 ---------------------------------------------------------------------------
110 -- GLOBAL MESSAGE CONSTANTS
111 ---------------------------------------------------------------------------
112 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
113 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
114 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
115 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
116 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
117 -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
118 -- OKL_API bug (points to OKL_CONTRACTS_REQUIRED_VALUE instead of OKL_REQUIRED_VALUE)
119
120 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
121
122 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126 ---------------------------------------------------------------------------
127 -- GLOBAL MESSAGE CONSTANTS - Post TAPI generation
128 ---------------------------------------------------------------------------
129 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
130 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
131 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
132 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
133 ---------------------------------------------------------------------------
134 -- GLOBAL EXCEPTIONS - Post TAPI generation
135 ---------------------------------------------------------------------------
136 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
137 ---------------------------------------------------------------------------
138 -- GLOBAL VARIABLES
139 ---------------------------------------------------------------------------
140 G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_Ptm_Pvt';
141 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
142 ---------------------------------------------------------------------------
143 -- Procedures and Functions
144 ---------------------------------------------------------------------------
145 PROCEDURE qc;
146 PROCEDURE change_version;
147 PROCEDURE api_copy;
148 PROCEDURE add_language;
149
150 PROCEDURE insert_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_ptmv_rec IN ptmv_rec_type,
157 x_ptmv_rec OUT NOCOPY ptmv_rec_type);
158 PROCEDURE insert_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_ptmv_tbl IN ptmv_tbl_type,
165 x_ptmv_tbl OUT NOCOPY ptmv_tbl_type);
166 PROCEDURE lock_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_ptmv_rec IN ptmv_rec_type);
173 PROCEDURE lock_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_ptmv_tbl IN ptmv_tbl_type);
180 PROCEDURE update_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_ptmv_rec IN ptmv_rec_type,
187 x_ptmv_rec OUT NOCOPY ptmv_rec_type);
188 PROCEDURE update_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_ptmv_tbl IN ptmv_tbl_type,
195 x_ptmv_tbl OUT NOCOPY ptmv_tbl_type);
196 PROCEDURE delete_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_ptmv_rec IN ptmv_rec_type);
203 PROCEDURE delete_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_ptmv_tbl IN ptmv_tbl_type);
210 PROCEDURE validate_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_ptmv_rec IN ptmv_rec_type);
217 PROCEDURE validate_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_ptmv_tbl IN ptmv_tbl_type);
224
225 END Okl_Ptm_Pvt;
226