APPS.IEX_SCORES_PKG dependencies on IEX_SCORES

Line 1: PACKAGE BODY IEX_SCORES_PKG AS

1: PACKAGE BODY IEX_SCORES_PKG AS
2: /* $Header: iextscob.pls 120.3 2004/10/28 17:51:46 clchang ship $ */
3:
4: /* Insert_Row procedure */
5: PG_DEBUG NUMBER(2) ;

Line 33: CURSOR C IS SELECT ROWID FROM IEX_SCORES

29: ,p_SCORE_RANGE_LOW VARCHAR2
30: ,p_SCORE_RANGE_HIGH VARCHAR2
31: ,p_OUT_OF_RANGE_RULE VARCHAR2
32: ) IS
33: CURSOR C IS SELECT ROWID FROM IEX_SCORES
34: WHERE SCORE_ID = p_SCORE_ID;
35:
36: l_status_determination varchar2(1);
37: l_weight_required varchar2(3);

Line 65: INSERT INTO IEX_SCORES

61: IF (l_out_of_range_rule is null) then
62: l_out_of_range_rule := 'CLOSEST';
63: end if;
64:
65: INSERT INTO IEX_SCORES
66: (
67: SCORE_ID
68: ,SCORE_NAME
69: ,SECURITY_GROUP_ID

Line 182: UPDATE IEX_SCORES SET

178: IF (l_out_of_range_rule is null) then
179: l_out_of_range_rule := 'CLOSEST';
180: end if;
181:
182: UPDATE IEX_SCORES SET
183: SCORE_ID = p_SCORE_ID
184: ,SCORE_NAME = p_SCORE_NAME
185: ,SECURITY_GROUP_ID = p_SECURITY_GROUP_ID
186: ,SCORE_DESCRIPTION = p_SCORE_DESCRIPTION

Line 217: DELETE FROM IEX_SCORES

213:
214: /* Delete_Row procedure */
215: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
216: BEGIN
217: DELETE FROM IEX_SCORES
218: WHERE rowid = x_rowid;
219:
220: if (sql%notfound) then
221: raise no_data_found;

Line 252: CURSOR C IS SELECT * FROM IEX_SCORES

248: ,p_SCORE_RANGE_LOW VARCHAR2
249: ,p_SCORE_RANGE_HIGH VARCHAR2
250: ,p_OUT_OF_RANGE_RULE VARCHAR2
251: ) IS
252: CURSOR C IS SELECT * FROM IEX_SCORES
253: WHERE rowid = x_rowid
254: FOR UPDATE of SCORE_ID NOWAIT;
255: Recinfo C%ROWTYPE;
256: BEGIN