APPS.CSK_SETUP_UTILITY_PKG_W dependencies on CSK_SETUP_UTILITY_PKG

Line 1: package body csk_setup_utility_pkg_w as

1: package body csk_setup_utility_pkg_w as
2: /* $Header: csktsuwb.pls 120.0 2005/06/01 11:49:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p12(t out nocopy csk_setup_utility_pkg.stmt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p12(t out nocopy csk_setup_utility_pkg.stmt_tbl_type, a0 JTF_NUMBER_TABLE

1: package body csk_setup_utility_pkg_w as
2: /* $Header: csktsuwb.pls 120.0 2005/06/01 11:49:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p12(t out nocopy csk_setup_utility_pkg.stmt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000

Line 13: t := csk_setup_utility_pkg.stmt_tbl_type();

9: ) as
10: ddindx binary_integer; indx binary_integer;
11: begin
12: if a0 is not null and a0.count=0 then
13: t := csk_setup_utility_pkg.stmt_tbl_type();
14: elsif a0 is not null and a0.count > 0 then
15: if a0.count > 0 then
16: t := csk_setup_utility_pkg.stmt_tbl_type();
17: t.extend(a0.count);

Line 16: t := csk_setup_utility_pkg.stmt_tbl_type();

12: if a0 is not null and a0.count=0 then
13: t := csk_setup_utility_pkg.stmt_tbl_type();
14: elsif a0 is not null and a0.count > 0 then
15: if a0.count > 0 then
16: t := csk_setup_utility_pkg.stmt_tbl_type();
17: t.extend(a0.count);
18: indx := a0.first;
19: ddindx := 1;
20: while true loop

Line 36: procedure rosetta_table_copy_out_p12(t csk_setup_utility_pkg.stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p12;
36: procedure rosetta_table_copy_out_p12(t csk_setup_utility_pkg.stmt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_100
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 92: procedure rosetta_table_copy_in_p13(t out nocopy csk_setup_utility_pkg.cat_tbl_type, a0 JTF_NUMBER_TABLE) as

88: end if;
89: end if;
90: end rosetta_table_copy_out_p12;
91:
92: procedure rosetta_table_copy_in_p13(t out nocopy csk_setup_utility_pkg.cat_tbl_type, a0 JTF_NUMBER_TABLE) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if a0 is null then
96: t := null;

Line 98: t := csk_setup_utility_pkg.cat_tbl_type();

94: begin
95: if a0 is null then
96: t := null;
97: elsif a0.count = 0 then
98: t := csk_setup_utility_pkg.cat_tbl_type();
99: else
100: if a0.count > 0 then
101: t := csk_setup_utility_pkg.cat_tbl_type();
102: t.extend(a0.count);

Line 101: t := csk_setup_utility_pkg.cat_tbl_type();

97: elsif a0.count = 0 then
98: t := csk_setup_utility_pkg.cat_tbl_type();
99: else
100: if a0.count > 0 then
101: t := csk_setup_utility_pkg.cat_tbl_type();
102: t.extend(a0.count);
103: indx := a0.first;
104: ddindx := 1;
105: while true loop

Line 116: procedure rosetta_table_copy_out_p13(t csk_setup_utility_pkg.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

112: end loop;
113: end if;
114: end if;
115: end rosetta_table_copy_in_p13;
116: procedure rosetta_table_copy_out_p13(t csk_setup_utility_pkg.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
117: ddindx binary_integer; indx binary_integer;
118: begin
119: if t is null then
120: a0 := null;

Line 164: ddp_soln_rec csk_setup_utility_pkg.soln_rec_type;

160: , p_publish number
161: )
162:
163: as
164: ddp_soln_rec csk_setup_utility_pkg.soln_rec_type;
165: ddp_stmt_tbl csk_setup_utility_pkg.stmt_tbl_type;
166: ddp_cat_tbl csk_setup_utility_pkg.cat_tbl_type;
167: ddp_publish boolean;
168: ddindx binary_integer; indx binary_integer;

Line 165: ddp_stmt_tbl csk_setup_utility_pkg.stmt_tbl_type;

161: )
162:
163: as
164: ddp_soln_rec csk_setup_utility_pkg.soln_rec_type;
165: ddp_stmt_tbl csk_setup_utility_pkg.stmt_tbl_type;
166: ddp_cat_tbl csk_setup_utility_pkg.cat_tbl_type;
167: ddp_publish boolean;
168: ddindx binary_integer; indx binary_integer;
169: begin

Line 166: ddp_cat_tbl csk_setup_utility_pkg.cat_tbl_type;

162:
163: as
164: ddp_soln_rec csk_setup_utility_pkg.soln_rec_type;
165: ddp_stmt_tbl csk_setup_utility_pkg.stmt_tbl_type;
166: ddp_cat_tbl csk_setup_utility_pkg.cat_tbl_type;
167: ddp_publish boolean;
168: ddindx binary_integer; indx binary_integer;
169: begin
170:

Line 185: csk_setup_utility_pkg_w.rosetta_table_copy_in_p12(ddp_stmt_tbl, p8_a0

181: ddp_soln_rec.set_type_id := p7_a2;
182: ddp_soln_rec.name := p7_a3;
183: ddp_soln_rec.visibility_id := p7_a4;
184:
185: csk_setup_utility_pkg_w.rosetta_table_copy_in_p12(ddp_stmt_tbl, p8_a0
186: , p8_a1
187: , p8_a2
188: , p8_a3
189: , p8_a4

Line 193: csk_setup_utility_pkg_w.rosetta_table_copy_in_p13(ddp_cat_tbl, p_cat_tbl);

189: , p8_a4
190: , p8_a5
191: );
192:
193: csk_setup_utility_pkg_w.rosetta_table_copy_in_p13(ddp_cat_tbl, p_cat_tbl);
194:
195: if p_publish is null
196: then ddp_publish := null;
197: elsif p_publish = 0

Line 203: csk_setup_utility_pkg.create_solution(p_api_version,

199: else ddp_publish := true;
200: end if;
201:
202: -- here's the delegated call to the old PL/SQL routine
203: csk_setup_utility_pkg.create_solution(p_api_version,
204: p_init_msg_list,
205: p_commit,
206: p_validation_level,
207: x_return_status,

Line 228: end csk_setup_utility_pkg_w;

224:
225:
226: end;
227:
228: end csk_setup_utility_pkg_w;