DBA Data[Home] [Help]

APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_DEFAULT_GROUPS_STAGE_S

Line 209: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,

205: (default_groups_id, resource_id, user_id, resource_number,
206: group_id, role_type_code, role_id, role_type_priority,
207: role_priority, start_date, end_date, denorm_count, usage,
208: created_by, creation_date, last_updated_by, last_update_date )
209: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,
210: x.resource_id, x.user_id, x.resource_number,
211: x.group_id,
212: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
213: x.start_date, x.end_date, x.denorm_count, 'FLD_SRV_DISTRICT' usage,

Line 280: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,

276: (default_groups_id, resource_id, user_id, resource_number,
277: group_id, role_type_code, role_id, role_type_priority,
278: role_priority, start_date, end_date, denorm_count, usage,
279: created_by, creation_date, last_updated_by, last_update_date )
280: SELECT JTF_RS_DEFAULT_GROUPS_STAGE_s.NEXTVAL default_groups_id,
281: x.resource_id, x.user_id, x.resource_number,
282: x.group_id,
283: x.role_type_code, x.role_id, x.role_type_priority, x.role_priority,
284: x.start_date, x.end_date, x.denorm_count, 'FLD_SRV_DISTRICT' usage,

Line 557: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_STAGE sg1

553: o := g_default_grp_tab.FIRST ;
554:
555: WHILE o IS NOT NULL
556: LOOP
557: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_STAGE sg1
558: (default_groups_id, resource_id, user_id, resource_number,
559: group_id, start_date, end_date, usage,
560: created_by, creation_date, last_updated_by, last_update_date )
561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,

Line 561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,

557: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_STAGE sg1
558: (default_groups_id, resource_id, user_id, resource_number,
559: group_id, start_date, end_date, usage,
560: created_by, creation_date, last_updated_by, last_update_date )
561: VALUES (JTF_RS_DEFAULT_GROUPS_STAGE_S.NEXTVAL, g_default_grp_tab(o).p_resource_id,
562: g_default_grp_tab(o).p_user_id, g_default_grp_tab(o).p_resource_number,
563: g_default_grp_tab(o).p_group_id, g_default_grp_tab(o).p_start_date,
564: g_default_grp_tab(o).p_end_date, l_usage,
565: l_user_id, sysdate, l_user_id, sysdate);