88: FUNCTION Contains_Value(
89: p_party_id NUMBER
90: , p_category VARCHAR2
91: , p_preference_code VARCHAR2
92: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
93: , p_value_number NUMBER := FND_API.G_MISS_NUM
94: , p_value_date DATE := FND_API.G_MISS_DATE
95: ) RETURN VARCHAR2;
96:
89: p_party_id NUMBER
90: , p_category VARCHAR2
91: , p_preference_code VARCHAR2
92: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
93: , p_value_number NUMBER := FND_API.G_MISS_NUM
94: , p_value_date DATE := FND_API.G_MISS_DATE
95: ) RETURN VARCHAR2;
96:
97:
90: , p_category VARCHAR2
91: , p_preference_code VARCHAR2
92: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
93: , p_value_number NUMBER := FND_API.G_MISS_NUM
94: , p_value_date DATE := FND_API.G_MISS_DATE
95: ) RETURN VARCHAR2;
96:
97:
98: ----------------------------------------------------------------
156: PROCEDURE Add(
157: p_party_id NUMBER
158: , p_category VARCHAR2
159: , p_preference_code VARCHAR2
160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
157: p_party_id NUMBER
158: , p_category VARCHAR2
159: , p_preference_code VARCHAR2
160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
158: , p_category VARCHAR2
159: , p_preference_code VARCHAR2
160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
159: , p_preference_code VARCHAR2
160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
161: , p_value_number NUMBER := FND_API.G_MISS_NUM
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
169: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
162: , p_value_date DATE := FND_API.G_MISS_DATE
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
169: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
170: , x_return_status OUT NOCOPY VARCHAR2
163: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
169: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
170: , x_return_status OUT NOCOPY VARCHAR2
171: , x_msg_count OUT NOCOPY NUMBER
164: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
169: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
170: , x_return_status OUT NOCOPY VARCHAR2
171: , x_msg_count OUT NOCOPY NUMBER
172: , x_msg_data OUT NOCOPY VARCHAR2
165: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
166: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
168: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
169: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
170: , x_return_status OUT NOCOPY VARCHAR2
171: , x_msg_count OUT NOCOPY NUMBER
172: , x_msg_data OUT NOCOPY VARCHAR2
173: , x_object_version_number OUT NOCOPY NUMBER
242: PROCEDURE Put(
243: p_party_id NUMBER
244: , p_category VARCHAR2
245: , p_preference_code VARCHAR2
246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
243: p_party_id NUMBER
244: , p_category VARCHAR2
245: , p_preference_code VARCHAR2
246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
244: , p_category VARCHAR2
245: , p_preference_code VARCHAR2
246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
245: , p_preference_code VARCHAR2
246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
247: , p_value_number NUMBER := FND_API.G_MISS_NUM
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
255: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
248: , p_value_date DATE := FND_API.G_MISS_DATE
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
255: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
256: , p_object_version_number IN OUT NOCOPY NUMBER
249: , p_value_name VARCHAR2 := FND_API.G_MISS_CHAR
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
255: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
256: , p_object_version_number IN OUT NOCOPY NUMBER
257: , x_return_status OUT NOCOPY VARCHAR2
250: , p_module VARCHAR2 := FND_API.G_MISS_CHAR
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
255: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
256: , p_object_version_number IN OUT NOCOPY NUMBER
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_msg_count OUT NOCOPY NUMBER
251: , p_additional_value1 VARCHAR2 := FND_API.G_MISS_CHAR
252: , p_additional_value2 VARCHAR2 := FND_API.G_MISS_CHAR
253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR
254: , p_additional_value4 VARCHAR2 := FND_API.G_MISS_CHAR
255: , p_additional_value5 VARCHAR2 := FND_API.G_MISS_CHAR
256: , p_object_version_number IN OUT NOCOPY NUMBER
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_msg_count OUT NOCOPY NUMBER
259: , x_msg_data OUT NOCOPY VARCHAR2
319: PROCEDURE Remove(
320: p_party_id NUMBER
321: , p_category VARCHAR2
322: , p_preference_code VARCHAR2
323: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
324: , p_value_number NUMBER := FND_API.G_MISS_NUM
325: , p_value_date DATE := FND_API.G_MISS_DATE
326: , p_object_version_number NUMBER
327: , x_return_status OUT NOCOPY VARCHAR2
320: p_party_id NUMBER
321: , p_category VARCHAR2
322: , p_preference_code VARCHAR2
323: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
324: , p_value_number NUMBER := FND_API.G_MISS_NUM
325: , p_value_date DATE := FND_API.G_MISS_DATE
326: , p_object_version_number NUMBER
327: , x_return_status OUT NOCOPY VARCHAR2
328: , x_msg_count OUT NOCOPY NUMBER
321: , p_category VARCHAR2
322: , p_preference_code VARCHAR2
323: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR
324: , p_value_number NUMBER := FND_API.G_MISS_NUM
325: , p_value_date DATE := FND_API.G_MISS_DATE
326: , p_object_version_number NUMBER
327: , x_return_status OUT NOCOPY VARCHAR2
328: , x_msg_count OUT NOCOPY NUMBER
329: , x_msg_data OUT NOCOPY VARCHAR2