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.GMA_PURGE_DDL dependencies on USER_SOURCE

Line 697: l_countstatement user_source.text%TYPE;

693: PROCEDURE coalescetablespace
694: (p_purge_id sy_purg_mst.purge_id%TYPE,
695: p_tablespace_name user_tablespaces.tablespace_name%TYPE,
696: p_debug_flag BOOLEAN) IS
697: l_countstatement user_source.text%TYPE;
698: l_alterstatement user_source.text%TYPE;
699:
700: l_cursor INTEGER;
701: l_currval INTEGER;

Line 698: l_alterstatement user_source.text%TYPE;

694: (p_purge_id sy_purg_mst.purge_id%TYPE,
695: p_tablespace_name user_tablespaces.tablespace_name%TYPE,
696: p_debug_flag BOOLEAN) IS
697: l_countstatement user_source.text%TYPE;
698: l_alterstatement user_source.text%TYPE;
699:
700: l_cursor INTEGER;
701: l_currval INTEGER;
702: l_lastval INTEGER;

Line 826: l_sqlstatement user_source.text%TYPE := NULL;

822: l_current_idx user_indexes.index_name%TYPE := NULL;
823:
824: -- These variables hold text fragments during index create statement
825: -- construction
826: l_sqlstatement user_source.text%TYPE := NULL;
827: l_runstatement user_source.text%TYPE := NULL;
828: l_sqlfront user_source.text%TYPE := NULL;
829: l_sqlback user_source.text%TYPE := NULL;
830: l_column_list user_source.text%TYPE := NULL;

Line 827: l_runstatement user_source.text%TYPE := NULL;

823:
824: -- These variables hold text fragments during index create statement
825: -- construction
826: l_sqlstatement user_source.text%TYPE := NULL;
827: l_runstatement user_source.text%TYPE := NULL;
828: l_sqlfront user_source.text%TYPE := NULL;
829: l_sqlback user_source.text%TYPE := NULL;
830: l_column_list user_source.text%TYPE := NULL;
831:

Line 828: l_sqlfront user_source.text%TYPE := NULL;

824: -- These variables hold text fragments during index create statement
825: -- construction
826: l_sqlstatement user_source.text%TYPE := NULL;
827: l_runstatement user_source.text%TYPE := NULL;
828: l_sqlfront user_source.text%TYPE := NULL;
829: l_sqlback user_source.text%TYPE := NULL;
830: l_column_list user_source.text%TYPE := NULL;
831:
832: l_cursor INTEGER;

Line 829: l_sqlback user_source.text%TYPE := NULL;

825: -- construction
826: l_sqlstatement user_source.text%TYPE := NULL;
827: l_runstatement user_source.text%TYPE := NULL;
828: l_sqlfront user_source.text%TYPE := NULL;
829: l_sqlback user_source.text%TYPE := NULL;
830: l_column_list user_source.text%TYPE := NULL;
831:
832: l_cursor INTEGER;
833:

Line 830: l_column_list user_source.text%TYPE := NULL;

826: l_sqlstatement user_source.text%TYPE := NULL;
827: l_runstatement user_source.text%TYPE := NULL;
828: l_sqlfront user_source.text%TYPE := NULL;
829: l_sqlback user_source.text%TYPE := NULL;
830: l_column_list user_source.text%TYPE := NULL;
831:
832: l_cursor INTEGER;
833:
834: BEGIN

Line 992: l_sqlstatement user_source.text%TYPE;

988: p_appl_short_name fnd_application.application_short_name%TYPE,
989: p_debug_flag BOOLEAN) IS
990:
991: l_cursor INTEGER;
992: l_sqlstatement user_source.text%TYPE;
993: l_indexname user_source.text%TYPE;
994: l_errortext user_source.text%TYPE;
995: l_parse_success BOOLEAN;
996:

Line 993: l_indexname user_source.text%TYPE;

989: p_debug_flag BOOLEAN) IS
990:
991: l_cursor INTEGER;
992: l_sqlstatement user_source.text%TYPE;
993: l_indexname user_source.text%TYPE;
994: l_errortext user_source.text%TYPE;
995: l_parse_success BOOLEAN;
996:
997: BEGIN

Line 994: l_errortext user_source.text%TYPE;

990:
991: l_cursor INTEGER;
992: l_sqlstatement user_source.text%TYPE;
993: l_indexname user_source.text%TYPE;
994: l_errortext user_source.text%TYPE;
995: l_parse_success BOOLEAN;
996:
997: BEGIN
998: