APPS.PA_PERF_KPA_SUMMARY_PKG dependencies on PA_PERF_KPA_SUMMARY

Line 1: package body PA_PERF_KPA_SUMMARY_PKG as

1: package body PA_PERF_KPA_SUMMARY_PKG as
2: /* $Header: PAPEESTB.pls 120.1 2005/08/19 16:38:39 mwasowic noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 43: cursor C is select ROWID from PA_PERF_KPA_SUMMARY

39: X_LAST_UPDATE_DATE in DATE,
40: X_LAST_UPDATED_BY in NUMBER,
41: X_LAST_UPDATE_LOGIN in NUMBER
42: ) is
43: cursor C is select ROWID from PA_PERF_KPA_SUMMARY
44: where KPA_SUMMARY_ID = X_KPA_SUMMARY_ID
45: ;
46: begin
47: insert into PA_PERF_KPA_SUMMARY (

Line 47: insert into PA_PERF_KPA_SUMMARY (

43: cursor C is select ROWID from PA_PERF_KPA_SUMMARY
44: where KPA_SUMMARY_ID = X_KPA_SUMMARY_ID
45: ;
46: begin
47: insert into PA_PERF_KPA_SUMMARY (
48: KPA_SUMMARY_ID,
49: OBJECT_TYPE,
50: OBJECT_ID,
51: DATE_CHECKED,

Line 171: update PA_PERF_KPA_SUMMARY set

167: X_LAST_UPDATED_BY in NUMBER ,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: begin
171: update PA_PERF_KPA_SUMMARY set
172: OBJECT_TYPE = X_OBJECT_TYPE,
173: OBJECT_ID = X_OBJECT_ID,
174: DATE_CHECKED = X_DATE_CHECKED,
175: CURRENT_FLAG = X_CURRENT_FLAG,

Line 218: delete from PA_PERF_KPA_SUMMARY

214: procedure DELETE_ROW (
215: X_KPA_SUMMARY_ID in NUMBER
216: ) is
217: begin
218: delete from PA_PERF_KPA_SUMMARY
219: where KPA_SUMMARY_ID = X_KPA_SUMMARY_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 228: end PA_PERF_KPA_SUMMARY_PKG;

224:
225: end DELETE_ROW;
226:
227:
228: end PA_PERF_KPA_SUMMARY_PKG;