[Home] [Help]
29: P_ATTRIBUTE14 in VARCHAR2,
30: P_ATTRIBUTE15 in VARCHAR2
31: ) is
32:
33: cursor C is select ROWID from CSD_RULE_CONDITIONS_B
34: where RULE_CONDITION_ID = PX_RULE_CONDITION_ID
35: ;
36:
37: begin
39: select CSD_RULE_CONDITIONS_S1.nextval
40: into PX_RULE_CONDITION_ID
41: from dual;
42:
43: insert into CSD_RULE_CONDITIONS_B (
44: RULE_CONDITION_ID,
45: OBJECT_VERSION_NUMBER,
46: CREATION_DATE,
47: CREATED_BY,
135: P_OBJECT_VERSION_NUMBER in NUMBER
136: ) is
137: cursor c is select
138: OBJECT_VERSION_NUMBER
139: from CSD_RULE_CONDITIONS_B
140: where RULE_CONDITION_ID = P_RULE_CONDITION_ID
141: for update of RULE_CONDITION_ID nowait;
142: recinfo c%rowtype;
143:
204: P_ATTRIBUTE14 in VARCHAR2,
205: P_ATTRIBUTE15 in VARCHAR2
206: ) is
207: begin
208: update CSD_RULE_CONDITIONS_B set
209: OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
210: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
211: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
212: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
264: if (sql%notfound) then
265: raise no_data_found;
266: end if;
267:
268: delete from CSD_RULE_CONDITIONS_B
269: where RULE_CONDITION_ID = P_RULE_CONDITION_ID;
270:
271: if (sql%notfound) then
272: raise no_data_found;
278: begin
279: delete from CSD_RULE_CONDITIONS_TL T
280: where not exists
281: (select NULL
282: from CSD_RULE_CONDITIONS_B B
283: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
284: );
285:
286: update CSD_RULE_CONDITIONS_TL T set (