DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RST_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p19(t out nocopy okl_populate_prceng_rst_pub.strm_tbl_type, a0 JTF_VARCHAR2_TABLE_200
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;

Line 51: , a2 out nocopy JTF_VARCHAR2_TABLE_100

47: end if;
48: end rosetta_table_copy_in_p19;
49: procedure rosetta_table_copy_out_p19(t okl_populate_prceng_rst_pub.strm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;

Line 60: a2 := JTF_VARCHAR2_TABLE_100();

56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_VARCHAR2_TABLE_200();
59: a1 := JTF_VARCHAR2_TABLE_200();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_VARCHAR2_TABLE_200();

Line 66: a2 := JTF_VARCHAR2_TABLE_100();

62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_VARCHAR2_TABLE_200();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_NUMBER_TABLE();
69: if t.count > 0 then
70: a0.extend(t.count);

Line 93: procedure rosetta_table_copy_in_p21(t out nocopy okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

89: end if;
90: end if;
91: end rosetta_table_copy_out_p19;
92:
93: procedure rosetta_table_copy_in_p21(t out nocopy okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
94: , a1 JTF_VARCHAR2_TABLE_300
95: , a2 JTF_VARCHAR2_TABLE_1000
96: ) as
97: ddindx binary_integer; indx binary_integer;

Line 95: , a2 JTF_VARCHAR2_TABLE_1000

91: end rosetta_table_copy_out_p19;
92:
93: procedure rosetta_table_copy_in_p21(t out nocopy okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
94: , a1 JTF_VARCHAR2_TABLE_300
95: , a2 JTF_VARCHAR2_TABLE_1000
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if a0 is not null and a0.count > 0 then

Line 116: procedure rosetta_table_copy_out_p21(t okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

112: end loop;
113: end if;
114: end if;
115: end rosetta_table_copy_in_p21;
116: procedure rosetta_table_copy_out_p21(t okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
117: , a1 out nocopy JTF_VARCHAR2_TABLE_300
118: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
119: ) as
120: ddindx binary_integer; indx binary_integer;

Line 118: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

114: end if;
115: end rosetta_table_copy_in_p21;
116: procedure rosetta_table_copy_out_p21(t okl_populate_prceng_rst_pub.strm_excp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
117: , a1 out nocopy JTF_VARCHAR2_TABLE_300
118: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then

Line 123: a0 := JTF_VARCHAR2_TABLE_100();

119: ) as
120: ddindx binary_integer; indx binary_integer;
121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_VARCHAR2_TABLE_100();
124: a1 := JTF_VARCHAR2_TABLE_300();
125: a2 := JTF_VARCHAR2_TABLE_1000();
126: else
127: a0 := JTF_VARCHAR2_TABLE_100();

Line 125: a2 := JTF_VARCHAR2_TABLE_1000();

121: begin
122: if t is null or t.count = 0 then
123: a0 := JTF_VARCHAR2_TABLE_100();
124: a1 := JTF_VARCHAR2_TABLE_300();
125: a2 := JTF_VARCHAR2_TABLE_1000();
126: else
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_300();
129: a2 := JTF_VARCHAR2_TABLE_1000();

Line 127: a0 := JTF_VARCHAR2_TABLE_100();

123: a0 := JTF_VARCHAR2_TABLE_100();
124: a1 := JTF_VARCHAR2_TABLE_300();
125: a2 := JTF_VARCHAR2_TABLE_1000();
126: else
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_300();
129: a2 := JTF_VARCHAR2_TABLE_1000();
130: if t.count > 0 then
131: a0.extend(t.count);

Line 129: a2 := JTF_VARCHAR2_TABLE_1000();

125: a2 := JTF_VARCHAR2_TABLE_1000();
126: else
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_300();
129: a2 := JTF_VARCHAR2_TABLE_1000();
130: if t.count > 0 then
131: a0.extend(t.count);
132: a1.extend(t.count);
133: a2.extend(t.count);

Line 154: , p2_a2 JTF_VARCHAR2_TABLE_100

150: procedure populate_sif_ret_strms(x_return_status out nocopy VARCHAR2
151: , p_index_number NUMBER
152: , p2_a0 JTF_VARCHAR2_TABLE_200
153: , p2_a1 JTF_VARCHAR2_TABLE_200
154: , p2_a2 JTF_VARCHAR2_TABLE_100
155: , p2_a3 JTF_NUMBER_TABLE
156: , p2_a4 JTF_NUMBER_TABLE
157: , p_sir_id NUMBER
158: )

Line 191: , p3_a0 JTF_VARCHAR2_TABLE_100

187:
188: procedure populate_sif_ret_errors(x_return_status out nocopy VARCHAR2
189: , x_id out nocopy NUMBER
190: , p_sir_id NUMBER
191: , p3_a0 JTF_VARCHAR2_TABLE_100
192: , p3_a1 JTF_VARCHAR2_TABLE_300
193: , p3_a2 JTF_VARCHAR2_TABLE_1000
194: , p_tag_attribute_name VARCHAR2
195: , p_tag_attribute_value VARCHAR2

Line 193: , p3_a2 JTF_VARCHAR2_TABLE_1000

189: , x_id out nocopy NUMBER
190: , p_sir_id NUMBER
191: , p3_a0 JTF_VARCHAR2_TABLE_100
192: , p3_a1 JTF_VARCHAR2_TABLE_300
193: , p3_a2 JTF_VARCHAR2_TABLE_1000
194: , p_tag_attribute_name VARCHAR2
195: , p_tag_attribute_value VARCHAR2
196: , p_description VARCHAR2
197: )