51:
52: --===================================================================
53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
52: --===================================================================
53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: TYPE list_src_field_rec_type IS RECORD
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: (
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
56: last_update_date DATE := FND_API.G_MISS_DATE,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: last_updated_by NUMBER := FND_API.G_MISS_NUM,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: created_by NUMBER := FND_API.G_MISS_NUM,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
62: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
63: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
64: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
65: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
67: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
68: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );
69: start_position NUMBER := FND_API.G_MISS_NUM,
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );
77:
70: end_position NUMBER := FND_API.G_MISS_NUM,
71: security_group_id NUMBER := FND_API.G_MISS_NUM,
72: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: no_of_buckets NUMBER := FND_API.G_MISS_NUM
75:
76: );
77:
78: g_miss_list_src_field_rec list_src_field_rec_type;
97: -- Parameters
98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_list_src_field_rec IN list_src_field_rec_type Required
104: --
105: -- OUT
98: --
99: -- IN
100: -- p_api_version_number IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
102: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
103: -- p_list_src_field_rec IN list_src_field_rec_type Required
104: --
105: -- OUT
106: -- x_return_status OUT VARCHAR2
115: --
116:
117: PROCEDURE Create_List_Src_Field(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
116:
117: PROCEDURE Create_List_Src_Field(
118: p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121:
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
139: -- Parameters
140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_list_src_field_rec IN list_src_field_rec_type Required
146: --
147: -- OUT
140: --
141: -- IN
142: -- p_api_version_number IN NUMBER Required
143: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_list_src_field_rec IN list_src_field_rec_type Required
146: --
147: -- OUT
148: -- x_return_status OUT VARCHAR2
157: --
158:
159: PROCEDURE Update_List_Src_Field(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
158:
159: PROCEDURE Update_List_Src_Field(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
181: -- Parameters
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
188: -- p_object_version_number IN NUMBER Optional Default = NULL
189: --
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
188: -- p_object_version_number IN NUMBER Optional Default = NULL
189: --
190: -- OUT
200: --
201:
202: PROCEDURE Delete_List_Src_Field(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
201:
202: PROCEDURE Delete_List_Src_Field(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_list_source_field_id IN NUMBER,
222: -- Parameters
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_list_src_field_rec IN list_src_field_rec_type Required
229: --
230: -- OUT
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_list_src_field_rec IN list_src_field_rec_type Required
229: --
230: -- OUT
231: -- x_return_status OUT VARCHAR2
240: --
241:
242: PROCEDURE Lock_List_Src_Field(
243: p_api_version_number IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: