APPS.FND_BUSINESS_PURPOSES_PKG dependencies on FND_BUSINESS_PURPOSES_B

Line 35: cursor C is select ROWID from FND_BUSINESS_PURPOSES_B

31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER,
33: X_PURPOSE_DEFAULT_CODE in VARCHAR2
34: ) is
35: cursor C is select ROWID from FND_BUSINESS_PURPOSES_B
36: where PURPOSE_CODE = X_PURPOSE_CODE
37: ;
38: begin
39: insert into FND_BUSINESS_PURPOSES_B (

Line 39: insert into FND_BUSINESS_PURPOSES_B (

35: cursor C is select ROWID from FND_BUSINESS_PURPOSES_B
36: where PURPOSE_CODE = X_PURPOSE_CODE
37: ;
38: begin
39: insert into FND_BUSINESS_PURPOSES_B (
40: PURPOSE_CODE,
41: APPLICATION_ID,
42: SEEDED_FLAG,
43: ATTRIBUTE1,

Line 184: from FND_BUSINESS_PURPOSES_B

180: ATTRIBUTE15,
181: ATTRIBUTE_CATEGORY,
182: OBJECT_VERSION_NUMBER,
183: PURPOSE_DEFAULT_CODE
184: from FND_BUSINESS_PURPOSES_B
185: where PURPOSE_CODE = X_PURPOSE_CODE
186: for update of PURPOSE_CODE nowait;
187: recinfo c%rowtype;
188:

Line 299: update FND_BUSINESS_PURPOSES_B set

295: X_LAST_UPDATE_LOGIN in NUMBER,
296: X_PURPOSE_DEFAULT_CODE in VARCHAR2
297: ) is
298: begin
299: update FND_BUSINESS_PURPOSES_B set
300: APPLICATION_ID = X_APPLICATION_ID,
301: SEEDED_FLAG = X_SEEDED_FLAG,
302: ATTRIBUTE1 = X_ATTRIBUTE1,
303: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 356: delete from FND_BUSINESS_PURPOSES_B

352: if (sql%notfound) then
353: raise no_data_found;
354: end if;
355:
356: delete from FND_BUSINESS_PURPOSES_B
357: where PURPOSE_CODE = X_PURPOSE_CODE;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 370: from FND_BUSINESS_PURPOSES_B B

366: begin
367: delete from FND_BUSINESS_PURPOSES_TL T
368: where not exists
369: (select NULL
370: from FND_BUSINESS_PURPOSES_B B
371: where B.PURPOSE_CODE = T.PURPOSE_CODE
372: );
373:
374: update FND_BUSINESS_PURPOSES_TL T set (