DBA Data[Home] [Help]

PACKAGE: APPS.PA_CI_COMMENTS_PKG

Source


1 package PA_CI_COMMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PACICOTS.pls 120.1 2005/08/19 16:17:57 mwasowic noship $ */
3 
4 procedure INSERT_ROW (
5     P_CI_COMMENT_ID             out NOCOPY NUMBER, --File.Sql.39 bug 4440895
6     P_CI_ID                     in NUMBER,
7     P_TYPE_CODE                 in VARCHAR2,
8     P_COMMENT_TEXT              in VARCHAR2,
9     P_LAST_UPDATED_BY		    in NUMBER,
10     P_CREATED_BY			    in NUMBER,
11     P_CREATION_DATE			    in DATE,
12     P_LAST_UPDATE_DATE		    in DATE,
13     P_LAST_UPDATE_LOGIN		    in NUMBER,
14     P_CI_ACTION_ID              in NUMBER
15 );
16 
17 procedure UPDATE_ROW (
18     P_CI_COMMENT_ID             in NUMBER,
19     P_CI_ID                     in NUMBER,
20     P_TYPE_CODE                 in VARCHAR2,
21     P_COMMENT_TEXT              in VARCHAR2,
22     P_LAST_UPDATED_BY		    in NUMBER,
23     P_CREATED_BY			    in NUMBER,
24     P_CREATION_DATE			    in DATE,
25     P_LAST_UPDATE_DATE		    in DATE,
26     P_LAST_UPDATE_LOGIN		    in NUMBER,
27     P_RECORD_VERSION_NUMBER     in NUMBER,
28     P_CI_ACTION_ID              in NUMBER
29 );
30 
31 procedure DELETE_ROW (
32 		      P_CI_COMMENT_ID in NUMBER );
33 
34 
35 END PA_CI_COMMENTS_PKG; -- Package Specification PA_CI_COMMENTS_PKG