DBA Data[Home] [Help]

APPS.CSK_SETUP_UTILITY_PKG_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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;
11: begin
12: if a0 is not null and a0.count=0 then

Line 37: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 41: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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;
44: begin
45: if t is null then

Line 54: a1 := JTF_VARCHAR2_TABLE_100();

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();
58: a5 := JTF_VARCHAR2_TABLE_100();

Line 58: a5 := JTF_VARCHAR2_TABLE_100();

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();
61: a1 := JTF_VARCHAR2_TABLE_100();
62: a2 := JTF_NUMBER_TABLE();

Line 61: a1 := JTF_VARCHAR2_TABLE_100();

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();
65: a5 := JTF_VARCHAR2_TABLE_100();

Line 65: a5 := JTF_VARCHAR2_TABLE_100();

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);
68: a1.extend(t.count);
69: a2.extend(t.count);

Line 154: , p8_a1 JTF_VARCHAR2_TABLE_100

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
158: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 158: , p8_a5 JTF_VARCHAR2_TABLE_100

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
161: )
162: