[Home] [Help]
1: PACKAGE BODY GCS_CONS_ENG_RUNS_PKG AS
2: /* $Header: gcs_eng_runb.pls 120.1 2005/10/30 05:18:01 appldev noship $ */
3:
4: -- Declaration of Global Variables
5: g_api VARCHAR2(200) := 'gcs.plsql.GCS_CONS_ENG_RUNS_PKG';
1: PACKAGE BODY GCS_CONS_ENG_RUNS_PKG AS
2: /* $Header: gcs_eng_runb.pls 120.1 2005/10/30 05:18:01 appldev noship $ */
3:
4: -- Declaration of Global Variables
5: g_api VARCHAR2(200) := 'gcs.plsql.GCS_CONS_ENG_RUNS_PKG';
6: -- End of Global Variables
7:
8: PROCEDURE insert_row ( p_run_name IN VARCHAR2,
9: p_hierarchy_id IN NUMBER,
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
26: (
27: RUN_NAME,
28: HIERARCHY_ID,
29: PROCESS_METHOD,
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
97: SET most_recent_flag = p_most_recent_flag,
98: status_code = NVL(p_status_code,status_code),
99: end_time = NVL(p_end_time,end_time),
100: last_update_date = sysdate,
110: COMMIT;
111:
112: END;
113:
114: END GCS_CONS_ENG_RUNS_PKG;
115: