[Home] [Help]
PACKAGE: APPS.OKC_QPP_PVT
Source
1 Package OKC_QPP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSQPPS.pls 120.0 2005/05/25 22:44:36 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE qpp_rec_type IS RECORD (
8 pdp_id NUMBER := OKC_API.G_MISS_NUM,
9 qlp_pdf_id NUMBER := OKC_API.G_MISS_NUM,
10 qlp_qcl_id NUMBER := OKC_API.G_MISS_NUM,
11 qlp_run_sequence NUMBER := OKC_API.G_MISS_NUM,
12 parm_value OKC_QA_PROCESS_PARMS.PARM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
13 object_version_number NUMBER := OKC_API.G_MISS_NUM,
14 created_by NUMBER := OKC_API.G_MISS_NUM,
15 creation_date OKC_QA_PROCESS_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17 last_update_date OKC_QA_PROCESS_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_update_login NUMBER := OKC_API.G_MISS_NUM,
19 attribute_category OKC_QA_PROCESS_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20 attribute1 OKC_QA_PROCESS_PARMS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21 attribute2 OKC_QA_PROCESS_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22 attribute3 OKC_QA_PROCESS_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23 attribute4 OKC_QA_PROCESS_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24 attribute5 OKC_QA_PROCESS_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25 attribute6 OKC_QA_PROCESS_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26 attribute7 OKC_QA_PROCESS_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27 attribute8 OKC_QA_PROCESS_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28 attribute9 OKC_QA_PROCESS_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29 attribute10 OKC_QA_PROCESS_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30 attribute11 OKC_QA_PROCESS_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31 attribute12 OKC_QA_PROCESS_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32 attribute13 OKC_QA_PROCESS_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33 attribute14 OKC_QA_PROCESS_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34 attribute15 OKC_QA_PROCESS_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
35 g_miss_qpp_rec qpp_rec_type;
36 TYPE qpp_tbl_type IS TABLE OF qpp_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE qppv_rec_type IS RECORD (
39 qlp_qcl_id NUMBER := OKC_API.G_MISS_NUM,
40 qlp_pdf_id NUMBER := OKC_API.G_MISS_NUM,
41 qlp_run_sequence NUMBER := OKC_API.G_MISS_NUM,
42 pdp_id NUMBER := OKC_API.G_MISS_NUM,
43 object_version_number NUMBER := OKC_API.G_MISS_NUM,
44 parm_value OKC_QA_PROCESS_PARMS_V.PARM_VALUE%TYPE := OKC_API.G_MISS_CHAR,
45 attribute_category OKC_QA_PROCESS_PARMS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
46 attribute1 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
47 attribute2 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
48 attribute3 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
49 attribute4 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
50 attribute5 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
51 attribute6 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
52 attribute7 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
53 attribute8 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
54 attribute9 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
55 attribute10 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
56 attribute11 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
57 attribute12 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
58 attribute13 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
59 attribute14 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
60 attribute15 OKC_QA_PROCESS_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
61 created_by NUMBER := OKC_API.G_MISS_NUM,
62 creation_date OKC_QA_PROCESS_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
63 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
64 last_update_date OKC_QA_PROCESS_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
65 last_update_login NUMBER := OKC_API.G_MISS_NUM);
66 g_miss_qppv_rec qppv_rec_type;
67 TYPE qppv_tbl_type IS TABLE OF qppv_rec_type
68 INDEX BY BINARY_INTEGER;
69 ---------------------------------------------------------------------------
70 -- GLOBAL MESSAGE CONSTANTS
71 ---------------------------------------------------------------------------
72 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
73 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
74 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
75 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
76 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
77 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
78 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
79 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
80 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
81 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
82 ---------------------------------------------------------------------------
83 -- GLOBAL VARIABLES
84 ---------------------------------------------------------------------------
85 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QPP_PVT';
86 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
87 ---------------------------------------------------------------------------
88 -- Procedures and Functions
89 ---------------------------------------------------------------------------
90
91 PROCEDURE qc;
92 PROCEDURE change_version;
93 PROCEDURE api_copy;
94 PROCEDURE insert_row(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_qppv_rec IN qppv_rec_type,
101 x_qppv_rec OUT NOCOPY qppv_rec_type);
102
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_qppv_tbl IN qppv_tbl_type,
110 x_qppv_tbl OUT NOCOPY qppv_tbl_type);
111
112 PROCEDURE lock_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_qppv_rec IN qppv_rec_type);
119
120 PROCEDURE lock_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_qppv_tbl IN qppv_tbl_type);
127
128 PROCEDURE update_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_qppv_rec IN qppv_rec_type,
135 x_qppv_rec OUT NOCOPY qppv_rec_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_qppv_tbl IN qppv_tbl_type,
144 x_qppv_tbl OUT NOCOPY qppv_tbl_type);
145
146 PROCEDURE delete_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_qppv_rec IN qppv_rec_type);
153
154 PROCEDURE delete_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_qppv_tbl IN qppv_tbl_type);
161
162 PROCEDURE validate_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_qppv_rec IN qppv_rec_type);
169
170 PROCEDURE validate_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_qppv_tbl IN qppv_tbl_type);
177
178 END OKC_QPP_PVT;