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_LOG_PKG

Line 67: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

63:
64: begin
65: -- Log only
66: -- BINDVAR_SCAN_IGNORE[5]
67: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
68: 'Begin seedAttributes(p_attributes '||
69: '(wf_parameter_list_t), '||p_origSystem||', '||
70: to_char(p_origSystemID)||', '||
71: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');

Line 105: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

101: g_Attributes := wf_parameter_list_t();
102:
103:
104: FOR i in p_attributes.FIRST..p_attributes.LAST loop
105: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
106: 'Processing parameter: '||p_attributes(i).getName());
107: begin
108: if (upper(p_attributes(i).getName()) = 'USER_NAME') then
109: g_name := p_attributes(i).getValue();

Line 209: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

205: g_creationDate := to_date(p_attributes(i).getValue(),
206: WF_CORE.canonical_date_mask);
207:
208: else
209: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
210: 'Parameter: '||p_attributes(i).getName()||
211: 'is ignored by seedAttributes.');
212:
213: WF_EVENT.addParameterToList(upper(p_attributes(i).getName()),

Line 222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,

218:
219:
220: exception
221: when OTHERS then
222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
223: 'Exception: '||sqlerrm||
224: ' continuing to retrieve attributes.');
225: null; --We need to attempt to get all attributes.
226:

Line 284: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

280: end if;
281:
282: end if;
283:
284: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
285: 'End seedAttributes(p_attributes '||
286: '(wf_parameter_list_t), '||p_origSystem||', '||
287: to_char(p_origSystemID)||', '||
288: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');

Line 292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,

288: to_char(p_expDate, WF_CORE.canonical_date_mask)||')');
289:
290: exception
291: when OTHERS then
292: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
293: 'Exception: '||sqlerrm);
294: WF_CORE.Context('WF_LOCAL_SYNCH', 'seedAttributes', p_origSystem,
295: to_char(p_origSystemID), to_char(p_expDate,
296: WF_CORE.canonical_date_mask));

Line 332: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

328: i number;
329: l_modulePkg varchar2(240) := g_modulePkg||'.update_entmgr';
330:
331: begin
332: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
333:
334: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
335: 'Begin update_entmgr('|| p_entity_type||', '||
336: p_entity_key_value||', '||

Line 334: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

330:
331: begin
332: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
333:
334: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
335: 'Begin update_entmgr('|| p_entity_type||', '||
336: p_entity_key_value||', '||
337: 'p_attributes (wf_parameter_list_t)'||', '||
338: p_source||')');

Line 357: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

353: p_entity_key_value,
354: p_source);
355: end if;
356:
357: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
358:
359: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
360: 'End update_entmgr('||p_entity_type||', '||
361: p_entity_key_value||', '||

Line 359: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

355: end if;
356:
357: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
358:
359: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
360: 'End update_entmgr('||p_entity_type||', '||
361: p_entity_key_value||', '||
362: 'p_attributes(wf_parameter_list_t)'||', '||
363: p_source||')');

Line 442: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

438: l_storage VARCHAR2(4000);
439:
440: begin
441:
442: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
443: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
444: l_modulePkg,
445: 'Begin Create_Stage_Indexes('||p_sourceTable||', '||
446: p_targetTable||')');

Line 443: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

439:
440: begin
441:
442: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
443: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
444: l_modulePkg,
445: 'Begin Create_Stage_Indexes('||p_sourceTable||', '||
446: p_targetTable||')');
447: end if;

Line 559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

555: end loop; -- IndParts (index partitions) Loop
556: end loop; --Index (l_owners index) Loop
557: end if; -- (l_owners.COUNT > 0);
558:
559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
561: l_modulePkg,
562: 'End Create_Stage_Indexes('||p_sourceTable||', '||
563: p_targetTable||')');

Line 560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

556: end loop; --Index (l_owners index) Loop
557: end if; -- (l_owners.COUNT > 0);
558:
559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
561: l_modulePkg,
562: 'End Create_Stage_Indexes('||p_sourceTable||', '||
563: p_targetTable||')');
564: end if;

Line 569: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

565:
566: exception
567: when OTHERS then
568:
569: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
570: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
571: 'Exception: '||sqlerrm);
572:
573: end if;

Line 570: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,

566: exception
567: when OTHERS then
568:
569: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
570: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
571: 'Exception: '||sqlerrm);
572:
573: end if;
574:

Line 617: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

613:
614: begin
615: -- Log only
616: -- BINDVAR_SCAN_IGNORE[3]
617: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
618: 'Begin BuildQuery('||p_orig_system||', '||p_stage_table||
619: ', '||p_seed_view||')');
620: --Prepend space to the lists.
621: p_columnList := ' ';

Line 624: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

620: --Prepend space to the lists.
621: p_columnList := ' ';
622: p_selectList := ' ';
623:
624: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
625: 'Obtaining the description of the stage table');
626: --First we will get a description of the staging table in its current form
627: --Open the Stage Cursor
628: l_stageCursor := DBMS_SQL.open_cursor;

Line 644: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

640:
641: --Close the Stage Cursor
642: DBMS_SQL.close_cursor(l_stageCursor);
643:
644: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
645: 'Obtaining the description of the seeding view');
646: --Now we will get a description of the seeding view in its current form
647: --Open the Seed Cursor
648: l_seedCursor := DBMS_SQL.open_cursor;

Line 674: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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
672: --that were in the calling apis.
673: --First, we can build the column list from the stage table description.
674: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
675: 'Populating p_columnList');
676: for l_colCount in l_stageTableDesc.FIRST..l_stageTableDesc.LAST loop
677: p_columnList := p_columnList||l_stageTableDesc(l_colCount).COL_NAME||', ';
678: end loop;

Line 682: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

678: end loop;
679:
680: --Now we will trim the last comma to end the column list.
681: p_columnList := rtrim(p_columnList, ', ');
682: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
683: 'p_columnList is: ' ||p_columnList);
684:
685: --Populating the select list is more involved. First we need to see if the
686: --seeding view populates the column, then we need to apply any business

Line 688: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

684:
685: --Populating the select list is more involved. First we need to see if the
686: --seeding view populates the column, then we need to apply any business
687: --rules such as controlling the partition_id.
688: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
689: 'Populating the select list...');
690: <>
691: for stageIND in l_stageTableDesc.FIRST..l_stageTableDesc.LAST loop
692: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 692: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

688: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
689: 'Populating the select list...');
690: <>
691: for stageIND in l_stageTableDesc.FIRST..l_stageTableDesc.LAST loop
692: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
693: 'Determing if the seeding view provides column: '||
694:
695: l_stageTableDesc(stageIND).COL_NAME);
696: l_colExists := FALSE;

Line 703: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

699: if (l_seedViewDesc(seedIND).col_name =
700: l_stageTableDesc(stageIND).col_name) then
701: --Our current stage table column is provided by the view so it can be
702: --used in our select and insert.
703: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
704: 'Column found, applying business rules.');
705: l_colExists := TRUE;
706: l_colName := l_seedViewDesc(seedIND).COL_NAME;
707: exit SeedLoop;

Line 721: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

717: --- the seeding view. We do duplicate the nullable column rule ---
718: --- because we split the rules by tables to aid performance. ---
719: --------------------------------------------------------------------------
720: if NOT (l_colExists) then
721: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
722: 'Seeding View does not provide column ['||
723: l_stageTableDesc(stageIND).COL_NAME||
724: '] applying business rules for missing column.');
725: end if;

Line 848: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

844:
845: end loop StageLoop;
846: --Now we will trim the last comma to end the select list.
847: p_selectList := rtrim(p_selectList, ', ');
848: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
849: 'p_select list is: '||p_selectList);
850: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
851: 'End BuildQuery('||p_orig_system||', '||p_stage_table||
852: ', '||p_seed_view||') [Returning True]');

Line 850: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

846: --Now we will trim the last comma to end the select list.
847: p_selectList := rtrim(p_selectList, ', ');
848: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
849: 'p_select list is: '||p_selectList);
850: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
851: 'End BuildQuery('||p_orig_system||', '||p_stage_table||
852: ', '||p_seed_view||') [Returning True]');
853: return TRUE;
854: exception

Line 857: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

853: return TRUE;
854: exception
855: when NoTable then
856: if (substr(p_seed_view, 1, 3) = 'WF_') then
857: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
858: 'End BuildQuery('||p_orig_system||', '||p_stage_table||
859: ', '||p_seed_view||') [Returning False]');
860: return FALSE;
861:

Line 910: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

906: p_aux_exp_date date;
907:
908: BEGIN
909:
910: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
911: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
912: l_modulePkg,
913: 'Begin propagate_user('||p_orig_system||', '||
914: p_orig_system_id||','||

Line 911: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

907:
908: BEGIN
909:
910: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
911: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
912: l_modulePkg,
913: 'Begin propagate_user('||p_orig_system||', '||
914: p_orig_system_id||','||
915: 'p_attributes(wf_parameter_list_t)'||','||

Line 1529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1525:
1526: end if;
1527: end if;
1528:
1529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1530: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1531: l_modulePkg,
1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||

Line 1530: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1526: end if;
1527: end if;
1528:
1529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1530: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1531: l_modulePkg,
1532: 'End propagate_user('||p_orig_system||', '||
1533: p_orig_system_id||','||
1534: 'p_attributes(wf_parameter_list_t)'||','||

Line 1543: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1539:
1540:
1541: exception
1542: when OTHERS then
1543: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1544: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
1545: 'Exception: '||sqlerrm);
1546:
1547: end if;

Line 1544: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,

1540:
1541: exception
1542: when OTHERS then
1543: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1544: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
1545: 'Exception: '||sqlerrm);
1546:
1547: end if;
1548:

Line 1588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1584: AND ORIG_SYSTEM_ID = c_orig_system_id;
1585:
1586: begin
1587:
1588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1589: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1590: l_modulePkg,
1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||

Line 1589: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1585:
1586: begin
1587:
1588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1589: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1590: l_modulePkg,
1591: 'Begin propagate_role('||p_orig_system||', '||
1592: p_orig_system_id||','||
1593: 'p_attributes(wf_parameter_list_t)'||','||

Line 1894: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1890:
1891: end if;
1892: end;
1893: end if;
1894: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1895: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1896: l_modulePkg,
1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||

Line 1895: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1891: end if;
1892: end;
1893: end if;
1894: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1895: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1896: l_modulePkg,
1897: 'End propagate_role('||p_orig_system||', '||
1898: p_orig_system_id||','||
1899: 'p_attributes(wf_parameter_list_t)'||','||

Line 1907: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1903: end if;
1904:
1905: exception
1906: when OTHERS then
1907: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1908: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,
1909: 'Exception: '||sqlerrm);
1910:
1911: end if;

Line 1908: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,

1904:
1905: exception
1906: when OTHERS then
1907: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1908: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,
1909: 'Exception: '||sqlerrm);
1910:
1911: end if;
1912:

Line 2147: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2143:
2144: begin
2145: -- Log only
2146: -- BINDVAR_SCAN_IGNORE[3]
2147: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2148: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2149: ', '||p_partitionName||', '||p_roleTLView||')');
2150:
2151: --Truncate the temp table.

Line 2157: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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
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);

Line 2195: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2191: l_columnList||') select /*+ parallel(R, '||
2192: to_char(g_parallel)||') */ '||l_selectList||
2193: ' from '||p_roletlview;
2194:
2195: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2196: 'Loading stage table with: '||l_sql);
2197:
2198: -- g_parallel is non-varchar
2199: -- BINDVAR_SCAN_IGNORE[2]

Line 2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2218: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2219: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2220: PERCENT=>10);
2221:
2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2223: 'Creating indexes on stage table.');
2224:
2225: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2226: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');

Line 2243: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2239: ' WITH TABLE ' ||wf_schema||
2240: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2241: 'INDEXES WITHOUT VALIDATION';
2242:
2243: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2244: 'Exchanging partition with: '||l_sql);
2245: execute IMMEDIATE l_sql;
2246: commit;
2247: end if;

Line 2248: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2244: 'Exchanging partition with: '||l_sql);
2245: execute IMMEDIATE l_sql;
2246: commit;
2247: end if;
2248: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2249: 'End syncRolesTL('||p_orig_system||', '|| p_partitionid||
2250: ', '||p_partitionName||', '||p_roleTLView||')');
2251: end;
2252: ------------------------------------------------------------------------------

Line 2283: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2279:
2280: begin
2281: -- Log only
2282: -- BINDVAR_SCAN_IGNORE[2]
2283: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2284: 'Begin syncRoles('||p_orig_system||')');
2285: --
2286: --If the orig_system is FND_USR we will synch PER_ROLE first.
2287: if (p_orig_system = 'FND_USR') then

Line 2297: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2293: Owner=>wf_schema);
2294:
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);

Line 2353: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2349: '('||l_columnList||') select /*+ parallel(R, '||
2350: to_char(g_parallel)||') */ '||l_selectList ||' from '||
2351: nvl(l_roleView, 'WF_'||l_partitionName||'_ROLES R ' );
2352:
2353: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2354: 'Loading stage table with: '||l_sql);
2355: execute IMMEDIATE 'alter session force parallel query parallel '||
2356: to_char(g_parallel) ;
2357: execute IMMEDIATE l_sql;

Line 2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2373: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2374: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2375: PERCENT=>10);
2376:
2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2378: 'Creating indexes on stage table.');
2379:
2380: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2381: p_targetTable=>'WF_LOCAL_ROLES_STAGE');

Line 2395: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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 '||
2394: 'INDEXES WITHOUT VALIDATION';
2395: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2396: 'Exchanging partition with: '||l_sql);
2397: execute IMMEDIATE l_sql;
2398: commit;
2399: end if;

Line 2410: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2406: SyncRolesTL(p_orig_system, l_partitionID,l_partitionName,l_role_tl_view);
2407: end if;
2408:
2409: commit;
2410: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2411: 'End syncRoles('||p_orig_system||')');
2412: end;
2413:
2414:

Line 2442: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2438:
2439: begin
2440: -- Log only
2441: -- BINDVAR_SCAN_IGNORE[2]
2442: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2443: 'Begin syncUserRoles('||p_orig_system||')');
2444:
2445: l_storageClause := ('STORAGE (INITIAL 4K NEXT 512K MINEXTENTS 1 MAXEXTENTS '||
2446: 'UNLIMITED PCTINCREASE 0 FREELIST GROUPS 4 FREELISTS 4) '||

Line 2463: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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
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);

Line 2477: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2473: Owner=>wf_schema);
2474:
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);

Line 2526: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2522: '( '||l_columnList||' ) select /*+ parallel(R, '||
2523: to_char(g_parallel)||') */ ' ||l_selectList||' from '||
2524: nvl(l_userRoleView, 'WF_'||l_partitionName||'_UR R ' );
2525:
2526: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2527: 'Loading WF_LOCAL_USER_ROLES_STAGE with: '||l_sql);
2528:
2529: -- BINDVAR_SCAN_IGNORE[2]
2530: execute IMMEDIATE 'alter session force parallel query parallel '||

Line 2569: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2565: 'ROLE_END_DATE, ''D'', '||
2566: ''''||to_char(l_partitionID)||''', ASSIGNMENT_REASON from '||
2567: 'WF_UR_ASSIGNMENTS_STAGE R';
2568:
2569: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2570: 'Loading WF_UR_ASSIGNMENTS_STAGE with: '||l_sql);
2571:
2572: execute IMMEDIATE 'alter session force parallel query parallel '||
2573: to_char(g_parallel) ;

Line 2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2597: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2598: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2599: PERCENT=>10);
2600:
2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2602: 'Creating indexes on stage table.');
2603:
2604: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2605: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');

Line 2626: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2623: 'EXCHANGE PARTITION ' || l_partitionName ||
2624: ' WITH TABLE ' ||wf_schema||
2625: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2626: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2627: 'Exchanging partition with: '||l_sql);
2628: execute IMMEDIATE l_sql;
2629: commit;
2630:

Line 2640: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

2636: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2637: 'EXCHANGE PARTITION ' || l_partitionName ||
2638: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2639: 'INCLUDING INDEXES WITHOUT VALIDATION';
2640: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2641: 'Exchanging partition with: '||l_sql);
2642: execute IMMEDIATE l_sql;
2643:
2644: end if;

Line 2647: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,

2643:
2644: end if;
2645: commit;
2646:
2647: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2648: 'End syncUserRoles('||p_orig_system||')');
2649: end;
2650: ------------------------------------------------------------------------------
2651: /*