1 PACKAGE okc_k_entity_locks_pkg
2 /* $Header: OKCVELKS.pls 120.1 2011/12/09 13:10:12 serukull noship $ */
3 AUTHID CURRENT_USER AS
4 PROCEDURE insert_row ( p_entity_name IN VARCHAR2,
5 p_entity_pk1 IN VARCHAR2,
6 p_entity_pk2 IN VARCHAR2,
7 p_entity_pk3 IN VARCHAR2,
8 p_entity_pk4 IN VARCHAR2,
9 p_entity_pk5 IN VARCHAR2,
10 P_LOCK_BY_ENTITY_ID IN NUMBER,
11 P_LOCK_by_document_type IN VARCHAR2,
12 p_LOCK_by_document_id IN NUMBER,
13 P_OBJECT_VERSION_NUMBER IN NUMBER,
14 P_CREATED_BY IN NUMBER,
15 P_CREATION_DATE IN DATE,
16 P_LAST_UPDATED_BY IN NUMBER,
17 P_LAST_UPDATE_DATE IN DATE,
18 P_LAST_UPDATE_LOGIN IN NUMBER,
19 x_k_entity_lock_id OUT NOCOPY NUMBER,
20 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
21 X_MSG_COUNT OUT NOCOPY NUMBER,
22 X_MSG_DATA OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE delete_row (P_ENTITY_NAME IN VARCHAR2,
26 P_ENTITY_PK1 IN VARCHAR2,
27 P_ENTITY_PK2 IN VARCHAR2,
28 P_ENTITY_PK3 IN VARCHAR2,
29 P_ENTITY_PK4 IN VARCHAR2,
30 P_ENTITY_PK5 IN VARCHAR2,
31 P_LOCK_BY_ENTITY_ID IN NUMBER,
32 P_LOCK_by_document_type IN VARCHAR2,
33 p_LOCK_by_document_id IN NUMBER,
34 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35 X_MSG_COUNT OUT NOCOPY NUMBER,
36 X_MSG_DATA OUT NOCOPY VARCHAR2
37 );
38 END okc_k_entity_locks_pkg;