27: -- create a row in AMS_LIST_WORD_FIELDS
28: -- Parameters
29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_wrd_fld_rec IN wrd_fld_rec_type
28: -- Parameters
29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_wrd_fld_rec IN wrd_fld_rec_type
36: --
29: -- IN:
30: -- p_api_version IN NUMBER
31: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32: -- p_commit IN VARCHAR2 := FND_API.g_false
33: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34: --
35: -- p_wrd_fld_rec IN wrd_fld_rec_type
36: --
37: -- OUT:
43: ------------------------------------------------------------------------------
44: PROCEDURE create_list_word_field
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,
44: PROCEDURE create_list_word_field
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
45: (
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48: p_commit IN VARCHAR2 := FND_API.g_false,
49: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50:
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
63: -- update a row in AMS_LIST_WORD_FIELDS
64: -- Parameters
65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: --
71: -- p_wrd_fld_rec IN wrd_fld_rec_type
64: -- Parameters
65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: --
71: -- p_wrd_fld_rec IN wrd_fld_rec_type
72: --
65: -- IN:
66: -- p_api_version IN NUMBER
67: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68: -- p_commit IN VARCHAR2 := FND_API.g_false
69: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70: --
71: -- p_wrd_fld_rec IN wrd_fld_rec_type
72: --
73: -- OUT:
77: ------------------------------------------------------------------------------
78: PROCEDURE update_list_word_field
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY VARCHAR2,
78: PROCEDURE update_list_word_field
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84:
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
96: -- delete a row from AMS_LIST_WORD_FIELDS
97: -- Parameters
98: -- IN:
99: -- p_api_version IN NUMBER
100: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
101: -- p_commit IN VARCHAR2 := FND_API.g_false
102: --
103: -- p_wrd_fld_id IN NUMBER
104: -- p_object_version IN NUMBER
97: -- Parameters
98: -- IN:
99: -- p_api_version IN NUMBER
100: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
101: -- p_commit IN VARCHAR2 := FND_API.g_false
102: --
103: -- p_wrd_fld_id IN NUMBER
104: -- p_object_version IN NUMBER
105: --
110: ------------------------------------------------------------------------------
111: PROCEDURE delete_list_word_field
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116:
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
111: PROCEDURE delete_list_word_field
112: (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115: p_commit IN VARCHAR2 := FND_API.g_false,
116:
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
129: -- lock a row form AMS_LIST_WORD_FIELDS
130: -- Parameters
131: -- IN:
132: -- p_api_version IN NUMBER
133: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
134: --
135: -- p_wrd_fld_id IN NUMBER
136: -- p_object_version IN NUMBER
137: --
142: ------------------------------------------------------------------------------
143: PROCEDURE lock_list_word_field
144: (
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
161: -- AMS_LIST_WORD_FIELDS
162: -- Parameters
163: -- IN:
164: -- p_api_version IN NUMBER
165: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
166: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
167: --
168: -- p_wrd_fld_rec IN wrd_fld_rec_type
169: --
162: -- Parameters
163: -- IN:
164: -- p_api_version IN NUMBER
165: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
166: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
167: --
168: -- p_wrd_fld_rec IN wrd_fld_rec_type
169: --
170: -- OUT:
174: ------------------------------------------------------------------------------
175: PROCEDURE validate_list_word_field
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
180:
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
175: PROCEDURE validate_list_word_field
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
180:
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,