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 455: -- For each of the tables from AD_LONG_COLUMN_CONVERSIONS

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

Line 840: FROM ad_long_column_conversions;

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

Line 911: l_Current_Status ad_long_column_conversions.status%TYPE ;

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

Line 922: FROM ad_long_column_conversions

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

Line 946: FROM ad_long_column_conversions

942: -- comes out saying the exception.
943: --
944: SELECT status
945: INTO l_Current_Status
946: FROM ad_long_column_conversions
947: WHERE schema_name = p_Schema
948: AND table_name = p_Table_Name
949: FOR UPDATE NOWAIT ;
950:

Line 955: UPDATE ad_long_column_conversions

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

Line 974: l_Prev_Status ad_long_column_conversions.status%TYPE ;

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

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

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

Line 982: FROM ad_long_column_conversions

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

Line 991: UPDATE ad_long_column_conversions

987:
988: --
989: -- Update status of the table to the prior status.
990: --
991: UPDATE ad_long_column_conversions
992: SET status = l_Prev_Status
993: WHERE schema_name = p_Schema
994: AND table_name = p_Table_Name;
995: