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_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_DEFAULT_GROUPS_INT

Line 5: This is a concurrent program to populate the data in JTF_RS_DEFAULT_GROUPS_INT,

1: PACKAGE BODY jtf_rs_default_groups_conc_pub AS
2: /* $Header: jtfrsbcb.pls 120.0 2005/05/11 08:19:15 appldev noship $ */
3:
4: /****************************************************************************
5: This is a concurrent program to populate the data in JTF_RS_DEFAULT_GROUPS_INT,
6: JTF_RS_DEFAULT_GROUPS_STAGE and JTF_RS_DEFAULT_GROUPS. This program will create
7: primary groups for resources based on usage and rules (specified by product
8: teams) for date date range from 01/01/1900 to 12/31/4712. For a specific date
9: there will be only one primary group for a resource in JTF_RS_DEFAULT_GROUPS.

Line 85: FROM JTF_RS_DEFAULT_GROUPS_INT

81: l_jtft varchar2(240);
82:
83: CURSOR c_outer IS
84: SELECT DISTINCT resource_id
85: FROM JTF_RS_DEFAULT_GROUPS_INT
86: ;
87:
88: CURSOR c1 (ll_resource_id NUMBER)IS
89: SELECT resource_id, user_id, resource_number, group_id, start_date, end_date

Line 90: FROM JTF_RS_DEFAULT_GROUPS_INT

86: ;
87:
88: CURSOR c1 (ll_resource_id NUMBER)IS
89: SELECT resource_id, user_id, resource_number, group_id, start_date, end_date
90: FROM JTF_RS_DEFAULT_GROUPS_INT
91: WHERE resource_id = ll_resource_id
92: AND start_date <= end_date
93: ORDER BY denorm_count ASC, role_type_priority ASC, role_priority ASC, START_DATE desc;
94:

Line 170: WHERE TABLE_NAME = 'JTF_RS_DEFAULT_GROUPS_INT'

166: BEGIN
167: SELECT owner, table_owner, tablespace_name
168: INTO l_index_owner, l_table_owner, l_index_tblspace
169: FROM ALL_INDEXES
170: WHERE TABLE_NAME = 'JTF_RS_DEFAULT_GROUPS_INT'
171: AND index_name = 'JTF_RS_DEFAULT_GROUPS_INT_N1'
172: AND table_owner= l_jtfu;
173:
174: l_index_exists := 'Y' ;

Line 171: AND index_name = 'JTF_RS_DEFAULT_GROUPS_INT_N1'

167: SELECT owner, table_owner, tablespace_name
168: INTO l_index_owner, l_table_owner, l_index_tblspace
169: FROM ALL_INDEXES
170: WHERE TABLE_NAME = 'JTF_RS_DEFAULT_GROUPS_INT'
171: AND index_name = 'JTF_RS_DEFAULT_GROUPS_INT_N1'
172: AND table_owner= l_jtfu;
173:
174: l_index_exists := 'Y' ;
175:

Line 191: l_stage := 'Stage=DROP_INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';

187: END;
188:
189:
190: --------- Drop Index before inserting into intermediate table ----------
191: l_stage := 'Stage=DROP_INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';
192:
193: IF (l_index_exists = 'Y') THEN
194: EXECUTE IMMEDIATE 'DROP INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';
195: END IF;

Line 194: EXECUTE IMMEDIATE 'DROP INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';

190: --------- Drop Index before inserting into intermediate table ----------
191: l_stage := 'Stage=DROP_INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';
192:
193: IF (l_index_exists = 'Y') THEN
194: EXECUTE IMMEDIATE 'DROP INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';
195: END IF;
196:
197: -------------Insert into intermediate table ---------
198: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT';

Line 198: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT';

194: EXECUTE IMMEDIATE 'DROP INDEX '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT_N1';
195: END IF;
196:
197: -------------Insert into intermediate table ---------
198: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT';
199:
200: COMMIT;
201:
202: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE';

Line 202: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE';

198: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.JTF_RS_DEFAULT_GROUPS_INT';
199:
200: COMMIT;
201:
202: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE';
203:
204: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_int sg1
205: (default_groups_id, resource_id, user_id, resource_number,
206: group_id, role_type_code, role_id, role_type_priority,

Line 204: INSERT INTO /+ APPEND PARALLEL(sg1) NOLOGGING / JTF_RS_DEFAULT_GROUPS_int sg1

200: COMMIT;
201:
202: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE';
203:
204: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_int sg1
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 )

Line 273: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE_FOR_UNASSIGNED_GROUPS';

269: /* Insert all the rest of the Field Service Resources who do not have any group
270: assign to them along with those who have groups assigned for limited time
271: */
272:
273: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE_FOR_UNASSIGNED_GROUPS';
274:
275: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_INT sg1
276: (default_groups_id, resource_id, user_id, resource_number,
277: group_id, role_type_code, role_id, role_type_priority,

Line 275: INSERT INTO /+ APPEND PARALLEL(sg1) NOLOGGING / JTF_RS_DEFAULT_GROUPS_INT sg1

271: */
272:
273: l_stage := 'Stage=INSERT_IN_JTF_RS_DEFAULT_GROUPS_INT_TABLE_FOR_UNASSIGNED_GROUPS';
274:
275: INSERT INTO /*+ APPEND PARALLEL(sg1) NOLOGGING */ JTF_RS_DEFAULT_GROUPS_INT sg1
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 )

Line 317: l_stage := 'Stage=CREATE_INDEX_ON_JTF_RS_DEFAULT_GROUPS_INT_TABLE';

313:
314:
315: -------------Create index and Analyze table on Intermediate table -------
316:
317: l_stage := 'Stage=CREATE_INDEX_ON_JTF_RS_DEFAULT_GROUPS_INT_TABLE';
318:
319: EXECUTE IMMEDIATE 'CREATE INDEX '||l_index_owner
320: ||'.JTF_RS_DEFAULT_GROUPS_INT_N1 ON '
321: ||l_table_owner||'.JTF_RS_DEFAULT_GROUPS_INT '

Line 320: ||'.JTF_RS_DEFAULT_GROUPS_INT_N1 ON '

316:
317: l_stage := 'Stage=CREATE_INDEX_ON_JTF_RS_DEFAULT_GROUPS_INT_TABLE';
318:
319: EXECUTE IMMEDIATE 'CREATE INDEX '||l_index_owner
320: ||'.JTF_RS_DEFAULT_GROUPS_INT_N1 ON '
321: ||l_table_owner||'.JTF_RS_DEFAULT_GROUPS_INT '
322: ||' (resource_id, denorm_count, role_type_priority, role_priority, start_date desc) '
323: ||' TABLESPACE '||l_index_tblspace
324: ||' NOLOGGING PARALLEL (DEGREE '||f_get_degree_of_parallelism||' ) ';

Line 321: ||l_table_owner||'.JTF_RS_DEFAULT_GROUPS_INT '

317: l_stage := 'Stage=CREATE_INDEX_ON_JTF_RS_DEFAULT_GROUPS_INT_TABLE';
318:
319: EXECUTE IMMEDIATE 'CREATE INDEX '||l_index_owner
320: ||'.JTF_RS_DEFAULT_GROUPS_INT_N1 ON '
321: ||l_table_owner||'.JTF_RS_DEFAULT_GROUPS_INT '
322: ||' (resource_id, denorm_count, role_type_priority, role_priority, start_date desc) '
323: ||' TABLESPACE '||l_index_tblspace
324: ||' NOLOGGING PARALLEL (DEGREE '||f_get_degree_of_parallelism||' ) ';
325:

Line 327: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_INT',

323: ||' TABLESPACE '||l_index_tblspace
324: ||' NOLOGGING PARALLEL (DEGREE '||f_get_degree_of_parallelism||' ) ';
325:
326:
327: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_INT',
328: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
329:
330: -------------Truncate the Staging table ---------
331: