APPS.CSD_FLOW_STATUSES_PKG dependencies on CSD_FLOW_STATUSES_B

Line 37: from CSD_FLOW_STATUSES_B

33: ) is
34:
35: cursor C is
36: select ROWID
37: from CSD_FLOW_STATUSES_B
38: where FLOW_STATUS_ID = PX_FLOW_STATUS_ID;
39:
40: P_ROWID ROWID;
41:

Line 48: insert into CSD_FLOW_STATUSES_B (

44: select CSD_FLOW_STATUSES_S1.nextval
45: into PX_FLOW_STATUS_ID
46: from dual;
47:
48: insert into CSD_FLOW_STATUSES_B (
49: ATTRIBUTE10,
50: ATTRIBUTE11,
51: ATTRIBUTE12,
52: ATTRIBUTE13,

Line 172: from CSD_FLOW_STATUSES_B

168: */
169: ) is
170: cursor c is select
171: OBJECT_VERSION_NUMBER
172: from CSD_FLOW_STATUSES_B
173: where FLOW_STATUS_ID = P_FLOW_STATUS_ID
174: for update of FLOW_STATUS_ID nowait;
175: recinfo c%rowtype;
176:

Line 241: update CSD_FLOW_STATUSES_B set

237: P_LAST_UPDATED_BY in NUMBER,
238: P_LAST_UPDATE_LOGIN in NUMBER
239: ) is
240: begin
241: update CSD_FLOW_STATUSES_B set
242: ATTRIBUTE10 = P_ATTRIBUTE10,
243: ATTRIBUTE11 = P_ATTRIBUTE11,
244: ATTRIBUTE12 = P_ATTRIBUTE12,
245: ATTRIBUTE13 = P_ATTRIBUTE13,

Line 297: delete from CSD_FLOW_STATUSES_B

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: delete from CSD_FLOW_STATUSES_B
298: where FLOW_STATUS_ID = P_FLOW_STATUS_ID;
299:
300: if (sql%notfound) then
301: raise no_data_found;

Line 311: from CSD_FLOW_STATUSES_B B

307: begin
308: delete from CSD_FLOW_STATUSES_TL T
309: where not exists
310: (select NULL
311: from CSD_FLOW_STATUSES_B B
312: where B.FLOW_STATUS_ID = T.FLOW_STATUS_ID
313: );
314:
315: update CSD_FLOW_STATUSES_TL T set (