APPS.PA_PERF_CMTS_PKG dependencies on PA_PERF_COMMENTS

Line 17: cursor C is select ROWID from PA_PERF_COMMENTS

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from PA_PERF_COMMENTS
18: where COMMENT_ID = X_COMMENT_ID
19: ;
20: begin
21: insert into PA_PERF_COMMENTS (

Line 21: insert into PA_PERF_COMMENTS (

17: cursor C is select ROWID from PA_PERF_COMMENTS
18: where COMMENT_ID = X_COMMENT_ID
19: ;
20: begin
21: insert into PA_PERF_COMMENTS (
22: COMMENT_ID,
23: PERF_TXN_ID,
24: COMMENT_TEXT,
25: COMMENTED_BY,

Line 66: update PA_PERF_COMMENTS set

62: X_LAST_UPDATED_BY in NUMBER ,
63: X_LAST_UPDATE_LOGIN in NUMBER
64: ) is
65: begin
66: update PA_PERF_COMMENTS set
67: PERF_TXN_ID = X_PERF_TXN_ID,
68: COMMENT_TEXT = X_COMMENT_TEXT,
69: COMMENTED_BY = X_COMMENTED_BY,
70: COMMENT_DATE = X_COMMENT_DATE,

Line 87: delete from PA_PERF_COMMENTS

83: procedure DELETE_ROW (
84: X_COMMENT_ID in NUMBER
85: ) is
86: begin
87: delete from PA_PERF_COMMENTS
88: where COMMENT_ID = X_COMMENT_ID;
89:
90: if (sql%notfound) then
91: raise no_data_found;