DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body cn_rt_quota_asgn_pvt_w as
2: /* $Header: cnwrtqab.pls 120.2 2005/09/14 04:29 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

Line 24: procedure rosetta_table_copy_out_p1(t cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

20: end loop;
21: end if;
22: end if;
23: end rosetta_table_copy_in_p1;
24: procedure rosetta_table_copy_out_p1(t cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin

Line 30: a0 := JTF_VARCHAR2_TABLE_100();

26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_NUMBER_TABLE();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_NUMBER_TABLE();

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_NUMBER_TABLE();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_NUMBER_TABLE();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);

Line 53: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100

49: end if;
50: end if;
51: end rosetta_table_copy_out_p1;
52:
53: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
54: , a1 JTF_NUMBER_TABLE
55: , a2 JTF_NUMBER_TABLE
56: , a3 JTF_NUMBER_TABLE
57: , a4 JTF_DATE_TABLE

Line 61: , a8 JTF_VARCHAR2_TABLE_100

57: , a4 JTF_DATE_TABLE
58: , a5 JTF_DATE_TABLE
59: , a6 JTF_NUMBER_TABLE
60: , a7 JTF_NUMBER_TABLE
61: , a8 JTF_VARCHAR2_TABLE_100
62: , a9 JTF_VARCHAR2_TABLE_100
63: , a10 JTF_VARCHAR2_TABLE_200
64: , a11 JTF_VARCHAR2_TABLE_200
65: , a12 JTF_VARCHAR2_TABLE_200

Line 62: , a9 JTF_VARCHAR2_TABLE_100

58: , a5 JTF_DATE_TABLE
59: , a6 JTF_NUMBER_TABLE
60: , a7 JTF_NUMBER_TABLE
61: , a8 JTF_VARCHAR2_TABLE_100
62: , a9 JTF_VARCHAR2_TABLE_100
63: , a10 JTF_VARCHAR2_TABLE_200
64: , a11 JTF_VARCHAR2_TABLE_200
65: , a12 JTF_VARCHAR2_TABLE_200
66: , a13 JTF_VARCHAR2_TABLE_200

Line 132: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

128: end loop;
129: end if;
130: end if;
131: end rosetta_table_copy_in_p3;
132: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
133: , a1 out nocopy JTF_NUMBER_TABLE
134: , a2 out nocopy JTF_NUMBER_TABLE
135: , a3 out nocopy JTF_NUMBER_TABLE
136: , a4 out nocopy JTF_DATE_TABLE

Line 140: , a8 out nocopy JTF_VARCHAR2_TABLE_100

136: , a4 out nocopy JTF_DATE_TABLE
137: , a5 out nocopy JTF_DATE_TABLE
138: , a6 out nocopy JTF_NUMBER_TABLE
139: , a7 out nocopy JTF_NUMBER_TABLE
140: , a8 out nocopy JTF_VARCHAR2_TABLE_100
141: , a9 out nocopy JTF_VARCHAR2_TABLE_100
142: , a10 out nocopy JTF_VARCHAR2_TABLE_200
143: , a11 out nocopy JTF_VARCHAR2_TABLE_200
144: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 141: , a9 out nocopy JTF_VARCHAR2_TABLE_100

137: , a5 out nocopy JTF_DATE_TABLE
138: , a6 out nocopy JTF_NUMBER_TABLE
139: , a7 out nocopy JTF_NUMBER_TABLE
140: , a8 out nocopy JTF_VARCHAR2_TABLE_100
141: , a9 out nocopy JTF_VARCHAR2_TABLE_100
142: , a10 out nocopy JTF_VARCHAR2_TABLE_200
143: , a11 out nocopy JTF_VARCHAR2_TABLE_200
144: , a12 out nocopy JTF_VARCHAR2_TABLE_200
145: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 167: a0 := JTF_VARCHAR2_TABLE_100();

163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin
166: if t is null or t.count = 0 then
167: a0 := JTF_VARCHAR2_TABLE_100();
168: a1 := JTF_NUMBER_TABLE();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_DATE_TABLE();

Line 175: a8 := JTF_VARCHAR2_TABLE_100();

171: a4 := JTF_DATE_TABLE();
172: a5 := JTF_DATE_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_VARCHAR2_TABLE_100();
177: a10 := JTF_VARCHAR2_TABLE_200();
178: a11 := JTF_VARCHAR2_TABLE_200();
179: a12 := JTF_VARCHAR2_TABLE_200();

Line 176: a9 := JTF_VARCHAR2_TABLE_100();

172: a5 := JTF_DATE_TABLE();
173: a6 := JTF_NUMBER_TABLE();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_VARCHAR2_TABLE_100();
177: a10 := JTF_VARCHAR2_TABLE_200();
178: a11 := JTF_VARCHAR2_TABLE_200();
179: a12 := JTF_VARCHAR2_TABLE_200();
180: a13 := JTF_VARCHAR2_TABLE_200();

Line 199: a0 := JTF_VARCHAR2_TABLE_100();

195: a28 := JTF_NUMBER_TABLE();
196: a29 := JTF_DATE_TABLE();
197: a30 := JTF_NUMBER_TABLE();
198: else
199: a0 := JTF_VARCHAR2_TABLE_100();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_NUMBER_TABLE();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_DATE_TABLE();

Line 207: a8 := JTF_VARCHAR2_TABLE_100();

203: a4 := JTF_DATE_TABLE();
204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_VARCHAR2_TABLE_200();
210: a11 := JTF_VARCHAR2_TABLE_200();
211: a12 := JTF_VARCHAR2_TABLE_200();

Line 208: a9 := JTF_VARCHAR2_TABLE_100();

204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_NUMBER_TABLE();
207: a8 := JTF_VARCHAR2_TABLE_100();
208: a9 := JTF_VARCHAR2_TABLE_100();
209: a10 := JTF_VARCHAR2_TABLE_200();
210: a11 := JTF_VARCHAR2_TABLE_200();
211: a12 := JTF_VARCHAR2_TABLE_200();
212: a13 := JTF_VARCHAR2_TABLE_200();

Line 721: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

717: , p_validation_level NUMBER
718: , p_type VARCHAR2
719: , p_quota_id NUMBER
720: , p_calc_formula_id NUMBER
721: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
722: , p7_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
724: , p8_a1 out nocopy JTF_NUMBER_TABLE
725: , p8_a2 out nocopy JTF_NUMBER_TABLE

Line 723: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

719: , p_quota_id NUMBER
720: , p_calc_formula_id NUMBER
721: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
722: , p7_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
724: , p8_a1 out nocopy JTF_NUMBER_TABLE
725: , p8_a2 out nocopy JTF_NUMBER_TABLE
726: , p8_a3 out nocopy JTF_NUMBER_TABLE
727: , p8_a4 out nocopy JTF_DATE_TABLE

Line 731: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

727: , p8_a4 out nocopy JTF_DATE_TABLE
728: , p8_a5 out nocopy JTF_DATE_TABLE
729: , p8_a6 out nocopy JTF_NUMBER_TABLE
730: , p8_a7 out nocopy JTF_NUMBER_TABLE
731: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
732: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
733: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
734: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
735: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 732: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

728: , p8_a5 out nocopy JTF_DATE_TABLE
729: , p8_a6 out nocopy JTF_NUMBER_TABLE
730: , p8_a7 out nocopy JTF_NUMBER_TABLE
731: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
732: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
733: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
734: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
735: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
736: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200