APPS.WF_LOCAL_SYNCH dependencies on WF_DDL

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

2098: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2099: ', '||p_partitionName||', '||p_roleTLView||')');
2100:
2101: --Truncate the temp table.
2102: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2103: Owner=>wf_schema);
2104:
2105: --Drop indexes from the temp table.
2106: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop

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

2105: --Drop indexes from the temp table.
2106: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop
2107: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2108: 'Dropping index '||c.INDEX_NAME);
2109: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2110: Owner=>wf_schema,
2111: IgnoreNotFound=>TRUE);
2112:
2113: end loop;

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

2234: syncRoles('PER_ROLE');
2235: end if;
2236:
2237: --Truncate the temp table.
2238: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2239: Owner=>wf_schema);
2240:
2241: --Drop indexes from the temp table.
2242: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop

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

2241: --Drop indexes from the temp table.
2242: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop
2243: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2244: 'Dropping index '||c.INDEX_NAME);
2245: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2246: Owner=>wf_schema,
2247: IgnoreNotFound=>TRUE);
2248:
2249: end loop;

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

2396: l_storageClause||' ';
2397: end if;
2398:
2399: --Truncate the temp table.
2400: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2401: Owner=>wf_schema);
2402:
2403: --Drop indexes from the temp table.
2404: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop

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

2403: --Drop indexes from the temp table.
2404: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop
2405: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2406: 'Dropping index '||c.INDEX_NAME);
2407: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2408: Owner=>wf_schema,
2409: IgnoreNotFound=>TRUE);
2410:
2411: end loop;

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

2410:
2411: end loop;
2412:
2413: --Truncate the temp table.
2414: WF_DDL.TruncateTable(TableName=>'WF_UR_ASSIGNMENTS_STAGE',
2415: Owner=>wf_schema);
2416:
2417: --Drop indexes from the temp table.
2418: for c in dbaIndexes('WF_UR_ASSIGNMENTS_STAGE', wf_schema) loop

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

2417: --Drop indexes from the temp table.
2418: for c in dbaIndexes('WF_UR_ASSIGNMENTS_STAGE', wf_schema) loop
2419: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2420: 'Dropping index '||c.INDEX_NAME);
2421: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2422: Owner=>wf_schema,
2423: IgnoreNotFound=>TRUE);
2424:
2425: end loop;