APPS.CS_CF_FLOW_TYPE_PAGES_PKG dependencies on CS_CF_FLOW_TYPE_PAGES

Line 1: package body CS_CF_FLOW_TYPE_PAGES_PKG as

1: package body CS_CF_FLOW_TYPE_PAGES_PKG as
2: /* $Header: CSCFFTYB.pls 120.0 2005/06/01 12:32:33 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_FLOW_TYPE_PAGE_ID in NUMBER,

Line 17: cursor C is select ROWID from CS_CF_FLOW_TYPE_PAGES

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from CS_CF_FLOW_TYPE_PAGES
18: where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
19: ;
20: begin
21: insert into CS_CF_FLOW_TYPE_PAGES (

Line 21: insert into CS_CF_FLOW_TYPE_PAGES (

17: cursor C is select ROWID from CS_CF_FLOW_TYPE_PAGES
18: where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
19: ;
20: begin
21: insert into CS_CF_FLOW_TYPE_PAGES (
22: FLOW_TYPE_PAGE_ID,
23: FLOW_TYPE_CODE,
24: PAGE_CODE,
25: SEQUENCE,

Line 71: from CS_CF_FLOW_TYPE_PAGES

67: PAGE_CODE,
68: SEQUENCE,
69: FUNCTION_NAME,
70: OBJECT_VERSION_NUMBER
71: from CS_CF_FLOW_TYPE_PAGES
72: where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
73: for update of FLOW_TYPE_PAGE_ID nowait;
74: recinfo c%rowtype;
75:

Line 117: update CS_CF_FLOW_TYPE_PAGES set

113: X_LAST_UPDATED_BY in NUMBER,
114: X_LAST_UPDATE_LOGIN in NUMBER
115: ) is
116: begin
117: update CS_CF_FLOW_TYPE_PAGES set
118: FLOW_TYPE_CODE = X_FLOW_TYPE_CODE,
119: PAGE_CODE = X_PAGE_CODE,
120: SEQUENCE = X_SEQUENCE,
121: FUNCTION_NAME = X_FUNCTION_NAME,

Line 139: delete from CS_CF_FLOW_TYPE_PAGES

135: X_FLOW_TYPE_PAGE_ID in NUMBER
136: ) is
137: begin
138:
139: delete from CS_CF_FLOW_TYPE_PAGES
140: where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID;
141:
142: if (sql%notfound) then
143: raise no_data_found;

Line 174: from CS_CF_FLOW_TYPE_PAGES

170: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
171:
172: select LAST_UPDATED_BY, LAST_UPDATE_DATE
173: into db_luby, db_ludate
174: from CS_CF_FLOW_TYPE_PAGES
175: where flow_type_page_id = X_FLOW_TYPE_PAGE_ID;
176:
177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
178: -- Update existing row

Line 181: FROM CS_CF_FLOW_TYPE_PAGES

177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
178: -- Update existing row
179: SELECT object_version_number, rowid
180: INTO l_object_version_number, l_rowid
181: FROM CS_CF_FLOW_TYPE_PAGES
182: WHERE flow_type_page_id = X_FLOW_TYPE_PAGE_ID
183: FOR UPDATE ;
184:
185: CS_CF_FLOW_TYPE_PAGES_PKG.Update_Row(

Line 185: CS_CF_FLOW_TYPE_PAGES_PKG.Update_Row(

181: FROM CS_CF_FLOW_TYPE_PAGES
182: WHERE flow_type_page_id = X_FLOW_TYPE_PAGE_ID
183: FOR UPDATE ;
184:
185: CS_CF_FLOW_TYPE_PAGES_PKG.Update_Row(
186: X_FLOW_TYPE_PAGE_ID => X_FLOW_TYPE_PAGE_ID,
187: X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
188: X_PAGE_CODE => X_PAGE_CODE,
189: X_SEQUENCE => X_SEQUENCE,

Line 199: CS_CF_FLOW_TYPE_PAGES_PKG.Insert_Row(

195: end if;
196: exception
197: when no_data_found then
198: -- Record doesn't exist - insert in all cases
199: CS_CF_FLOW_TYPE_PAGES_PKG.Insert_Row(
200: X_ROWID => l_rowid,
201: X_FLOW_TYPE_PAGE_ID => X_FLOW_TYPE_PAGE_ID,
202: X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
203: X_PAGE_CODE => X_PAGE_CODE,

Line 214: end CS_CF_FLOW_TYPE_PAGES_PKG;

210: X_LAST_UPDATED_BY => f_luby,
211: X_LAST_UPDATE_LOGIN => 0);
212: end LOAD_ROW;
213:
214: end CS_CF_FLOW_TYPE_PAGES_PKG;