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:
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:
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;
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:
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:
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
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
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
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:
365:
366:
367: end;
368:
369: end cn_sfp_group_util_pvt_w;