eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MULTI_RATE_SCHEDULES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_multi_rate_schedules_pvt_w as
2: /* $Header: cnwrschb.pls 120.4 2006/01/18 16:13 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwrschb.pls 120.4 2006/01/18 16:13 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin
11: if a0 is not null and a0.count > 0 then

Line 30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: end loop;
27: end if;
28: end if;
29: end rosetta_table_copy_in_p5;
30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE

Line 33: , a3 out nocopy JTF_NUMBER_TABLE

29: end rosetta_table_copy_in_p5;
30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin

Line 34: , a4 out nocopy JTF_NUMBER_TABLE

30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if t is null or t.count = 0 then

Line 39: a0 := JTF_NUMBER_TABLE();

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

Line 42: a3 := JTF_NUMBER_TABLE();

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

Line 43: a4 := JTF_NUMBER_TABLE();

39: a0 := JTF_NUMBER_TABLE();
40: a1 := JTF_VARCHAR2_TABLE_100();
41: a2 := JTF_VARCHAR2_TABLE_100();
42: a3 := JTF_NUMBER_TABLE();
43: a4 := JTF_NUMBER_TABLE();
44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_100();

Line 45: a0 := JTF_NUMBER_TABLE();

41: a2 := JTF_VARCHAR2_TABLE_100();
42: a3 := JTF_NUMBER_TABLE();
43: a4 := JTF_NUMBER_TABLE();
44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_100();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();

Line 48: a3 := JTF_NUMBER_TABLE();

44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_100();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);

Line 49: a4 := JTF_NUMBER_TABLE();

45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_100();
48: a3 := JTF_NUMBER_TABLE();
49: a4 := JTF_NUMBER_TABLE();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);
53: a2.extend(t.count);

Line 74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE

70: end if;
71: end if;
72: end rosetta_table_copy_out_p5;
73:
74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100

Line 75: , a1 JTF_NUMBER_TABLE

71: end if;
72: end rosetta_table_copy_out_p5;
73:
74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE

Line 76: , a2 JTF_NUMBER_TABLE

72: end rosetta_table_copy_out_p5;
73:
74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_VARCHAR2_TABLE_100

Line 77: , a3 JTF_NUMBER_TABLE

73:
74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_NUMBER_TABLE

Line 79: , a5 JTF_NUMBER_TABLE

75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;

Line 81: , a7 JTF_NUMBER_TABLE

77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_VARCHAR2_TABLE_100
81: , a7 JTF_NUMBER_TABLE
82: ) as
83: ddindx binary_integer; indx binary_integer;
84: begin
85: if a0 is not null and a0.count > 0 then

Line 107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a1 out nocopy JTF_NUMBER_TABLE

104: end if;
105: end if;
106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_NUMBER_TABLE

Line 109: , a2 out nocopy JTF_NUMBER_TABLE

105: end if;
106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , a3 out nocopy JTF_NUMBER_TABLE

106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_NUMBER_TABLE

Line 112: , a5 out nocopy JTF_NUMBER_TABLE

108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_NUMBER_TABLE
115: ) as
116: ddindx binary_integer; indx binary_integer;

Line 114: , a7 out nocopy JTF_NUMBER_TABLE

110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_VARCHAR2_TABLE_100
114: , a7 out nocopy JTF_NUMBER_TABLE
115: ) as
116: ddindx binary_integer; indx binary_integer;
117: begin
118: if t is null or t.count = 0 then

Line 119: a0 := JTF_NUMBER_TABLE();

115: ) as
116: ddindx binary_integer; indx binary_integer;
117: begin
118: if t is null or t.count = 0 then
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();

Line 120: a1 := JTF_NUMBER_TABLE();

116: ddindx binary_integer; indx binary_integer;
117: begin
118: if t is null or t.count = 0 then
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();

Line 121: a2 := JTF_NUMBER_TABLE();

117: begin
118: if t is null or t.count = 0 then
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_VARCHAR2_TABLE_100();

Line 122: a3 := JTF_NUMBER_TABLE();

118: if t is null or t.count = 0 then
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();

Line 124: a5 := JTF_NUMBER_TABLE();

120: a1 := JTF_NUMBER_TABLE();
121: a2 := JTF_NUMBER_TABLE();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();

Line 126: a7 := JTF_NUMBER_TABLE();

122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();

Line 128: a0 := JTF_NUMBER_TABLE();

124: a5 := JTF_NUMBER_TABLE();
125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();
131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();

Line 129: a1 := JTF_NUMBER_TABLE();

125: a6 := JTF_VARCHAR2_TABLE_100();
126: a7 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();
131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();
133: a5 := JTF_NUMBER_TABLE();

Line 130: a2 := JTF_NUMBER_TABLE();

126: a7 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();
131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();
133: a5 := JTF_NUMBER_TABLE();
134: a6 := JTF_VARCHAR2_TABLE_100();

Line 131: a3 := JTF_NUMBER_TABLE();

127: else
128: a0 := JTF_NUMBER_TABLE();
129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();
131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();
133: a5 := JTF_NUMBER_TABLE();
134: a6 := JTF_VARCHAR2_TABLE_100();
135: a7 := JTF_NUMBER_TABLE();

Line 133: a5 := JTF_NUMBER_TABLE();

129: a1 := JTF_NUMBER_TABLE();
130: a2 := JTF_NUMBER_TABLE();
131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();
133: a5 := JTF_NUMBER_TABLE();
134: a6 := JTF_VARCHAR2_TABLE_100();
135: a7 := JTF_NUMBER_TABLE();
136: if t.count > 0 then
137: a0.extend(t.count);

Line 135: a7 := JTF_NUMBER_TABLE();

131: a3 := JTF_NUMBER_TABLE();
132: a4 := JTF_VARCHAR2_TABLE_100();
133: a5 := JTF_NUMBER_TABLE();
134: a6 := JTF_VARCHAR2_TABLE_100();
135: a7 := JTF_NUMBER_TABLE();
136: if t.count > 0 then
137: a0.extend(t.count);
138: a1.extend(t.count);
139: a2.extend(t.count);

Line 207: procedure rosetta_table_copy_in_p8(t out nocopy cn_multi_rate_schedules_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

203: end if;
204: end if;
205: end rosetta_table_copy_out_p7;
206:
207: procedure rosetta_table_copy_in_p8(t out nocopy cn_multi_rate_schedules_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
208: ddindx binary_integer; indx binary_integer;
209: begin
210: if a0 is not null and a0.count > 0 then
211: if a0.count > 0 then

Line 225: procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

221: end loop;
222: end if;
223: end if;
224: end rosetta_table_copy_in_p8;
225: procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();

Line 229: a0 := JTF_NUMBER_TABLE();

225: procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: if t.count > 0 then
233: a0.extend(t.count);

Line 231: a0 := JTF_NUMBER_TABLE();

227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();
230: else
231: a0 := JTF_NUMBER_TABLE();
232: if t.count > 0 then
233: a0.extend(t.count);
234: ddindx := t.first;
235: indx := 1;

Line 248: procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE

244: end if;
245: end if;
246: end rosetta_table_copy_out_p8;
247:
248: procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_VARCHAR2_TABLE_100
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_VARCHAR2_TABLE_100

Line 251: , a3 JTF_NUMBER_TABLE

247:
248: procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_VARCHAR2_TABLE_100
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_VARCHAR2_TABLE_100
253: , a5 JTF_DATE_TABLE
254: , a6 JTF_DATE_TABLE
255: ) as

Line 279: procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

275: end loop;
276: end if;
277: end if;
278: end rosetta_table_copy_in_p9;
279: procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 282: , a3 out nocopy JTF_NUMBER_TABLE

278: end rosetta_table_copy_in_p9;
279: procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , a5 out nocopy JTF_DATE_TABLE
285: , a6 out nocopy JTF_DATE_TABLE
286: ) as

Line 290: a0 := JTF_NUMBER_TABLE();

286: ) as
287: ddindx binary_integer; indx binary_integer;
288: begin
289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_VARCHAR2_TABLE_100();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_VARCHAR2_TABLE_100();

Line 293: a3 := JTF_NUMBER_TABLE();

289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_VARCHAR2_TABLE_100();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_VARCHAR2_TABLE_100();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_DATE_TABLE();
297: else

Line 298: a0 := JTF_NUMBER_TABLE();

294: a4 := JTF_VARCHAR2_TABLE_100();
295: a5 := JTF_DATE_TABLE();
296: a6 := JTF_DATE_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_VARCHAR2_TABLE_100();
300: a2 := JTF_VARCHAR2_TABLE_100();
301: a3 := JTF_NUMBER_TABLE();
302: a4 := JTF_VARCHAR2_TABLE_100();

Line 301: a3 := JTF_NUMBER_TABLE();

297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_VARCHAR2_TABLE_100();
300: a2 := JTF_VARCHAR2_TABLE_100();
301: a3 := JTF_NUMBER_TABLE();
302: a4 := JTF_VARCHAR2_TABLE_100();
303: a5 := JTF_DATE_TABLE();
304: a6 := JTF_DATE_TABLE();
305: if t.count > 0 then

Line 333: procedure rosetta_table_copy_in_p10(t out nocopy cn_multi_rate_schedules_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE

329: end if;
330: end if;
331: end rosetta_table_copy_out_p9;
332:
333: procedure rosetta_table_copy_in_p10(t out nocopy cn_multi_rate_schedules_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
334: , a1 JTF_VARCHAR2_TABLE_100
335: , a2 JTF_VARCHAR2_TABLE_100
336: , a3 JTF_DATE_TABLE
337: , a4 JTF_DATE_TABLE

Line 360: procedure rosetta_table_copy_out_p10(t cn_multi_rate_schedules_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p10;
360: procedure rosetta_table_copy_out_p10(t cn_multi_rate_schedules_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_VARCHAR2_TABLE_100
362: , a2 out nocopy JTF_VARCHAR2_TABLE_100
363: , a3 out nocopy JTF_DATE_TABLE
364: , a4 out nocopy JTF_DATE_TABLE

Line 369: a0 := JTF_NUMBER_TABLE();

365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if t is null or t.count = 0 then
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_VARCHAR2_TABLE_100();
371: a2 := JTF_VARCHAR2_TABLE_100();
372: a3 := JTF_DATE_TABLE();
373: a4 := JTF_DATE_TABLE();

Line 375: a0 := JTF_NUMBER_TABLE();

371: a2 := JTF_VARCHAR2_TABLE_100();
372: a3 := JTF_DATE_TABLE();
373: a4 := JTF_DATE_TABLE();
374: else
375: a0 := JTF_NUMBER_TABLE();
376: a1 := JTF_VARCHAR2_TABLE_100();
377: a2 := JTF_VARCHAR2_TABLE_100();
378: a3 := JTF_DATE_TABLE();
379: a4 := JTF_DATE_TABLE();

Line 404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE

400: end if;
401: end if;
402: end rosetta_table_copy_out_p10;
403:
404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_NUMBER_TABLE
407: , a3 JTF_NUMBER_TABLE
408: ) as

Line 405: , a1 JTF_NUMBER_TABLE

401: end if;
402: end rosetta_table_copy_out_p10;
403:
404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_NUMBER_TABLE
407: , a3 JTF_NUMBER_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;

Line 406: , a2 JTF_NUMBER_TABLE

402: end rosetta_table_copy_out_p10;
403:
404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_NUMBER_TABLE
407: , a3 JTF_NUMBER_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin

Line 407: , a3 JTF_NUMBER_TABLE

403:
404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_NUMBER_TABLE
407: , a3 JTF_NUMBER_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin
411: if a0 is not null and a0.count > 0 then

Line 429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p11;
429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: ) as

Line 430: , a1 out nocopy JTF_NUMBER_TABLE

426: end if;
427: end if;
428: end rosetta_table_copy_in_p11;
429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: ) as
434: ddindx binary_integer; indx binary_integer;

Line 431: , a2 out nocopy JTF_NUMBER_TABLE

427: end if;
428: end rosetta_table_copy_in_p11;
429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: ) as
434: ddindx binary_integer; indx binary_integer;
435: begin

Line 432: , a3 out nocopy JTF_NUMBER_TABLE

428: end rosetta_table_copy_in_p11;
429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: ) as
434: ddindx binary_integer; indx binary_integer;
435: begin
436: if t is null or t.count = 0 then

Line 437: a0 := JTF_NUMBER_TABLE();

433: ) as
434: ddindx binary_integer; indx binary_integer;
435: begin
436: if t is null or t.count = 0 then
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else

Line 438: a1 := JTF_NUMBER_TABLE();

434: ddindx binary_integer; indx binary_integer;
435: begin
436: if t is null or t.count = 0 then
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();

Line 439: a2 := JTF_NUMBER_TABLE();

435: begin
436: if t is null or t.count = 0 then
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();

Line 440: a3 := JTF_NUMBER_TABLE();

436: if t is null or t.count = 0 then
437: a0 := JTF_NUMBER_TABLE();
438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();
444: a2 := JTF_NUMBER_TABLE();

Line 442: a0 := JTF_NUMBER_TABLE();

438: a1 := JTF_NUMBER_TABLE();
439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();
444: a2 := JTF_NUMBER_TABLE();
445: a3 := JTF_NUMBER_TABLE();
446: if t.count > 0 then

Line 443: a1 := JTF_NUMBER_TABLE();

439: a2 := JTF_NUMBER_TABLE();
440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();
444: a2 := JTF_NUMBER_TABLE();
445: a3 := JTF_NUMBER_TABLE();
446: if t.count > 0 then
447: a0.extend(t.count);

Line 444: a2 := JTF_NUMBER_TABLE();

440: a3 := JTF_NUMBER_TABLE();
441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();
444: a2 := JTF_NUMBER_TABLE();
445: a3 := JTF_NUMBER_TABLE();
446: if t.count > 0 then
447: a0.extend(t.count);
448: a1.extend(t.count);

Line 445: a3 := JTF_NUMBER_TABLE();

441: else
442: a0 := JTF_NUMBER_TABLE();
443: a1 := JTF_NUMBER_TABLE();
444: a2 := JTF_NUMBER_TABLE();
445: a3 := JTF_NUMBER_TABLE();
446: if t.count > 0 then
447: a0.extend(t.count);
448: a1.extend(t.count);
449: a2.extend(t.count);

Line 475: , p7_a0 JTF_NUMBER_TABLE

471: , p_validation_level NUMBER
472: , p_name VARCHAR2
473: , p_commission_unit_code VARCHAR2
474: , p_number_dim NUMBER
475: , p7_a0 JTF_NUMBER_TABLE
476: , p7_a1 JTF_NUMBER_TABLE
477: , p7_a2 JTF_NUMBER_TABLE
478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 476: , p7_a1 JTF_NUMBER_TABLE

472: , p_name VARCHAR2
473: , p_commission_unit_code VARCHAR2
474: , p_number_dim NUMBER
475: , p7_a0 JTF_NUMBER_TABLE
476: , p7_a1 JTF_NUMBER_TABLE
477: , p7_a2 JTF_NUMBER_TABLE
478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100
480: , p7_a5 JTF_NUMBER_TABLE

Line 477: , p7_a2 JTF_NUMBER_TABLE

473: , p_commission_unit_code VARCHAR2
474: , p_number_dim NUMBER
475: , p7_a0 JTF_NUMBER_TABLE
476: , p7_a1 JTF_NUMBER_TABLE
477: , p7_a2 JTF_NUMBER_TABLE
478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100
480: , p7_a5 JTF_NUMBER_TABLE
481: , p7_a6 JTF_VARCHAR2_TABLE_100

Line 478: , p7_a3 JTF_NUMBER_TABLE

474: , p_number_dim NUMBER
475: , p7_a0 JTF_NUMBER_TABLE
476: , p7_a1 JTF_NUMBER_TABLE
477: , p7_a2 JTF_NUMBER_TABLE
478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100
480: , p7_a5 JTF_NUMBER_TABLE
481: , p7_a6 JTF_VARCHAR2_TABLE_100
482: , p7_a7 JTF_NUMBER_TABLE

Line 480: , p7_a5 JTF_NUMBER_TABLE

476: , p7_a1 JTF_NUMBER_TABLE
477: , p7_a2 JTF_NUMBER_TABLE
478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100
480: , p7_a5 JTF_NUMBER_TABLE
481: , p7_a6 JTF_VARCHAR2_TABLE_100
482: , p7_a7 JTF_NUMBER_TABLE
483: , p_org_id NUMBER
484: , x_rate_schedule_id in out nocopy NUMBER

Line 482: , p7_a7 JTF_NUMBER_TABLE

478: , p7_a3 JTF_NUMBER_TABLE
479: , p7_a4 JTF_VARCHAR2_TABLE_100
480: , p7_a5 JTF_NUMBER_TABLE
481: , p7_a6 JTF_VARCHAR2_TABLE_100
482: , p7_a7 JTF_NUMBER_TABLE
483: , p_org_id NUMBER
484: , x_rate_schedule_id in out nocopy NUMBER
485: , x_return_status out nocopy VARCHAR2
486: , x_msg_count out nocopy NUMBER

Line 558: , p10_a0 JTF_NUMBER_TABLE

554: , p_commission_unit_code VARCHAR2
555: , p_number_dim NUMBER
556: , p_org_id NUMBER
557: , p_object_version_number in out nocopy NUMBER
558: , p10_a0 JTF_NUMBER_TABLE
559: , p10_a1 JTF_NUMBER_TABLE
560: , p10_a2 JTF_NUMBER_TABLE
561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100

Line 559: , p10_a1 JTF_NUMBER_TABLE

555: , p_number_dim NUMBER
556: , p_org_id NUMBER
557: , p_object_version_number in out nocopy NUMBER
558: , p10_a0 JTF_NUMBER_TABLE
559: , p10_a1 JTF_NUMBER_TABLE
560: , p10_a2 JTF_NUMBER_TABLE
561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100
563: , p10_a5 JTF_NUMBER_TABLE

Line 560: , p10_a2 JTF_NUMBER_TABLE

556: , p_org_id NUMBER
557: , p_object_version_number in out nocopy NUMBER
558: , p10_a0 JTF_NUMBER_TABLE
559: , p10_a1 JTF_NUMBER_TABLE
560: , p10_a2 JTF_NUMBER_TABLE
561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100
563: , p10_a5 JTF_NUMBER_TABLE
564: , p10_a6 JTF_VARCHAR2_TABLE_100

Line 561: , p10_a3 JTF_NUMBER_TABLE

557: , p_object_version_number in out nocopy NUMBER
558: , p10_a0 JTF_NUMBER_TABLE
559: , p10_a1 JTF_NUMBER_TABLE
560: , p10_a2 JTF_NUMBER_TABLE
561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100
563: , p10_a5 JTF_NUMBER_TABLE
564: , p10_a6 JTF_VARCHAR2_TABLE_100
565: , p10_a7 JTF_NUMBER_TABLE

Line 563: , p10_a5 JTF_NUMBER_TABLE

559: , p10_a1 JTF_NUMBER_TABLE
560: , p10_a2 JTF_NUMBER_TABLE
561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100
563: , p10_a5 JTF_NUMBER_TABLE
564: , p10_a6 JTF_VARCHAR2_TABLE_100
565: , p10_a7 JTF_NUMBER_TABLE
566: , x_return_status out nocopy VARCHAR2
567: , x_msg_count out nocopy NUMBER

Line 565: , p10_a7 JTF_NUMBER_TABLE

561: , p10_a3 JTF_NUMBER_TABLE
562: , p10_a4 JTF_VARCHAR2_TABLE_100
563: , p10_a5 JTF_NUMBER_TABLE
564: , p10_a6 JTF_VARCHAR2_TABLE_100
565: , p10_a7 JTF_NUMBER_TABLE
566: , x_return_status out nocopy VARCHAR2
567: , x_msg_count out nocopy NUMBER
568: , x_msg_data out nocopy VARCHAR2
569: )

Line 633: , p_rate_dim_tier_id_tbl JTF_NUMBER_TABLE

629:
630: end;
631:
632: procedure get_rate_tier_info(p_rate_schedule_id NUMBER
633: , p_rate_dim_tier_id_tbl JTF_NUMBER_TABLE
634: , x_rate_tier_id out nocopy NUMBER
635: , x_rate_sequence out nocopy NUMBER
636: , x_commission_amount out nocopy NUMBER
637: , x_object_version_number out nocopy NUMBER

Line 670: , p1_a0 JTF_NUMBER_TABLE

666:
667: end;
668:
669: procedure update_comm_rate(p_rate_schedule_id NUMBER
670: , p1_a0 JTF_NUMBER_TABLE
671: , p1_a1 JTF_NUMBER_TABLE
672: , p1_a2 JTF_NUMBER_TABLE
673: , p1_a3 JTF_NUMBER_TABLE
674: , p_org_id NUMBER

Line 671: , p1_a1 JTF_NUMBER_TABLE

667: end;
668:
669: procedure update_comm_rate(p_rate_schedule_id NUMBER
670: , p1_a0 JTF_NUMBER_TABLE
671: , p1_a1 JTF_NUMBER_TABLE
672: , p1_a2 JTF_NUMBER_TABLE
673: , p1_a3 JTF_NUMBER_TABLE
674: , p_org_id NUMBER
675: )

Line 672: , p1_a2 JTF_NUMBER_TABLE

668:
669: procedure update_comm_rate(p_rate_schedule_id NUMBER
670: , p1_a0 JTF_NUMBER_TABLE
671: , p1_a1 JTF_NUMBER_TABLE
672: , p1_a2 JTF_NUMBER_TABLE
673: , p1_a3 JTF_NUMBER_TABLE
674: , p_org_id NUMBER
675: )
676:

Line 673: , p1_a3 JTF_NUMBER_TABLE

669: procedure update_comm_rate(p_rate_schedule_id NUMBER
670: , p1_a0 JTF_NUMBER_TABLE
671: , p1_a1 JTF_NUMBER_TABLE
672: , p1_a2 JTF_NUMBER_TABLE
673: , p1_a3 JTF_NUMBER_TABLE
674: , p_org_id NUMBER
675: )
676:
677: as