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_PLAN_TEXTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_NUMBER_TABLE

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

Line 15: , a2 JTF_NUMBER_TABLE

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

Line 16: , a3 JTF_NUMBER_TABLE

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

Line 20: , a7 JTF_NUMBER_TABLE

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

Line 21: , a8 JTF_NUMBER_TABLE

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_2000
19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then

Line 48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a1 out nocopy JTF_NUMBER_TABLE

45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 50: , a2 out nocopy JTF_NUMBER_TABLE

46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 51: , a3 out nocopy JTF_NUMBER_TABLE

47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a7 out nocopy JTF_NUMBER_TABLE

Line 55: , a7 out nocopy JTF_NUMBER_TABLE

51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a7 out nocopy JTF_NUMBER_TABLE
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a8 out nocopy JTF_NUMBER_TABLE

52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a7 out nocopy JTF_NUMBER_TABLE
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then

Line 61: a0 := JTF_NUMBER_TABLE();

57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();

Line 62: a1 := JTF_NUMBER_TABLE();

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

Line 63: a2 := JTF_NUMBER_TABLE();

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

Line 64: a3 := JTF_NUMBER_TABLE();

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

Line 68: a7 := JTF_NUMBER_TABLE();

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

Line 69: a8 := JTF_NUMBER_TABLE();

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

Line 71: a0 := JTF_NUMBER_TABLE();

67: a6 := JTF_VARCHAR2_TABLE_2000();
68: a7 := JTF_NUMBER_TABLE();
69: a8 := JTF_NUMBER_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_NUMBER_TABLE();
73: a2 := JTF_NUMBER_TABLE();
74: a3 := JTF_NUMBER_TABLE();
75: a4 := JTF_VARCHAR2_TABLE_100();

Line 72: a1 := JTF_NUMBER_TABLE();

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

Line 73: a2 := JTF_NUMBER_TABLE();

69: a8 := JTF_NUMBER_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_NUMBER_TABLE();
73: a2 := JTF_NUMBER_TABLE();
74: a3 := JTF_NUMBER_TABLE();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_VARCHAR2_TABLE_2000();
77: a6 := JTF_VARCHAR2_TABLE_2000();

Line 74: a3 := JTF_NUMBER_TABLE();

70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_NUMBER_TABLE();
73: a2 := JTF_NUMBER_TABLE();
74: a3 := JTF_NUMBER_TABLE();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_VARCHAR2_TABLE_2000();
77: a6 := JTF_VARCHAR2_TABLE_2000();
78: a7 := JTF_NUMBER_TABLE();

Line 78: a7 := JTF_NUMBER_TABLE();

74: a3 := JTF_NUMBER_TABLE();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_VARCHAR2_TABLE_2000();
77: a6 := JTF_VARCHAR2_TABLE_2000();
78: a7 := JTF_NUMBER_TABLE();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 79: a8 := JTF_NUMBER_TABLE();

75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_VARCHAR2_TABLE_2000();
77: a6 := JTF_VARCHAR2_TABLE_2000();
78: a7 := JTF_NUMBER_TABLE();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 112: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_out_p1;
111:
112: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin

Line 133: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

129: end loop;
130: end if;
131: end if;
132: end rosetta_table_copy_in_p3;
133: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin

Line 139: a0 := JTF_NUMBER_TABLE();

135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_VARCHAR2_TABLE_100();

Line 142: a0 := JTF_NUMBER_TABLE();

138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_VARCHAR2_TABLE_100();
144: if t.count > 0 then
145: a0.extend(t.count);
146: a1.extend(t.count);

Line 351: , p6_a0 out nocopy JTF_NUMBER_TABLE

347: , p_commit VARCHAR2
348: , p_validation_level NUMBER
349: , p_role_id NUMBER
350: , p_role_model_id NUMBER
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 352: , p6_a1 out nocopy JTF_NUMBER_TABLE

348: , p_validation_level NUMBER
349: , p_role_id NUMBER
350: , p_role_model_id NUMBER
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 353: , p6_a2 out nocopy JTF_NUMBER_TABLE

349: , p_role_id NUMBER
350: , p_role_model_id NUMBER
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 354: , p6_a3 out nocopy JTF_NUMBER_TABLE

350: , p_role_model_id NUMBER
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
358: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 358: , p6_a7 out nocopy JTF_NUMBER_TABLE

354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
358: , p6_a7 out nocopy JTF_NUMBER_TABLE
359: , p6_a8 out nocopy JTF_NUMBER_TABLE
360: , x_updatable out nocopy VARCHAR2
361: , x_return_status out nocopy VARCHAR2
362: , x_msg_count out nocopy NUMBER

Line 359: , p6_a8 out nocopy JTF_NUMBER_TABLE

355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
358: , p6_a7 out nocopy JTF_NUMBER_TABLE
359: , p6_a8 out nocopy JTF_NUMBER_TABLE
360: , x_updatable out nocopy VARCHAR2
361: , x_return_status out nocopy VARCHAR2
362: , x_msg_count out nocopy NUMBER
363: , x_msg_data out nocopy VARCHAR2

Line 425: , p6_a0 out nocopy JTF_NUMBER_TABLE

421: , p_commit VARCHAR2
422: , p_validation_level NUMBER
423: , p_role_id NUMBER
424: , p_role_model_id NUMBER
425: , p6_a0 out nocopy JTF_NUMBER_TABLE
426: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2

Line 481: , p6_a0 out nocopy JTF_NUMBER_TABLE

477: , p_commit VARCHAR2
478: , p_validation_level NUMBER
479: , p_role_id NUMBER
480: , p_role_model_id NUMBER
481: , p6_a0 out nocopy JTF_NUMBER_TABLE
482: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
483: , x_return_status out nocopy VARCHAR2
484: , x_msg_count out nocopy NUMBER
485: , x_msg_data out nocopy VARCHAR2

Line 538: , p7_a0 out nocopy JTF_NUMBER_TABLE

534: , p_validation_level NUMBER
535: , p_role_id NUMBER
536: , p_role_model_id NUMBER
537: , p_quota_cate_type VARCHAR2
538: , p7_a0 out nocopy JTF_NUMBER_TABLE
539: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
540: , x_return_status out nocopy VARCHAR2
541: , x_msg_count out nocopy NUMBER
542: , x_msg_data out nocopy VARCHAR2