APPS.CS_CF_FLOWS_PKG dependencies on CS_CF_FLOWS_B

Line 33: cursor C is select ROWID from CS_CF_FLOWS_B

29: X_ATTRIBUTE15 in VARCHAR2,
30: X_SEEDED_FLAG in VARCHAR2
31:
32: ) is
33: cursor C is select ROWID from CS_CF_FLOWS_B
34: where FLOW_ID = X_FLOW_ID
35: ;
36: begin
37: insert into CS_CF_FLOWS_B (

Line 37: insert into CS_CF_FLOWS_B (

33: cursor C is select ROWID from CS_CF_FLOWS_B
34: where FLOW_ID = X_FLOW_ID
35: ;
36: begin
37: insert into CS_CF_FLOWS_B (
38: OBJECT_VERSION_NUMBER,
39: FLOW_ID,
40: FLOW_TYPE_CODE,
41: CREATION_DATE,

Line 173: from CS_CF_FLOWS_B

169: ATTRIBUTE13,
170: ATTRIBUTE14,
171: ATTRIBUTE15,
172: SEEDED_FLAG
173: from CS_CF_FLOWS_B
174: where FLOW_ID = X_FLOW_ID
175: for update of FLOW_ID nowait;
176: recinfo c%rowtype;
177:

Line 282: update CS_CF_FLOWS_B set

278: X_SEEDED_FLAG in VARCHAR2
279:
280: ) is
281: begin
282: update CS_CF_FLOWS_B set
283: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
284: FLOW_TYPE_CODE = X_FLOW_TYPE_CODE,
285: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
286: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 336: delete from CS_CF_FLOWS_B

332: if (sql%notfound) then
333: raise no_data_found;
334: end if;
335:
336: delete from CS_CF_FLOWS_B
337: where FLOW_ID = X_FLOW_ID;
338:
339: if (sql%notfound) then
340: raise no_data_found;

Line 350: from CS_CF_FLOWS_B B

346: begin
347: delete from CS_CF_FLOWS_TL T
348: where not exists
349: (select NULL
350: from CS_CF_FLOWS_B B
351: where B.FLOW_ID = T.FLOW_ID
352: );
353:
354: update CS_CF_FLOWS_TL T set (

Line 450: from CS_CF_FLOWS_B

446: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
447:
448: select LAST_UPDATED_BY, LAST_UPDATE_DATE
449: into db_luby, db_ludate
450: from CS_CF_FLOWS_B
451: where flow_id = X_FLOW_ID;
452:
453: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
454: -- Update existing row

Line 489: FROM CS_CF_FLOWS_B

485: l_attribute12,
486: l_attribute13,
487: l_attribute14,
488: l_attribute15
489: FROM CS_CF_FLOWS_B
490: WHERE flow_id = X_FLOW_ID
491: FOR UPDATE;
492:
493: CS_CF_FLOWS_PKG.Update_Row(