APPS.CSD_RULES_PKG dependencies on CSD_RULES_B

Line 38: cursor C is select ROWID from CSD_RULES_B

34: P_ATTRIBUTE14 in VARCHAR2,
35: P_ATTRIBUTE15 in VARCHAR2
36: ) is
37:
38: cursor C is select ROWID from CSD_RULES_B
39: where RULE_ID = PX_RULE_ID
40: ;
41:
42: begin

Line 48: insert into CSD_RULES_B (

44: select CSD_RULES_S1.nextval
45: into PX_RULE_ID
46: from dual;
47:
48: insert into CSD_RULES_B (
49: RULE_ID,
50: OBJECT_VERSION_NUMBER,
51: CREATION_DATE,
52: CREATED_BY,

Line 154: from CSD_RULES_B

150: P_OBJECT_VERSION_NUMBER in NUMBER
151: ) is
152: cursor c is select
153: OBJECT_VERSION_NUMBER
154: from CSD_RULES_B
155: where RULE_ID = P_RULE_ID
156: for update of RULE_ID nowait;
157: recinfo c%rowtype;
158:

Line 228: update CSD_RULES_B set

224: P_ATTRIBUTE14 in VARCHAR2,
225: P_ATTRIBUTE15 in VARCHAR2
226: ) is
227: begin
228: update CSD_RULES_B set
229: OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
230: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
231: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
232: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)

Line 293: delete from CSD_RULES_B

289: if (sql%notfound) then
290: raise no_data_found;
291: end if;
292:
293: delete from CSD_RULES_B
294: where RULE_ID = P_RULE_ID;
295:
296: if (sql%notfound) then
297: raise no_data_found;

Line 307: from CSD_RULES_B B

303: begin
304: delete from CSD_RULES_TL T
305: where not exists
306: (select NULL
307: from CSD_RULES_B B
308: where B.RULE_ID = T.RULE_ID
309: );
310:
311: update CSD_RULES_TL T set (