APPS.WF_LOCAL_SYNCH dependencies on WF_DIRECTORY_PARTITIONS

Line 631: -- p_stage_table came from table wf_directory_partitions

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

Line 651: -- p_seed_view came from table wf_directory_partitions

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

Line 667: from WF_DIRECTORY_PARTITIONS

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

Line 2183: -- p_roletlview came from wf_directory_partitions

2179: p_columnList=>l_columnList,
2180: p_selectList=>l_selectList)) then
2181: -- l_selectList is controlled by us
2182: -- g_parallel must not be varchar
2183: -- p_roletlview came from wf_directory_partitions
2184: -- BINDVAR_SCAN_IGNORE[4]
2185: if g_logging='LOGGING' then
2186: l_sql := 'insert ';
2187: else

Line 2320: FROM wf_directory_partitions

2316:
2317: --Retrieve the role and the user/role view names to be used.
2318: SELECT trim(role_view) , trim(role_tl_view)
2319: INTO l_roleView ,l_role_tl_view
2320: FROM wf_directory_partitions
2321: WHERE partition_id = l_partitionID;
2322: --Enable parallel DML
2323: execute IMMEDIATE 'alter session enable parallel dml';
2324:

Line 2341: -- l_partitionName came from wf_directory_partitions

2337: p_selectList=>l_selectList)) then
2338: -- g_parallel must not be varchar2
2339: -- wf_schema came from wf_resources
2340: -- l_selectList is controlled by us
2341: -- l_partitionName came from wf_directory_partitions
2342: -- BINDVAR_SCAN_IGNORE[5]
2343: if g_logging='LOGGING' then
2344: l_sql := 'insert ';
2345: else

Line 2389: -- l_partitionName came from wf_directory_partitions

2385: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2386: 'in exclusive mode';
2387: --Partition exchange the temp table into the wf_local_roles table.
2388: -- wf_schema came from wf_resources
2389: -- l_partitionName came from wf_directory_partitions
2390: -- BINDVAR_SCAN_IGNORE[4]
2391: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2392: 'EXCHANGE PARTITION ' || l_partitionName ||
2393: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||

Line 2491: FROM wf_directory_partitions

2487:
2488: --Retrieve the role and the user/role view names to be used.
2489: SELECT trim(user_role_view)
2490: INTO l_userRoleView
2491: FROM wf_directory_partitions
2492: WHERE partition_id = l_partitionID;
2493:
2494: --Enable parallel DML
2495: execute IMMEDIATE 'alter session enable parallel dml';

Line 2513: -- l_userRoleView came from wf_directory_partitions

2509: -- g_parallel must be number
2510: -- wf_schema came from wf_resources
2511: -- l_columnList came from DBMS_SQL.describe_columns()
2512: -- l_selectList controlled by us
2513: -- l_userRoleView came from wf_directory_partitions
2514: -- l_partitionName came from wf_directory_partitions
2515: -- BINDVAR_SCAN_IGNORE[5]
2516: if g_logging='LOGGING' then
2517: l_sql:='insert ';

Line 2514: -- l_partitionName came from wf_directory_partitions

2510: -- wf_schema came from wf_resources
2511: -- l_columnList came from DBMS_SQL.describe_columns()
2512: -- l_selectList controlled by us
2513: -- l_userRoleView came from wf_directory_partitions
2514: -- l_partitionName came from wf_directory_partitions
2515: -- BINDVAR_SCAN_IGNORE[5]
2516: if g_logging='LOGGING' then
2517: l_sql:='insert ';
2518: else

Line 2620: -- l_partitionName came from wf_directory_partitions

2616: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2617: 'in exclusive mode';
2618: --Partition exchange the temp table into the wf_local_user_roles table.
2619: -- wf_schema came from wf_resources
2620: -- l_partitionName came from wf_directory_partitions
2621: -- BINDVAR_SCAN_IGNORE[4]
2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2623: 'EXCHANGE PARTITION ' || l_partitionName ||
2624: ' WITH TABLE ' ||wf_schema||