APPS.FND_OAM_DSCRAM_STATS_PKG dependencies on FND_OAM_DSCRAM_STATS

Line 1: PACKAGE BODY FND_OAM_DSCRAM_STATS_PKG as

1: PACKAGE BODY FND_OAM_DSCRAM_STATS_PKG as
2: /* $Header: AFOAMDSSTATB.pls 120.5 2006/06/07 17:56:52 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 33: INTO fnd_oam_dscram_stats (STAT_ID,

29: x_return_msg := '';
30:
31: --do the insert
32: INSERT
33: INTO fnd_oam_dscram_stats (STAT_ID,
34: RUN_STAT_ID,
35: SOURCE_OBJECT_TYPE,
36: SOURCE_OBJECT_ID,
37: OBJECT_START,

Line 45: VALUES (FND_OAM_DSCRAM_STATS_S.NEXTVAL,

41: CREATION_DATE,
42: LAST_UPDATED_BY,
43: LAST_UPDATE_DATE,
44: LAST_UPDATE_LOGIN)
45: VALUES (FND_OAM_DSCRAM_STATS_S.NEXTVAL,
46: p_run_stat_id,
47: p_source_object_type,
48: p_source_object_id,
49: p_start_time,

Line 89: UPDATE fnd_oam_dscram_stats

85: x_return_status := FND_API.G_RET_STS_ERROR;
86: x_return_msg := '';
87:
88: --do the update
89: UPDATE fnd_oam_dscram_stats
90: SET object_end = p_end_time,
91: postend_object_status = p_postend_status,
92: message = p_end_message,
93: last_updated_by = fnd_global.user_id,

Line 136: SELECT FND_OAM_DSCRAM_STATS_S.NEXTVAL

132: x_return_status := FND_API.G_RET_STS_ERROR;
133: x_return_msg := '';
134:
135: --select the stat_id first so we can use it as the run_stat_id also
136: SELECT FND_OAM_DSCRAM_STATS_S.NEXTVAL
137: INTO l_run_stat_id
138: FROM DUAL;
139:
140: --can't use INTERNAL_CREATE since we are creating the run_stat_id at the same time

Line 142: INTO fnd_oam_dscram_stats (STAT_ID,

138: FROM DUAL;
139:
140: --can't use INTERNAL_CREATE since we are creating the run_stat_id at the same time
141: INSERT
142: INTO fnd_oam_dscram_stats (STAT_ID,
143: RUN_STAT_ID,
144: SOURCE_OBJECT_TYPE,
145: SOURCE_OBJECT_ID,
146: OBJECT_START,

Line 384: FROM fnd_oam_dscram_stats

380: l_stat_id NUMBER;
381: BEGIN
382: SELECT stat_id
383: INTO l_stat_id
384: FROM fnd_oam_dscram_stats
385: WHERE run_stat_id = p_run_stat_id
386: AND source_object_type = p_source_object_type
387: AND source_object_id = p_source_object_id;
388:

Line 415: END FND_OAM_DSCRAM_STATS_PKG;

411: fnd_oam_debug.log(6, l_ctxt, 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
412: RETURN FALSE;
413: END;
414:
415: END FND_OAM_DSCRAM_STATS_PKG;