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.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_DBI_DENORM_RES_GROUPS

Line 6: and JTF_RS_DBI_DENORM_RES_GROUPS

2: /* $Header: jtfrsdbb.pls 120.2 2011/08/15 22:07:41 nsinghai noship $ */
3:
4: /****************************************************************************
5: This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS
6: and JTF_RS_DBI_DENORM_RES_GROUPS
7: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales
8: Group Hierarchy in DBI product. This program is exclusively built for DBI
9: product and is NOT included in mainline code of ATG Resource Manager.
10:

Line 116: and JTF_RS_DBI_DENORM_RES_GROUPS table so that it can be accessed via view

112: END populate_fld_srv_district;
113:
114: /****************************************************************************
115: This is main procedure to populate the data in JTF_RS_DBI_MGR_GROUPS
116: and JTF_RS_DBI_DENORM_RES_GROUPS table so that it can be accessed via view
117: JTF_RS_DBI_RES_GRP_VL for usage 'SALES' (Sales Group Hierarchy) and
118: 'FLD_SRV_DISTRICT' (Field Service District Hierarchy) in DBI product.
119:
120: This program is exclusively built for DBI product and is NOT included in

Line 203: WHERE TABLE_NAME = 'JTF_RS_DBI_DENORM_RES_GROUPS'

199: BEGIN
200: SELECT owner, table_owner, tablespace_name
201: INTO l_index_owner, l_table_owner, l_index_tblspace
202: FROM ALL_INDEXES
203: WHERE TABLE_NAME = 'JTF_RS_DBI_DENORM_RES_GROUPS'
204: AND index_name = 'JTF_RS_DBI_DENORM_RES_GRPS_N1'
205: AND table_owner= l_jtfu;
206:
207: l_index_exists := 'Y' ;

Line 242: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS TRUNCATE PARTITION '||l_partition;

238: ||': Partition= '||l_partition);
239:
240: -- Truncate Table Partitions
241: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS TRUNCATE PARTITION '||l_partition ;
242: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS TRUNCATE PARTITION '||l_partition;
243:
244: -- Make indexes unusable
245: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
246: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';

Line 246: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';

242: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS TRUNCATE PARTITION '||l_partition;
243:
244: -- Make indexes unusable
245: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
246: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
247:
248: -- change session parameter so that data can be inserted in partition containing unusable index
249: EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE ' ;
250:

Line 265: INTO /+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING / jtf_rs_dbi_denorm_res_groups

261: ,last_update_date, last_updated_by, usage )
262: VALUES (jtf_rs_dbi_mgr_groups_s.nextval, resource_id, user_id, group_id
263: , l_sysdate, l_user_id
264: , l_sysdate, l_user_id, usage)
265: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
266: (VALUE, id , current_id ,
267: parent_id , denorm_level ,
268: start_date , end_date ,
269: user_id ,

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

275: VALUES (' * ', group_id, TO_NUMBER(-9999),
276: group_id, TO_NUMBER(0),
277: start_date_active, end_date_active,
278: user_id, resource_id,
279: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',
280: 'A', l_sysdate, l_user_id ,'Y'
281: , l_sysdate, l_user_id, usage)
282: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
283: (VALUE,

Line 282: INTO /+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING / jtf_rs_dbi_denorm_res_groups

278: user_id, resource_id,
279: 'Z-TOP-MANAGER-GROUPS', jtf_rs_dbi_denorm_res_groups_s.NEXTVAL, 'N',
280: 'A', l_sysdate, l_user_id ,'Y'
281: , l_sysdate, l_user_id, usage)
282: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
283: (VALUE,
284: id ,
285: current_id ,
286: parent_id ,

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

299: ,last_update_date, last_updated_by, usage )
300: VALUES ( ' ', group_id , TO_NUMBER(-1111) , group_id ,
301: TO_NUMBER(0) , start_date_active , end_date_active ,
302: user_id , resource_id ,
303: '0-FIRST-TIME-PARENT-GROUPS' , jtf_rs_dbi_denorm_res_groups_s.nextval
304: ,'N' , 'A' ,l_sysdate, l_user_id, 'Y'
305: , l_sysdate, l_user_id, usage)
306: SELECT /*+ use_hash(g x usg) parallel(g) parallel(x) parallel(usg)*/
307: x.resource_id, x.user_id, x.group_id

Line 339: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

335: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
336: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'ALL',cascade=>TRUE);
337:
338: -- first time login child groups
339: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
340: (VALUE,
341: id ,
342: current_id ,
343: parent_id ,

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

361: , d1.group_id id,
362: TO_NUMBER(-1111) current_id, d1.actual_parent_id parent_id,
363: d1.denorm_level , d1.start_date_active start_date,
364: d1.end_date_active end_date, n1.user_id ,n1.resource_id ,
365: '0-FIRST-TIME-CHILD-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
366: ,'N' mem_flag , 'A' mem_status
367: ,l_sysdate, l_user_id
368: ,DECODE(d1.active_flag,'Y','Y','N')
369: ,l_sysdate, l_user_id, usg.usage

Line 385: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

381:
382: COMMIT;
383:
384: --parent
385: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
386: (VALUE,
387: id ,
388: current_id ,
389: parent_id ,

Line 411: jtf_rs_dbi_denorm_res_groups_s.nextval

407: , d1.group_id id, d2.group_id current_id,
408: d1.actual_parent_id parent_id, d1.denorm_level,
409: d1.start_date_active start_date, d1.end_date_active end_date,
410: n1.user_id, n1.resource_id, 'A-PARENT' debug_column,
411: jtf_rs_dbi_denorm_res_groups_s.nextval
412: ,'N' mem_flag , 'A' mem_status
413: ,l_sysdate, l_user_id
414: ,DECODE(d1.active_flag,'Y','Y','N')
415: ,l_sysdate, l_user_id, usg.usage

Line 435: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

431:
432: COMMIT;
433:
434: --self
435: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
436: (VALUE,
437: id ,
438: current_id ,
439: parent_id ,

Line 461: jtf_rs_dbi_denorm_res_groups_s.nextval

457: , d1.group_id id, d1.group_id current_id,
458: d1.actual_parent_id parent_id, d1.denorm_level,
459: d1.start_date_active start_date, d1.end_date_active end_date,
460: n1.user_id, n1.resource_id, 'C-SELF' debug_column,
461: jtf_rs_dbi_denorm_res_groups_s.nextval
462: ,'N' mem_flag , 'A' mem_status
463: ,l_sysdate, l_user_id
464: ,DECODE(d1.active_flag,'Y','Y','N')
465: ,l_sysdate, l_user_id, usg.usage

Line 480: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

476:
477: COMMIT;
478:
479: --child
480: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
481: (VALUE,
482: id ,
483: current_id ,
484: parent_id ,

Line 506: , jtf_rs_dbi_denorm_res_groups_s.nextval

502: ,d1.group_id id,
503: d1.actual_parent_id current_id, d1.actual_parent_id parent_id,
504: d1.denorm_level, d1.start_date_active start_date,
505: d1.end_date_active end_date, n1.user_id, n1.resource_id, 'D-CHILD' debug_column
506: , jtf_rs_dbi_denorm_res_groups_s.nextval
507: ,'N' mem_flag , 'A' mem_status
508: ,l_sysdate, l_user_id
509: ,DECODE(d1.active_flag,'Y','Y','N')
510: ,l_sysdate, l_user_id, usg.usage

Line 535: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

531: -- since they are not for specific user.
532: -- modified for ER 3263259 on 11/18/2003 - to just show the persons with member roles
533: -- on 01/16/2004, above ER is reverted. Now manager and member roles will be displayed
534: -- admin roles will be excluded.
535: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
536: (VALUE,
537: id_for_grp_mem ,
538: current_id ,
539: parent_id ,

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

551: usage )
552: SELECT Decode(x.mem_status,'I','----[ ','----')value,
553: x.resource_id||'.'||x.group_id id_for_grp_mem, x.group_id current_id,
554: x.group_id parent_id, to_number(100) denorm_level,
555: 'E-SELF-GROUP-MEMBERS' debug_column , jtf_rs_dbi_denorm_res_groups_s.NEXTVAL denorm_id
556: ,x.resource_id grp_mem_resource_id, 'Y' mem_flag, x.mem_status
557: ,l_sysdate, l_user_id
558: ,'Y' active_grp_rel_only
559: ,l_sysdate, l_user_id, x.usage

Line 620: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

616:
617: COMMIT;
618:
619: -- Member Login for DBI 7.1. new insert stmt created by nsinghai on 8-Oct-2004
620: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
621: (VALUE,id, id_for_grp_mem , current_id , parent_id , denorm_level ,
622: START_DATE, end_date, resource_id, user_id, grp_mem_resource_id,
623: debug_column, denorm_id, mem_flag, mem_status, creation_date, created_by,
624: active_grp_rel_only, last_update_date, last_updated_by, usage )

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

624: active_grp_rel_only, last_update_date, last_updated_by, usage )
625: SELECT ' * ' VALUE, group_id id, resource_id||'.'||group_id id_for_grp_mem,
626: TO_NUMBER(-7777) current_id, group_id parent_id, TO_NUMBER(0) denorm_level,
627: START_DATE , end_date, resource_id, user_id, resource_id grp_mem_resource_id,
628: '1-GROUP-MEMBER-LOGIN' debug_column ,jtf_rs_dbi_denorm_res_groups_s.NEXTVAL,
629: 'N' mem_flag , 'A' mem_status ,l_sysdate, l_user_id, 'Y' active_grp_rel_only
630: ,l_sysdate, l_user_id, usage
631: FROM (
632: SELECT /*+ use_hash(gm rrl rol res usg) parallel(gm) parallel(rrl) parallel(rol) parallel(res) parallel(usg)*/

Line 665: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||

661: l_insert_count := l_insert_count + SQL%ROWCOUNT ;
662:
663: COMMIT;
664:
665: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||
666: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
667:
668: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
669: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);

Line 668: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',

664:
665: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||
666: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
667:
668: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
669: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
670:
671: BIS_COLLECTION_UTILITIES.wrapup(
672: p_status => TRUE ,