PACKAGE: APPS.OKE_NOTIFICATIONS_PKG

Source

1 package OKE_NOTIFICATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: OKEONXXS.pls 115.0 2003/10/22 22:24:54 ybchen noship $ */
3 procedure INSERT_ROW (
4   X_ROWID 			in out NOCOPY VARCHAR2
5 , X_ID                          in      NUMBER
6 , X_SOURCE_CODE 	        in      VARCHAR2
7 , X_USAGE_CODE 	                in      VARCHAR2
8 , X_CREATION_DATE 		in 	DATE
9 , X_CREATED_BY 			in 	NUMBER
10 , X_LAST_UPDATE_DATE 		in 	DATE
11 , X_LAST_UPDATED_BY 		in 	NUMBER
12 , X_LAST_UPDATE_LOGIN 		in 	NUMBER
13 , X_TARGET_DATE         	in 	VARCHAR2
14 , X_BEFORE_AFTER                in      VARCHAR2
15 , X_DURATION_DAYS		in 	NUMBER
16 , X_RECIPIENT    		in 	VARCHAR2
17 , X_ROLE_ID		        in 	NUMBER
18 );
19 
20 procedure LOCK_ROW (
21   X_ID    			in      NUMBER
22 , X_SOURCE_CODE 	        in      VARCHAR2
23 , X_USAGE_CODE 	                in 	VARCHAR2
24 , X_TARGET_DATE         	in 	VARCHAR2
25 , X_BEFORE_AFTER                in      VARCHAR2
26 , X_DURATION_DAYS		in 	NUMBER
27 , X_RECIPIENT    		in 	VARCHAR2
28 , X_ROLE_ID		        in 	NUMBER
29 );
30 
31 procedure UPDATE_ROW (
32   X_ID 	        		in      NUMBER
33 , X_SOURCE_CODE 	        in      VARCHAR2
34 , X_USAGE_CODE 	                in 	VARCHAR2
35 , X_LAST_UPDATE_DATE 		in 	DATE
36 , X_LAST_UPDATED_BY 		in 	NUMBER
37 , X_LAST_UPDATE_LOGIN 		in 	NUMBER
38 , X_TARGET_DATE         	in 	VARCHAR2
39 , X_BEFORE_AFTER                in      VARCHAR2
40 , X_DURATION_DAYS		in 	NUMBER
41 , X_RECIPIENT    		in 	VARCHAR2
42 , X_ROLE_ID		        in 	NUMBER
43 );
44 
45 procedure DELETE_ROW (
46   X_ID 		        	in      NUMBER
47 );
48 
49 end OKE_NOTIFICATIONS_PKG;