APPS.PA_PERF_KPA_TRANS_PKG dependencies on PA_PERF_KPA_TRANS

Line 1: package body PA_PERF_KPA_TRANS_PKG as

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

Line 14: cursor C is select ROWID from PA_PERF_KPA_TRANS

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER ,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from PA_PERF_KPA_TRANS
15: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
16: and PERF_TXN_ID = X_PERF_TXN_ID
17: ;
18: begin

Line 19: insert into PA_PERF_KPA_TRANS (

15: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
16: and PERF_TXN_ID = X_PERF_TXN_ID
17: ;
18: begin
19: insert into PA_PERF_KPA_TRANS (
20: KPA_SUMMARY_DET_ID,
21: PERF_TXN_ID,
22: CREATION_DATE,
23: CREATED_BY,

Line 56: update PA_PERF_KPA_TRANS set

52: X_LAST_UPDATED_BY in NUMBER ,
53: X_LAST_UPDATE_LOGIN in NUMBER
54: ) is
55: begin
56: update PA_PERF_KPA_TRANS set
57: KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID,
58: PERF_TXN_ID = X_PERF_TXN_ID,
59: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,sysdate),
60: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,fnd_global.user_id),

Line 76: delete from PA_PERF_KPA_TRANS

72: X_KPA_SUMMARY_DET_ID in NUMBER,
73: X_PERF_TXN_ID in NUMBER
74: ) is
75: begin
76: delete from PA_PERF_KPA_TRANS
77: where KPA_SUMMARY_DET_ID = X_KPA_SUMMARY_DET_ID
78: and PERF_TXN_ID = X_PERF_TXN_ID
79: ;
80:

Line 88: end PA_PERF_KPA_TRANS_PKG;

84:
85: end DELETE_ROW;
86:
87:
88: end PA_PERF_KPA_TRANS_PKG;