APPS.AMS_DM_SCORE_RESULTS_PKG dependencies on AMS_DM_SCORE_RESULTS

Line 1: PACKAGE BODY AMS_DM_SCORE_RESULTS_PKG as

1: PACKAGE BODY AMS_DM_SCORE_RESULTS_PKG as
2: /* $Header: amstdrsb.pls 120.1 2005/06/15 23:58:16 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_SCORE_RESULTS_PKG

2: /* $Header: amstdrsb.pls 120.1 2005/06/15 23:58:16 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_SCORE_RESULTS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 24-Jan-2001 choang Created.

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_SCORE_RESULTS_PKG';

20: -- End of Comments
21: -- ===============================================================
22:
23:
24: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DM_SCORE_RESULTS_PKG';
25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstdrsb.pls';
26:
27:
28: ----------------------------------------------------------

Line 72: INSERT INTO AMS_DM_SCORE_RESULTS(

68:
69: px_object_version_number := 1;
70:
71:
72: INSERT INTO AMS_DM_SCORE_RESULTS(
73: score_result_id,
74: last_update_date,
75: last_updated_by,
76: creation_date,

Line 133: Update AMS_DM_SCORE_RESULTS

129: p_confidence NUMBER)
130:
131: IS
132: BEGIN
133: Update AMS_DM_SCORE_RESULTS
134: SET
135: score_result_id = DECODE( p_score_result_id, FND_API.g_miss_num, score_result_id, p_score_result_id),
136: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
137: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 173: DELETE FROM AMS_DM_SCORE_RESULTS

169: PROCEDURE Delete_Row(
170: p_SCORE_RESULT_ID NUMBER)
171: IS
172: BEGIN
173: DELETE FROM AMS_DM_SCORE_RESULTS
174: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID;
175: If (SQL%NOTFOUND) then
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: End If;

Line 215: FROM AMS_DM_SCORE_RESULTS

211:
212: IS
213: CURSOR C IS
214: SELECT *
215: FROM AMS_DM_SCORE_RESULTS
216: WHERE SCORE_RESULT_ID = p_SCORE_RESULT_ID
217: FOR UPDATE of SCORE_RESULT_ID NOWAIT;
218: Recinfo C%ROWTYPE;
219: BEGIN

Line 271: END AMS_DM_SCORE_RESULTS_PKG;

267: APP_EXCEPTION.RAISE_EXCEPTION;
268: END IF;
269: END Lock_Row;
270:
271: END AMS_DM_SCORE_RESULTS_PKG;