APPS.PA_CI_COMMENTS_PKG dependencies on PA_CI_COMMENTS

Line 1: PACKAGE BODY PA_CI_COMMENTS_PKG AS

1: PACKAGE BODY PA_CI_COMMENTS_PKG AS
2: /* $Header: PACICOTB.pls 120.2 2005/08/22 05:10:59 sukhanna noship $ */
3:
4:
5:

Line 21: FROM PA_CI_COMMENTS

17: ) IS
18: -- Enter the procedure variables here. As shown below
19: CURSOR c1 IS
20: SELECT rowid
21: FROM PA_CI_COMMENTS
22: WHERE ci_comment_id = p_ci_comment_id;
23:
24: l_row_id ROWID;
25:

Line 28: Insert into PA_CI_COMMENTS (

24: l_row_id ROWID;
25:
26: BEGIN
27:
28: Insert into PA_CI_COMMENTS (
29: CI_COMMENT_ID,
30: CI_ID,
31: TYPE_CODE,
32: COMMENT_TEXT,

Line 41: ( PA_CI_COMMENTS_S.NEXTVAL ,

37: LAST_UPDATE_DATE,
38: LAST_UPDATE_LOGIN,
39: CI_ACTION_ID
40: ) VALUES
41: ( PA_CI_COMMENTS_S.NEXTVAL ,
42: P_CI_ID,
43: P_TYPE_CODE,
44: P_COMMENT_TEXT,
45: 1,

Line 75: UPDATE PA_CI_COMMENTS

71: P_RECORD_VERSION_NUMBER in NUMBER,
72: P_CI_ACTION_ID in NUMBER
73: ) IS
74: BEGIN
75: UPDATE PA_CI_COMMENTS
76: SET
77: CI_ID = P_CI_ID,
78: TYPE_CODE = P_TYPE_CODE,
79: COMMENT_TEXT = P_COMMENT_TEXT,

Line 99: DELETE FROM PA_CI_COMMENTS

95: procedure DELETE_ROW (
96: P_CI_COMMENT_ID in NUMBER )
97: IS
98: BEGIN
99: DELETE FROM PA_CI_COMMENTS
100: WHERE CI_COMMENT_ID = P_CI_COMMENT_ID;
101:
102: EXCEPTION
103: WHEN OTHERS THEN

Line 108: END PA_CI_COMMENTS_PKG; -- Package Body PA_CI_COMMENTS_PKG

104: RAISE;
105: END DELETE_ROW;
106:
107: -- Enter further code below as specified in the Package spec.
108: END PA_CI_COMMENTS_PKG; -- Package Body PA_CI_COMMENTS_PKG