DBA Data[Home] [Help]

APPS.QP_UTIL_OA dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy qp_util.v_segs_upg_tab, a0 JTF_VARCHAR2_TABLE_100

1: package body qp_util_oa as
2: /* $Header: ozfaqpub.pls 115.0 2003/11/07 18:45:30 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy qp_util.v_segs_upg_tab, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body qp_util_oa as
2: /* $Header: ozfaqpub.pls 115.0 2003/11/07 18:45:30 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy qp_util.v_segs_upg_tab, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: ozfaqpub.pls 115.0 2003/11/07 18:45:30 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy qp_util.v_segs_upg_tab, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: ) as
8: ddindx binary_integer; indx binary_integer;
9: begin
10: if a0 is not null and a0.count > 0 then

Line 28: procedure rosetta_table_copy_out_p1(t qp_util.v_segs_upg_tab, a0 out nocopy JTF_VARCHAR2_TABLE_100

24: end loop;
25: end if;
26: end if;
27: end rosetta_table_copy_in_p1;
28: procedure rosetta_table_copy_out_p1(t qp_util.v_segs_upg_tab, a0 out nocopy JTF_VARCHAR2_TABLE_100
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_NUMBER_TABLE
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as

Line 29: , a1 out nocopy JTF_VARCHAR2_TABLE_100

25: end if;
26: end if;
27: end rosetta_table_copy_in_p1;
28: procedure rosetta_table_copy_out_p1(t qp_util.v_segs_upg_tab, a0 out nocopy JTF_VARCHAR2_TABLE_100
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_NUMBER_TABLE
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;

Line 31: , a3 out nocopy JTF_VARCHAR2_TABLE_100

27: end rosetta_table_copy_in_p1;
28: procedure rosetta_table_copy_out_p1(t qp_util.v_segs_upg_tab, a0 out nocopy JTF_VARCHAR2_TABLE_100
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_NUMBER_TABLE
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then

Line 36: a0 := JTF_VARCHAR2_TABLE_100();

32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_VARCHAR2_TABLE_100();
37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_NUMBER_TABLE();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else

Line 37: a1 := JTF_VARCHAR2_TABLE_100();

33: ddindx binary_integer; indx binary_integer;
34: begin
35: if t is null or t.count = 0 then
36: a0 := JTF_VARCHAR2_TABLE_100();
37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_NUMBER_TABLE();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_VARCHAR2_TABLE_100();

Line 39: a3 := JTF_VARCHAR2_TABLE_100();

35: if t is null or t.count = 0 then
36: a0 := JTF_VARCHAR2_TABLE_100();
37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_NUMBER_TABLE();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_VARCHAR2_TABLE_100();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_NUMBER_TABLE();

Line 41: a0 := JTF_VARCHAR2_TABLE_100();

37: a1 := JTF_VARCHAR2_TABLE_100();
38: a2 := JTF_NUMBER_TABLE();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_VARCHAR2_TABLE_100();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_NUMBER_TABLE();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then

Line 42: a1 := JTF_VARCHAR2_TABLE_100();

38: a2 := JTF_NUMBER_TABLE();
39: a3 := JTF_VARCHAR2_TABLE_100();
40: else
41: a0 := JTF_VARCHAR2_TABLE_100();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_NUMBER_TABLE();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);

Line 44: a3 := JTF_VARCHAR2_TABLE_100();

40: else
41: a0 := JTF_VARCHAR2_TABLE_100();
42: a1 := JTF_VARCHAR2_TABLE_100();
43: a2 := JTF_NUMBER_TABLE();
44: a3 := JTF_VARCHAR2_TABLE_100();
45: if t.count > 0 then
46: a0.extend(t.count);
47: a1.extend(t.count);
48: a2.extend(t.count);

Line 67: procedure rosetta_table_copy_in_p39(t out nocopy qp_util.create_context_out_tbl, a0 JTF_VARCHAR2_TABLE_100

63: end if;
64: end if;
65: end rosetta_table_copy_out_p1;
66:
67: procedure rosetta_table_copy_in_p39(t out nocopy qp_util.create_context_out_tbl, a0 JTF_VARCHAR2_TABLE_100
68: , a1 JTF_VARCHAR2_TABLE_300
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin

Line 88: procedure rosetta_table_copy_out_p39(t qp_util.create_context_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

84: end loop;
85: end if;
86: end if;
87: end rosetta_table_copy_in_p39;
88: procedure rosetta_table_copy_out_p39(t qp_util.create_context_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
89: , a1 out nocopy JTF_VARCHAR2_TABLE_300
90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin

Line 94: a0 := JTF_VARCHAR2_TABLE_100();

90: ) as
91: ddindx binary_integer; indx binary_integer;
92: begin
93: if t is null or t.count = 0 then
94: a0 := JTF_VARCHAR2_TABLE_100();
95: a1 := JTF_VARCHAR2_TABLE_300();
96: else
97: a0 := JTF_VARCHAR2_TABLE_100();
98: a1 := JTF_VARCHAR2_TABLE_300();

Line 97: a0 := JTF_VARCHAR2_TABLE_100();

93: if t is null or t.count = 0 then
94: a0 := JTF_VARCHAR2_TABLE_100();
95: a1 := JTF_VARCHAR2_TABLE_300();
96: else
97: a0 := JTF_VARCHAR2_TABLE_100();
98: a1 := JTF_VARCHAR2_TABLE_300();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);

Line 117: procedure rosetta_table_copy_in_p41(t out nocopy qp_util.create_attribute_out_tbl, a0 JTF_VARCHAR2_TABLE_100

113: end if;
114: end if;
115: end rosetta_table_copy_out_p39;
116:
117: procedure rosetta_table_copy_in_p41(t out nocopy qp_util.create_attribute_out_tbl, a0 JTF_VARCHAR2_TABLE_100
118: , a1 JTF_VARCHAR2_TABLE_300
119: , a2 JTF_VARCHAR2_TABLE_100
120: , a3 JTF_NUMBER_TABLE
121: , a4 JTF_NUMBER_TABLE

Line 119: , a2 JTF_VARCHAR2_TABLE_100

115: end rosetta_table_copy_out_p39;
116:
117: procedure rosetta_table_copy_in_p41(t out nocopy qp_util.create_attribute_out_tbl, a0 JTF_VARCHAR2_TABLE_100
118: , a1 JTF_VARCHAR2_TABLE_300
119: , a2 JTF_VARCHAR2_TABLE_100
120: , a3 JTF_NUMBER_TABLE
121: , a4 JTF_NUMBER_TABLE
122: ) as
123: ddindx binary_integer; indx binary_integer;

Line 144: procedure rosetta_table_copy_out_p41(t qp_util.create_attribute_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

140: end loop;
141: end if;
142: end if;
143: end rosetta_table_copy_in_p41;
144: procedure rosetta_table_copy_out_p41(t qp_util.create_attribute_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
145: , a1 out nocopy JTF_VARCHAR2_TABLE_300
146: , a2 out nocopy JTF_VARCHAR2_TABLE_100
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE

Line 146: , a2 out nocopy JTF_VARCHAR2_TABLE_100

142: end if;
143: end rosetta_table_copy_in_p41;
144: procedure rosetta_table_copy_out_p41(t qp_util.create_attribute_out_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
145: , a1 out nocopy JTF_VARCHAR2_TABLE_300
146: , a2 out nocopy JTF_VARCHAR2_TABLE_100
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_NUMBER_TABLE
149: ) as
150: ddindx binary_integer; indx binary_integer;

Line 153: a0 := JTF_VARCHAR2_TABLE_100();

149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_300();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_NUMBER_TABLE();
157: a4 := JTF_NUMBER_TABLE();

Line 155: a2 := JTF_VARCHAR2_TABLE_100();

151: begin
152: if t is null or t.count = 0 then
153: a0 := JTF_VARCHAR2_TABLE_100();
154: a1 := JTF_VARCHAR2_TABLE_300();
155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_NUMBER_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: else
159: a0 := JTF_VARCHAR2_TABLE_100();

Line 159: a0 := JTF_VARCHAR2_TABLE_100();

155: a2 := JTF_VARCHAR2_TABLE_100();
156: a3 := JTF_NUMBER_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: else
159: a0 := JTF_VARCHAR2_TABLE_100();
160: a1 := JTF_VARCHAR2_TABLE_300();
161: a2 := JTF_VARCHAR2_TABLE_100();
162: a3 := JTF_NUMBER_TABLE();
163: a4 := JTF_NUMBER_TABLE();

Line 161: a2 := JTF_VARCHAR2_TABLE_100();

157: a4 := JTF_NUMBER_TABLE();
158: else
159: a0 := JTF_VARCHAR2_TABLE_100();
160: a1 := JTF_VARCHAR2_TABLE_300();
161: a2 := JTF_VARCHAR2_TABLE_100();
162: a3 := JTF_NUMBER_TABLE();
163: a4 := JTF_NUMBER_TABLE();
164: if t.count > 0 then
165: a0.extend(t.count);

Line 256: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100

252: end;
253:
254: procedure get_segs_for_flex(flexfield_name VARCHAR2
255: , application_short_name VARCHAR2
256: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a2 out nocopy JTF_NUMBER_TABLE
259: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , error_code out nocopy NUMBER

Line 257: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

253:
254: procedure get_segs_for_flex(flexfield_name VARCHAR2
255: , application_short_name VARCHAR2
256: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a2 out nocopy JTF_NUMBER_TABLE
259: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , error_code out nocopy NUMBER
261: )

Line 259: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

255: , application_short_name VARCHAR2
256: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
257: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
258: , p2_a2 out nocopy JTF_NUMBER_TABLE
259: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , error_code out nocopy NUMBER
261: )
262:
263: as

Line 290: procedure get_segs_flex_precedence(p0_a0 JTF_VARCHAR2_TABLE_100

286: );
287:
288: end;
289:
290: procedure get_segs_flex_precedence(p0_a0 JTF_VARCHAR2_TABLE_100
291: , p0_a1 JTF_VARCHAR2_TABLE_100
292: , p0_a2 JTF_NUMBER_TABLE
293: , p0_a3 JTF_VARCHAR2_TABLE_100
294: , p_context VARCHAR2

Line 291: , p0_a1 JTF_VARCHAR2_TABLE_100

287:
288: end;
289:
290: procedure get_segs_flex_precedence(p0_a0 JTF_VARCHAR2_TABLE_100
291: , p0_a1 JTF_VARCHAR2_TABLE_100
292: , p0_a2 JTF_NUMBER_TABLE
293: , p0_a3 JTF_VARCHAR2_TABLE_100
294: , p_context VARCHAR2
295: , p_attribute VARCHAR2

Line 293: , p0_a3 JTF_VARCHAR2_TABLE_100

289:
290: procedure get_segs_flex_precedence(p0_a0 JTF_VARCHAR2_TABLE_100
291: , p0_a1 JTF_VARCHAR2_TABLE_100
292: , p0_a2 JTF_NUMBER_TABLE
293: , p0_a3 JTF_VARCHAR2_TABLE_100
294: , p_context VARCHAR2
295: , p_attribute VARCHAR2
296: , x_precedence out nocopy NUMBER
297: , x_datatype out nocopy VARCHAR2

Line 336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

332: , p_check_enabled VARCHAR2
333: , p_limits VARCHAR2
334: , p_list_line_type_code VARCHAR2
335: , x_return_status out nocopy VARCHAR2
336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
338: )
339:
340: as

Line 382: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

378: , p_list_line_type_code VARCHAR2
379: , p_segment_level NUMBER
380: , p_field_context VARCHAR2
381: , x_return_status out nocopy VARCHAR2
382: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
383: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
384: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
385: , p8_a3 out nocopy JTF_NUMBER_TABLE
386: , p8_a4 out nocopy JTF_NUMBER_TABLE

Line 384: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

380: , p_field_context VARCHAR2
381: , x_return_status out nocopy VARCHAR2
382: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
383: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
384: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
385: , p8_a3 out nocopy JTF_NUMBER_TABLE
386: , p8_a4 out nocopy JTF_NUMBER_TABLE
387: )
388: