1 PACKAGE OKE_K_ACCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVKASS.pls 115.4 2002/11/20 20:44:14 who ship $ */
3 PROCEDURE CREATE_CONTRACT_ACCESS
4 ( P_COMMIT IN VARCHAR2
5 , P_OBJECT_TYPE IN VARCHAR2
6 , P_OBJECT_ID IN NUMBER
7 , P_ROLE_ID IN NUMBER
8 , P_PERSON_ID IN NUMBER
9 , P_START_DATE_ACTIVE IN DATE
10 , P_END_DATE_ACTIVE IN OUT NOCOPY DATE
11 , X_PROJECT_PARTY_ID OUT NOCOPY NUMBER
12 , X_RESOURCE_ID OUT NOCOPY NUMBER
13 , X_ASSIGNMENT_ID OUT NOCOPY NUMBER
14 , X_RECORD_VERSION_NUMBER OUT NOCOPY NUMBER
15 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
16 , X_MSG_COUNT OUT NOCOPY NUMBER
17 , X_MSG_DATA OUT NOCOPY VARCHAR2
18 );
19
20
21 PROCEDURE LOCK_ROW
22 ( P_OBJECT_TYPE IN VARCHAR2
23 , P_OBJECT_ID IN NUMBER
24 , P_ROLE_ID IN NUMBER
25 , P_PERSON_ID IN NUMBER
26 , P_START_DATE_ACTIVE IN DATE
27 , P_END_DATE_ACTIVE IN DATE
28 , P_PROJECT_PARTY_ID IN NUMBER
29 , P_RESOURCE_ID IN NUMBER
30 );
31
32
33 PROCEDURE UPDATE_CONTRACT_ACCESS
34 ( P_COMMIT IN VARCHAR2
35 , P_OBJECT_TYPE IN VARCHAR2
36 , P_OBJECT_ID IN NUMBER
37 , P_ROLE_ID IN NUMBER
38 , P_PERSON_ID IN NUMBER
39 , P_START_DATE_ACTIVE IN DATE
40 , P_END_DATE_ACTIVE IN OUT NOCOPY DATE
41 , P_PROJECT_PARTY_ID IN NUMBER
42 , P_RECORD_VERSION_NUMBER IN NUMBER
43 , P_RESOURCE_ID IN NUMBER
44 , P_ASSIGNMENT_ID IN NUMBER
45 , X_ASSIGNMENT_ID OUT NOCOPY NUMBER
46 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
47 , X_MSG_COUNT OUT NOCOPY NUMBER
48 , X_MSG_DATA OUT NOCOPY VARCHAR2
49 );
50
51 END OKE_K_ACCESS_PVT;
[Home] [Help]