APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_DBI_DENORM_RES_GROUPS_S

Line 272: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',

268: VALUES (' * ', group_id, TO_NUMBER(-9999),
269: group_id, TO_NUMBER(0),
270: start_date_active, end_date_active,
271: user_id, resource_id,
272: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',
273: 'A', l_sysdate, l_user_id ,'Y'
274: , l_sysdate, l_user_id, usage)
275: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
276: (VALUE,

Line 296: '0-FIRST-TIME-PARENT-GROUPS' , jtf_rs_dbi_denorm_res_groups_s.nextval

292: ,last_update_date, last_updated_by, usage )
293: VALUES ( ' ', group_id , TO_NUMBER(-1111) , group_id ,
294: TO_NUMBER(0) , start_date_active , end_date_active ,
295: user_id , resource_id ,
296: '0-FIRST-TIME-PARENT-GROUPS' , jtf_rs_dbi_denorm_res_groups_s.nextval
297: ,'N' , 'A' ,l_sysdate, l_user_id, 'Y'
298: , l_sysdate, l_user_id, usage)
299: SELECT /*+ use_hash(g x usg) parallel(g) parallel(x) parallel(usg)*/
300: x.resource_id, x.user_id, x.group_id

Line 358: '0-FIRST-TIME-CHILD-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval

354: , d1.group_id id,
355: TO_NUMBER(-1111) current_id, d1.actual_parent_id parent_id,
356: d1.denorm_level , d1.start_date_active start_date,
357: d1.end_date_active end_date, n1.user_id ,n1.resource_id ,
358: '0-FIRST-TIME-CHILD-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
359: ,'N' mem_flag , 'A' mem_status
360: ,l_sysdate, l_user_id
361: ,DECODE(d1.active_flag,'Y','Y','N')
362: ,l_sysdate, l_user_id, usg.usage

Line 404: jtf_rs_dbi_denorm_res_groups_s.nextval

400: , d1.group_id id, d2.group_id current_id,
401: d1.actual_parent_id parent_id, d1.denorm_level,
402: d1.start_date_active start_date, d1.end_date_active end_date,
403: n1.user_id, n1.resource_id, 'A-PARENT' debug_column,
404: jtf_rs_dbi_denorm_res_groups_s.nextval
405: ,'N' mem_flag , 'A' mem_status
406: ,l_sysdate, l_user_id
407: ,DECODE(d1.active_flag,'Y','Y','N')
408: ,l_sysdate, l_user_id, usg.usage

Line 454: jtf_rs_dbi_denorm_res_groups_s.nextval

450: , d1.group_id id, d1.group_id current_id,
451: d1.actual_parent_id parent_id, d1.denorm_level,
452: d1.start_date_active start_date, d1.end_date_active end_date,
453: n1.user_id, n1.resource_id, 'C-SELF' debug_column,
454: jtf_rs_dbi_denorm_res_groups_s.nextval
455: ,'N' mem_flag , 'A' mem_status
456: ,l_sysdate, l_user_id
457: ,DECODE(d1.active_flag,'Y','Y','N')
458: ,l_sysdate, l_user_id, usg.usage

Line 499: , jtf_rs_dbi_denorm_res_groups_s.nextval

495: ,d1.group_id id,
496: d1.actual_parent_id current_id, d1.actual_parent_id parent_id,
497: d1.denorm_level, d1.start_date_active start_date,
498: d1.end_date_active end_date, n1.user_id, n1.resource_id, 'D-CHILD' debug_column
499: , jtf_rs_dbi_denorm_res_groups_s.nextval
500: ,'N' mem_flag , 'A' mem_status
501: ,l_sysdate, l_user_id
502: ,DECODE(d1.active_flag,'Y','Y','N')
503: ,l_sysdate, l_user_id, usg.usage

Line 548: 'E-SELF-GROUP-MEMBERS' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id

544: usage )
545: SELECT Decode(x.mem_status,'I','----[ ','----')value,
546: x.resource_id||'.'||x.group_id id_for_grp_mem, x.group_id current_id,
547: x.group_id parent_id, to_number(100) denorm_level,
548: 'E-SELF-GROUP-MEMBERS' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id
549: ,x.resource_id grp_mem_resource_id, 'Y' mem_flag, x.mem_status
550: ,l_sysdate, l_user_id
551: ,'Y' active_grp_rel_only
552: ,l_sysdate, l_user_id, x.usage

Line 621: '1-GROUP-MEMBER-LOGIN' debug_column ,jtf_rs_dbi_denorm_res_groups_s.NEXTVAL,

617: active_grp_rel_only, last_update_date, last_updated_by, usage )
618: SELECT ' * ' VALUE, group_id id, resource_id||'.'||group_id id_for_grp_mem,
619: TO_NUMBER(-7777) current_id, group_id parent_id, TO_NUMBER(0) denorm_level,
620: START_DATE , end_date, resource_id, user_id, resource_id grp_mem_resource_id,
621: '1-GROUP-MEMBER-LOGIN' debug_column ,jtf_rs_dbi_denorm_res_groups_s.NEXTVAL,
622: 'N' mem_flag , 'A' mem_status ,l_sysdate, l_user_id, 'Y' active_grp_rel_only
623: ,l_sysdate, l_user_id, usage
624: FROM (
625: SELECT /*+ use_hash(gm rrl rol res usg) parallel(gm) parallel(rrl) parallel(rol) parallel(res) parallel(usg)*/