APPS.FND_SVC_COMP_TYPES_PKG dependencies on FND_SVC_COMP_TYPES_B

Line 19: cursor C is select ROWID from FND_SVC_COMP_TYPES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FND_SVC_COMP_TYPES_B
20: where COMPONENT_TYPE = X_COMPONENT_TYPE
21: ;
22: begin
23: insert into FND_SVC_COMP_TYPES_B (

Line 23: insert into FND_SVC_COMP_TYPES_B (

19: cursor C is select ROWID from FND_SVC_COMP_TYPES_B
20: where COMPONENT_TYPE = X_COMPONENT_TYPE
21: ;
22: begin
23: insert into FND_SVC_COMP_TYPES_B (
24: COMPONENT_TYPE,
25: COMPONENT_CLASS_NAME,
26: CONFIG_UI_REGION,
27: CUSTOMIZATION_LEVEL,

Line 105: from FND_SVC_COMP_TYPES_B

101: COMPONENT_CLASS_NAME,
102: CONFIG_UI_REGION,
103: CUSTOMIZATION_LEVEL,
104: OBJECT_VERSION_NUMBER
105: from FND_SVC_COMP_TYPES_B
106: where COMPONENT_TYPE = X_COMPONENT_TYPE
107: for update of COMPONENT_TYPE nowait;
108: recinfo c%rowtype;
109:

Line 182: from FND_SVC_COMP_TYPES_B

178: -- Allow update. Increment the database's OVN by 1
179: --
180: select OBJECT_VERSION_NUMBER
181: into l_object_version_number
182: from FND_SVC_COMP_TYPES_B
183: where COMPONENT_TYPE = X_COMPONENT_TYPE;
184:
185: l_object_version_number := l_object_version_number + 1;
186:

Line 199: from FND_SVC_COMP_TYPES_B

195: --
196:
197: select OBJECT_VERSION_NUMBER
198: into l_object_version_number
199: from FND_SVC_COMP_TYPES_B
200: where COMPONENT_TYPE = X_COMPONENT_TYPE
201: for update;
202:
203: if (l_object_version_number = X_OBJECT_VERSION_NUMBER) then

Line 215: update FND_SVC_COMP_TYPES_B set

211: end if;
212:
213: end if;
214:
215: update FND_SVC_COMP_TYPES_B set
216: COMPONENT_CLASS_NAME = X_COMPONENT_CLASS_NAME,
217: CONFIG_UI_REGION = X_CONFIG_UI_REGION,
218: CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
219: OBJECT_VERSION_NUMBER = l_object_version_number,

Line 260: delete from FND_SVC_COMP_TYPES_B

256: if (sql%notfound) then
257: raise no_data_found;
258: end if;
259:
260: delete from FND_SVC_COMP_TYPES_B
261: where COMPONENT_TYPE = X_COMPONENT_TYPE;
262:
263: if (sql%notfound) then
264: raise no_data_found;

Line 279: from FND_SVC_COMP_TYPES_B B

275: begin
276: delete from FND_SVC_COMP_TYPES_TL T
277: where not exists
278: (select NULL
279: from FND_SVC_COMP_TYPES_B B
280: where B.COMPONENT_TYPE = T.COMPONENT_TYPE
281: );
282:
283: update FND_SVC_COMP_TYPES_TL T set (