DBA Data[Home] [Help]

APPS.CSD_RO_BULLETINS_PVT_W dependencies on CSD_RO_BULLETINS_PVT

Line 1: package body csd_ro_bulletins_pvt_w as

1: package body csd_ro_bulletins_pvt_w as
2: /* $Header: csdwrobb.pls 120.0 2008/02/28 04:39:26 rfieldma noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p6(t out nocopy csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type, a0 JTF_NUMBER_TABLE) as

1: package body csd_ro_bulletins_pvt_w as
2: /* $Header: csdwrobb.pls 120.0 2008/02/28 04:39:26 rfieldma noship $ */
3: procedure rosetta_table_copy_in_p6(t out nocopy csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p6(t csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p6;
21: procedure rosetta_table_copy_out_p6(t csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 44: procedure rosetta_table_copy_in_p9(t out nocopy csd_ro_bulletins_pvt.ro_bulletin_tbl_type, a0 JTF_NUMBER_TABLE

40: end if;
41: end if;
42: end rosetta_table_copy_out_p6;
43:
44: procedure rosetta_table_copy_in_p9(t out nocopy csd_ro_bulletins_pvt.ro_bulletin_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_DATE_TABLE
48: , a4 JTF_NUMBER_TABLE

Line 87: procedure rosetta_table_copy_out_p9(t csd_ro_bulletins_pvt.ro_bulletin_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p9;
87: procedure rosetta_table_copy_out_p9(t csd_ro_bulletins_pvt.ro_bulletin_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_NUMBER_TABLE
90: , a3 out nocopy JTF_DATE_TABLE
91: , a4 out nocopy JTF_NUMBER_TABLE

Line 195: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;

191: , x_msg_data out nocopy VARCHAR2
192: )
193:
194: as
195: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;
196: ddindx binary_integer; indx binary_integer;
197: begin
198:
199: -- copy data to the local IN or IN-OUT args, if any

Line 223: csd_ro_bulletins_pvt.create_ro_bulletin(p_api_version_number,

219:
220:
221:
222: -- here's the delegated call to the old PL/SQL routine
223: csd_ro_bulletins_pvt.create_ro_bulletin(p_api_version_number,
224: p_init_msg_list,
225: p_commit,
226: p_validation_level,
227: ddp_ro_bulletin_rec,

Line 267: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;

263: , x_msg_data out nocopy VARCHAR2
264: )
265:
266: as
267: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;
268: ddindx binary_integer; indx binary_integer;
269: begin
270:
271: -- copy data to the local IN or IN-OUT args, if any

Line 294: csd_ro_bulletins_pvt.update_ro_bulletin(p_api_version_number,

290:
291:
292:
293: -- here's the delegated call to the old PL/SQL routine
294: csd_ro_bulletins_pvt.update_ro_bulletin(p_api_version_number,
295: p_init_msg_list,
296: p_commit,
297: p_validation_level,
298: ddp_ro_bulletin_rec,

Line 336: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;

332: , x_msg_data out nocopy VARCHAR2
333: )
334:
335: as
336: ddp_ro_bulletin_rec csd_ro_bulletins_pvt.ro_bulletin_rec_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:
340: -- copy data to the local IN or IN-OUT args, if any

Line 363: csd_ro_bulletins_pvt.lock_ro_bulletin(p_api_version_number,

359:
360:
361:
362: -- here's the delegated call to the old PL/SQL routine
363: csd_ro_bulletins_pvt.lock_ro_bulletin(p_api_version_number,
364: p_init_msg_list,
365: p_commit,
366: p_validation_level,
367: ddp_ro_bulletin_rec,

Line 394: ddpx_ro_sc_ids_tbl csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type;

390: , x_msg_data out nocopy VARCHAR2
391: )
392:
393: as
394: ddpx_ro_sc_ids_tbl csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type;
395: ddindx binary_integer; indx binary_integer;
396: begin
397:
398: -- copy data to the local IN or IN-OUT args, if any

Line 404: csd_ro_bulletins_pvt_w.rosetta_table_copy_in_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);

400:
401:
402:
403:
404: csd_ro_bulletins_pvt_w.rosetta_table_copy_in_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);
405:
406:
407:
408:

Line 410: csd_ro_bulletins_pvt.link_bulletins_to_ro(p_api_version_number,

406:
407:
408:
409: -- here's the delegated call to the old PL/SQL routine
410: csd_ro_bulletins_pvt.link_bulletins_to_ro(p_api_version_number,
411: p_init_msg_list,
412: p_commit,
413: p_validation_level,
414: p_repair_line_id,

Line 426: csd_ro_bulletins_pvt_w.rosetta_table_copy_out_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);

422:
423:
424:
425:
426: csd_ro_bulletins_pvt_w.rosetta_table_copy_out_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);
427:
428:
429:
430: end;

Line 446: ddpx_ro_sc_ids_tbl csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type;

442: , x_msg_data out nocopy VARCHAR2
443: )
444:
445: as
446: ddpx_ro_sc_ids_tbl csd_ro_bulletins_pvt.csd_ro_sc_ids_tbl_type;
447: ddindx binary_integer; indx binary_integer;
448: begin
449:
450: -- copy data to the local IN or IN-OUT args, if any

Line 458: csd_ro_bulletins_pvt_w.rosetta_table_copy_in_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);

454:
455:
456:
457:
458: csd_ro_bulletins_pvt_w.rosetta_table_copy_in_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);
459:
460:
461:
462:

Line 464: csd_ro_bulletins_pvt.create_new_ro_bulletin_link(p_api_version_number,

460:
461:
462:
463: -- here's the delegated call to the old PL/SQL routine
464: csd_ro_bulletins_pvt.create_new_ro_bulletin_link(p_api_version_number,
465: p_commit,
466: p_init_msg_list,
467: p_validation_level,
468: p_repair_line_id,

Line 484: csd_ro_bulletins_pvt_w.rosetta_table_copy_out_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);

480:
481:
482:
483:
484: csd_ro_bulletins_pvt_w.rosetta_table_copy_out_p6(ddpx_ro_sc_ids_tbl, px_ro_sc_ids_tbl);
485:
486:
487:
488: end;

Line 490: end csd_ro_bulletins_pvt_w;

486:
487:
488: end;
489:
490: end csd_ro_bulletins_pvt_w;