APPS.IEX_STATUS_RULE_PKG dependencies on IEX_CUST_STATUS_RULES

Line 23: CURSOR C IS SELECT ROWID FROM IEX_CUST_STATUS_RULES

19: ,p_SECURITY_GROUP_ID NUMBER
20: ,p_PROGRAM_ID NUMBER
21: ,p_OBJECT_VERSION_NUMBER NUMBER
22: ) IS
23: CURSOR C IS SELECT ROWID FROM IEX_CUST_STATUS_RULES
24: WHERE STATUS_RULE_ID = p_STATUS_RULE_ID;
25:
26: BEGIN
27: INSERT INTO IEX_CUST_STATUS_RULES

Line 27: INSERT INTO IEX_CUST_STATUS_RULES

23: CURSOR C IS SELECT ROWID FROM IEX_CUST_STATUS_RULES
24: WHERE STATUS_RULE_ID = p_STATUS_RULE_ID;
25:
26: BEGIN
27: INSERT INTO IEX_CUST_STATUS_RULES
28: (
29: STATUS_RULE_ID
30: ,STATUS_RULE_NAME
31: ,STATUS_RULE_DESCRIPTION

Line 87: UPDATE IEX_CUST_STATUS_RULES SET

83: ,p_PROGRAM_ID NUMBER
84: ,p_OBJECT_VERSION_NUMBER NUMBER
85: ) IS
86: BEGIN
87: UPDATE IEX_CUST_STATUS_RULES SET
88: STATUS_RULE_ID = p_STATUS_RULE_ID
89: ,STATUS_RULE_NAME = p_STATUS_RULE_NAME
90: ,STATUS_RULE_DESCRIPTION = p_STATUS_RULE_DESCRIPTION
91: ,START_DATE = p_START_DATE

Line 112: DELETE FROM IEX_CUST_STATUS_RULES

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

Line 137: CURSOR C IS SELECT * FROM IEX_CUST_STATUS_RULES

133: ,p_PROGRAM_ID NUMBER
134: ,p_SECURITY_GROUP_ID NUMBER
135: ,p_OBJECT_VERSION_NUMBER NUMBER
136: ) IS
137: CURSOR C IS SELECT * FROM IEX_CUST_STATUS_RULES
138: WHERE rowid = x_rowid
139: FOR UPDATE of STATUS_RULE_ID NOWAIT;
140: Recinfo C%ROWTYPE;
141: BEGIN