APPS.CSD_RETURN_RULES_PKG dependencies on CSD_RETURN_RULES_B

Line 19: cursor C is select ROWID from CSD_RETURN_RULES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from CSD_RETURN_RULES_B
20: where RULE_ID = X_RULE_ID
21: ;
22: begin
23: insert into CSD_RETURN_RULES_B (

Line 23: insert into CSD_RETURN_RULES_B (

19: cursor C is select ROWID from CSD_RETURN_RULES_B
20: where RULE_ID = X_RULE_ID
21: ;
22: begin
23: insert into CSD_RETURN_RULES_B (
24: OBJECT_VERSION_NUMBER,
25: SOURCE_ID,
26: SOURCE_TYPE,
27: PRECEDENCE,

Line 105: from CSD_RETURN_RULES_B

101: SOURCE_ID,
102: SOURCE_TYPE,
103: PRECEDENCE,
104: VALUE
105: from CSD_RETURN_RULES_B
106: where RULE_ID = X_RULE_ID
107: for update of RULE_ID nowait;
108: recinfo c%rowtype;
109:

Line 171: update CSD_RETURN_RULES_B set

167: X_LAST_UPDATED_BY in NUMBER,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: begin
171: update CSD_RETURN_RULES_B set
172: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
173: SOURCE_ID = X_SOURCE_ID,
174: SOURCE_TYPE = X_SOURCE_TYPE,
175: PRECEDENCE = X_PRECEDENCE,

Line 212: delete from CSD_RETURN_RULES_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from CSD_RETURN_RULES_B
213: where RULE_ID = X_RULE_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from CSD_RETURN_RULES_B B

222: begin
223: delete from CSD_RETURN_RULES_TL T
224: where not exists
225: (select NULL
226: from CSD_RETURN_RULES_B B
227: where B.RULE_ID = T.RULE_ID
228: );
229:
230: update CSD_RETURN_RULES_TL T set (