[Home] [Help]
201: (srp_groups_id, resource_id, salesrep_id, org_id, user_id,
202: group_id, role_type_code, role_id, role_type_priority,
203: role_priority, start_date, end_date, denorm_count,
204: created_by, creation_date, last_updated_by, last_update_date )
205: SELECT jtf_rs_srp_groups_stage_s.NEXTVAL srp_groups_id,
206: x.resource_id, x.salesrep_id, x.org_id, x.user_id,
207: x.group_id,
208: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
209: x.start_date, x.end_date, x.denorm_count,
266: (srp_groups_id, resource_id, salesrep_id, org_id, user_id,
267: group_id, role_type_code, role_id, role_type_priority,
268: role_priority, start_date, end_date, denorm_count,
269: created_by, creation_date, last_updated_by, last_update_date )
270: SELECT jtf_rs_srp_groups_stage_s.NEXTVAL srp_groups_id,
271: x.resource_id, x.salesrep_id, x.org_id, x.user_id,
272: x.group_id,
273: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
274: x.start_date, x.end_date, x.denorm_count,
543: o := g_srp_grp_tab.FIRST ;
544:
545: WHILE o IS NOT NULL
546: LOOP
547: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ jtf_rs_srp_groups_stage sg1
548: (srp_groups_id, resource_id, salesrep_id, org_id, user_id,
549: group_id, start_date, end_date,
550: created_by, creation_date, last_updated_by, last_update_date )
551: VALUES (jtf_rs_srp_groups_stage_s.NEXTVAL, g_srp_grp_tab(o).p_resource_id,
547: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ jtf_rs_srp_groups_stage sg1
548: (srp_groups_id, resource_id, salesrep_id, org_id, user_id,
549: group_id, start_date, end_date,
550: created_by, creation_date, last_updated_by, last_update_date )
551: VALUES (jtf_rs_srp_groups_stage_s.NEXTVAL, g_srp_grp_tab(o).p_resource_id,
552: g_srp_grp_tab(o).p_salesrep_id, g_srp_grp_tab(o).p_org_id,
553: g_srp_grp_tab(o).p_user_id, g_srp_grp_tab(o).p_group_id,
554: g_srp_grp_tab(o).p_start_date, g_srp_grp_tab(o).p_end_date,
555: l_user_id, sysdate, l_user_id, sysdate);