DBA Data[Home] [Help]

APPS.AMS_LISTGENERATION_UTIL_PKG_W dependencies on AMS_LISTGENERATION_UTIL_PKG

Line 1: package body ams_listgeneration_util_pkg_w as

1: package body ams_listgeneration_util_pkg_w as
2: /* $Header: amswlgub.pls 120.0 2006/02/23 00:55 rmbhanda noship $ */
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_p3(t out nocopy ams_listgeneration_util_pkg.spl_preview_count_tbl, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_listgeneration_util_pkg.spl_preview_count_tbl, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_32767
24: , a2 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 45: procedure rosetta_table_copy_out_p3(t ams_listgeneration_util_pkg.spl_preview_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p3;
45: procedure rosetta_table_copy_out_p3(t ams_listgeneration_util_pkg.spl_preview_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
47: , a2 out nocopy JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 89: ddp_split_preview_count_tbl ams_listgeneration_util_pkg.spl_preview_count_tbl;

85: , x_msg_data out nocopy VARCHAR2
86: )
87:
88: as
89: ddp_split_preview_count_tbl ams_listgeneration_util_pkg.spl_preview_count_tbl;
90: ddindx binary_integer; indx binary_integer;
91: begin
92:
93: -- copy data to the local IN or IN-OUT args, if any

Line 94: ams_listgeneration_util_pkg_w.rosetta_table_copy_in_p3(ddp_split_preview_count_tbl, p0_a0

90: ddindx binary_integer; indx binary_integer;
91: begin
92:
93: -- copy data to the local IN or IN-OUT args, if any
94: ams_listgeneration_util_pkg_w.rosetta_table_copy_in_p3(ddp_split_preview_count_tbl, p0_a0
95: , p0_a1
96: , p0_a2
97: );
98:

Line 104: ams_listgeneration_util_pkg.get_split_preview_count(ddp_split_preview_count_tbl,

100:
101:
102:
103: -- here's the delegated call to the old PL/SQL routine
104: ams_listgeneration_util_pkg.get_split_preview_count(ddp_split_preview_count_tbl,
105: p_list_header_id,
106: x_return_status,
107: x_msg_count,
108: x_msg_data);

Line 111: ams_listgeneration_util_pkg_w.rosetta_table_copy_out_p3(ddp_split_preview_count_tbl, p0_a0

107: x_msg_count,
108: x_msg_data);
109:
110: -- copy data back from the local variables to OUT or IN-OUT args, if any
111: ams_listgeneration_util_pkg_w.rosetta_table_copy_out_p3(ddp_split_preview_count_tbl, p0_a0
112: , p0_a1
113: , p0_a2
114: );
115:

Line 121: end ams_listgeneration_util_pkg_w;

117:
118:
119: end;
120:
121: end ams_listgeneration_util_pkg_w;