[Home] [Help]
33: P_SOO_ATTRIBUTE2 in VARCHAR2,
34: P_SOO_ATTRIBUTE3 in VARCHAR2
35: ) is
36:
37: cursor C is select ROWID from CSD_RULE_CONDITIONS_B
38: where RULE_CONDITION_ID = PX_RULE_CONDITION_ID
39: ;
40:
41: begin
43: select CSD_RULE_CONDITIONS_S1.nextval
44: into PX_RULE_CONDITION_ID
45: from dual;
46:
47: insert into CSD_RULE_CONDITIONS_B (
48: RULE_CONDITION_ID,
49: OBJECT_VERSION_NUMBER,
50: CREATION_DATE,
51: CREATED_BY,
147: P_OBJECT_VERSION_NUMBER in NUMBER
148: ) is
149: cursor c is select
150: OBJECT_VERSION_NUMBER
151: from CSD_RULE_CONDITIONS_B
152: where RULE_CONDITION_ID = P_RULE_CONDITION_ID
153: for update of RULE_CONDITION_ID nowait;
154: recinfo c%rowtype;
155:
220: P_SOO_ATTRIBUTE2 in VARCHAR2,
221: P_SOO_ATTRIBUTE3 in VARCHAR2
222: ) is
223: begin
224: update CSD_RULE_CONDITIONS_B set
225: OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
226: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)
227: ,CREATION_DATE = decode( P_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, P_CREATION_DATE)
228: ,LAST_UPDATED_BY = decode( P_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, P_LAST_UPDATED_BY)
284: if (sql%notfound) then
285: raise no_data_found;
286: end if;
287:
288: delete from CSD_RULE_CONDITIONS_B
289: where RULE_CONDITION_ID = P_RULE_CONDITION_ID;
290:
291: if (sql%notfound) then
292: raise no_data_found;
298: begin
299: delete from CSD_RULE_CONDITIONS_TL T
300: where not exists
301: (select NULL
302: from CSD_RULE_CONDITIONS_B B
303: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
304: );
305:
306: update CSD_RULE_CONDITIONS_TL T set (