APPS.IEX_STATUS_RULE_LINE_PKG dependencies on IEX_CU_STS_RL_LINES

Line 22: CURSOR C IS SELECT ROWID FROM IEX_CU_STS_RL_LINES

18: ,p_PROGRAM_ID NUMBER
19: ,p_SECURITY_GROUP_ID NUMBER
20: ,p_OBJECT_VERSION_NUMBER NUMBER
21: ) IS
22: CURSOR C IS SELECT ROWID FROM IEX_CU_STS_RL_LINES
23: WHERE STATUS_RULE_LINE_ID = p_STATUS_RULE_LINE_ID;
24:
25: BEGIN
26: INSERT INTO IEX_CU_STS_RL_LINES

Line 26: INSERT INTO IEX_CU_STS_RL_LINES

22: CURSOR C IS SELECT ROWID FROM IEX_CU_STS_RL_LINES
23: WHERE STATUS_RULE_LINE_ID = p_STATUS_RULE_LINE_ID;
24:
25: BEGIN
26: INSERT INTO IEX_CU_STS_RL_LINES
27: (
28: STATUS_RULE_LINE_ID
29: ,PRIORITY
30: ,DELINQUENCY_STATUS

Line 83: UPDATE IEX_CU_STS_RL_LINES SET

79: ,p_SECURITY_GROUP_ID NUMBER
80: ,p_OBJECT_VERSION_NUMBER NUMBER
81: ) IS
82: BEGIN
83: UPDATE IEX_CU_STS_RL_LINES SET
84: STATUS_RULE_LINE_ID = p_STATUS_RULE_LINE_ID
85: ,PRIORITY = p_PRIORITY
86: ,DELINQUENCY_STATUS = p_DELINQUENCY_STATUS
87: ,STATUS_RULE_ID = p_STATUS_RULE_ID

Line 107: DELETE FROM IEX_CU_STS_RL_LINES

103:
104: /* Delete_Row procedure */
105: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
106: BEGIN
107: DELETE FROM IEX_CU_STS_RL_LINES
108: WHERE rowid = x_rowid;
109:
110: if (sql%notfound) then
111: raise no_data_found;

Line 131: CURSOR C IS SELECT * FROM IEX_CU_STS_RL_LINES

127: ,p_PROGRAM_ID NUMBER
128: ,p_SECURITY_GROUP_ID NUMBER
129: ,p_OBJECT_VERSION_NUMBER NUMBER
130: ) IS
131: CURSOR C IS SELECT * FROM IEX_CU_STS_RL_LINES
132: WHERE rowid = x_rowid
133: FOR UPDATE of STATUS_RULE_LINE_ID NOWAIT;
134: Recinfo C%ROWTYPE;
135: BEGIN