APPS.WF_LOCAL_SYNCH dependencies on WF_DDL

Line 2152: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',

2148: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2149: ', '||p_partitionName||', '||p_roleTLView||')');
2150:
2151: --Truncate the temp table.
2152: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2153: Owner=>wf_schema);
2154:
2155: --Drop indexes from the temp table.
2156: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop

Line 2159: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,

2155: --Drop indexes from the temp table.
2156: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop
2157: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2158: 'Dropping index '||c.INDEX_NAME);
2159: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2160: Owner=>wf_schema,
2161: IgnoreNotFound=>TRUE);
2162:
2163: end loop;

Line 2292: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',

2288: syncRoles('PER_ROLE');
2289: end if;
2290:
2291: --Truncate the temp table.
2292: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2293: Owner=>wf_schema);
2294:
2295: --Drop indexes from the temp table.
2296: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop

Line 2299: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,

2295: --Drop indexes from the temp table.
2296: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop
2297: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2298: 'Dropping index '||c.INDEX_NAME);
2299: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2300: Owner=>wf_schema,
2301: IgnoreNotFound=>TRUE);
2302:
2303: end loop;

Line 2458: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',

2454: l_storageClause||' ';
2455: end if;
2456:
2457: --Truncate the temp table.
2458: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2459: Owner=>wf_schema);
2460:
2461: --Drop indexes from the temp table.
2462: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop

Line 2465: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,

2461: --Drop indexes from the temp table.
2462: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop
2463: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2464: 'Dropping index '||c.INDEX_NAME);
2465: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2466: Owner=>wf_schema,
2467: IgnoreNotFound=>TRUE);
2468:
2469: end loop;

Line 2472: WF_DDL.TruncateTable(TableName=>'WF_UR_ASSIGNMENTS_STAGE',

2468:
2469: end loop;
2470:
2471: --Truncate the temp table.
2472: WF_DDL.TruncateTable(TableName=>'WF_UR_ASSIGNMENTS_STAGE',
2473: Owner=>wf_schema);
2474:
2475: --Drop indexes from the temp table.
2476: for c in dbaIndexes('WF_UR_ASSIGNMENTS_STAGE', wf_schema) loop

Line 2479: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,

2475: --Drop indexes from the temp table.
2476: for c in dbaIndexes('WF_UR_ASSIGNMENTS_STAGE', wf_schema) loop
2477: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2478: 'Dropping index '||c.INDEX_NAME);
2479: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2480: Owner=>wf_schema,
2481: IgnoreNotFound=>TRUE);
2482:
2483: end loop;