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