DBA Data[Home] [Help]

APPS.JTS_CONFIG_VERSION_PVT_W dependencies on JTS_CONFIG_VERSION_PVT

Line 1: package body jts_config_version_pvt_w as

1: package body jts_config_version_pvt_w as
2: /* $Header: jtswcvrb.pls 115.5 2002/03/27 18:03:14 pkm ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300

Line 125: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE

121: end loop;
122: end if;
123: end if;
124: end rosetta_table_copy_in_p4;
125: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
126: , a1 out JTF_NUMBER_TABLE
127: , a2 out JTF_VARCHAR2_TABLE_100
128: , a3 out JTF_NUMBER_TABLE
129: , a4 out JTF_VARCHAR2_TABLE_300

Line 359: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE) as

355: end if;
356: end if;
357: end rosetta_table_copy_out_p4;
358:
359: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE) as
360: ddindx binary_integer; indx binary_integer;
361: begin
362: if a0 is not null and a0.count > 0 then
363: if a0.count > 0 then

Line 377: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE) as

373: end loop;
374: end if;
375: end if;
376: end rosetta_table_copy_in_p5;
377: procedure rosetta_table_copy_out_p5(t jts_config_version_pvt.version_id_tbl_type, a0 out JTF_NUMBER_TABLE) as
378: ddindx binary_integer; indx binary_integer;
379: begin
380: if t is null or t.count = 0 then
381: a0 := JTF_NUMBER_TABLE();

Line 405: ddp_version_tbl jts_config_version_pvt.version_id_tbl_type;

401: , p_version_tbl JTF_NUMBER_TABLE
402: )
403:
404: as
405: ddp_version_tbl jts_config_version_pvt.version_id_tbl_type;
406: ddindx binary_integer; indx binary_integer;
407: begin
408:
409: -- copy data to the local IN or IN-OUT args, if any

Line 411: jts_config_version_pvt_w.rosetta_table_copy_in_p5(ddp_version_tbl, p_version_tbl);

407: begin
408:
409: -- copy data to the local IN or IN-OUT args, if any
410:
411: jts_config_version_pvt_w.rosetta_table_copy_in_p5(ddp_version_tbl, p_version_tbl);
412:
413: -- here's the delegated call to the old PL/SQL routine
414: jts_config_version_pvt.delete_some_versions(p_api_version,
415: ddp_version_tbl);

Line 414: jts_config_version_pvt.delete_some_versions(p_api_version,

410:
411: jts_config_version_pvt_w.rosetta_table_copy_in_p5(ddp_version_tbl, p_version_tbl);
412:
413: -- here's the delegated call to the old PL/SQL routine
414: jts_config_version_pvt.delete_some_versions(p_api_version,
415: ddp_version_tbl);
416:
417: -- copy data back from the local variables to OUT or IN-OUT args, if any
418:

Line 472: ddx_version_rec jts_config_version_pvt.config_version_rec_type;

468: , x_msg_data out VARCHAR2
469: )
470:
471: as
472: ddx_version_rec jts_config_version_pvt.config_version_rec_type;
473: ddindx binary_integer; indx binary_integer;
474: begin
475:
476: -- copy data to the local IN or IN-OUT args, if any

Line 484: jts_config_version_pvt.get_version(p_api_version,

480:
481:
482:
483: -- here's the delegated call to the old PL/SQL routine
484: jts_config_version_pvt.get_version(p_api_version,
485: p_version_id,
486: ddx_version_rec,
487: x_return_status,
488: x_msg_count,

Line 595: ddx_version_tbl jts_config_version_pvt.config_version_tbl_type;

591: , x_msg_data out VARCHAR2
592: )
593:
594: as
595: ddx_version_tbl jts_config_version_pvt.config_version_tbl_type;
596: ddindx binary_integer; indx binary_integer;
597: begin
598:
599: -- copy data to the local IN or IN-OUT args, if any

Line 609: jts_config_version_pvt.get_versions(p_api_version,

605:
606:
607:
608: -- here's the delegated call to the old PL/SQL routine
609: jts_config_version_pvt.get_versions(p_api_version,
610: p_config_id,
611: p_order_by,
612: p_how_to_order,
613: ddx_version_tbl,

Line 623: jts_config_version_pvt_w.rosetta_table_copy_out_p4(ddx_version_tbl, p4_a0

619:
620:
621:
622:
623: jts_config_version_pvt_w.rosetta_table_copy_out_p4(ddx_version_tbl, p4_a0
624: , p4_a1
625: , p4_a2
626: , p4_a3
627: , p4_a4

Line 672: end jts_config_version_pvt_w;

668:
669:
670: end;
671:
672: end jts_config_version_pvt_w;