APPS.CSD_RET_RULE_CONDITIONS_PKG dependencies on CSD_RET_RULE_CONDITIONS_B

Line 31: cursor C is select ROWID from CSD_RET_RULE_CONDITIONS_B

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from CSD_RET_RULE_CONDITIONS_B
32: where RULE_CONDITION_ID = X_RULE_CONDITION_ID
33: ;
34: begin
35: insert into CSD_RET_RULE_CONDITIONS_B (

Line 35: insert into CSD_RET_RULE_CONDITIONS_B (

31: cursor C is select ROWID from CSD_RET_RULE_CONDITIONS_B
32: where RULE_CONDITION_ID = X_RULE_CONDITION_ID
33: ;
34: begin
35: insert into CSD_RET_RULE_CONDITIONS_B (
36: RULE_CONDITION_ID,
37: ATTRIBUTE10,
38: ATTRIBUTE9,
39: ATTRIBUTE14,

Line 166: from CSD_RET_RULE_CONDITIONS_B

162: RETURN_RULE_ID,
163: ATTRIBUTE11,
164: ATTRIBUTE12,
165: ATTRIBUTE13
166: from CSD_RET_RULE_CONDITIONS_B
167: where RULE_CONDITION_ID = X_RULE_CONDITION_ID
168: for update of RULE_CONDITION_ID nowait;
169: recinfo c%rowtype;
170:

Line 269: update CSD_RET_RULE_CONDITIONS_B set

265: X_LAST_UPDATED_BY in NUMBER,
266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: update CSD_RET_RULE_CONDITIONS_B set
270: ATTRIBUTE10 = X_ATTRIBUTE10,
271: ATTRIBUTE9 = X_ATTRIBUTE9,
272: ATTRIBUTE14 = X_ATTRIBUTE14,
273: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 322: delete from CSD_RET_RULE_CONDITIONS_B

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: delete from CSD_RET_RULE_CONDITIONS_B
323: where RULE_CONDITION_ID = X_RULE_CONDITION_ID;
324:
325: if (sql%notfound) then
326: raise no_data_found;

Line 336: from CSD_RET_RULE_CONDITIONS_B B

332: begin
333: delete from CSD_RET_RULE_CONDITIONS_TL T
334: where not exists
335: (select NULL
336: from CSD_RET_RULE_CONDITIONS_B B
337: where B.RULE_CONDITION_ID = T.RULE_CONDITION_ID
338: );
339:
340: update CSD_RET_RULE_CONDITIONS_TL T set (