DBA Data[Home] [Help]

APPS.OKC_SECTIONS_PVT dependencies on OKC_SCN_PVT

Line 73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,

69: p_init_msg_list IN VARCHAR2 ,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN

Line 74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS

70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
78: -- initialize return status

Line 76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;

72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
74: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
75:
76: l_scnv_rec OKC_SCN_PVT.scnv_rec_type := p_scnv_rec;
77: BEGIN
78: -- initialize return status
79: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80:

Line 81: OKC_SCN_PVT.Insert_Row(

77: BEGIN
78: -- initialize return status
79: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80:
81: OKC_SCN_PVT.Insert_Row(
82: p_api_version => p_api_version,
83: p_init_msg_list => p_init_msg_list,
84: x_return_status => x_return_status,
85: x_msg_count => x_msg_count,

Line 105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,

101: p_init_msg_list IN VARCHAR2 ,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_Row(

Line 106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS

102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_Row(
110: p_api_version => p_api_version,

Line 109: OKC_SCN_PVT.Insert_Row(

105: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
106: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
107:
108: BEGIN
109: OKC_SCN_PVT.Insert_Row(
110: p_api_version => p_api_version,
111: p_init_msg_list => p_init_msg_list,
112: x_return_status => x_return_status,
113: x_msg_count => x_msg_count,

Line 125: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,

121: p_init_msg_list IN VARCHAR2 ,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:

Line 126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS

122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type,
126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:
130: OKC_SCN_PVT.Update_Row(

Line 130: OKC_SCN_PVT.Update_Row(

126: x_scnv_rec OUT NOCOPY OKC_SCN_PVT.scnv_rec_type) IS
127:
128: BEGIN
129:
130: OKC_SCN_PVT.Update_Row(
131: p_api_version => p_api_version,
132: p_init_msg_list => p_init_msg_list,
133: x_return_status => x_return_status,
134: x_msg_count => x_msg_count,

Line 165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,

161: p_init_msg_list IN VARCHAR2 ,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_Row(

Line 166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS

162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_Row(
170: p_api_version => p_api_version,

Line 169: OKC_SCN_PVT.Update_Row(

165: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type,
166: x_scnv_tbl OUT NOCOPY OKC_SCN_PVT.scnv_tbl_type) IS
167:
168: BEGIN
169: OKC_SCN_PVT.Update_Row(
170: p_api_version => p_api_version,
171: p_init_msg_list => p_init_msg_list,
172: x_return_status => x_return_status,
173: x_msg_count => x_msg_count,

Line 185: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS

181: p_init_msg_list IN VARCHAR2 ,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
186:
187: l_chr_id NUMBER;
188: Cursor l_scn_csr IS
189: SELECT chr_id

Line 198: OKC_SCN_PVT.Delete_Row(

194: open l_scn_csr;
195: fetch l_scn_csr into l_chr_id;
196: close l_scn_csr;
197:
198: OKC_SCN_PVT.Delete_Row(
199: p_api_version => p_api_version,
200: p_init_msg_list => p_init_msg_list,
201: x_return_status => x_return_status,
202: x_msg_count => x_msg_count,

Line 233: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS

229: p_init_msg_list IN VARCHAR2 ,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
234:
235: BEGIN
236: OKC_SCN_PVT.Delete_Row(
237: p_api_version => p_api_version,

Line 236: OKC_SCN_PVT.Delete_Row(

232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
234:
235: BEGIN
236: OKC_SCN_PVT.Delete_Row(
237: p_api_version => p_api_version,
238: p_init_msg_list => p_init_msg_list,
239: x_return_status => x_return_status,
240: x_msg_count => x_msg_count,

Line 251: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS

247: p_init_msg_list IN VARCHAR2 ,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
252:
253: BEGIN
254: OKC_SCN_PVT.Lock_Row(
255: p_api_version => p_api_version,

Line 254: OKC_SCN_PVT.Lock_Row(

250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
252:
253: BEGIN
254: OKC_SCN_PVT.Lock_Row(
255: p_api_version => p_api_version,
256: p_init_msg_list => p_init_msg_list,
257: x_return_status => x_return_status,
258: x_msg_count => x_msg_count,

Line 269: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS

265: p_init_msg_list IN VARCHAR2 ,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
270:
271: BEGIN
272: OKC_SCN_PVT.Lock_Row(
273: p_api_version => p_api_version,

Line 272: OKC_SCN_PVT.Lock_Row(

268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
270:
271: BEGIN
272: OKC_SCN_PVT.Lock_Row(
273: p_api_version => p_api_version,
274: p_init_msg_list => p_init_msg_list,
275: x_return_status => x_return_status,
276: x_msg_count => x_msg_count,

Line 287: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS

283: p_init_msg_list IN VARCHAR2 ,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
288:
289: BEGIN
290: OKC_SCN_PVT.Validate_Row(
291: p_api_version => p_api_version,

Line 290: OKC_SCN_PVT.Validate_Row(

286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_scnv_rec IN OKC_SCN_PVT.scnv_rec_type) IS
288:
289: BEGIN
290: OKC_SCN_PVT.Validate_Row(
291: p_api_version => p_api_version,
292: p_init_msg_list => p_init_msg_list,
293: x_return_status => x_return_status,
294: x_msg_count => x_msg_count,

Line 305: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS

301: p_init_msg_list IN VARCHAR2 ,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
306:
307: BEGIN
308: OKC_SCN_PVT.Validate_Row(
309: p_api_version => p_api_version,

Line 308: OKC_SCN_PVT.Validate_Row(

304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_scnv_tbl IN OKC_SCN_PVT.scnv_tbl_type) IS
306:
307: BEGIN
308: OKC_SCN_PVT.Validate_Row(
309: p_api_version => p_api_version,
310: p_init_msg_list => p_init_msg_list,
311: x_return_status => x_return_status,
312: x_msg_count => x_msg_count,

Line 582: OKC_SCN_PVT.add_language;

578: END validate_section_content;
579:
580: PROCEDURE add_language IS
581: BEGIN
582: OKC_SCN_PVT.add_language;
583: END add_language;
584:
585: END OKC_SECTIONS_PVT;