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.WF_LOCAL_SYNCH dependencies on WF_DIRECTORY_PARTITIONS

Line 629: -- p_stage_table came from table wf_directory_partitions

625: --Open the Stage Cursor
626: l_stageCursor := DBMS_SQL.open_cursor;
627:
628: --Select one row to get the description.
629: -- p_stage_table came from table wf_directory_partitions
630: -- also l_sql is not to be run, but to get the columns
631: -- BINDVAR_SCAN_IGNORE
632: l_sql := 'select * from '||p_stage_table||' where rownum < 2';
633: DBMS_SQL.parse(c=>l_stageCursor, statement=>l_sql,

Line 649: -- p_seed_view came from table wf_directory_partitions

645: --Open the Seed Cursor
646: l_seedCursor := DBMS_SQL.open_cursor;
647:
648: --Select one row to get the description.
649: -- p_seed_view came from table wf_directory_partitions
650: -- also l_sql is not to be run, but to get the columns
651: -- BINDVAR_SCAN_IGNORE
652: l_sql := 'select * from '||p_seed_view||' where rownum < 2';
653: DBMS_SQL.parse(c=>l_seedCursor, statement=>l_sql,

Line 665: from WF_DIRECTORY_PARTITIONS

661:
662: --Retrieve the partition id.
663: select PARTITION_ID, ORIG_SYSTEM
664: into l_partitionID, l_partitionName
665: from WF_DIRECTORY_PARTITIONS
666: where ORIG_SYSTEM = upper(p_orig_system);
667:
668: --We now have two description tables that we can compare and build our
669: --column and select lists. We will also apply the special rules in this api

Line 2133: -- p_roletlview came from wf_directory_partitions

2129: p_columnList=>l_columnList,
2130: p_selectList=>l_selectList)) then
2131: -- l_selectList is controlled by us
2132: -- g_parallel must not be varchar
2133: -- p_roletlview came from wf_directory_partitions
2134: -- BINDVAR_SCAN_IGNORE[4]
2135: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2136: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_TL_STAGE T ('||
2137: l_columnList||') select /*+ parallel(R, '||

Line 2266: FROM wf_directory_partitions

2262:
2263: --Retrieve the role and the user/role view names to be used.
2264: SELECT trim(role_view) , trim(role_tl_view)
2265: INTO l_roleView ,l_role_tl_view
2266: FROM wf_directory_partitions
2267: WHERE partition_id = l_partitionID;
2268: --Enable parallel DML
2269: execute IMMEDIATE 'alter session enable parallel dml';
2270:

Line 2287: -- l_partitionName came from wf_directory_partitions

2283: p_selectList=>l_selectList)) then
2284: -- g_parallel must not be varchar2
2285: -- wf_schema came from wf_resources
2286: -- l_selectList is controlled by us
2287: -- l_partitionName came from wf_directory_partitions
2288: -- BINDVAR_SCAN_IGNORE[5]
2289: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2290: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_STAGE T '||
2291: '('||l_columnList||') select /*+ parallel(R, '||

Line 2331: -- l_partitionName came from wf_directory_partitions

2327: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2328: 'in exclusive mode';
2329: --Partition exchange the temp table into the wf_local_roles table.
2330: -- wf_schema came from wf_resources
2331: -- l_partitionName came from wf_directory_partitions
2332: -- BINDVAR_SCAN_IGNORE[4]
2333: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2334: 'EXCHANGE PARTITION ' || l_partitionName ||
2335: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||

Line 2433: FROM wf_directory_partitions

2429:
2430: --Retrieve the role and the user/role view names to be used.
2431: SELECT trim(user_role_view)
2432: INTO l_userRoleView
2433: FROM wf_directory_partitions
2434: WHERE partition_id = l_partitionID;
2435:
2436: --Enable parallel DML
2437: execute IMMEDIATE 'alter session enable parallel dml';

Line 2455: -- l_userRoleView came from wf_directory_partitions

2451: -- g_parallel must be number
2452: -- wf_schema came from wf_resources
2453: -- l_columnList came from DBMS_SQL.describe_columns()
2454: -- l_selectList controlled by us
2455: -- l_userRoleView came from wf_directory_partitions
2456: -- l_partitionName came from wf_directory_partitions
2457: -- BINDVAR_SCAN_IGNORE[5]
2458: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2459: ') */ into '||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE T '||

Line 2456: -- l_partitionName came from wf_directory_partitions

2452: -- wf_schema came from wf_resources
2453: -- l_columnList came from DBMS_SQL.describe_columns()
2454: -- l_selectList controlled by us
2455: -- l_userRoleView came from wf_directory_partitions
2456: -- l_partitionName came from wf_directory_partitions
2457: -- BINDVAR_SCAN_IGNORE[5]
2458: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2459: ') */ into '||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE T '||
2460: '( '||l_columnList||' ) select /*+ parallel(R, '||

Line 2554: -- l_partitionName came from wf_directory_partitions

2550: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2551: 'in exclusive mode';
2552: --Partition exchange the temp table into the wf_local_user_roles table.
2553: -- wf_schema came from wf_resources
2554: -- l_partitionName came from wf_directory_partitions
2555: -- BINDVAR_SCAN_IGNORE[4]
2556: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2557: 'EXCHANGE PARTITION ' || l_partitionName ||
2558: ' WITH TABLE ' ||wf_schema||