APPS.PA_PERF_KPA_SUMDET_PKG dependencies on PA_PERF_KPA_SUMMARY_DET

Line 31: cursor C is select ROWID from PA_PERF_KPA_SUMMARY_DET

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER ,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from PA_PERF_KPA_SUMMARY_DET
32: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
33: ;
34: begin
35: insert into PA_PERF_KPA_SUMMARY_DET (

Line 35: insert into PA_PERF_KPA_SUMMARY_DET (

31: cursor C is select ROWID from PA_PERF_KPA_SUMMARY_DET
32: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
33: ;
34: begin
35: insert into PA_PERF_KPA_SUMMARY_DET (
36: KPA_SUMMARY_DET_ID,
37: KPA_SUMMARY_ID,
38: OBJECT_TYPE,
39: OBJECT_ID,

Line 123: update PA_PERF_KPA_SUMMARY_DET set

119: X_LAST_UPDATED_BY in NUMBER ,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: begin
123: update PA_PERF_KPA_SUMMARY_DET set
124: KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID,
125: KPA_SUMMARY_ID = X_KPA_SUMMARY_ID,
126: OBJECT_TYPE = X_OBJECT_TYPE,
127: OBJECT_ID = X_OBJECT_ID,

Line 158: delete from PA_PERF_KPA_SUMMARY_DET

154: procedure DELETE_ROW (
155: X_KPA_SUMMARY_DET_ID in NUMBER
156: ) is
157: begin
158: delete from PA_PERF_KPA_SUMMARY_DET
159: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID;
160:
161: if (sql%notfound) then
162: raise no_data_found;