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.AD_LONGTOLOB_PKG dependencies on AD_LONG_COLUMN_CONVERSIONS

Line 38: FROM ad_long_column_conversions

34: l_status VARCHAR2 (30);
35: BEGIN
36: SELECT status
37: INTO l_status
38: FROM ad_long_column_conversions
39: WHERE schema_name = p_Schema
40: AND table_name = p_Table_Name
41: AND old_column_name = p_Old_Column_Name;
42:

Line 112: UPDATE AD_LONG_COLUMN_CONVERSIONS

108:
109: --
110: -- Update the table with the new status.
111: --
112: UPDATE AD_LONG_COLUMN_CONVERSIONS
113: SET status = p_Status
114: WHERE schema_name = p_Schema
115: AND table_name = p_Table_Name
116: AND old_column_name = p_Old_Column_Name;

Line 216: INSERT INTO AD_LONG_COLUMN_CONVERSIONS (

212: p_Product,
213: p_Table_Name,
214: l_Schema);
215: IF ( l_register_flg = TRUE ) THEN
216: INSERT INTO AD_LONG_COLUMN_CONVERSIONS (
217: schema_name, table_name, old_column_name,
218: old_data_type,
219: new_column_name, new_data_type,
220: action, status

Line 229: FROM AD_LONG_COLUMN_CONVERSIONS l

225: p_Action, l_Status
226: FROM dual
227: WHERE NOT EXISTS (
228: SELECT 'x'
229: FROM AD_LONG_COLUMN_CONVERSIONS l
230: WHERE l.schema_name = l_Schema
231: AND l.table_name = p_Table_Name
232: AND l.old_column_name = p_Old_Column_Name);
233: END IF ; -- end if l_register_flg

Line 240: -- ad_long_column_conversions table with the tables and the related

236: END register_table;
237:
238: --
239: -- This procedure is called initially to populate the
240: -- ad_long_column_conversions table with the tables and the related
241: -- information.
242: --
243: PROCEDURE initialize_process(
244: p_Specific_Table VARCHAR2 := NULL ,

Line 451: -- For each of the tables from AD_LONG_COLUMN_CONVERSIONS

447:
448: --
449: -- The following procedure alters the table to add the new column.
450: -- with the new data type.
451: -- For each of the tables from AD_LONG_COLUMN_CONVERSIONS
452: -- this procedure has to be called repeatedly.
453: --
454: PROCEDURE add_new_column(p_Schema IN VARCHAR2 ,
455: p_Table_Name IN VARCHAR2 ,

Line 836: FROM ad_long_column_conversions;

832: -- Load the information from the control table
833: SELECT table_name, NEW_DATA_TYPE
834: BULK COLLECT
835: INTO l_TableNames_Tbl, l_To_DataType_Tbl
836: FROM ad_long_column_conversions;
837:
838: IF l_TableNames_Tbl.COUNT = 0 THEN
839: RAISE_APPLICATION_ERROR (-20001,
840: ' The tables are not Initialized.'||

Line 907: l_Current_Status ad_long_column_conversions.status%TYPE ;

903: --
904: PROCEDURE defer_table( p_Schema IN VARCHAR2 ,
905: p_Table_Name IN VARCHAR2 )
906: IS
907: l_Current_Status ad_long_column_conversions.status%TYPE ;
908: l_Count NUMBER(3) ;
909: BEGIN
910: --
911: -- Since this procedure can be called even before starting any of the

Line 918: FROM ad_long_column_conversions

914: -- If not the initialize_process is called to initialize the tables.
915: --
916: SELECT COUNT(*)
917: INTO l_Count
918: FROM ad_long_column_conversions
919: WHERE schema_name = p_Schema
920: AND table_name = p_Table_Name ;
921:
922: --

Line 942: FROM ad_long_column_conversions

938: -- comes out saying the exception.
939: --
940: SELECT status
941: INTO l_Current_Status
942: FROM ad_long_column_conversions
943: WHERE schema_name = p_Schema
944: AND table_name = p_Table_Name
945: FOR UPDATE NOWAIT ;
946:

Line 951: UPDATE ad_long_column_conversions

947: --
948: -- Now update the status to indicate that the table is deferred.
949: -- The status will be 'DEFFERRED_'||old_status.
950: --
951: UPDATE ad_long_column_conversions
952: SET status = G_DEFERRED_STATUS||'_'||status
953: WHERE schema_name = p_Schema
954: AND table_name = p_Table_Name;
955:

Line 970: l_Prev_Status ad_long_column_conversions.status%TYPE ;

966: --
967: PROCEDURE re_enable_table(p_Schema IN VARCHAR2 ,
968: p_Table_Name IN VARCHAR2 )
969: IS
970: l_Prev_Status ad_long_column_conversions.status%TYPE ;
971: BEGIN
972: --
973: -- Lock the entry in ad_long_column_conversions corresponding to the
974: -- table being re-enabled.

Line 973: -- Lock the entry in ad_long_column_conversions corresponding to the

969: IS
970: l_Prev_Status ad_long_column_conversions.status%TYPE ;
971: BEGIN
972: --
973: -- Lock the entry in ad_long_column_conversions corresponding to the
974: -- table being re-enabled.
975: --
976: SELECT LTRIM (status,G_DEFERRED_STATUS||'_')
977: INTO l_Prev_Status

Line 978: FROM ad_long_column_conversions

974: -- table being re-enabled.
975: --
976: SELECT LTRIM (status,G_DEFERRED_STATUS||'_')
977: INTO l_Prev_Status
978: FROM ad_long_column_conversions
979: WHERE schema_name = p_Schema
980: AND table_name = p_Table_Name
981: AND status LIKE G_DEFERRED_STATUS||'_%'
982: FOR UPDATE NOWAIT ;

Line 987: UPDATE ad_long_column_conversions

983:
984: --
985: -- Update status of the table to the prior status.
986: --
987: UPDATE ad_long_column_conversions
988: SET status = l_Prev_Status
989: WHERE schema_name = p_Schema
990: AND table_name = p_Table_Name;
991: