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_QUOTA_CATEGORIES_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_VARCHAR2_TABLE_100

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_categories_pub.quota_categories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE

Line 19: , a6 JTF_VARCHAR2_TABLE_100

15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: ) as

Line 21: , a8 JTF_VARCHAR2_TABLE_100

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: ) as
24: ddindx binary_integer; indx binary_integer;
25: begin

Line 51: , a1 out nocopy JTF_VARCHAR2_TABLE_100

47: end if;
48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 52: , a2 out nocopy JTF_VARCHAR2_TABLE_100

48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a3 out nocopy JTF_VARCHAR2_TABLE_100

49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , a7 out nocopy JTF_NUMBER_TABLE

Line 54: , a4 out nocopy JTF_VARCHAR2_TABLE_100

50: procedure rosetta_table_copy_out_p1(t cn_quota_categories_pub.quota_categories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , a7 out nocopy JTF_NUMBER_TABLE
58: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a5 out nocopy JTF_VARCHAR2_TABLE_100

51: , a1 out nocopy JTF_VARCHAR2_TABLE_100
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , a7 out nocopy JTF_NUMBER_TABLE
58: , a8 out nocopy JTF_VARCHAR2_TABLE_100
59: , a9 out nocopy JTF_NUMBER_TABLE

Line 56: , a6 out nocopy JTF_VARCHAR2_TABLE_100

52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_VARCHAR2_TABLE_100
54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , a7 out nocopy JTF_NUMBER_TABLE
58: , a8 out nocopy JTF_VARCHAR2_TABLE_100
59: , a9 out nocopy JTF_NUMBER_TABLE
60: ) as

Line 58: , a8 out nocopy JTF_VARCHAR2_TABLE_100

54: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , a7 out nocopy JTF_NUMBER_TABLE
58: , a8 out nocopy JTF_VARCHAR2_TABLE_100
59: , a9 out nocopy JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin

Line 65: a1 := JTF_VARCHAR2_TABLE_100();

61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();

Line 66: a2 := JTF_VARCHAR2_TABLE_100();

62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();

Line 67: a3 := JTF_VARCHAR2_TABLE_100();

63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: a7 := JTF_NUMBER_TABLE();

Line 68: a4 := JTF_VARCHAR2_TABLE_100();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_VARCHAR2_TABLE_100();

Line 69: a5 := JTF_VARCHAR2_TABLE_100();

65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_VARCHAR2_TABLE_100();
73: a9 := JTF_NUMBER_TABLE();

Line 70: a6 := JTF_VARCHAR2_TABLE_100();

66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_VARCHAR2_TABLE_100();
73: a9 := JTF_NUMBER_TABLE();
74: else

Line 72: a8 := JTF_VARCHAR2_TABLE_100();

68: a4 := JTF_VARCHAR2_TABLE_100();
69: a5 := JTF_VARCHAR2_TABLE_100();
70: a6 := JTF_VARCHAR2_TABLE_100();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_VARCHAR2_TABLE_100();
73: a9 := JTF_NUMBER_TABLE();
74: else
75: a0 := JTF_NUMBER_TABLE();
76: a1 := JTF_VARCHAR2_TABLE_100();

Line 76: a1 := JTF_VARCHAR2_TABLE_100();

72: a8 := JTF_VARCHAR2_TABLE_100();
73: a9 := JTF_NUMBER_TABLE();
74: else
75: a0 := JTF_NUMBER_TABLE();
76: a1 := JTF_VARCHAR2_TABLE_100();
77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();

Line 77: a2 := JTF_VARCHAR2_TABLE_100();

73: a9 := JTF_NUMBER_TABLE();
74: else
75: a0 := JTF_NUMBER_TABLE();
76: a1 := JTF_VARCHAR2_TABLE_100();
77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();

Line 78: a3 := JTF_VARCHAR2_TABLE_100();

74: else
75: a0 := JTF_NUMBER_TABLE();
76: a1 := JTF_VARCHAR2_TABLE_100();
77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();
82: a7 := JTF_NUMBER_TABLE();

Line 79: a4 := JTF_VARCHAR2_TABLE_100();

75: a0 := JTF_NUMBER_TABLE();
76: a1 := JTF_VARCHAR2_TABLE_100();
77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();
82: a7 := JTF_NUMBER_TABLE();
83: a8 := JTF_VARCHAR2_TABLE_100();

Line 80: a5 := JTF_VARCHAR2_TABLE_100();

76: a1 := JTF_VARCHAR2_TABLE_100();
77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();
82: a7 := JTF_NUMBER_TABLE();
83: a8 := JTF_VARCHAR2_TABLE_100();
84: a9 := JTF_NUMBER_TABLE();

Line 81: a6 := JTF_VARCHAR2_TABLE_100();

77: a2 := JTF_VARCHAR2_TABLE_100();
78: a3 := JTF_VARCHAR2_TABLE_100();
79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();
82: a7 := JTF_NUMBER_TABLE();
83: a8 := JTF_VARCHAR2_TABLE_100();
84: a9 := JTF_NUMBER_TABLE();
85: if t.count > 0 then

Line 83: a8 := JTF_VARCHAR2_TABLE_100();

79: a4 := JTF_VARCHAR2_TABLE_100();
80: a5 := JTF_VARCHAR2_TABLE_100();
81: a6 := JTF_VARCHAR2_TABLE_100();
82: a7 := JTF_NUMBER_TABLE();
83: a8 := JTF_VARCHAR2_TABLE_100();
84: a9 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);

Line 261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

257: , p_search_name VARCHAR2
258: , p_search_type VARCHAR2
259: , p_search_unit VARCHAR2
260: , p11_a0 out nocopy JTF_NUMBER_TABLE
261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100

258: , p_search_type VARCHAR2
259: , p_search_unit VARCHAR2
260: , p11_a0 out nocopy JTF_NUMBER_TABLE
261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

259: , p_search_unit VARCHAR2
260: , p11_a0 out nocopy JTF_NUMBER_TABLE
261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p11_a7 out nocopy JTF_NUMBER_TABLE

Line 264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

260: , p11_a0 out nocopy JTF_NUMBER_TABLE
261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p11_a7 out nocopy JTF_NUMBER_TABLE
268: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

261: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p11_a7 out nocopy JTF_NUMBER_TABLE
268: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a9 out nocopy JTF_NUMBER_TABLE

Line 266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

262: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p11_a7 out nocopy JTF_NUMBER_TABLE
268: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a9 out nocopy JTF_NUMBER_TABLE
270: , x_total_records out nocopy NUMBER

Line 268: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100

264: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
265: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
267: , p11_a7 out nocopy JTF_NUMBER_TABLE
268: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
269: , p11_a9 out nocopy JTF_NUMBER_TABLE
270: , x_total_records out nocopy NUMBER
271: )
272: