APPS.GMA_MIGRATION dependencies on GMA_MIGRATION_CONTROL

Line 31: INSERT INTO gma_migration_control

27: v_message_token := 'GMA_MIGRATION_FAILED';
28: RAISE raise_gma_insert_message;
29: ELSE
30: l_pos := 2;
31: INSERT INTO gma_migration_control
32: (application_short_name,
33: run_id,
34: mig_name,
35: mig_start_date

Line 144: UPDATE gma_migration_control

140: v_message_token := 'GMA_MIGRATION_FAIL';
141: RAISE raise_gma_insert_message;
142: END IF;
143:
144: UPDATE gma_migration_control
145: SET mig_end_date = v_mig_end_date
146: WHERE run_id = l_run_id;
147: END IF;
148: l_pos := 2;

Line 193: SELECT run_id from gma_migration_control WHERE mig_name = p_mig_name

189: FUNCTION get_mig_run_id(p_mig_name IN VARCHAR2) RETURN NUMBER IS
190: v_run_id NUMBER;
191:
192: CURSOR c_get_mig_run_id IS
193: SELECT run_id from gma_migration_control WHERE mig_name = p_mig_name
194: AND mig_end_date is NULL
195: ORDER BY run_id desc;
196:
197: BEGIN

Line 211: v_mig_name gma_migration_control.mig_name%TYPE;

207:
208: END get_mig_run_id;
209:
210: FUNCTION get_mig_name(p_run_id IN NUMBER) RETURN VARCHAR2 IS
211: v_mig_name gma_migration_control.mig_name%TYPE;
212:
213: CURSOR c_get_mig_name IS
214: SELECT mig_name from gma_migration_control WHERE run_id = p_run_id
215: ORDER BY run_id desc;

Line 214: SELECT mig_name from gma_migration_control WHERE run_id = p_run_id

210: FUNCTION get_mig_name(p_run_id IN NUMBER) RETURN VARCHAR2 IS
211: v_mig_name gma_migration_control.mig_name%TYPE;
212:
213: CURSOR c_get_mig_name IS
214: SELECT mig_name from gma_migration_control WHERE run_id = p_run_id
215: ORDER BY run_id desc;
216:
217: BEGIN
218: OPEN c_get_mig_name;

Line 323: v_mig_name gma_migration_control.mig_name%TYPE;

319: PROCEDURE run IS
320: l_pos NUMBER := 0;
321: v_run_id NUMBER;
322: new_run_id NUMBER;
323: v_mig_name gma_migration_control.mig_name%TYPE;
324: v_mig_name2 VARCHAR2(80) := NULL;
325:
326: BEGIN
327: l_pos := 1;