1 PACKAGE PSB_POSITION_ATTRIBUTES_PVT AS
2 /* $Header: PSBVPATS.pls 120.3 2006/06/28 12:18:12 mvenugop ship $ */
3
4
5 PROCEDURE INSERT_ROW
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 p_ROW_ID IN OUT NOCOPY VARCHAR2,
15 p_ATTRIBUTE_ID IN NUMBER,
16 p_BUSINESS_GROUP_ID IN NUMBER,
17 p_NAME IN VARCHAR2,
18 p_DISPLAY_IN_WORKSHEET IN VARCHAR2,
19 p_DISPLAY_SEQUENCE IN NUMBER,
20 p_DISPLAY_PROMPT IN VARCHAR2,
21 p_REQUIRED_FOR_IMPORT_FLAG IN VARCHAR2,
22 p_REQUIRED_FOR_POSITIONS_FLAG IN VARCHAR2,
23 p_ALLOW_IN_POSITION_SET_FLAG IN VARCHAR2,
24 p_VALUE_TABLE_FLAG IN VARCHAR2,
25 p_PROTECTED_FLAG IN VARCHAR2,
26 p_DEFINITION_TYPE IN VARCHAR2,
27 p_DEFINITION_STRUCTURE IN VARCHAR2,
28 p_DEFINITION_TABLE IN VARCHAR2,
29 p_DEFINITION_COLUMN IN VARCHAR2,
30 p_ATTRIBUTE_TYPE_ID IN NUMBER,
31 p_DATA_TYPE IN VARCHAR2,
32 p_APPLICATION_ID IN NUMBER,
33 p_SYSTEM_ATTRIBUTE_TYPE IN VARCHAR2,
34 p_LAST_UPDATE_DATE IN DATE,
35 p_LAST_UPDATED_BY IN NUMBER,
36 p_LAST_UPDATE_LOGIN IN NUMBER,
37 p_CREATED_BY IN NUMBER,
38 p_CREATION_DATE IN DATE
39 );
40
41 PROCEDURE UPDATE_ROW
42 ( p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_return_status OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 --
50 p_ATTRIBUTE_ID IN NUMBER,
51 p_BUSINESS_GROUP_ID IN NUMBER,
52 p_NAME IN VARCHAR2,
53 p_DISPLAY_IN_WORKSHEET IN VARCHAR2,
54 p_DISPLAY_SEQUENCE IN NUMBER,
55 p_DISPLAY_PROMPT IN VARCHAR2,
56 p_REQUIRED_FOR_IMPORT_FLAG IN VARCHAR2,
57 p_REQUIRED_FOR_POSITIONS_FLAG IN VARCHAR2,
58 p_ALLOW_IN_POSITION_SET_FLAG IN VARCHAR2,
59 p_VALUE_TABLE_FLAG IN VARCHAR2,
60 p_PROTECTED_FLAG IN VARCHAR2,
61 p_DEFINITION_TYPE IN VARCHAR2,
62 p_DEFINITION_STRUCTURE IN VARCHAR2,
63 p_DEFINITION_TABLE IN VARCHAR2,
64 p_DEFINITION_COLUMN IN VARCHAR2,
65 p_ATTRIBUTE_TYPE_ID IN NUMBER,
66 p_DATA_TYPE IN VARCHAR2,
67 p_APPLICATION_ID IN NUMBER,
68 p_SYSTEM_ATTRIBUTE_TYPE IN VARCHAR2,
69 p_LAST_UPDATE_DATE IN DATE,
70 p_LAST_UPDATED_BY IN NUMBER,
71 p_LAST_UPDATE_LOGIN IN NUMBER
72 );
73
74 PROCEDURE DELETE_ROW
75 ( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77 p_commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79 p_return_status OUT NOCOPY VARCHAR2,
80 p_msg_count OUT NOCOPY NUMBER,
81 p_msg_data OUT NOCOPY VARCHAR2,
82 --
83 p_ATTRIBUTE_ID IN NUMBER
84 );
85
86 PROCEDURE LOCK_ROW
87 ( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 p_return_status OUT NOCOPY VARCHAR2,
92 p_msg_count OUT NOCOPY NUMBER,
93 p_msg_data OUT NOCOPY VARCHAR2,
94 --
95 p_lock_row OUT NOCOPY VARCHAR2,
96 --
97 p_ROW_ID IN VARCHAR2,
98 p_ATTRIBUTE_ID IN NUMBER,
99 p_BUSINESS_GROUP_ID IN NUMBER,
100 p_NAME IN VARCHAR2,
101 p_DISPLAY_IN_WORKSHEET IN VARCHAR2,
102 p_DISPLAY_SEQUENCE IN NUMBER,
103 p_DISPLAY_PROMPT IN VARCHAR2,
104 p_REQUIRED_FOR_IMPORT_FLAG IN VARCHAR2,
105 p_REQUIRED_FOR_POSITIONS_FLAG IN VARCHAR2,
106 p_ALLOW_IN_POSITION_SET_FLAG IN VARCHAR2,
107 p_VALUE_TABLE_FLAG IN VARCHAR2,
108 p_PROTECTED_FLAG IN VARCHAR2,
109 p_DEFINITION_TYPE IN VARCHAR2,
110 p_DEFINITION_STRUCTURE IN VARCHAR2,
111 p_DEFINITION_TABLE IN VARCHAR2,
112 p_DEFINITION_COLUMN IN VARCHAR2,
113 p_ATTRIBUTE_TYPE_ID IN NUMBER,
114 p_DATA_TYPE IN VARCHAR2,
115 p_APPLICATION_ID IN NUMBER,
116 p_SYSTEM_ATTRIBUTE_TYPE IN VARCHAR2
117 );
118
119 PROCEDURE Check_Unique
120 (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 p_return_status OUT NOCOPY VARCHAR2,
126 p_msg_count OUT NOCOPY NUMBER,
127 p_msg_data OUT NOCOPY VARCHAR2,
128 --
129 p_Row_Id IN VARCHAR2,
130 p_Name IN VARCHAR2,
131 p_Business_Group_ID IN NUMBER,
132 p_Return_Value IN OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE Check_References1
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 p_return_status OUT NOCOPY VARCHAR2,
142 p_msg_count OUT NOCOPY NUMBER,
143 p_msg_data OUT NOCOPY VARCHAR2,
144 --
145 p_ATTRIBUTE_ID IN NUMBER,
146 p_Return_Value IN OUT NOCOPY VARCHAR2
147 );
148
149
150
151 PROCEDURE Check_References2
152 (
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 p_return_status OUT NOCOPY VARCHAR2,
158 p_msg_count OUT NOCOPY NUMBER,
159 p_msg_data OUT NOCOPY VARCHAR2,
160 --
161 p_attribute_id IN NUMBER,
162 p_Return_Value IN OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE Insert_System_Attributes
166 (
167
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 p_return_status OUT NOCOPY VARCHAR2,
173 p_msg_count OUT NOCOPY NUMBER,
174 p_msg_data OUT NOCOPY VARCHAR2,
175 --
176 p_business_group_id IN NUMBER
177 );
178
179 FUNCTION GET_TRANSLATED_NAME(p_sys_attribute_type IN varchar2)
180 RETURN varchar2;
181 PRAGMA RESTRICT_REFERENCES(GET_TRANSLATED_NAME, WNDS);
182
183 PROCEDURE ADD_LANGUAGE;
184
185 END PSB_POSITION_ATTRIBUTES_PVT;