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_VALIDATE dependencies on SY_PURG_DEF

Line 148: p_purge_type sy_purg_def.purge_type%TYPE) IS

144:
145: /***********************************************************/
146:
147: PROCEDURE checksql(p_purge_id sy_purg_mst.purge_id%TYPE,
148: p_purge_type sy_purg_def.purge_type%TYPE) IS
149: -- used for debugging... checks sql syntax
150:
151: CURSOR l_sql_cur(c_purge_type sy_purg_def.purge_type%TYPE) IS
152: SELECT sqlstatement

Line 151: CURSOR l_sql_cur(c_purge_type sy_purg_def.purge_type%TYPE) IS

147: PROCEDURE checksql(p_purge_id sy_purg_mst.purge_id%TYPE,
148: p_purge_type sy_purg_def.purge_type%TYPE) IS
149: -- used for debugging... checks sql syntax
150:
151: CURSOR l_sql_cur(c_purge_type sy_purg_def.purge_type%TYPE) IS
152: SELECT sqlstatement
153: FROM sy_purg_def SD
154: WHERE SD.purge_type = c_purge_type;
155:

Line 153: FROM sy_purg_def SD

149: -- used for debugging... checks sql syntax
150:
151: CURSOR l_sql_cur(c_purge_type sy_purg_def.purge_type%TYPE) IS
152: SELECT sqlstatement
153: FROM sy_purg_def SD
154: WHERE SD.purge_type = c_purge_type;
155:
156: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
157: l_cursor INTEGER;

Line 156: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

152: SELECT sqlstatement
153: FROM sy_purg_def SD
154: WHERE SD.purge_type = c_purge_type;
155:
156: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
157: l_cursor INTEGER;
158:
159: BEGIN
160: