APPS.IEX_SCORE_COMP_DET_PKG dependencies on IEX_SCORE_COMP_DET

Line 1: PACKAGE BODY IEX_SCORE_COMP_DET_PKG AS

1: PACKAGE BODY IEX_SCORE_COMP_DET_PKG AS
2: /* $Header: iextscdb.pls 120.2 2004/10/28 16:06:46 clchang ship $ */
3:
4: /* Insert_Row procedure */
5: PG_DEBUG NUMBER(2) ;

Line 26: CURSOR C IS SELECT ROWID FROM IEX_SCORE_COMP_DET

22: ,p_RANGE_LOW NUMBER
23: ,p_RANGE_HIGH NUMBER
24: ,p_SCORE_COMPONENT_ID NUMBER
25: ) IS
26: CURSOR C IS SELECT ROWID FROM IEX_SCORE_COMP_DET
27: WHERE SCORE_COMP_DET_ID = p_SCORE_COMP_DET_ID;
28:
29: BEGIN
30: INSERT INTO IEX_SCORE_COMP_DET

Line 30: INSERT INTO IEX_SCORE_COMP_DET

26: CURSOR C IS SELECT ROWID FROM IEX_SCORE_COMP_DET
27: WHERE SCORE_COMP_DET_ID = p_SCORE_COMP_DET_ID;
28:
29: BEGIN
30: INSERT INTO IEX_SCORE_COMP_DET
31: (
32: SCORE_COMP_DET_ID
33: ,OBJECT_VERSION_NUMBER
34: ,PROGRAM_ID

Line 87: UPDATE IEX_SCORE_COMP_DET SET

83: ,p_RANGE_HIGH NUMBER
84: ,p_SCORE_COMPONENT_ID NUMBER
85: ) IS
86: BEGIN
87: UPDATE IEX_SCORE_COMP_DET SET
88: SCORE_COMP_DET_ID = p_SCORE_COMP_DET_ID
89: ,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
90: ,PROGRAM_ID = p_PROGRAM_ID
91: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE

Line 111: DELETE FROM IEX_SCORE_COMP_DET

107:
108: /* Delete_Row procedure */
109: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
110: BEGIN
111: DELETE FROM IEX_SCORE_COMP_DET
112: WHERE rowid = x_rowid;
113:
114: if (sql%notfound) then
115: raise no_data_found;

Line 135: CURSOR C IS SELECT * FROM IEX_SCORE_COMP_DET

131: ,p_RANGE_LOW NUMBER
132: ,p_RANGE_HIGH NUMBER
133: ,p_SCORE_COMPONENT_ID NUMBER
134: ) IS
135: CURSOR C IS SELECT * FROM IEX_SCORE_COMP_DET
136: WHERE rowid = x_rowid
137: FOR UPDATE of SCORE_COMP_DET_ID NOWAIT;
138: Recinfo C%ROWTYPE;
139: BEGIN