DBA Data[Home] [Help]

APPS.HZ_PREFERENCE_PUB dependencies on FND_API

Line 92: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR

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:

Line 93: , p_value_number NUMBER := FND_API.G_MISS_NUM

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:

Line 94: , p_value_date DATE := FND_API.G_MISS_DATE

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: ----------------------------------------------------------------

Line 160: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 161: , p_value_number NUMBER := FND_API.G_MISS_NUM

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

Line 162: , p_value_date DATE := FND_API.G_MISS_DATE

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

Line 163: , p_value_name 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

Line 164: , p_module 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

Line 165: , p_additional_value1 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

Line 166: , p_additional_value2 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

Line 167: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 168: , p_additional_value4 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
172: , x_msg_data OUT NOCOPY VARCHAR2

Line 169: , p_additional_value5 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
173: , x_object_version_number OUT NOCOPY NUMBER

Line 246: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 247: , p_value_number NUMBER := FND_API.G_MISS_NUM

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

Line 248: , p_value_date DATE := FND_API.G_MISS_DATE

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

Line 249: , p_value_name 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

Line 250: , p_module 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

Line 251: , p_additional_value1 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

Line 252: , p_additional_value2 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

Line 253: , p_additional_value3 VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 254: , p_additional_value4 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
258: , x_msg_count OUT NOCOPY NUMBER

Line 255: , p_additional_value5 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
259: , x_msg_data OUT NOCOPY VARCHAR2

Line 323: , p_value_varchar2 VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 324: , p_value_number NUMBER := FND_API.G_MISS_NUM

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

Line 325: , p_value_date DATE := FND_API.G_MISS_DATE

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