DBA Data[Home] [Help]

APPS.CSK_SETUP_UTILITY_PKG_W dependencies on 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 5: , a2 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
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as

Line 6: , a3 JTF_NUMBER_TABLE

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
8: , a5 JTF_VARCHAR2_TABLE_100
9: ) as
10: ddindx binary_integer; indx binary_integer;

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 38: , a2 out nocopy JTF_NUMBER_TABLE

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
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: ) as

Line 39: , a3 out nocopy JTF_NUMBER_TABLE

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
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;

Line 53: a0 := JTF_NUMBER_TABLE();

49: a3 := null;
50: a4 := null;
51: a5 := null;
52: elsif t.count = 0 then
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_VARCHAR2_TABLE_2000();

Line 55: a2 := JTF_NUMBER_TABLE();

51: a5 := null;
52: elsif t.count = 0 then
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_VARCHAR2_TABLE_2000();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: else

Line 56: a3 := JTF_NUMBER_TABLE();

52: elsif t.count = 0 then
53: a0 := JTF_NUMBER_TABLE();
54: a1 := JTF_VARCHAR2_TABLE_100();
55: a2 := JTF_NUMBER_TABLE();
56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_VARCHAR2_TABLE_2000();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: else
60: a0 := JTF_NUMBER_TABLE();

Line 60: a0 := JTF_NUMBER_TABLE();

56: a3 := JTF_NUMBER_TABLE();
57: a4 := JTF_VARCHAR2_TABLE_2000();
58: a5 := JTF_VARCHAR2_TABLE_100();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_100();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_2000();

Line 62: a2 := JTF_NUMBER_TABLE();

58: a5 := JTF_VARCHAR2_TABLE_100();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_100();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: if t.count > 0 then

Line 63: a3 := JTF_NUMBER_TABLE();

59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_100();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: if t.count > 0 then
67: a0.extend(t.count);

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 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 122: a0 := JTF_NUMBER_TABLE();

118: begin
119: if t is null then
120: a0 := null;
121: elsif t.count = 0 then
122: a0 := JTF_NUMBER_TABLE();
123: else
124: a0 := JTF_NUMBER_TABLE();
125: if t.count > 0 then
126: a0.extend(t.count);

Line 124: a0 := JTF_NUMBER_TABLE();

120: a0 := null;
121: elsif t.count = 0 then
122: a0 := JTF_NUMBER_TABLE();
123: else
124: a0 := JTF_NUMBER_TABLE();
125: if t.count > 0 then
126: a0.extend(t.count);
127: ddindx := t.first;
128: indx := 1;

Line 153: , p8_a0 JTF_NUMBER_TABLE

149: , p7_a1 VARCHAR2
150: , p7_a2 NUMBER
151: , p7_a3 VARCHAR2
152: , p7_a4 VARCHAR2
153: , p8_a0 JTF_NUMBER_TABLE
154: , p8_a1 JTF_VARCHAR2_TABLE_100
155: , p8_a2 JTF_NUMBER_TABLE
156: , p8_a3 JTF_NUMBER_TABLE
157: , p8_a4 JTF_VARCHAR2_TABLE_2000

Line 155: , p8_a2 JTF_NUMBER_TABLE

151: , p7_a3 VARCHAR2
152: , p7_a4 VARCHAR2
153: , p8_a0 JTF_NUMBER_TABLE
154: , p8_a1 JTF_VARCHAR2_TABLE_100
155: , p8_a2 JTF_NUMBER_TABLE
156: , p8_a3 JTF_NUMBER_TABLE
157: , p8_a4 JTF_VARCHAR2_TABLE_2000
158: , p8_a5 JTF_VARCHAR2_TABLE_100
159: , p_cat_tbl JTF_NUMBER_TABLE

Line 156: , p8_a3 JTF_NUMBER_TABLE

152: , p7_a4 VARCHAR2
153: , p8_a0 JTF_NUMBER_TABLE
154: , p8_a1 JTF_VARCHAR2_TABLE_100
155: , p8_a2 JTF_NUMBER_TABLE
156: , p8_a3 JTF_NUMBER_TABLE
157: , p8_a4 JTF_VARCHAR2_TABLE_2000
158: , p8_a5 JTF_VARCHAR2_TABLE_100
159: , p_cat_tbl JTF_NUMBER_TABLE
160: , p_publish number

Line 159: , p_cat_tbl JTF_NUMBER_TABLE

155: , p8_a2 JTF_NUMBER_TABLE
156: , p8_a3 JTF_NUMBER_TABLE
157: , p8_a4 JTF_VARCHAR2_TABLE_2000
158: , p8_a5 JTF_VARCHAR2_TABLE_100
159: , p_cat_tbl JTF_NUMBER_TABLE
160: , p_publish number
161: )
162:
163: as