APPS.CS_CF_FLOW_PAGES_PKG dependencies on CS_CF_FLOW_PAGES_B

Line 32: cursor C is select ROWID from CS_CF_FLOW_PAGES_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from CS_CF_FLOW_PAGES_B
33: where FLOW_ID = X_FLOW_ID
34: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
35: ;
36: begin

Line 37: insert into CS_CF_FLOW_PAGES_B (

33: where FLOW_ID = X_FLOW_ID
34: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
35: ;
36: begin
37: insert into CS_CF_FLOW_PAGES_B (
38: FLOW_ID,
39: FLOW_TYPE_PAGE_ID,
40: ENABLED_FLAG,
41: OBJECT_VERSION_NUMBER,

Line 174: from CS_CF_FLOW_PAGES_B

170: ATTRIBUTE12,
171: ATTRIBUTE13,
172: ATTRIBUTE14,
173: ATTRIBUTE15
174: from CS_CF_FLOW_PAGES_B
175: where FLOW_ID = X_FLOW_ID
176: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
177: for update of FLOW_ID nowait;
178: recinfo c%rowtype;

Line 282: update CS_CF_FLOW_PAGES_B set

278: X_LAST_UPDATED_BY in NUMBER,
279: X_LAST_UPDATE_LOGIN in NUMBER
280: ) is
281: begin
282: update CS_CF_FLOW_PAGES_B set
283: ENABLED_FLAG = X_ENABLED_FLAG,
284: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
285: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
286: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 339: delete from CS_CF_FLOW_PAGES_B

335: if (sql%notfound) then
336: raise no_data_found;
337: end if;
338:
339: delete from CS_CF_FLOW_PAGES_B
340: where FLOW_ID = X_FLOW_ID
341: and FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID;
342:
343: if (sql%notfound) then

Line 354: from CS_CF_FLOW_PAGES_B B

350: begin
351: delete from CS_CF_FLOW_PAGES_TL T
352: where not exists
353: (select NULL
354: from CS_CF_FLOW_PAGES_B B
355: where B.FLOW_ID = T.FLOW_ID
356: and B.FLOW_TYPE_PAGE_ID = T.FLOW_TYPE_PAGE_ID
357: );
358:

Line 460: from CS_CF_FLOW_PAGES_B

456: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
457:
458: select LAST_UPDATED_BY, LAST_UPDATE_DATE
459: into db_luby, db_ludate
460: from CS_CF_FLOW_PAGES_B
461: where flow_id = X_FLOW_ID
462: and flow_type_page_id = X_FLOW_TYPE_PAGE_ID;
463:
464: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

Line 500: FROM CS_CF_FLOW_PAGES_B

496: l_attribute12,
497: l_attribute13,
498: l_attribute14,
499: l_attribute15
500: FROM CS_CF_FLOW_PAGES_B
501: WHERE flow_id = X_FLOW_ID
502: and flow_type_page_id = X_FLOW_TYPE_PAGE_ID
503: FOR UPDATE ;
504: