17:
18: IS PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<
23: END IF;
24:
25: INSERT INTO gcs_cons_eng_runs
18: IS PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<
24:
25: INSERT INTO gcs_cons_eng_runs
26: (
71: sysdate,
72: p_request_id
73: );
74:
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<
77: END IF;
78:
79: COMMIT;
72: p_request_id
73: );
74:
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<
78:
79: COMMIT;
80:
88:
89: IS PRAGMA AUTONOMOUS_TRANSACTION;
90:
91: BEGIN
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<
94: END IF;
95:
96: UPDATE gcs_cons_eng_runs
89: IS PRAGMA AUTONOMOUS_TRANSACTION;
90:
91: BEGIN
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<
95:
96: UPDATE gcs_cons_eng_runs
97: SET most_recent_flag = p_most_recent_flag,
101: last_updated_by = FND_GLOBAL.USER_ID
102: WHERE run_name = p_run_name
103: AND run_entity_id = p_run_entity_id;
104:
105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<
107: END IF;
108:
109:
102: WHERE run_name = p_run_name
103: AND run_entity_id = p_run_entity_id;
104:
105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<
108:
109:
110: COMMIT;