APPS.CSD_RETURN_TYPES_PKG dependencies on CSD_RETURN_TYPES_B

Line 19: cursor C is select ROWID from CSD_RETURN_TYPES_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_TYPES_B
20: where RETURN_TYPE_ID = X_RETURN_TYPE_ID
21: ;
22: begin
23: insert into CSD_RETURN_TYPES_B (

Line 23: insert into CSD_RETURN_TYPES_B (

19: cursor C is select ROWID from CSD_RETURN_TYPES_B
20: where RETURN_TYPE_ID = X_RETURN_TYPE_ID
21: ;
22: begin
23: insert into CSD_RETURN_TYPES_B (
24: ACTIVE_START_DATE,
25: ACTIVE_END_DATE,
26: OBJECT_VERSION_NUMBER,
27: RETURN_TYPE_ID,

Line 104: from CSD_RETURN_TYPES_B

100: ACTIVE_START_DATE,
101: ACTIVE_END_DATE,
102: OBJECT_VERSION_NUMBER,
103: REPAIR_TYPE_ID
104: from CSD_RETURN_TYPES_B
105: where RETURN_TYPE_ID = X_RETURN_TYPE_ID
106: for update of RETURN_TYPE_ID nowait;
107: recinfo c%rowtype;
108:

Line 172: update CSD_RETURN_TYPES_B set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update CSD_RETURN_TYPES_B set
173: ACTIVE_START_DATE = X_ACTIVE_START_DATE,
174: ACTIVE_END_DATE = X_ACTIVE_END_DATE,
175: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
176: REPAIR_TYPE_ID = X_REPAIR_TYPE_ID,

Line 213: delete from CSD_RETURN_TYPES_B

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: delete from CSD_RETURN_TYPES_B
214: where RETURN_TYPE_ID = X_RETURN_TYPE_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 227: from CSD_RETURN_TYPES_B B

223: begin
224: delete from CSD_RETURN_TYPES_TL T
225: where not exists
226: (select NULL
227: from CSD_RETURN_TYPES_B B
228: where B.RETURN_TYPE_ID = T.RETURN_TYPE_ID
229: );
230:
231: update CSD_RETURN_TYPES_TL T set (