50:
51: --===================================================================
52: TYPE list_src_field_rec_type IS RECORD
53: (
54: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
51: --===================================================================
52: TYPE list_src_field_rec_type IS RECORD
53: (
54: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
52: TYPE list_src_field_rec_type IS RECORD
53: (
54: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
53: (
54: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: list_source_field_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: last_updated_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
60: object_version_number NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
61: de_list_source_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
62: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
63: field_table_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: field_column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
65: source_column_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: source_column_meaning VARCHAR2(120) := FND_API.G_MISS_CHAR,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
67: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: start_position NUMBER := FND_API.G_MISS_NUM,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: end_position NUMBER := FND_API.G_MISS_NUM,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: analytics_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: auto_binning_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: no_of_buckets NUMBER := FND_API.G_MISS_NUM,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
73: FIELD_DATA_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
74: FIELD_DATA_SIZE NUMBER := FND_API.G_MISS_NUM,
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
82: LOV_DEFINED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
75: DEFAULT_UI_CONTROL VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
82: LOV_DEFINED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
83:
76: FIELD_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
82: LOV_DEFINED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
83:
84: );
77: FIELD_LOOKUP_TYPE_VIEW_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
82: LOV_DEFINED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
83:
84: );
85:
78: ALLOW_LABEL_OVERRIDE VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: FIELD_USAGE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: DIALOG_ENABLED VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: ATTB_LOV_ID NUMBER := FND_API.G_MISS_NUM,
82: LOV_DEFINED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
83:
84: );
85:
86: g_miss_list_src_field_rec list_src_field_rec_type;
99: -- Parameters
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_src_field_rec IN list_src_field_rec_type Required
107: --
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_src_field_rec IN list_src_field_rec_type Required
107: --
108: -- OUT
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_src_field_rec IN list_src_field_rec_type Required
107: --
108: -- OUT
109: -- x_return_status OUT VARCHAR2
118: --
119:
120: PROCEDURE Create_List_Src_Field(
121: p_api_version_number 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:
126: x_return_status OUT NOCOPY VARCHAR2,
119:
120: PROCEDURE Create_List_Src_Field(
121: p_api_version_number 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:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
120: PROCEDURE Create_List_Src_Field(
121: p_api_version_number 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:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
143: -- Parameters
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_src_field_rec IN list_src_field_rec_type Required
151: --
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_src_field_rec IN list_src_field_rec_type Required
151: --
152: -- OUT
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_src_field_rec IN list_src_field_rec_type Required
151: --
152: -- OUT
153: -- x_return_status OUT VARCHAR2
162: --
163:
164: PROCEDURE Update_List_Src_Field(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
163:
164: PROCEDURE Update_List_Src_Field(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
164: PROCEDURE Update_List_Src_Field(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
187: -- Parameters
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_LIST_SOURCE_FIELD_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
197: -- OUT
207: --
208:
209: PROCEDURE Delete_List_Src_Field(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
208:
209: PROCEDURE Delete_List_Src_Field(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
209: PROCEDURE Delete_List_Src_Field(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_list_source_field_id IN NUMBER,
230: -- Parameters
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_src_field_rec IN list_src_field_rec_type Required
238: --
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_src_field_rec IN list_src_field_rec_type Required
238: --
239: -- OUT
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_src_field_rec IN list_src_field_rec_type Required
238: --
239: -- OUT
240: -- x_return_status OUT VARCHAR2
249: --
250:
251: PROCEDURE Lock_List_Src_Field(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254:
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
273: -- End of Comments
274:
275: PROCEDURE Validate_list_src_field(
276: p_api_version_number IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
279: p_list_src_field_rec IN list_src_field_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
274:
275: PROCEDURE Validate_list_src_field(
276: p_api_version_number IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
279: p_list_src_field_rec IN list_src_field_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2
311: -- End of Comments
312:
313: PROCEDURE Validate_list_src_field_rec(
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_list_src_field_rec IN list_src_field_rec_type