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.AP_ACCTG_DATA_FIX_PKG dependencies on ALL_TAB_COLUMNS

Line 147: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';

143: TYPE sqlCurTyp IS REF CURSOR;
144: cur sqlCurTyp;
145: stmt_str VARCHAR2(500);
146: col_name varchar2(100);
147: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';
148: l_calling_sequence VARCHAR2(2000);
149: l_message varchar2(500);
150:
151: begin

Line 155: stmt_str := 'select column_name from '|| l_all_tab_columns ||

151: begin
152:
153: l_calling_sequence :=
154: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
155: stmt_str := 'select column_name from '|| l_all_tab_columns ||
156: ' where table_name=:1 and column_name<>''DATAFIX_UPDATE_DATE''';
157: OPEN cur FOR stmt_str USING TAB_NAME;
158: LOOP
159: FETCH cur INTO COL_NAME;

Line 187: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';

183: TYPE sqlCurTyp IS REF CURSOR;
184: cur sqlCurTyp;
185: stmt_str VARCHAR2(500);
186: col_name varchar2(100);
187: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';
188: l_calling_sequence VARCHAR2(2000);
189: l_message varchar2(500);
190:
191: begin

Line 195: stmt_str := 'select column_name from '|| l_all_tab_columns ||

191: begin
192:
193: l_calling_sequence :=
194: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
195: stmt_str := 'select column_name from '|| l_all_tab_columns ||
196: ' where table_name=:1 and owner =:2 and column_name<>''DATAFIX_UPDATE_DATE''';
197: OPEN cur FOR stmt_str USING TAB_NAME, SCHEMA_NAME;
198: LOOP
199: FETCH cur INTO COL_NAME;

Line 437: FROM all_tab_columns

433: end if;
434:
435: SELECT data_type,DATA_LENGTH
436: INTO coltype (col_count) ,collen(col_count)
437: FROM all_tab_columns
438: WHERE owner = owner_nm
439: AND table_name = table_nm
440: AND column_name=colname (col_count);
441:

Line 606: FROM all_tab_columns

602:
603: --bug12833171
604: sql_stmt := 'SELECT column_name,
605: data_type|| decode(data_type, ''DATE'', '''', ''(''||data_length||''''||nvl2(data_precision, '',''||data_precision||'')'', '')'')) column_type
606: FROM all_tab_columns
607: WHERE table_name IN ('''||p_source_table||''')
608: MINUS
609: SELECT column_name,
610: data_type|| decode(data_type, ''DATE'', '''', ''(''||data_length||''''||nvl2(data_precision, '',''||data_precision||'')'', '')'')) column_type

Line 611: FROM all_tab_columns

607: WHERE table_name IN ('''||p_source_table||''')
608: MINUS
609: SELECT column_name,
610: data_type|| decode(data_type, ''DATE'', '''', ''(''||data_length||''''||nvl2(data_precision, '',''||data_precision||'')'', '')'')) column_type
611: FROM all_tab_columns
612: WHERE table_name IN ('''||p_destination_table||''')';
613:
614: OPEN cur FOR sql_stmt;
615: LOOP

Line 1156: FROM sys.all_tab_columns

1152: 'driver ';
1153: BEGIN
1154: SELECT 1
1155: INTO l_dummy
1156: FROM sys.all_tab_columns
1157: WHERE table_name = l_driver_table
1158: AND column_name = 'EVENT_ID';
1159:
1160: EXCEPTION

Line 1172: FROM sys.all_tab_columns

1168: l_debug_info := 'Check for the presence of the process_flag on the driver table ';
1169: BEGIN
1170: SELECT 'Y'
1171: INTO l_check_process_flag
1172: FROM sys.all_tab_columns
1173: WHERE table_name = l_driver_table
1174: AND column_name = 'PROCESS_FLAG';
1175:
1176: EXCEPTION

Line 1202: FROM sys.all_tab_columns

1198: l_debug_info := 'Checking the events having a user proposed undo date';
1199: BEGIN
1200: SELECT 'Y'
1201: INTO l_check_proposed_col
1202: FROM sys.all_tab_columns
1203: WHERE table_name = l_driver_table
1204: AND column_name = 'PROPOSED_UNDO_DATE';
1205:
1206: EXCEPTION

Line 1506: FROM sys.all_tab_columns

1502: l_debug_info := 'Check for the presence of columns for calculated undo dates and periods';
1503: BEGIN
1504: SELECT 1
1505: INTO l_dummy
1506: FROM sys.all_tab_columns
1507: WHERE table_name = l_driver_table
1508: AND column_name = 'CALCULATED_UNDO_DATE';
1509:
1510: EXCEPTION

Line 1875: FROM sys.all_tab_columns

1871:
1872: BEGIN
1873: SELECT 'Y'
1874: INTO l_check_process_flag
1875: FROM sys.all_tab_columns
1876: WHERE table_name = l_driver_table
1877: AND column_name = 'PROCESS_FLAG';
1878:
1879: EXCEPTION

Line 2728: FROM sys.all_tab_columns

2724: 'temp data driver';
2725: BEGIN
2726: SELECT 1
2727: INTO l_dummy
2728: FROM sys.all_tab_columns
2729: WHERE table_name = l_driver_table
2730: AND column_name = 'REVERSAL_EVENT_ID';
2731:
2732: EXCEPTION

Line 4537: FROM sys.all_tab_columns

4533: BEGIN
4534: l_debug_info := 'Checking if the invoice_id column is there in the driver table';
4535: SELECT 'Y'
4536: INTO l_check_invoice_col
4537: FROM sys.all_tab_columns
4538: WHERE table_name = l_driver_table
4539: AND column_name = 'INVOICE_ID';
4540:
4541: EXCEPTION

Line 4550: FROM sys.all_tab_columns

4546: BEGIN
4547: l_debug_info := 'Checking if the return_status column is there in the driver table';
4548: SELECT 'Y'
4549: INTO l_check_ret_stat_col
4550: FROM sys.all_tab_columns
4551: WHERE table_name = l_driver_table
4552: AND column_name = 'RETURN_STATUS';
4553:
4554: EXCEPTION

Line 4563: FROM sys.all_tab_columns

4559: BEGIN
4560: l_debug_info := 'Checking if the process_flag column is there in the driver table';
4561: SELECT 'Y'
4562: INTO l_check_process_col
4563: FROM sys.all_tab_columns
4564: WHERE table_name = l_driver_table
4565: AND column_name = 'PROCESS_FLAG';
4566:
4567: EXCEPTION

Line 4586: FROM sys.all_tab_columns

4582: BEGIN
4583: l_debug_info := 'Checking if the event_id column is there in the driver table';
4584: SELECT 'Y'
4585: INTO l_check_event_col
4586: FROM sys.all_tab_columns
4587: WHERE table_name = l_driver_table
4588: AND column_name = 'EVENT_ID';
4589:
4590: EXCEPTION

Line 5086: FROM sys.all_tab_columns

5082: BEGIN
5083: l_debug_info := 'Checking if the invoice_id column is there in the driver table';
5084: SELECT 'Y'
5085: INTO l_check_invoice_col
5086: FROM sys.all_tab_columns
5087: WHERE table_name = l_driver_table
5088: AND column_name = 'INVOICE_ID';
5089:
5090: EXCEPTION

Line 5100: FROM sys.all_tab_columns

5096: l_debug_info := 'Checking if the del_cas_rt_sts column is there in the driver table';
5097:
5098: SELECT 'Y'
5099: INTO l_check_ret_stat_col
5100: FROM sys.all_tab_columns
5101: WHERE table_name = l_driver_table
5102: AND column_name = 'DEL_CAS_RT_STS'; --bug10056653, changed column name to CAPS
5103:
5104: EXCEPTION

Line 5113: FROM sys.all_tab_columns

5109: BEGIN
5110: l_debug_info := 'Checking if the process_flag column is there in the driver table';
5111: SELECT 'Y'
5112: INTO l_check_process_col
5113: FROM sys.all_tab_columns
5114: WHERE table_name = l_driver_table
5115: AND column_name = 'PROCESS_FLAG';
5116:
5117: EXCEPTION

Line 5135: FROM sys.all_tab_columns

5131: BEGIN
5132: l_debug_info := 'Checking if the event_id column is there in the driver table';
5133: SELECT 'Y'
5134: INTO l_check_event_col
5135: FROM sys.all_tab_columns
5136: WHERE table_name = l_driver_table
5137: AND column_name = 'EVENT_ID';
5138:
5139: EXCEPTION

Line 5193: FROM sys.all_tab_columns

5189: l_debug_info := 'Checking if cancelled_date column is there in the driver table';
5190:
5191: SELECT 'Y'
5192: INTO l_check_canc_dt_col
5193: FROM sys.all_tab_columns
5194: WHERE table_name = l_driver_table
5195: AND column_name = 'CANCELLED_DATE';
5196:
5197: EXCEPTION