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_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sfp_group_util_pvt.srprole_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_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;

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
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

Line 36: procedure rosetta_table_copy_out_p1(t cn_sfp_group_util_pvt.srprole_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: end loop;
33: end if;
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;

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: end if;
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

Line 43: a0 := JTF_NUMBER_TABLE();

39: ) as
40: ddindx binary_integer; indx binary_integer;
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();

Line 44: a1 := JTF_NUMBER_TABLE();

40: ddindx binary_integer; indx binary_integer;
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();

Line 47: a0 := JTF_NUMBER_TABLE();

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();
50: if t.count > 0 then
51: a0.extend(t.count);

Line 48: a1 := 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();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);

Line 120: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE) as

116: end if;
117: end if;
118: end rosetta_table_copy_out_p3;
119:
120: procedure rosetta_table_copy_in_p4(t out nocopy cn_sfp_group_util_pvt.grpnum_tbl_type, a0 JTF_NUMBER_TABLE) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if a0 is not null and a0.count > 0 then
124: if a0.count > 0 then

Line 138: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

134: end loop;
135: end if;
136: end if;
137: end rosetta_table_copy_in_p4;
138: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();

Line 142: a0 := JTF_NUMBER_TABLE();

138: procedure rosetta_table_copy_out_p4(t cn_sfp_group_util_pvt.grpnum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);

Line 144: a0 := JTF_NUMBER_TABLE();

140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: else
144: a0 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: ddindx := t.first;
148: indx := 1;

Line 165: , p_selected_groups JTF_NUMBER_TABLE

161: procedure get_descendant_groups(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2
163: , p_commit VARCHAR2
164: , p_validation_level NUMBER
165: , p_selected_groups JTF_NUMBER_TABLE
166: , p_effective_date date
167: , x_descendant_groups out nocopy JTF_NUMBER_TABLE
168: , x_return_status out nocopy VARCHAR2
169: , x_msg_count out nocopy NUMBER

Line 167: , x_descendant_groups out nocopy JTF_NUMBER_TABLE

163: , p_commit VARCHAR2
164: , p_validation_level NUMBER
165: , p_selected_groups JTF_NUMBER_TABLE
166: , p_effective_date date
167: , x_descendant_groups out nocopy JTF_NUMBER_TABLE
168: , x_return_status out nocopy VARCHAR2
169: , x_msg_count out nocopy NUMBER
170: , x_msg_data out nocopy VARCHAR2
171: )

Line 222: , p_selected_groups JTF_NUMBER_TABLE

218: procedure get_salesrep_roles(p_api_version NUMBER
219: , p_init_msg_list VARCHAR2
220: , p_commit VARCHAR2
221: , p_validation_level NUMBER
222: , p_selected_groups JTF_NUMBER_TABLE
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

Line 225: , p7_a0 out nocopy JTF_NUMBER_TABLE

221: , p_validation_level NUMBER
222: , p_selected_groups JTF_NUMBER_TABLE
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

Line 226: , p7_a1 out nocopy JTF_NUMBER_TABLE

222: , p_selected_groups JTF_NUMBER_TABLE
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