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.0 2005/05/11 08:19:47 appldev 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 114: and JTF_RS_DBI_DENORM_RES_GROUPS table so that it can be accessed via view

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

Line 200: WHERE TABLE_NAME = 'JTF_RS_DBI_DENORM_RES_GROUPS'

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

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

231: ||': Partition= '||l_partition);
232:
233: -- Truncate Table Partitions
234: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS TRUNCATE PARTITION '||l_partition ;
235: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS TRUNCATE PARTITION '||l_partition;
236:
237: -- Make indexes unusable
238: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
239: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';

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

235: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS TRUNCATE PARTITION '||l_partition;
236:
237: -- Make indexes unusable
238: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
239: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS MODIFY PARTITION '||l_partition||' UNUSABLE LOCAL INDEXES ';
240:
241: -- change session parameter so that data can be inserted in partition containing unusable index
242: EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE ' ;
243:

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

254: ,last_update_date, last_updated_by, usage )
255: VALUES (jtf_rs_dbi_mgr_groups_s.nextval, resource_id, user_id, group_id
256: , l_sysdate, l_user_id
257: , l_sysdate, l_user_id, usage)
258: INTO /*+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING */ jtf_rs_dbi_denorm_res_groups
259: (VALUE, id , current_id ,
260: parent_id , denorm_level ,
261: start_date , end_date ,
262: user_id ,

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 275: INTO /+ APPEND PARALLEL(jtf_rs_dbi_denorm_res_groups) NOLOGGING / jtf_rs_dbi_denorm_res_groups

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,
277: id ,
278: current_id ,
279: parent_id ,

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 332: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

328: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
329: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'ALL',cascade=>TRUE);
330:
331: -- first time login child groups
332: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
333: (VALUE,
334: id ,
335: current_id ,
336: parent_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 378: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

374:
375: COMMIT;
376:
377: --parent
378: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
379: (VALUE,
380: id ,
381: current_id ,
382: parent_id ,

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 428: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

424:
425: COMMIT;
426:
427: --self
428: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
429: (VALUE,
430: id ,
431: current_id ,
432: parent_id ,

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 473: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

469:
470: COMMIT;
471:
472: --child
473: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
474: (VALUE,
475: id ,
476: current_id ,
477: parent_id ,

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 528: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

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

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 613: INSERT /+ APPEND PARALLEL(a) NOLOGGING / INTO jtf_rs_dbi_denorm_res_groups a

609:
610: COMMIT;
611:
612: -- Member Login for DBI 7.1. new insert stmt created by nsinghai on 8-Oct-2004
613: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
614: (VALUE,id, id_for_grp_mem , current_id , parent_id , denorm_level ,
615: START_DATE, end_date, resource_id, user_id, grp_mem_resource_id,
616: debug_column, denorm_id, mem_flag, mem_status, creation_date, created_by,
617: active_grp_rel_only, last_update_date, last_updated_by, 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)*/

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

654: l_insert_count := l_insert_count + SQL%ROWCOUNT ;
655:
656: COMMIT;
657:
658: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||
659: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
660:
661: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
662: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);

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

657:
658: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||
659: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
660:
661: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
662: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
663:
664: BIS_COLLECTION_UTILITIES.wrapup(
665: p_status => TRUE ,