[Home] [Help]
PACKAGE: APPS.OKL_RPP_PVT
Source
1 PACKAGE OKL_RPP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSRPPS.pls 120.1 2007/12/31 11:07:22 dcshanmu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_REPORT_PARAMETERS Record Spec
7 TYPE rpp_rec_type IS RECORD (
8 parameter_id NUMBER
9 ,report_id NUMBER
10 ,parameter_type OKL_REPORT_PARAMETERS.PARAMETER_TYPE_CODE%TYPE
11 ,param_num_value1 NUMBER
12 ,param_char_value1 OKL_REPORT_PARAMETERS.PARAM_CHAR_VALUE1%TYPE
13 ,param_date_value1 OKL_REPORT_PARAMETERS.PARAM_DATE_VALUE1%TYPE
14 ,created_by NUMBER
15 ,source_table OKL_REPORT_PARAMETERS.SOURCE_TABLE%TYPE
16 ,creation_date OKL_REPORT_PARAMETERS.CREATION_DATE%TYPE
17 ,last_updated_by NUMBER
18 ,last_update_date OKL_REPORT_PARAMETERS.LAST_UPDATE_DATE%TYPE
19 ,last_update_login NUMBER);
20 G_MISS_rpp_rec rpp_rec_type;
21 TYPE rpp_tbl_type IS TABLE OF rpp_rec_type
22 INDEX BY BINARY_INTEGER;
23 ---------------------------------------------------------------------------
24 -- GLOBAL MESSAGE CONSTANTS
25 ---------------------------------------------------------------------------
26 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
27 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
28 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
29 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
30 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
31 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
32 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
33 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
34 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
35 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
36 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
37 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
38 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
39 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
40 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
41
42 ---------------------------------------------------------------------------
43 -- GLOBAL EXCEPTIONS
44 ---------------------------------------------------------------------------
45 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
46
47 ---------------------------------------------------------------------------
48 -- GLOBAL VARIABLES
49 ---------------------------------------------------------------------------
50 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RPP_PVT';
51 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
52 ---------------------------------------------------------------------------
53 -- Procedures and Functions
54 ---------------------------------------------------------------------------
55
56 PROCEDURE qc;
57 PROCEDURE change_version;
58 PROCEDURE api_copy;
59 PROCEDURE insert_row(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_rpp_rec IN rpp_rec_type,
66 x_rpp_rec OUT NOCOPY rpp_rec_type);
67 PROCEDURE insert_row(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_rpp_tbl IN rpp_tbl_type,
74 x_rpp_tbl OUT NOCOPY rpp_tbl_type,
75 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
76 PROCEDURE insert_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_rpp_tbl IN rpp_tbl_type,
83 x_rpp_tbl OUT NOCOPY rpp_tbl_type);
84 PROCEDURE lock_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_rpp_rec IN rpp_rec_type);
91 PROCEDURE lock_row(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_rpp_tbl IN rpp_tbl_type,
98 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
99 PROCEDURE lock_row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_rpp_tbl IN rpp_tbl_type);
106 PROCEDURE update_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_rpp_rec IN rpp_rec_type,
113 x_rpp_rec OUT NOCOPY rpp_rec_type);
114 PROCEDURE update_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_rpp_tbl IN rpp_tbl_type,
121 x_rpp_tbl OUT NOCOPY rpp_tbl_type,
122 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
123 PROCEDURE update_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_rpp_tbl IN rpp_tbl_type,
130 x_rpp_tbl OUT NOCOPY rpp_tbl_type);
131 PROCEDURE delete_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_rpp_rec IN rpp_rec_type);
138 PROCEDURE delete_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_rpp_tbl IN rpp_tbl_type,
145 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
146 PROCEDURE delete_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_rpp_tbl IN rpp_tbl_type);
153 PROCEDURE validate_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_rpp_rec IN rpp_rec_type);
160 PROCEDURE validate_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_rpp_tbl IN rpp_tbl_type,
167 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
168 PROCEDURE validate_row(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_rpp_tbl IN rpp_tbl_type);
175 END OKL_RPP_PVT;