APPS.SO_RESULTS_PKG dependencies on SO_RESULTS_B

Line 32: cursor C is select ROWID from SO_RESULTS_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 SO_RESULTS_B
33: where RESULT_ID = X_RESULT_ID
34: ;
35: begin
36: insert into SO_RESULTS_B (

Line 36: insert into SO_RESULTS_B (

32: cursor C is select ROWID from SO_RESULTS_B
33: where RESULT_ID = X_RESULT_ID
34: ;
35: begin
36: insert into SO_RESULTS_B (
37: ATTRIBUTE10,
38: ATTRIBUTE11,
39: ATTRIBUTE12,
40: ATTRIBUTE13,

Line 170: from SO_RESULTS_B

166: ATTRIBUTE6,
167: ATTRIBUTE7,
168: ATTRIBUTE8,
169: ATTRIBUTE9
170: from SO_RESULTS_B
171: where RESULT_ID = X_RESULT_ID
172: for update of RESULT_ID nowait;
173: recinfo c%rowtype;
174:

Line 277: update SO_RESULTS_B set

273: X_LAST_UPDATED_BY in NUMBER,
274: X_LAST_UPDATE_LOGIN in NUMBER
275: ) is
276: begin
277: update SO_RESULTS_B set
278: ATTRIBUTE10 = X_ATTRIBUTE10,
279: ATTRIBUTE11 = X_ATTRIBUTE11,
280: ATTRIBUTE12 = X_ATTRIBUTE12,
281: ATTRIBUTE13 = X_ATTRIBUTE13,

Line 448: delete from SO_RESULTS_B

444: if (sql%notfound) then
445: raise no_data_found;
446: end if;
447:
448: delete from SO_RESULTS_B
449: where RESULT_ID = X_RESULT_ID;
450:
451: if (sql%notfound) then
452: raise no_data_found;

Line 462: from SO_RESULTS_B B

458: begin
459: delete from SO_RESULTS_TL T
460: where not exists
461: (select NULL
462: from SO_RESULTS_B B
463: where B.RESULT_ID = T.RESULT_ID
464: );
465:
466: update SO_RESULTS_TL T set (