1 PACKAGE CS_SR_LINK_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cstlntys.pls 115.1 2002/12/04 02:56:22 dejoseph noship $ */
3
4 PROCEDURE INSERT_ROW (
5 PX_LINK_TYPE_ID IN OUT NOCOPY NUMBER,
6 P_NAME IN VARCHAR2,
7 P_DESCRIPTION IN VARCHAR2,
8 P_RECIPROCAL_LINK_TYPE_ID IN NUMBER,
9 P_START_DATE_ACTIVE IN DATE,
10 P_END_DATE_ACTIVE IN DATE,
11 P_APPLICATION_ID IN NUMBER,
12 P_SEEDED_FLAG IN VARCHAR2,
13 P_USER_ID IN NUMBER, -- used for created and updated by
14 P_LOGIN_ID IN NUMBER, -- used for last update login id.
15 P_ATTRIBUTE1 IN VARCHAR2,
16 P_ATTRIBUTE2 IN VARCHAR2,
17 P_ATTRIBUTE3 IN VARCHAR2,
18 P_ATTRIBUTE4 IN VARCHAR2,
19 P_ATTRIBUTE5 IN VARCHAR2,
20 P_ATTRIBUTE6 IN VARCHAR2,
21 P_ATTRIBUTE7 IN VARCHAR2,
22 P_ATTRIBUTE8 IN VARCHAR2,
23 P_ATTRIBUTE9 IN VARCHAR2,
24 P_ATTRIBUTE10 IN VARCHAR2,
25 P_ATTRIBUTE11 IN VARCHAR2,
26 P_ATTRIBUTE12 IN VARCHAR2,
27 P_ATTRIBUTE13 IN VARCHAR2,
28 P_ATTRIBUTE14 IN VARCHAR2,
29 P_ATTRIBUTE15 IN VARCHAR2,
30 P_CONTEXT IN VARCHAR2,
31 P_OBJECT_VERSION_NUMBER IN NUMBER,
32 P_SECURITY_GROUP_ID IN NUMBER,
33 P_ATTRIBUTE_CONTEXT IN VARCHAR2,
34 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35 X_MSG_COUNT OUT NOCOPY NUMBER,
36 X_MSG_DATA OUT NOCOPY VARCHAR2,
37 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
38 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER,
39 X_LINK_ID OUT NOCOPY NUMBER );
40
41 PROCEDURE LOCK_ROW (
42 P_LINK_TYPE_ID IN NUMBER,
43 P_OBJECT_VERSION_NUMBER IN NUMBER );
44
45 PROCEDURE UPDATE_ROW (
46 P_LINK_TYPE_ID IN NUMBER,
47 P_RECIPROCAL_LINK_TYPE_ID IN NUMBER,
48 P_START_DATE_ACTIVE IN DATE,
49 P_END_DATE_ACTIVE IN DATE,
50 P_APPLICATION_ID IN NUMBER,
51 P_SEEDED_FLAG IN VARCHAR2,
52 P_USER_ID IN NUMBER, -- used for created and updated by
53 P_LOGIN_ID IN NUMBER, -- used for last update login id.
54 P_ATTRIBUTE1 IN VARCHAR2,
55 P_ATTRIBUTE2 IN VARCHAR2,
56 P_ATTRIBUTE3 IN VARCHAR2,
57 P_ATTRIBUTE4 IN VARCHAR2,
58 P_ATTRIBUTE5 IN VARCHAR2,
59 P_ATTRIBUTE6 IN VARCHAR2,
60 P_ATTRIBUTE7 IN VARCHAR2,
61 P_ATTRIBUTE8 IN VARCHAR2,
62 P_ATTRIBUTE9 IN VARCHAR2,
63 P_ATTRIBUTE10 IN VARCHAR2,
64 P_ATTRIBUTE11 IN VARCHAR2,
65 P_ATTRIBUTE12 IN VARCHAR2,
66 P_ATTRIBUTE13 IN VARCHAR2,
67 P_ATTRIBUTE14 IN VARCHAR2,
68 P_ATTRIBUTE15 IN VARCHAR2,
69 P_CONTEXT IN VARCHAR2,
70 P_OBJECT_VERSION_NUMBER IN NUMBER,
71 P_SECURITY_GROUP_ID IN NUMBER,
72 P_ATTRIBUTE_CONTEXT IN VARCHAR2,
73 P_NAME IN VARCHAR2,
74 P_DESCRIPTION IN VARCHAR2,
75 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
76 X_MSG_COUNT OUT NOCOPY NUMBER,
77 X_MSG_DATA OUT NOCOPY VARCHAR2,
78 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
79 X_RECIPROCAL_LINK_ID OUT NOCOPY NUMBER,
80 X_LINK_ID OUT NOCOPY NUMBER );
81
82 PROCEDURE DELETE_ROW (
83 P_LINK_TYPE_ID in NUMBER );
84
85 PROCEDURE ADD_LANGUAGE;
86
87 PROCEDURE TRANSLATE_ROW (
88 P_LINK_TYPE_ID IN NUMBER,
89 P_NAME IN VARCHAR2,
90 P_DESCRIPTION IN VARCHAR2,
91 P_OWNER IN VARCHAR2 );
92
93 PROCEDURE LOAD_ROW (
94 P_LINK_TYPE_ID IN NUMBER,
95 P_NAME IN VARCHAR2,
96 P_DESCRIPTION IN VARCHAR2,
97 P_RECIPROCAL_LINK_TYPE_ID IN NUMBER,
98 P_START_DATE_ACTIVE IN VARCHAR2,
99 P_END_DATE_ACTIVE IN VARCHAR2,
100 P_OWNER IN VARCHAR2,
101 P_APPLICATION_ID IN NUMBER,
102 P_SEEDED_FLAG IN VARCHAR2,
103 P_ATTRIBUTE1 IN VARCHAR2,
104 P_ATTRIBUTE2 IN VARCHAR2,
105 P_ATTRIBUTE3 IN VARCHAR2,
106 P_ATTRIBUTE4 IN VARCHAR2,
107 P_ATTRIBUTE5 IN VARCHAR2,
108 P_ATTRIBUTE6 IN VARCHAR2,
109 P_ATTRIBUTE7 IN VARCHAR2,
110 P_ATTRIBUTE8 IN VARCHAR2,
111 P_ATTRIBUTE9 IN VARCHAR2,
112 P_ATTRIBUTE10 IN VARCHAR2,
113 P_ATTRIBUTE11 IN VARCHAR2,
114 P_ATTRIBUTE12 IN VARCHAR2,
115 P_ATTRIBUTE13 IN VARCHAR2,
116 P_ATTRIBUTE14 IN VARCHAR2,
117 P_ATTRIBUTE15 IN VARCHAR2,
118 P_CONTEXT IN VARCHAR2,
119 P_OBJECT_VERSION_NUMBER IN NUMBER,
120 P_SECURITY_GROUP_ID IN NUMBER,
121 P_ATTRIBUTE_CONTEXT IN VARCHAR2 );
122
123
124
125 END CS_SR_LINK_TYPES_PKG;