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 CN_SFP_GROUP_UTIL_PVT

Line 1: package body cn_sfp_group_util_pvt_w as

1: package body cn_sfp_group_util_pvt_w as
2: /* $Header: cnwsfgrb.pls 115.0 2003/08/19 20:50:22 sbadami noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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 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 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 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 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 174: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;

170: , x_msg_data out nocopy VARCHAR2
171: )
172:
173: as
174: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
175: ddp_effective_date date;
176: ddx_descendant_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
177: ddindx binary_integer; indx binary_integer;
178: begin

Line 176: ddx_descendant_groups cn_sfp_group_util_pvt.grpnum_tbl_type;

172:
173: as
174: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
175: ddp_effective_date date;
176: ddx_descendant_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
177: ddindx binary_integer; indx binary_integer;
178: begin
179:
180: -- copy data to the local IN or IN-OUT args, if any

Line 185: cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);

181:
182:
183:
184:
185: cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);
186:
187: ddp_effective_date := rosetta_g_miss_date_in_map(p_effective_date);
188:
189:

Line 194: cn_sfp_group_util_pvt.get_descendant_groups(p_api_version,

190:
191:
192:
193: -- here's the delegated call to the old PL/SQL routine
194: cn_sfp_group_util_pvt.get_descendant_groups(p_api_version,
195: p_init_msg_list,
196: p_commit,
197: p_validation_level,
198: ddp_selected_groups,

Line 212: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p4(ddx_descendant_groups, x_descendant_groups);

208:
209:
210:
211:
212: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p4(ddx_descendant_groups, x_descendant_groups);
213:
214:
215:
216: end;

Line 234: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;

230: , x_msg_data out nocopy VARCHAR2
231: )
232:
233: as
234: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
235: ddp_effective_date date;
236: ddx_salesrep_roles cn_sfp_group_util_pvt.srprole_tbl_type;
237: ddindx binary_integer; indx binary_integer;
238: begin

Line 236: ddx_salesrep_roles cn_sfp_group_util_pvt.srprole_tbl_type;

232:
233: as
234: ddp_selected_groups cn_sfp_group_util_pvt.grpnum_tbl_type;
235: ddp_effective_date date;
236: ddx_salesrep_roles cn_sfp_group_util_pvt.srprole_tbl_type;
237: ddindx binary_integer; indx binary_integer;
238: begin
239:
240: -- copy data to the local IN or IN-OUT args, if any

Line 245: cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);

241:
242:
243:
244:
245: cn_sfp_group_util_pvt_w.rosetta_table_copy_in_p4(ddp_selected_groups, p_selected_groups);
246:
247:
248: ddp_effective_date := rosetta_g_miss_date_in_map(p_effective_date);
249:

Line 255: cn_sfp_group_util_pvt.get_salesrep_roles(p_api_version,

251:
252:
253:
254: -- here's the delegated call to the old PL/SQL routine
255: cn_sfp_group_util_pvt.get_salesrep_roles(p_api_version,
256: p_init_msg_list,
257: p_commit,
258: p_validation_level,
259: ddp_selected_groups,

Line 275: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p1(ddx_salesrep_roles, p7_a0

271:
272:
273:
274:
275: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p1(ddx_salesrep_roles, p7_a0
276: , p7_a1
277: , p7_a2
278: );
279:

Line 305: ddx_updview_organization cn_sfp_group_util_pvt.grporg_tbl_type;

301: )
302:
303: as
304: ddp_effective_date date;
305: ddx_updview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
306: ddx_upd_organization cn_sfp_group_util_pvt.grporg_tbl_type;
307: ddx_view_organization cn_sfp_group_util_pvt.grporg_tbl_type;
308: ddx_noview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
309: ddindx binary_integer; indx binary_integer;

Line 306: ddx_upd_organization cn_sfp_group_util_pvt.grporg_tbl_type;

302:
303: as
304: ddp_effective_date date;
305: ddx_updview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
306: ddx_upd_organization cn_sfp_group_util_pvt.grporg_tbl_type;
307: ddx_view_organization cn_sfp_group_util_pvt.grporg_tbl_type;
308: ddx_noview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin

Line 307: ddx_view_organization cn_sfp_group_util_pvt.grporg_tbl_type;

303: as
304: ddp_effective_date date;
305: ddx_updview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
306: ddx_upd_organization cn_sfp_group_util_pvt.grporg_tbl_type;
307: ddx_view_organization cn_sfp_group_util_pvt.grporg_tbl_type;
308: ddx_noview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:

Line 308: ddx_noview_organization cn_sfp_group_util_pvt.grporg_tbl_type;

304: ddp_effective_date date;
305: ddx_updview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
306: ddx_upd_organization cn_sfp_group_util_pvt.grporg_tbl_type;
307: ddx_view_organization cn_sfp_group_util_pvt.grporg_tbl_type;
308: ddx_noview_organization cn_sfp_group_util_pvt.grporg_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:
312: -- copy data to the local IN or IN-OUT args, if any

Line 328: cn_sfp_group_util_pvt.get_grp_organization_access(p_api_version,

324:
325:
326:
327: -- here's the delegated call to the old PL/SQL routine
328: cn_sfp_group_util_pvt.get_grp_organization_access(p_api_version,
329: p_init_msg_list,
330: p_commit,
331: p_validation_level,
332: p_comp_group_id,

Line 349: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_updview_organization, p6_a0

345:
346:
347:
348:
349: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_updview_organization, p6_a0
350: , p6_a1
351: );
352:
353: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_upd_organization, p7_a0

Line 353: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_upd_organization, p7_a0

349: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_updview_organization, p6_a0
350: , p6_a1
351: );
352:
353: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_upd_organization, p7_a0
354: , p7_a1
355: );
356:
357: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_view_organization, p8_a0

Line 357: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_view_organization, p8_a0

353: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_upd_organization, p7_a0
354: , p7_a1
355: );
356:
357: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_view_organization, p8_a0
358: , p8_a1
359: );
360:
361: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_noview_organization, p9_a0

Line 361: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_noview_organization, p9_a0

357: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_view_organization, p8_a0
358: , p8_a1
359: );
360:
361: cn_sfp_group_util_pvt_w.rosetta_table_copy_out_p3(ddx_noview_organization, p9_a0
362: , p9_a1
363: );
364:
365:

Line 369: end cn_sfp_group_util_pvt_w;

365:
366:
367: end;
368:
369: end cn_sfp_group_util_pvt_w;