1 PACKAGE CS_SR_LINK_VALID_OBJ_PKG AUTHID CURRENT_USER AS
2 /* $Header: cstlnvos.pls 115.1 2002/12/04 03:27:21 dejoseph noship $ */
3
4 PROCEDURE INSERT_ROW (
5 PX_LINK_VALID_OBJ_ID IN OUT NOCOPY NUMBER,
6 P_SUBJECT_TYPE IN VARCHAR2,
7 P_OBJECT_TYPE IN VARCHAR2,
8 P_LINK_TYPE_ID IN NUMBER,
9 P_START_DATE_ACTIVE IN DATE,
10 P_END_DATE_ACTIVE IN DATE,
11 P_USER_ID IN NUMBER,
12 P_LOGIN_ID IN NUMBER,
13 P_SECURITY_GROUP_ID IN NUMBER,
14 P_APPLICATION_ID IN NUMBER,
15 P_SEEDED_FLAG IN VARCHAR2,
16 P_OBJECT_VERSION_NUMBER IN NUMBER );
17
18
19 PROCEDURE LOCK_ROW (
20 P_LINK_VALID_OBJ_ID IN NUMBER,
21 P_OBJECT_VERSION_NUMBER IN NUMBER );
22
23
24 PROCEDURE UPDATE_ROW (
25 P_LINK_VALID_OBJ_ID IN NUMBER,
26 P_SUBJECT_TYPE IN VARCHAR2,
27 P_OBJECT_TYPE IN VARCHAR2,
28 P_LINK_TYPE_ID IN NUMBER,
29 P_START_DATE_ACTIVE IN DATE,
30 P_END_DATE_ACTIVE IN DATE,
31 P_USER_ID IN NUMBER,
32 P_LOGIN_ID IN NUMBER,
33 P_SECURITY_GROUP_ID IN NUMBER,
34 P_APPLICATION_ID IN NUMBER,
35 P_SEEDED_FLAG IN VARCHAR2,
36 P_OBJECT_VERSION_NUMBER IN NUMBER );
37
38 PROCEDURE DELETE_ROW (
39 P_LINK_VALID_OBJ_ID IN NUMBER );
40
41 PROCEDURE LOAD_ROW (
42 P_LINK_VALID_OBJ_ID IN NUMBER,
43 P_SUBJECT_TYPE IN VARCHAR2,
44 P_OBJECT_TYPE IN VARCHAR2,
45 P_LINK_TYPE_ID IN NUMBER,
46 P_START_DATE_ACTIVE IN VARCHAR2,
47 P_END_DATE_ACTIVE IN VARCHAR2,
48 P_OWNER IN VARCHAR2,
49 P_APPLICATION_ID IN NUMBER,
50 P_SEEDED_FLAG IN VARCHAR2,
51 P_SECURITY_GROUP_ID IN NUMBER,
52 P_OBJECT_VERSION_NUMBER IN NUMBER );
53
54
55 END CS_SR_LINK_VALID_OBJ_PKG;