1 PACKAGE gmo_oper_cert_trans_dbl AS
2 /* $Header: GMOVGOCS.pls 120.1 2007/06/21 06:15:16 rvsingh noship $ */
3 /*============================================================================
4 | Copyright (c) 2001 Oracle Corporation
5 | TVP, Reading
6 | All rights reserved
7 =============================================================================
8 | FILENAME
9 | GMOVGOCS.pls
10 |
11 | DESCRIPTION
12 | Spec of package gmo_oper_cert_trans_dbl
13 |
14 |
15 |
16 | NOTES
17 |
18 | HISTORY
19 | 12-MAR-07 Pawan Kumar Created
20 | bug number- 4440475
21 | - insert_row
22 | - update_row
23 | - lock_row
24 |
25 |
26 =============================================================================
27 */
28 PROCEDURE INSERT_ROW (
29 p_operator_CERTIFICATE_ID IN OUT NOCOPY NUMBER
30 ,p_HEADER_ID IN NUMBER
31 ,p_TRANSACTION_ID IN VARCHAR2
32 ,p_USER_ID IN NUMBER
33 ,p_comments IN VARCHAR2
34 ,p_OVERRIDER_ID IN NUMBER
35 ,p_User_key_label_product IN VARCHAR2
36 ,p_User_key_label_token IN VARCHAR2
37 ,p_User_key_value IN VARCHAR2
38 ,p_Erecord_id IN NUMBER
39 ,p_Trans_object_id IN NUMBER
40 ,p_STATUS IN VARCHAR2
41 ,p_event_name IN VARCHAR2
42 ,p_event_key IN VARCHAR2
43 ,p_CREATION_DATE IN DATE
44 ,p_CREATED_BY IN NUMBER
45 ,p_LAST_UPDATE_DATE IN DATE
46 ,p_LAST_UPDATED_BY IN NUMBER
47 ,p_LAST_UPDATE_LOGIN IN NUMBER
48 ,x_return_Status OUT NOCOPY VARCHAR2 );
49
50 PROCEDURE delete_row (p_oper_cert_id IN NUMBER
51 ,x_return_Status OUT NOCOPY VARCHAR2 );
52
53
54 PROCEDURE UPDATE_ROW (
55 P_operator_CERTIFICATE_ID IN NUMBER
56 ,P_HEADER_ID IN NUMBER
57 ,P_TRANSACTION_ID IN VARCHAR2
58 ,P_USER_ID IN NUMBER
59 ,P_comments IN VARCHAR2
60 ,P_OVERRIDER_ID IN NUMBER
61 ,P_User_key_label_product IN VARCHAR2
62 ,P_User_key_label_token IN VARCHAR2
63 ,P_User_key_value IN VARCHAR2
64 ,P_Erecord_id IN NUMBER
65 ,P_Trans_object_id IN NUMBER
66 ,P_STATUS IN VARCHAR2
67 ,P_event_name IN VARCHAR2
68 ,p_event_key IN VARCHAR2
69 ,P_CREATION_DATE IN DATE
70 ,P_CREATED_BY IN NUMBER
71 ,P_LAST_UPDATE_DATE IN DATE
72 ,P_LAST_UPDATED_BY IN NUMBER
73 ,P_LAST_UPDATE_LOGIN IN NUMBER
74 ,x_return_Status OUT NOCOPY VARCHAR2 );
75
76
77
78 PROCEDURE lock_row (p_oper_cert_id IN NUMBER
79 ,x_return_Status OUT NOCOPY VARCHAR2 ) ;
80
81 END gmo_oper_cert_trans_dbl;