[Home] [Help]
PACKAGE: APPS.OKC_PDP_PVT
Source
1 Package OKC_PDP_PVT AS
2 /* $Header: OKCSPDPS.pls 120.0 2005/05/25 18:31:07 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE OkcProcessDefParmsTlRecType IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 language OKC_PROCESS_DEF_PARMS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9 source_lang OKC_PROCESS_DEF_PARMS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10 sfwt_flag OKC_PROCESS_DEF_PARMS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11 name OKC_PROCESS_DEF_PARMS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12 description OKC_PROCESS_DEF_PARMS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKC_PROCESS_DEF_PARMS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKC_PROCESS_DEF_PARMS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_update_login NUMBER := OKC_API.G_MISS_NUM);
18 GMissOkcProcessDefParmsTlRec OkcProcessDefParmsTlRecType;
19 TYPE OkcProcessDefParmsTlTblType IS TABLE OF OkcProcessDefParmsTlRecType
20 INDEX BY BINARY_INTEGER;
21 TYPE pdp_rec_type IS RECORD (
22 id NUMBER := OKC_API.G_MISS_NUM,
23 pdf_id NUMBER := OKC_API.G_MISS_NUM,
24 name OKC_PROCESS_DEF_PARMS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
25 data_type OKC_PROCESS_DEF_PARMS_B.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26 required_yn OKC_PROCESS_DEF_PARMS_B.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
27 object_version_number NUMBER := OKC_API.G_MISS_NUM,
28 created_by NUMBER := OKC_API.G_MISS_NUM,
29 creation_date OKC_PROCESS_DEF_PARMS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31 last_update_date OKC_PROCESS_DEF_PARMS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32 default_value OKC_PROCESS_DEF_PARMS_B.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
33 last_update_login NUMBER := OKC_API.G_MISS_NUM,
34 application_id NUMBER := OKC_API.G_MISS_NUM,
35 seeded_flag OKC_PROCESS_DEF_PARMS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
36 jtot_object_code OKC_PROCESS_DEF_PARMS_B.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37 NAME_COLUMN OKC_PROCESS_DEF_PARMS_B.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
38 description_column OKC_PROCESS_DEF_PARMS_B.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
39 g_miss_pdp_rec pdp_rec_type;
40 TYPE pdp_tbl_type IS TABLE OF pdp_rec_type
41 INDEX BY BINARY_INTEGER;
42 TYPE pdpv_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM,
44 object_version_number NUMBER := OKC_API.G_MISS_NUM,
45 sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46 pdf_id NUMBER := OKC_API.G_MISS_NUM,
47 name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48 user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49 data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50 default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51 required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52 description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53 application_id NUMBER := OKC_API.G_MISS_NUM,
54 seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55 created_by NUMBER := OKC_API.G_MISS_NUM,
56 creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58 last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59 last_update_login NUMBER := OKC_API.G_MISS_NUM,
60 jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61 NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62 description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63 g_miss_pdpv_rec pdpv_rec_type;
64 TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
65 INDEX BY BINARY_INTEGER;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
80 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
81 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
82 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
83 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
84 ---------------------------------------------------------------------------
85 -- GLOBAL VARIABLES
86 ---------------------------------------------------------------------------
87 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PDP_PVT';
88 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89 G_VIEW CONSTANT VARCHAR2(200) := 'OKC_PROCESS_DEF_PARAMETERS_V';
90 ---------------------------------------------------------------------------
91 -- GLOBAL EXCEPTION
92 ---------------------------------------------------------------------------
93 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
94
95 ---------------------------------------------------------------------------
96 -- Procedures and Functions
97 ---------------------------------------------------------------------------
98
99 PROCEDURE qc;
100 PROCEDURE change_version;
101 PROCEDURE api_copy;
102 PROCEDURE add_language;
103 PROCEDURE insert_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_pdpv_rec IN pdpv_rec_type,
110 x_pdpv_rec OUT NOCOPY pdpv_rec_type);
111
112 PROCEDURE insert_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_pdpv_tbl IN pdpv_tbl_type,
119 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
120
121 PROCEDURE lock_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_pdpv_rec IN pdpv_rec_type);
128
129 PROCEDURE lock_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_pdpv_tbl IN pdpv_tbl_type);
136
137 PROCEDURE update_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_pdpv_rec IN pdpv_rec_type,
144 x_pdpv_rec OUT NOCOPY pdpv_rec_type);
145
146 PROCEDURE update_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_pdpv_tbl IN pdpv_tbl_type,
153 x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
154
155 PROCEDURE delete_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_pdpv_rec IN pdpv_rec_type);
162
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_pdpv_tbl IN pdpv_tbl_type);
170
171 PROCEDURE validate_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_pdpv_rec IN pdpv_rec_type);
178
179 PROCEDURE validate_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_pdpv_tbl IN pdpv_tbl_type);
186
187 END OKC_PDP_PVT;