APPS.CS_CF_SOURCE_CXT_TYPES_PKG dependencies on CS_CF_SOURCE_CXT_TYPES

Line 1: package body CS_CF_SOURCE_CXT_TYPES_PKG as

1: package body CS_CF_SOURCE_CXT_TYPES_PKG as
2: /* $Header: CSCFCTYB.pls 120.0 2005/06/01 11:06:00 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SOURCE_CONTEXT_TYPE_ID in NUMBER,

Line 18: cursor C is select ROWID from CS_CF_SOURCE_CXT_TYPES

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from CS_CF_SOURCE_CXT_TYPES
19: where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID
20: ;
21: begin
22: insert into CS_CF_SOURCE_CXT_TYPES (

Line 22: insert into CS_CF_SOURCE_CXT_TYPES (

18: cursor C is select ROWID from CS_CF_SOURCE_CXT_TYPES
19: where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID
20: ;
21: begin
22: insert into CS_CF_SOURCE_CXT_TYPES (
23: SOURCE_CONTEXT_TYPE_ID,
24: SOURCE_CODE,
25: CONTEXT_TYPE,
26: PRIORITY,

Line 75: from CS_CF_SOURCE_CXT_TYPES

71: PRIORITY,
72: SOURCE_TYPE,
73: PURPOSE,
74: OBJECT_VERSION_NUMBER
75: from CS_CF_SOURCE_CXT_TYPES
76: where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID
77: for update of SOURCE_CONTEXT_TYPE_ID nowait;
78: recinfo c%rowtype;
79:

Line 124: update CS_CF_SOURCE_CXT_TYPES set

120: X_LAST_UPDATED_BY in NUMBER,
121: X_LAST_UPDATE_LOGIN in NUMBER
122: ) is
123: begin
124: update CS_CF_SOURCE_CXT_TYPES set
125: SOURCE_CODE = X_SOURCE_CODE,
126: CONTEXT_TYPE = X_CONTEXT_TYPE,
127: PRIORITY = X_PRIORITY,
128: SOURCE_TYPE = X_SOURCE_TYPE,

Line 147: delete from CS_CF_SOURCE_CXT_TYPES

143: X_SOURCE_CONTEXT_TYPE_ID in NUMBER
144: ) is
145: begin
146:
147: delete from CS_CF_SOURCE_CXT_TYPES
148: where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID;
149:
150: if (sql%notfound) then
151: raise no_data_found;

Line 182: from CS_CF_SOURCE_CXT_TYPES

178: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
179:
180: select LAST_UPDATED_BY, LAST_UPDATE_DATE
181: into db_luby, db_ludate
182: from CS_CF_SOURCE_CXT_TYPES
183: where source_context_type_id = X_SOURCE_CONTEXT_TYPE_ID;
184:
185: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
186: -- Update existing row

Line 189: FROM CS_CF_SOURCE_CXT_TYPES

185: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
186: -- Update existing row
187: SELECT object_version_number, rowid
188: INTO l_object_version_number, l_rowid
189: FROM CS_CF_SOURCE_CXT_TYPES
190: WHERE source_context_type_id = X_SOURCE_CONTEXT_TYPE_ID
191: FOR UPDATE;
192:
193: CS_CF_SOURCE_CXT_TYPES_PKG.Update_Row(

Line 193: CS_CF_SOURCE_CXT_TYPES_PKG.Update_Row(

189: FROM CS_CF_SOURCE_CXT_TYPES
190: WHERE source_context_type_id = X_SOURCE_CONTEXT_TYPE_ID
191: FOR UPDATE;
192:
193: CS_CF_SOURCE_CXT_TYPES_PKG.Update_Row(
194: X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
195: X_SOURCE_CODE => X_SOURCE_CODE,
196: X_CONTEXT_TYPE => X_CONTEXT_TYPE,
197: X_PRIORITY => X_PRIORITY,

Line 208: CS_CF_SOURCE_CXT_TYPES_PKG.Insert_Row(

204: end if;
205: exception
206: when no_data_found then
207: -- Record doesn't exist - insert in all cases
208: CS_CF_SOURCE_CXT_TYPES_PKG.Insert_Row(
209: X_ROWID => l_rowid,
210: X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
211: X_SOURCE_CODE => X_SOURCE_CODE,
212: X_CONTEXT_TYPE => X_CONTEXT_TYPE,

Line 224: end CS_CF_SOURCE_CXT_TYPES_PKG;

220: X_LAST_UPDATED_BY => f_luby,
221: X_LAST_UPDATE_LOGIN => 0);
222: end LOAD_ROW;
223:
224: end CS_CF_SOURCE_CXT_TYPES_PKG;