APPS.AMS_LIST_SRC_FIELDS_PKG dependencies on FND_API

Line 114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),

110: attb_lov_id ,
111: lov_defined_flag ,
112: column_type
113: ) VALUES (
114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

111: lov_defined_flag ,
112: column_type
113: ) VALUES (
114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

112: column_type
113: ) VALUES (
114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

113: ) VALUES (
114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),

Line 118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

114: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),

Line 119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

115: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),

Line 120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

116: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),

Line 121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),

117: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

Line 122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),

118: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

Line 123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),

119: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),

Line 124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),

120: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),

Line 125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

121: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),

Line 126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

122: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),

Line 127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),

123: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),

Line 128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),

124: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),

Line 129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),

125: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

Line 130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),

126: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),

Line 131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),

127: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),

Line 132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),

128: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),

Line 133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

129: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),

Line 134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),

130: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),

Line 135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),

131: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),

Line 136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),

132: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),

Line 137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),

133: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),

Line 138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),

134: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)

Line 139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),

135: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );

Line 140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),

136: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );
144:

Line 141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),

137: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );
144:
145: insert into AMS_LIST_SRC_FIELDS_TL (

Line 142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)

138: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
139: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
140: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );
144:
145: insert into AMS_LIST_SRC_FIELDS_TL (
146: LANGUAGE,

Line 158: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),

154: LAST_UPDATE_LOGIN
155: ) select
156: l.language_code,
157: userenv('LANG'),
158: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),
159: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
160: --Modified for bug 5237401. bmuthukr
161: /*
162: sysdate,

Line 159: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),

155: ) select
156: l.language_code,
157: userenv('LANG'),
158: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),
159: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
160: --Modified for bug 5237401. bmuthukr
161: /*
162: sysdate,
163: FND_GLOBAL.user_id,

Line 167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

163: FND_GLOBAL.user_id,
164: sysdate,
165: FND_GLOBAL.user_id,
166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
171: --

Line 168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

164: sysdate,
165: FND_GLOBAL.user_id,
166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
171: --
172: FND_GLOBAL.conc_login_id

Line 169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

165: FND_GLOBAL.user_id,
166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
171: --
172: FND_GLOBAL.conc_login_id
173: from FND_LANGUAGES L

Line 170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

166: */
167: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
168: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
169: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
170: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
171: --
172: FND_GLOBAL.conc_login_id
173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')

Line 238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),

234: IS
235: BEGIN
236: Update AMS_LIST_SRC_FIELDS
237: SET
238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

235: BEGIN
236: Update AMS_LIST_SRC_FIELDS
237: SET
238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

236: Update AMS_LIST_SRC_FIELDS
237: SET
238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

Line 241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

237: SET
238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),

Line 242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

238: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),

Line 243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

239: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),

Line 244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

240: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),

Line 245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),

241: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

Line 246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),

242: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),

243: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),

Line 248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),

244: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),

Line 249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

245: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),

Line 250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

246: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),

Line 251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),

247: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),

Line 252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),

248: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),

Line 253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),

249: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

Line 254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),

250: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),

Line 255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),

251: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),

Line 256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),

252: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),

Line 257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

253: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),

Line 258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),

254: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),

Line 259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),

255: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),

Line 260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),

256: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),

Line 261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),

257: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),

Line 262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),

258: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)

Line 263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),

259: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
267:

Line 264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),

260: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
267:
268: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID

Line 265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),

261: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
267:
268: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
269: AND object_version_number = p_object_version_number;

Line 266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)

262: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
263: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
264: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
265: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
266: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
267:
268: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
269: AND object_version_number = p_object_version_number;
270:

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
269: AND object_version_number = p_object_version_number;
270:
271: IF (SQL%NOTFOUND) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: update AMS_LIST_SRC_FIELDS_TL set
276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),

Line 276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),

272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: update AMS_LIST_SRC_FIELDS_TL set
276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
280: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),

Line 280: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),

276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
280: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
281: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
282: SOURCE_LANG = userenv('LANG')
283: where list_source_field_id = p_list_source_field_id
284: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: where list_source_field_id = p_list_source_field_id
284: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
285:
286: IF (SQL%NOTFOUND) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290:
291: END Update_Row;

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: BEGIN
314: DELETE FROM AMS_LIST_SRC_FIELDS
315: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;
316: If (SQL%NOTFOUND) then
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: End If;
319:
320: DELETE FROM AMS_LIST_SRC_FIELDS_TL
321: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319:
320: DELETE FROM AMS_LIST_SRC_FIELDS_TL
321: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;
322: If (SQL%NOTFOUND) then
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: End If;
325: END Delete_Row ;
326:
327:

Line 477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),

473: DEFAULT_CHART_TYPE ,
474: USE_FOR_SPLITTING_FLAG ,
475: column_type
476: ) VALUES (
477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

474: USE_FOR_SPLITTING_FLAG ,
475: column_type
476: ) VALUES (
477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

475: column_type
476: ) VALUES (
477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

476: ) VALUES (
477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),

Line 481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

477: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),

Line 482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

478: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),

Line 483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

479: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),

Line 484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),

480: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

Line 485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),

481: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

Line 486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),

482: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),

Line 487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),

483: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),

Line 488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),

484: DECODE( p_de_list_source_type_code, FND_API.g_miss_char, NULL, p_de_list_source_type_code),
485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),

Line 489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

485: DECODE( p_list_source_type_id, FND_API.g_miss_num, NULL, p_list_source_type_id),
486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),

Line 490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),

486: DECODE( p_field_table_name, FND_API.g_miss_char, NULL, p_field_table_name),
487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),

Line 491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),

487: DECODE( p_field_column_name, FND_API.g_miss_char, NULL, p_field_column_name),
488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),

Line 492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),

488: DECODE( p_source_column_name, FND_API.g_miss_char, NULL, p_source_column_name),
489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

Line 493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),

489: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),

Line 494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),

490: DECODE( p_start_position, FND_API.g_miss_num, NULL, p_start_position),
491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),

Line 495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),

491: DECODE( p_end_position, FND_API.g_miss_num, NULL, p_end_position),
492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),

Line 496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

492: decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,null,p_field_data_type),
493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),

Line 497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),

493: decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,null,p_field_data_size),
494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),

Line 498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),

494: decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,null,p_DEFAULT_UI_CONTROL ),
495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),

Line 499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),

495: decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE),
496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),

Line 500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),

496: decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,null,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),

Line 501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),

497: decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,null,p_ALLOW_LABEL_OVERRIDE ),
498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),

Line 502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),

498: decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,null,p_FIELD_USAGE_TYPE),
499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),

Line 503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),

499: decode( p_dialog_enabled,FND_API.g_miss_char,null,p_dialog_enabled),
500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),

Line 504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),

500: decode( p_analytics_flag,FND_API.g_miss_char,null,p_analytics_flag),
501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),

Line 505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),

501: decode( p_auto_binning_flag,FND_API.g_miss_char,null,p_auto_binning_flag),
502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)

Line 506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),

502: decode( p_no_of_buckets,FND_API.g_miss_char,null,p_no_of_buckets),
503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );

Line 507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),

503: decode( p_attb_lov_id,FND_API.g_miss_num,null,p_attb_lov_id),
504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );
511:

Line 508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),

504: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );
511:
512: insert into AMS_LIST_SRC_FIELDS_TL (

Line 509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)

505: decode( p_used_in_list_entries,FND_API.g_miss_char,null,p_used_in_list_entries),
506: decode( p_chart_enabled_flag,FND_API.g_miss_char,null,p_chart_enabled_flag),
507: decode( p_default_chart_type,FND_API.g_miss_char,null,p_default_chart_type),
508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );
511:
512: insert into AMS_LIST_SRC_FIELDS_TL (
513: LANGUAGE,

Line 525: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),

521: LAST_UPDATE_LOGIN
522: ) select
523: l.language_code,
524: userenv('LANG'),
525: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),
526: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
527: --Added for bug 5237401. bmuthukr
528: /*
529: sysdate,

Line 526: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),

522: ) select
523: l.language_code,
524: userenv('LANG'),
525: DECODE( p_source_column_meaning, FND_API.g_miss_char, NULL, p_source_column_meaning),
526: DECODE( px_list_source_field_id, FND_API.g_miss_num, NULL, px_list_source_field_id),
527: --Added for bug 5237401. bmuthukr
528: /*
529: sysdate,
530: FND_GLOBAL.user_id,

Line 534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

530: FND_GLOBAL.user_id,
531: sysdate,
532: FND_GLOBAL.user_id,
533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
538: --

Line 535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

531: sysdate,
532: FND_GLOBAL.user_id,
533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
538: --
539: FND_GLOBAL.conc_login_id

Line 536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

532: FND_GLOBAL.user_id,
533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
538: --
539: FND_GLOBAL.conc_login_id
540: from FND_LANGUAGES L

Line 537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

533: */
534: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
535: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
536: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
537: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
538: --
539: FND_GLOBAL.conc_login_id
540: from FND_LANGUAGES L
541: where L.INSTALLED_FLAG in ('I', 'B')

Line 609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),

605: IS
606: BEGIN
607: Update AMS_LIST_SRC_FIELDS
608: SET
609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

606: BEGIN
607: Update AMS_LIST_SRC_FIELDS
608: SET
609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

607: Update AMS_LIST_SRC_FIELDS
608: SET
609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

Line 612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

608: SET
609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),

Line 613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

609: list_source_field_id = DECODE( p_list_source_field_id, FND_API.g_miss_num, list_source_field_id, p_list_source_field_id),
610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),

Line 614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),

Line 615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),

611: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),

Line 616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),

612: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

Line 617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),

613: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

Line 618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),

614: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),

Line 619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),

615: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 1, p_object_version_number+1 ),
616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),

Line 620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),

616: de_list_source_type_code = DECODE( p_de_list_source_type_code, FND_API.g_miss_char, de_list_source_type_code, p_de_list_source_type_code),
617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),

Line 621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),

617: list_source_type_id = DECODE( p_list_source_type_id, FND_API.g_miss_num, list_source_type_id, p_list_source_type_id),
618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),

Line 622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),

618: field_table_name = DECODE( p_field_table_name, FND_API.g_miss_char, field_table_name, p_field_table_name),
619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),

Line 623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),

619: field_column_name = DECODE( p_field_column_name, FND_API.g_miss_char, field_column_name, p_field_column_name),
620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),

Line 624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),

620: source_column_name = DECODE( p_source_column_name, FND_API.g_miss_char, source_column_name, p_source_column_name),
621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

Line 625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),

621: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag),
622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),

Line 626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),

622: start_position = DECODE( p_start_position, FND_API.g_miss_num, start_position, p_start_position),
623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),

Line 627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),

623: end_position = DECODE( p_end_position, FND_API.g_miss_num, end_position, p_end_position),
624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),

Line 628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),

624: FIELD_DATA_TYPE = decode( p_FIELD_DATA_TYPE ,FND_API.g_miss_char,FIELD_DATA_TYPE ,p_field_data_type),
625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),

Line 629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),

625: FIELD_DATA_SIZE = decode( p_FIELD_DATA_SIZE ,FND_API.g_miss_num,FIELD_DATA_SIZE,p_field_data_size),
626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),

Line 630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),

626: DEFAULT_UI_CONTROL= decode( p_DEFAULT_UI_CONTROL ,FND_API.g_miss_char,DEFAULT_UI_CONTROL,p_DEFAULT_UI_CONTROL ),
627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),

Line 631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),

627: FIELD_LOOKUP_TYPE = decode( p_FIELD_LOOKUP_TYPE,FND_API.g_miss_char,FIELD_LOOKUP_TYPE,p_FIELD_LOOKUP_TYPE),
628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),

Line 632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),

628: FIELD_LOOKUP_TYPE_VIEW_NAME = decode( p_FIELD_LOOKUP_TYPE_VIEW_NAME,FND_API.g_miss_char,FIELD_LOOKUP_TYPE_VIEW_NAME,p_FIELD_LOOKUP_TYPE_VIEW_NAME),
629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),

Line 633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),

629: ALLOW_LABEL_OVERRIDE= decode( p_ALLOW_LABEL_OVERRIDE ,FND_API.g_miss_char,ALLOW_LABEL_OVERRIDE ,p_ALLOW_LABEL_OVERRIDE ),
630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),

Line 634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),

630: FIELD_USAGE_TYPE= decode( p_FIELD_USAGE_TYPE,FND_API.g_miss_char,FIELD_USAGE_TYPE,p_FIELD_USAGE_TYPE),
631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),

Line 635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),

631: dialog_enabled= decode( p_dialog_enabled,FND_API.g_miss_char,dialog_enabled,p_dialog_enabled),
632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),

Line 636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),

632: analytics_flag = decode( p_analytics_flag,FND_API.g_miss_char,analytics_flag,p_analytics_flag),
633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),

Line 637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),

633: auto_binning_flag = decode( p_auto_binning_flag,FND_API.g_miss_char,auto_binning_flag,p_auto_binning_flag),
634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),
641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)

Line 638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),

634: no_of_buckets = decode( p_no_of_buckets,FND_API.g_miss_num,no_of_buckets,p_no_of_buckets),
635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),
641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
642: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID

Line 639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),

635: attb_lov_id = decode( p_attb_lov_id,FND_API.g_miss_num,attb_lov_id,p_attb_lov_id),
636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),
641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
642: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
643: AND object_version_number = p_object_version_number;

Line 640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),

636: lov_defined_flag = decode( p_lov_defined_flag,FND_API.g_miss_char,lov_defined_flag,p_lov_defined_flag),
637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),
641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
642: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
643: AND object_version_number = p_object_version_number;
644:

Line 641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)

637: used_in_list_entries = decode( p_used_in_list_entries,FND_API.g_miss_char,used_in_list_entries,p_used_in_list_entries),
638: chart_enabled_flag = decode( p_chart_enabled_flag,FND_API.g_miss_char,chart_enabled_flag,p_chart_enabled_flag),
639: default_chart_type = decode( p_default_chart_type,FND_API.g_miss_char,default_chart_type,p_default_chart_type),
640: use_for_splitting_flag = decode( p_use_for_splitting_flag,FND_API.g_miss_char,use_for_splitting_flag,p_use_for_splitting_flag),
641: column_type = decode( p_column_type,FND_API.g_miss_char,column_type,p_column_type)
642: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
643: AND object_version_number = p_object_version_number;
644:
645: IF (SQL%NOTFOUND) THEN

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID
643: AND object_version_number = p_object_version_number;
644:
645: IF (SQL%NOTFOUND) THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649: update AMS_LIST_SRC_FIELDS_TL set
650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),

Line 650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),

646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649: update AMS_LIST_SRC_FIELDS_TL set
650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
654: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),

Line 654: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),

650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,
654: last_update_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
655: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
656: SOURCE_LANG = userenv('LANG')
657: where list_source_field_id = p_list_source_field_id
658: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

657: where list_source_field_id = p_list_source_field_id
658: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
659:
660: IF (SQL%NOTFOUND) THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: END IF;
663:
664:
665: END Update_Row;