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_SFP_GROUP_UTIL_PVT_W dependencies on 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_sfp_group_util_pvt.srprole_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: ) as
17: ddindx binary_integer; indx binary_integer;
18: begin
19: if a0 is not null and a0.count > 0 then

Line 38: , a2 out nocopy JTF_VARCHAR2_TABLE_100

34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then

Line 45: a2 := JTF_VARCHAR2_TABLE_100();

41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_NUMBER_TABLE();
44: a1 := JTF_NUMBER_TABLE();
45: a2 := JTF_VARCHAR2_TABLE_100();
46: else
47: a0 := JTF_NUMBER_TABLE();
48: a1 := JTF_NUMBER_TABLE();
49: a2 := JTF_VARCHAR2_TABLE_100();

Line 49: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 70: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

66: end if;
67: end if;
68: end rosetta_table_copy_out_p1;
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
71: , a1 JTF_VARCHAR2_TABLE_100
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin

Line 71: , a1 JTF_VARCHAR2_TABLE_100

67: end if;
68: end rosetta_table_copy_out_p1;
69:
70: procedure rosetta_table_copy_in_p3(t out nocopy cn_sfp_group_util_pvt.grporg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
71: , a1 JTF_VARCHAR2_TABLE_100
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if a0 is not null and a0.count > 0 then

Line 91: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p3;
91: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin

Line 92: , a1 out nocopy JTF_VARCHAR2_TABLE_100

88: end if;
89: end if;
90: end rosetta_table_copy_in_p3;
91: procedure rosetta_table_copy_out_p3(t cn_sfp_group_util_pvt.grporg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: ) as
94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then

Line 97: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 98: a1 := JTF_VARCHAR2_TABLE_100();

94: ddindx binary_integer; indx binary_integer;
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_VARCHAR2_TABLE_100();
98: a1 := JTF_VARCHAR2_TABLE_100();
99: else
100: a0 := JTF_VARCHAR2_TABLE_100();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: if t.count > 0 then

Line 100: a0 := JTF_VARCHAR2_TABLE_100();

96: if t is null or t.count = 0 then
97: a0 := JTF_VARCHAR2_TABLE_100();
98: a1 := JTF_VARCHAR2_TABLE_100();
99: else
100: a0 := JTF_VARCHAR2_TABLE_100();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: if t.count > 0 then
103: a0.extend(t.count);
104: a1.extend(t.count);

Line 101: a1 := JTF_VARCHAR2_TABLE_100();

97: a0 := JTF_VARCHAR2_TABLE_100();
98: a1 := JTF_VARCHAR2_TABLE_100();
99: else
100: a0 := JTF_VARCHAR2_TABLE_100();
101: a1 := JTF_VARCHAR2_TABLE_100();
102: if t.count > 0 then
103: a0.extend(t.count);
104: a1.extend(t.count);
105: ddindx := t.first;

Line 227: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

223: , p_status VARCHAR2
224: , p_effective_date date
225: , p7_a0 out nocopy JTF_NUMBER_TABLE
226: , p7_a1 out nocopy JTF_NUMBER_TABLE
227: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
228: , x_return_status out nocopy VARCHAR2
229: , x_msg_count out nocopy NUMBER
230: , x_msg_data out nocopy VARCHAR2
231: )

Line 290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

286: , p_commit VARCHAR2
287: , p_validation_level NUMBER
288: , p_comp_group_id NUMBER
289: , p_effective_date date
290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

287: , p_validation_level NUMBER
288: , p_comp_group_id NUMBER
289: , p_effective_date date
290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

288: , p_comp_group_id NUMBER
289: , p_effective_date date
290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

289: , p_effective_date date
290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

290: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
298: , x_return_status out nocopy VARCHAR2

Line 295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

291: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER

Line 296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

292: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2

Line 297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

293: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
294: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
295: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
297: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
298: , x_return_status out nocopy VARCHAR2
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: )