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 441: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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

Line 442: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

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

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

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

Line 558: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

902: l_modulePkg varchar2(240) := g_modulePkg||'.propagate_user';
903:
904: BEGIN
905:
906: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
907: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
908: l_modulePkg,
909: 'Begin propagate_user('||p_orig_system||', '||
910: p_orig_system_id||','||

Line 907: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

903:
904: BEGIN
905:
906: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
907: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
908: l_modulePkg,
909: 'Begin propagate_user('||p_orig_system||', '||
910: p_orig_system_id||','||
911: 'p_attributes(wf_parameter_list_t)'||','||

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

1517:
1518: end if;
1519: end if;
1520:
1521: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1522: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1523: l_modulePkg,
1524: 'End propagate_user('||p_orig_system||', '||
1525: p_orig_system_id||','||

Line 1522: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1518: end if;
1519: end if;
1520:
1521: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1522: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1523: l_modulePkg,
1524: 'End propagate_user('||p_orig_system||', '||
1525: p_orig_system_id||','||
1526: 'p_attributes(wf_parameter_list_t)'||','||

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

1533: exception
1534: when OTHERS then
1535: if (g_raiseErrors) then
1536:
1537: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1538: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
1539: 'Exception: '||sqlerrm);
1540:
1541: end if;

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

1534: when OTHERS then
1535: if (g_raiseErrors) then
1536:
1537: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1538: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED, l_modulePkg,
1539: 'Exception: '||sqlerrm);
1540:
1541: end if;
1542:

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

1575: AND ORIG_SYSTEM_ID = c_orig_system_id;
1576:
1577: begin
1578:
1579: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1580: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1581: l_modulePkg,
1582: 'Begin propagate_role('||p_orig_system||', '||
1583: p_orig_system_id||','||

Line 1580: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1576:
1577: begin
1578:
1579: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1580: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1581: l_modulePkg,
1582: 'Begin propagate_role('||p_orig_system||', '||
1583: p_orig_system_id||','||
1584: 'p_attributes(wf_parameter_list_t)'||','||

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

1841:
1842: end if;
1843: end;
1844: end if;
1845: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1847: l_modulePkg,
1848: 'End propagate_role('||p_orig_system||', '||
1849: p_orig_system_id||','||

Line 1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,

1842: end if;
1843: end;
1844: end if;
1845: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
1847: l_modulePkg,
1848: 'End propagate_role('||p_orig_system||', '||
1849: p_orig_system_id||','||
1850: 'p_attributes(wf_parameter_list_t)'||','||

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

1855:
1856: exception
1857: when OTHERS then
1858: if (g_raiseErrors) then
1859: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1860: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,
1861: 'Exception: '||sqlerrm);
1862:
1863: end if;

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

1856: exception
1857: when OTHERS then
1858: if (g_raiseErrors) then
1859: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1860: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,l_modulePkg,
1861: 'Exception: '||sqlerrm);
1862:
1863: end if;
1864:

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

2093:
2094: begin
2095: -- Log only
2096: -- BINDVAR_SCAN_IGNORE[3]
2097: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2098: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2099: ', '||p_partitionName||', '||p_roleTLView||')');
2100:
2101: --Truncate the temp table.

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

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

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

2137: l_columnList||') select /*+ parallel(R, '||
2138: to_char(g_parallel)||') */ '||l_selectList||
2139: ' from '||p_roletlview );
2140:
2141: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2142: 'Loading stage table with: '||l_sql);
2143:
2144: -- g_parallel is non-varchar
2145: -- BINDVAR_SCAN_IGNORE[2]

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

2164: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2165: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2166: PERCENT=>10);
2167:
2168: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2169: 'Creating indexes on stage table.');
2170:
2171: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2172: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');

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

2185: ' WITH TABLE ' ||wf_schema||
2186: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2187: 'INDEXES WITHOUT VALIDATION';
2188:
2189: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2190: 'Exchanging partition with: '||l_sql);
2191: execute IMMEDIATE l_sql;
2192: commit;
2193: end if;

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

2190: 'Exchanging partition with: '||l_sql);
2191: execute IMMEDIATE l_sql;
2192: commit;
2193: end if;
2194: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2195: 'End syncRolesTL('||p_orig_system||', '|| p_partitionid||
2196: ', '||p_partitionName||', '||p_roleTLView||')');
2197: end;
2198: ------------------------------------------------------------------------------

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

2225:
2226: begin
2227: -- Log only
2228: -- BINDVAR_SCAN_IGNORE[2]
2229: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2230: 'Begin syncRoles('||p_orig_system||')');
2231: --
2232: --If the orig_system is FND_USR we will synch PER_ROLE first.
2233: if (p_orig_system = 'FND_USR') then

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

2239: Owner=>wf_schema);
2240:
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);

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

2291: '('||l_columnList||') select /*+ parallel(R, '||
2292: to_char(g_parallel)||') */ '||l_selectList ||' from '||
2293: nvl(l_roleView, 'WF_'||l_partitionName||'_ROLES R ' ));
2294:
2295: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2296: 'Loading stage table with: '||l_sql);
2297: execute IMMEDIATE 'alter session force parallel query parallel '||
2298: to_char(g_parallel) ;
2299: execute IMMEDIATE l_sql;

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

2315: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2316: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2317: PERCENT=>10);
2318:
2319: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2320: 'Creating indexes on stage table.');
2321:
2322: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2323: p_targetTable=>'WF_LOCAL_ROLES_STAGE');

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

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 '||
2336: 'INDEXES WITHOUT VALIDATION';
2337: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2338: 'Exchanging partition with: '||l_sql);
2339: execute IMMEDIATE l_sql;
2340: commit;
2341: end if;

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

2348: SyncRolesTL(p_orig_system, l_partitionID,l_partitionName,l_role_tl_view);
2349: end if;
2350:
2351: commit;
2352: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2353: 'End syncRoles('||p_orig_system||')');
2354: end;
2355:
2356:

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

2380:
2381: begin
2382: -- Log only
2383: -- BINDVAR_SCAN_IGNORE[2]
2384: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2385: 'Begin syncUserRoles('||p_orig_system||')');
2386:
2387: l_storageClause := ('STORAGE (INITIAL 4K NEXT 512K MINEXTENTS 1 MAXEXTENTS '||
2388: 'UNLIMITED PCTINCREASE 0 FREELIST GROUPS 4 FREELISTS 4) '||

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

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

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

2415: Owner=>wf_schema);
2416:
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);

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

2460: '( '||l_columnList||' ) select /*+ parallel(R, '||
2461: to_char(g_parallel)||') */ ' ||l_selectList||' from '||
2462: nvl(l_userRoleView, 'WF_'||l_partitionName||'_UR R ' ));
2463:
2464: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2465: 'Loading WF_LOCAL_USER_ROLES_STAGE with: '||l_sql);
2466:
2467: -- BINDVAR_SCAN_IGNORE[2]
2468: execute IMMEDIATE 'alter session force parallel query parallel '||

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

2499: 'ROLE_END_DATE, ''D'', '||
2500: ''''||to_char(l_partitionID)||''', ASSIGNMENT_REASON from '||
2501: wf_schema||'.WF_UR_ASSIGNMENTS_STAGE R';
2502:
2503: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2504: 'Loading WF_UR_ASSIGNMENTS_STAGE with: '||l_sql);
2505:
2506: execute IMMEDIATE 'alter session force parallel query parallel '||
2507: to_char(g_parallel) ;

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

2531: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2532: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2533: PERCENT=>10);
2534:
2535: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2536: 'Creating indexes on stage table.');
2537:
2538: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2539: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');

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

2556: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2557: 'EXCHANGE PARTITION ' || l_partitionName ||
2558: ' WITH TABLE ' ||wf_schema||
2559: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2561: 'Exchanging partition with: '||l_sql);
2562: execute IMMEDIATE l_sql;
2563: commit;
2564:

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

2570: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2571: 'EXCHANGE PARTITION ' || l_partitionName ||
2572: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2573: 'INCLUDING INDEXES WITHOUT VALIDATION';
2574: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2575: 'Exchanging partition with: '||l_sql);
2576: execute IMMEDIATE l_sql;
2577:
2578: end if;

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

2577:
2578: end if;
2579: commit;
2580:
2581: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_modulePkg,
2582: 'End syncUserRoles('||p_orig_system||')');
2583: end;
2584: ------------------------------------------------------------------------------
2585: /*