DBA Data[Home] [Help]

APPS.OKL_RES_PVT_W dependencies on OKL_RES_PVT

Line 1: package body okl_res_pvt_w as

1: package body okl_res_pvt_w as
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_res_pvt_w as
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, a0 out nocopy JTF_NUMBER_TABLE

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE

Line 155: ddp_res_rec okl_res_pvt.okl_res_rec;

151: , p6_a11 out nocopy NUMBER
152: )
153:
154: as
155: ddp_res_rec okl_res_pvt.okl_res_rec;
156: ddx_res_rec okl_res_pvt.okl_res_rec;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:

Line 156: ddx_res_rec okl_res_pvt.okl_res_rec;

152: )
153:
154: as
155: ddp_res_rec okl_res_pvt.okl_res_rec;
156: ddx_res_rec okl_res_pvt.okl_res_rec;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:
160: -- copy data to the local IN or IN-OUT args, if any

Line 181: okl_res_pvt.insert_row(p_api_version,

177: ddp_res_rec.category_set_id := p5_a11;
178:
179:
180: -- here's the delegated call to the old PL/SQL routine
181: okl_res_pvt.insert_row(p_api_version,
182: p_init_msg_list,
183: x_return_status,
184: x_msg_count,
185: x_msg_data,

Line 242: ddp_res_tbl okl_res_pvt.okl_res_tbl;

238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: )
240:
241: as
242: ddp_res_tbl okl_res_pvt.okl_res_tbl;
243: ddx_res_tbl okl_res_pvt.okl_res_tbl;
244: ddindx binary_integer; indx binary_integer;
245: begin
246:

Line 243: ddx_res_tbl okl_res_pvt.okl_res_tbl;

239: )
240:
241: as
242: ddp_res_tbl okl_res_pvt.okl_res_tbl;
243: ddx_res_tbl okl_res_pvt.okl_res_tbl;
244: ddindx binary_integer; indx binary_integer;
245: begin
246:
247: -- copy data to the local IN or IN-OUT args, if any

Line 253: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0

249:
250:
251:
252:
253: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0
254: , p5_a1
255: , p5_a2
256: , p5_a3
257: , p5_a4

Line 269: okl_res_pvt.insert_row(p_api_version,

265: );
266:
267:
268: -- here's the delegated call to the old PL/SQL routine
269: okl_res_pvt.insert_row(p_api_version,
270: p_init_msg_list,
271: x_return_status,
272: x_msg_count,
273: x_msg_data,

Line 284: okl_res_pvt_w.rosetta_table_copy_out_p1(ddx_res_tbl, p6_a0

280:
281:
282:
283:
284: okl_res_pvt_w.rosetta_table_copy_out_p1(ddx_res_tbl, p6_a0
285: , p6_a1
286: , p6_a2
287: , p6_a3
288: , p6_a4

Line 331: ddp_res_rec okl_res_pvt.okl_res_rec;

327: , p6_a11 out nocopy NUMBER
328: )
329:
330: as
331: ddp_res_rec okl_res_pvt.okl_res_rec;
332: ddx_res_rec okl_res_pvt.okl_res_rec;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:

Line 332: ddx_res_rec okl_res_pvt.okl_res_rec;

328: )
329:
330: as
331: ddp_res_rec okl_res_pvt.okl_res_rec;
332: ddx_res_rec okl_res_pvt.okl_res_rec;
333: ddindx binary_integer; indx binary_integer;
334: begin
335:
336: -- copy data to the local IN or IN-OUT args, if any

Line 357: okl_res_pvt.update_row(p_api_version,

353: ddp_res_rec.category_set_id := p5_a11;
354:
355:
356: -- here's the delegated call to the old PL/SQL routine
357: okl_res_pvt.update_row(p_api_version,
358: p_init_msg_list,
359: x_return_status,
360: x_msg_count,
361: x_msg_data,

Line 418: ddp_res_tbl okl_res_pvt.okl_res_tbl;

414: , p6_a11 out nocopy JTF_NUMBER_TABLE
415: )
416:
417: as
418: ddp_res_tbl okl_res_pvt.okl_res_tbl;
419: ddx_res_tbl okl_res_pvt.okl_res_tbl;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:

Line 419: ddx_res_tbl okl_res_pvt.okl_res_tbl;

415: )
416:
417: as
418: ddp_res_tbl okl_res_pvt.okl_res_tbl;
419: ddx_res_tbl okl_res_pvt.okl_res_tbl;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:
423: -- copy data to the local IN or IN-OUT args, if any

Line 429: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0

425:
426:
427:
428:
429: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0
430: , p5_a1
431: , p5_a2
432: , p5_a3
433: , p5_a4

Line 445: okl_res_pvt.update_row(p_api_version,

441: );
442:
443:
444: -- here's the delegated call to the old PL/SQL routine
445: okl_res_pvt.update_row(p_api_version,
446: p_init_msg_list,
447: x_return_status,
448: x_msg_count,
449: x_msg_data,

Line 460: okl_res_pvt_w.rosetta_table_copy_out_p1(ddx_res_tbl, p6_a0

456:
457:
458:
459:
460: okl_res_pvt_w.rosetta_table_copy_out_p1(ddx_res_tbl, p6_a0
461: , p6_a1
462: , p6_a2
463: , p6_a3
464: , p6_a4

Line 495: ddp_res_rec okl_res_pvt.okl_res_rec;

491: , p5_a11 NUMBER
492: )
493:
494: as
495: ddp_res_rec okl_res_pvt.okl_res_rec;
496: ddindx binary_integer; indx binary_integer;
497: begin
498:
499: -- copy data to the local IN or IN-OUT args, if any

Line 519: okl_res_pvt.delete_row(p_api_version,

515: ddp_res_rec.category_id := p5_a10;
516: ddp_res_rec.category_set_id := p5_a11;
517:
518: -- here's the delegated call to the old PL/SQL routine
519: okl_res_pvt.delete_row(p_api_version,
520: p_init_msg_list,
521: x_return_status,
522: x_msg_count,
523: x_msg_data,

Line 554: ddp_res_tbl okl_res_pvt.okl_res_tbl;

550: , p5_a11 JTF_NUMBER_TABLE
551: )
552:
553: as
554: ddp_res_tbl okl_res_pvt.okl_res_tbl;
555: ddindx binary_integer; indx binary_integer;
556: begin
557:
558: -- copy data to the local IN or IN-OUT args, if any

Line 564: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0

560:
561:
562:
563:
564: okl_res_pvt_w.rosetta_table_copy_in_p1(ddp_res_tbl, p5_a0
565: , p5_a1
566: , p5_a2
567: , p5_a3
568: , p5_a4

Line 579: okl_res_pvt.delete_row(p_api_version,

575: , p5_a11
576: );
577:
578: -- here's the delegated call to the old PL/SQL routine
579: okl_res_pvt.delete_row(p_api_version,
580: p_init_msg_list,
581: x_return_status,
582: x_msg_count,
583: x_msg_data,

Line 594: end okl_res_pvt_w;

590:
591:
592: end;
593:
594: end okl_res_pvt_w;