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 DBMS_SQL

Line 596: l_seedViewDesc DBMS_SQL.DESC_TAB;

592: p_columnList in out NOCOPY VARCHAR2,
593: p_selectList in out NOCOPY VARCHAR2) return BOOLEAN is
594:
595: l_seedCursor NUMBER;
596: l_seedViewDesc DBMS_SQL.DESC_TAB;
597: l_stageCursor NUMBER;
598: l_stageTableDesc DBMS_SQL.DESC_TAB;
599: l_rowCount NUMBER;
600: l_colCount PLS_INTEGER;

Line 598: l_stageTableDesc DBMS_SQL.DESC_TAB;

594:
595: l_seedCursor NUMBER;
596: l_seedViewDesc DBMS_SQL.DESC_TAB;
597: l_stageCursor NUMBER;
598: l_stageTableDesc DBMS_SQL.DESC_TAB;
599: l_rowCount NUMBER;
600: l_colCount PLS_INTEGER;
601: l_colExists BOOLEAN;
602: l_colName VARCHAR2(30);

Line 628: l_stageCursor := DBMS_SQL.open_cursor;

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

Line 635: DBMS_SQL.parse(c=>l_stageCursor, statement=>l_sql,

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,
636: language_flag=>DBMS_SQL.native);
637:
638: --Obtain the column list
639: DBMS_SQL.describe_columns(l_stageCursor, l_colCount, l_stageTableDesc);

Line 636: language_flag=>DBMS_SQL.native);

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,
636: language_flag=>DBMS_SQL.native);
637:
638: --Obtain the column list
639: DBMS_SQL.describe_columns(l_stageCursor, l_colCount, l_stageTableDesc);
640:

Line 639: DBMS_SQL.describe_columns(l_stageCursor, l_colCount, l_stageTableDesc);

635: DBMS_SQL.parse(c=>l_stageCursor, statement=>l_sql,
636: language_flag=>DBMS_SQL.native);
637:
638: --Obtain the column list
639: DBMS_SQL.describe_columns(l_stageCursor, l_colCount, l_stageTableDesc);
640:
641: --Close the Stage Cursor
642: DBMS_SQL.close_cursor(l_stageCursor);
643:

Line 642: DBMS_SQL.close_cursor(l_stageCursor);

638: --Obtain the column list
639: DBMS_SQL.describe_columns(l_stageCursor, l_colCount, l_stageTableDesc);
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

Line 648: l_seedCursor := DBMS_SQL.open_cursor;

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

Line 655: DBMS_SQL.parse(c=>l_seedCursor, statement=>l_sql,

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,
656: language_flag=>DBMS_SQL.native);
657:
658: --Obtain the column list
659: DBMS_SQL.describe_columns(l_seedCursor, l_colCount, l_seedViewDesc);

Line 656: language_flag=>DBMS_SQL.native);

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,
656: language_flag=>DBMS_SQL.native);
657:
658: --Obtain the column list
659: DBMS_SQL.describe_columns(l_seedCursor, l_colCount, l_seedViewDesc);
660:

Line 659: DBMS_SQL.describe_columns(l_seedCursor, l_colCount, l_seedViewDesc);

655: DBMS_SQL.parse(c=>l_seedCursor, statement=>l_sql,
656: language_flag=>DBMS_SQL.native);
657:
658: --Obtain the column list
659: DBMS_SQL.describe_columns(l_seedCursor, l_colCount, l_seedViewDesc);
660:
661: --Close the Stage Cursor
662: DBMS_SQL.close_cursor(l_seedCursor);
663:

Line 662: DBMS_SQL.close_cursor(l_seedCursor);

658: --Obtain the column list
659: DBMS_SQL.describe_columns(l_seedCursor, l_colCount, l_seedViewDesc);
660:
661: --Close the Stage Cursor
662: DBMS_SQL.close_cursor(l_seedCursor);
663:
664: --Retrieve the partition id.
665: select PARTITION_ID, ORIG_SYSTEM
666: into l_partitionID, l_partitionName

Line 2511: -- l_columnList came from DBMS_SQL.describe_columns()

2507: p_selectList=>l_selectList)) then
2508:
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]