103: ,x_bali_col_label_text
104: ,x_bali_col_condition_code
105: ,x_bali_col_condition_value
106: ,x_bali_col_value
107: ,decode( x_right_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_right_parenthesis_code)
108: ,decode( x_left_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_left_parenthesis_code)
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
104: ,x_bali_col_condition_code
105: ,x_bali_col_condition_value
106: ,x_bali_col_value
107: ,decode( x_right_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_right_parenthesis_code)
108: ,decode( x_left_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_left_parenthesis_code)
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
105: ,x_bali_col_condition_value
106: ,x_bali_col_value
107: ,decode( x_right_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_right_parenthesis_code)
108: ,decode( x_left_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_left_parenthesis_code)
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
107: ,decode( x_right_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_right_parenthesis_code)
108: ,decode( x_left_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_left_parenthesis_code)
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
108: ,decode( x_left_parenthesis_code, FND_API.G_MISS_CHAR, NULL, x_left_parenthesis_code)
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
109: ,decode( x_boolean_operator_code, FND_API.G_MISS_CHAR, NULL, x_boolean_operator_code)
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
110: ,x_object_version_number
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
111: ,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: );
137:
138: OPEN C;
139: FETCH C INTO x_rowid;
189: x_last_update_login in number)
190: IS
191: BEGIN
192: UPDATE IEX_BALI_FILTERS SET
193: BALI_FILTER_ID = decode( x_BALI_FILTER_ID, FND_API.G_MISS_NUM, NULL,
194: NULL, BALI_FILTER_ID, x_BALI_FILTER_ID)
195: ,bali_filter_name =decode( x_bali_filter_name, fnd_api.g_miss_char,null,
196: null,bali_filter_name, x_bali_filter_name)
197: ,bali_datasource=decode( x_bali_datasource, fnd_api.g_miss_char,null,
191: BEGIN
192: UPDATE IEX_BALI_FILTERS SET
193: BALI_FILTER_ID = decode( x_BALI_FILTER_ID, FND_API.G_MISS_NUM, NULL,
194: NULL, BALI_FILTER_ID, x_BALI_FILTER_ID)
195: ,bali_filter_name =decode( x_bali_filter_name, fnd_api.g_miss_char,null,
196: null,bali_filter_name, x_bali_filter_name)
197: ,bali_datasource=decode( x_bali_datasource, fnd_api.g_miss_char,null,
198: null,bali_datasource, x_bali_datasource)
199: ,bali_user_id = decode( x_bali_user_id, FND_API.G_MISS_NUM, NULL,
193: BALI_FILTER_ID = decode( x_BALI_FILTER_ID, FND_API.G_MISS_NUM, NULL,
194: NULL, BALI_FILTER_ID, x_BALI_FILTER_ID)
195: ,bali_filter_name =decode( x_bali_filter_name, fnd_api.g_miss_char,null,
196: null,bali_filter_name, x_bali_filter_name)
197: ,bali_datasource=decode( x_bali_datasource, fnd_api.g_miss_char,null,
198: null,bali_datasource, x_bali_datasource)
199: ,bali_user_id = decode( x_bali_user_id, FND_API.G_MISS_NUM, NULL,
200: NULL, bali_user_id, x_bali_user_id)
201: ,bali_col_alias=decode( x_bali_col_alias, fnd_api.g_miss_char,null,
195: ,bali_filter_name =decode( x_bali_filter_name, fnd_api.g_miss_char,null,
196: null,bali_filter_name, x_bali_filter_name)
197: ,bali_datasource=decode( x_bali_datasource, fnd_api.g_miss_char,null,
198: null,bali_datasource, x_bali_datasource)
199: ,bali_user_id = decode( x_bali_user_id, FND_API.G_MISS_NUM, NULL,
200: NULL, bali_user_id, x_bali_user_id)
201: ,bali_col_alias=decode( x_bali_col_alias, fnd_api.g_miss_char,null,
202: null,bali_col_alias, x_bali_col_alias)
203: ,bali_col_data_type=decode( x_bali_col_data_type, fnd_api.g_miss_char,null,
197: ,bali_datasource=decode( x_bali_datasource, fnd_api.g_miss_char,null,
198: null,bali_datasource, x_bali_datasource)
199: ,bali_user_id = decode( x_bali_user_id, FND_API.G_MISS_NUM, NULL,
200: NULL, bali_user_id, x_bali_user_id)
201: ,bali_col_alias=decode( x_bali_col_alias, fnd_api.g_miss_char,null,
202: null,bali_col_alias, x_bali_col_alias)
203: ,bali_col_data_type=decode( x_bali_col_data_type, fnd_api.g_miss_char,null,
204: null,bali_col_data_type, x_bali_col_data_type)
205: ,bali_col_label_text=decode( x_bali_col_label_text, fnd_api.g_miss_char,null,
199: ,bali_user_id = decode( x_bali_user_id, FND_API.G_MISS_NUM, NULL,
200: NULL, bali_user_id, x_bali_user_id)
201: ,bali_col_alias=decode( x_bali_col_alias, fnd_api.g_miss_char,null,
202: null,bali_col_alias, x_bali_col_alias)
203: ,bali_col_data_type=decode( x_bali_col_data_type, fnd_api.g_miss_char,null,
204: null,bali_col_data_type, x_bali_col_data_type)
205: ,bali_col_label_text=decode( x_bali_col_label_text, fnd_api.g_miss_char,null,
206: null,bali_col_label_text, x_bali_col_label_text)
207: ,bali_col_condition_code=decode( x_bali_col_condition_code, fnd_api.g_miss_char,null,
201: ,bali_col_alias=decode( x_bali_col_alias, fnd_api.g_miss_char,null,
202: null,bali_col_alias, x_bali_col_alias)
203: ,bali_col_data_type=decode( x_bali_col_data_type, fnd_api.g_miss_char,null,
204: null,bali_col_data_type, x_bali_col_data_type)
205: ,bali_col_label_text=decode( x_bali_col_label_text, fnd_api.g_miss_char,null,
206: null,bali_col_label_text, x_bali_col_label_text)
207: ,bali_col_condition_code=decode( x_bali_col_condition_code, fnd_api.g_miss_char,null,
208: null,bali_col_condition_code, x_bali_col_condition_code)
209: ,bali_col_condition_value=decode( x_bali_col_condition_value, fnd_api.g_miss_char,null,
203: ,bali_col_data_type=decode( x_bali_col_data_type, fnd_api.g_miss_char,null,
204: null,bali_col_data_type, x_bali_col_data_type)
205: ,bali_col_label_text=decode( x_bali_col_label_text, fnd_api.g_miss_char,null,
206: null,bali_col_label_text, x_bali_col_label_text)
207: ,bali_col_condition_code=decode( x_bali_col_condition_code, fnd_api.g_miss_char,null,
208: null,bali_col_condition_code, x_bali_col_condition_code)
209: ,bali_col_condition_value=decode( x_bali_col_condition_value, fnd_api.g_miss_char,null,
210: null,bali_col_condition_value, x_bali_col_condition_value)
211: ,bali_col_value=decode( x_bali_col_value, fnd_api.g_miss_char,null,
205: ,bali_col_label_text=decode( x_bali_col_label_text, fnd_api.g_miss_char,null,
206: null,bali_col_label_text, x_bali_col_label_text)
207: ,bali_col_condition_code=decode( x_bali_col_condition_code, fnd_api.g_miss_char,null,
208: null,bali_col_condition_code, x_bali_col_condition_code)
209: ,bali_col_condition_value=decode( x_bali_col_condition_value, fnd_api.g_miss_char,null,
210: null,bali_col_condition_value, x_bali_col_condition_value)
211: ,bali_col_value=decode( x_bali_col_value, fnd_api.g_miss_char,null,
212: null,bali_col_value, x_bali_col_value)
213: ,right_parenthesis_code = decode( x_right_parenthesis_code, fnd_api.g_miss_char,null,
207: ,bali_col_condition_code=decode( x_bali_col_condition_code, fnd_api.g_miss_char,null,
208: null,bali_col_condition_code, x_bali_col_condition_code)
209: ,bali_col_condition_value=decode( x_bali_col_condition_value, fnd_api.g_miss_char,null,
210: null,bali_col_condition_value, x_bali_col_condition_value)
211: ,bali_col_value=decode( x_bali_col_value, fnd_api.g_miss_char,null,
212: null,bali_col_value, x_bali_col_value)
213: ,right_parenthesis_code = decode( x_right_parenthesis_code, fnd_api.g_miss_char,null,
214: null,right_parenthesis_code, x_right_parenthesis_code)
215: ,left_parenthesis_code = decode( x_left_parenthesis_code, fnd_api.g_miss_char,null,
209: ,bali_col_condition_value=decode( x_bali_col_condition_value, fnd_api.g_miss_char,null,
210: null,bali_col_condition_value, x_bali_col_condition_value)
211: ,bali_col_value=decode( x_bali_col_value, fnd_api.g_miss_char,null,
212: null,bali_col_value, x_bali_col_value)
213: ,right_parenthesis_code = decode( x_right_parenthesis_code, fnd_api.g_miss_char,null,
214: null,right_parenthesis_code, x_right_parenthesis_code)
215: ,left_parenthesis_code = decode( x_left_parenthesis_code, fnd_api.g_miss_char,null,
216: null,left_parenthesis_code, x_left_parenthesis_code)
217: ,boolean_operator_code = decode( x_boolean_operator_code, fnd_api.g_miss_char,null,
211: ,bali_col_value=decode( x_bali_col_value, fnd_api.g_miss_char,null,
212: null,bali_col_value, x_bali_col_value)
213: ,right_parenthesis_code = decode( x_right_parenthesis_code, fnd_api.g_miss_char,null,
214: null,right_parenthesis_code, x_right_parenthesis_code)
215: ,left_parenthesis_code = decode( x_left_parenthesis_code, fnd_api.g_miss_char,null,
216: null,left_parenthesis_code, x_left_parenthesis_code)
217: ,boolean_operator_code = decode( x_boolean_operator_code, fnd_api.g_miss_char,null,
218: null,boolean_operator_code, x_boolean_operator_code)
219:
213: ,right_parenthesis_code = decode( x_right_parenthesis_code, fnd_api.g_miss_char,null,
214: null,right_parenthesis_code, x_right_parenthesis_code)
215: ,left_parenthesis_code = decode( x_left_parenthesis_code, fnd_api.g_miss_char,null,
216: null,left_parenthesis_code, x_left_parenthesis_code)
217: ,boolean_operator_code = decode( x_boolean_operator_code, fnd_api.g_miss_char,null,
218: null,boolean_operator_code, x_boolean_operator_code)
219:
220: ,object_version_number = decode( x_object_version_number, fnd_api.g_miss_num,null,
221: null,object_version_number, x_object_version_number)
216: null,left_parenthesis_code, x_left_parenthesis_code)
217: ,boolean_operator_code = decode( x_boolean_operator_code, fnd_api.g_miss_char,null,
218: null,boolean_operator_code, x_boolean_operator_code)
219:
220: ,object_version_number = decode( x_object_version_number, fnd_api.g_miss_num,null,
221: null,object_version_number, x_object_version_number)
222:
223: ,request_id = decode( x_request_id, fnd_api.g_miss_num,null,
224: null,request_id, x_request_id),
219:
220: ,object_version_number = decode( x_object_version_number, fnd_api.g_miss_num,null,
221: null,object_version_number, x_object_version_number)
222:
223: ,request_id = decode( x_request_id, fnd_api.g_miss_num,null,
224: null,request_id, x_request_id),
225: program_application_id = decode( x_program_application_id, fnd_api.g_miss_num,null,
226: null,program_application_id, x_program_application_id),
227: program_id = decode( x_program_id, fnd_api.g_miss_num,null,
221: null,object_version_number, x_object_version_number)
222:
223: ,request_id = decode( x_request_id, fnd_api.g_miss_num,null,
224: null,request_id, x_request_id),
225: program_application_id = decode( x_program_application_id, fnd_api.g_miss_num,null,
226: null,program_application_id, x_program_application_id),
227: program_id = decode( x_program_id, fnd_api.g_miss_num,null,
228: null,program_id, x_program_id),
229: program_update_date = decode( x_program_update_date, fnd_api.g_miss_date,null,
223: ,request_id = decode( x_request_id, fnd_api.g_miss_num,null,
224: null,request_id, x_request_id),
225: program_application_id = decode( x_program_application_id, fnd_api.g_miss_num,null,
226: null,program_application_id, x_program_application_id),
227: program_id = decode( x_program_id, fnd_api.g_miss_num,null,
228: null,program_id, x_program_id),
229: program_update_date = decode( x_program_update_date, fnd_api.g_miss_date,null,
230: null,program_update_date, x_program_update_date),
231: attribute_category = decode( x_attribute_category, fnd_api.g_miss_char,null,
225: program_application_id = decode( x_program_application_id, fnd_api.g_miss_num,null,
226: null,program_application_id, x_program_application_id),
227: program_id = decode( x_program_id, fnd_api.g_miss_num,null,
228: null,program_id, x_program_id),
229: program_update_date = decode( x_program_update_date, fnd_api.g_miss_date,null,
230: null,program_update_date, x_program_update_date),
231: attribute_category = decode( x_attribute_category, fnd_api.g_miss_char,null,
232: null,attribute_category, x_attribute_category),
233: attribute1 = decode( x_attribute1, fnd_api.g_miss_char,null,
227: program_id = decode( x_program_id, fnd_api.g_miss_num,null,
228: null,program_id, x_program_id),
229: program_update_date = decode( x_program_update_date, fnd_api.g_miss_date,null,
230: null,program_update_date, x_program_update_date),
231: attribute_category = decode( x_attribute_category, fnd_api.g_miss_char,null,
232: null,attribute_category, x_attribute_category),
233: attribute1 = decode( x_attribute1, fnd_api.g_miss_char,null,
234: null,attribute1, x_attribute1),
235: attribute2 = decode( x_attribute2, fnd_api.g_miss_char,null,
229: program_update_date = decode( x_program_update_date, fnd_api.g_miss_date,null,
230: null,program_update_date, x_program_update_date),
231: attribute_category = decode( x_attribute_category, fnd_api.g_miss_char,null,
232: null,attribute_category, x_attribute_category),
233: attribute1 = decode( x_attribute1, fnd_api.g_miss_char,null,
234: null,attribute1, x_attribute1),
235: attribute2 = decode( x_attribute2, fnd_api.g_miss_char,null,
236: null,attribute2, x_attribute2),
237: attribute3 = decode( x_attribute3, fnd_api.g_miss_char, null,
231: attribute_category = decode( x_attribute_category, fnd_api.g_miss_char,null,
232: null,attribute_category, x_attribute_category),
233: attribute1 = decode( x_attribute1, fnd_api.g_miss_char,null,
234: null,attribute1, x_attribute1),
235: attribute2 = decode( x_attribute2, fnd_api.g_miss_char,null,
236: null,attribute2, x_attribute2),
237: attribute3 = decode( x_attribute3, fnd_api.g_miss_char, null,
238: null,attribute3, x_attribute3),
239: attribute4 = decode( x_attribute4, fnd_api.g_miss_char,null,
233: attribute1 = decode( x_attribute1, fnd_api.g_miss_char,null,
234: null,attribute1, x_attribute1),
235: attribute2 = decode( x_attribute2, fnd_api.g_miss_char,null,
236: null,attribute2, x_attribute2),
237: attribute3 = decode( x_attribute3, fnd_api.g_miss_char, null,
238: null,attribute3, x_attribute3),
239: attribute4 = decode( x_attribute4, fnd_api.g_miss_char,null,
240: null,attribute4, x_attribute4),
241: attribute5 = decode( x_attribute5, fnd_api.g_miss_char,null,
235: attribute2 = decode( x_attribute2, fnd_api.g_miss_char,null,
236: null,attribute2, x_attribute2),
237: attribute3 = decode( x_attribute3, fnd_api.g_miss_char, null,
238: null,attribute3, x_attribute3),
239: attribute4 = decode( x_attribute4, fnd_api.g_miss_char,null,
240: null,attribute4, x_attribute4),
241: attribute5 = decode( x_attribute5, fnd_api.g_miss_char,null,
242: null,attribute5, x_attribute5),
243:
237: attribute3 = decode( x_attribute3, fnd_api.g_miss_char, null,
238: null,attribute3, x_attribute3),
239: attribute4 = decode( x_attribute4, fnd_api.g_miss_char,null,
240: null,attribute4, x_attribute4),
241: attribute5 = decode( x_attribute5, fnd_api.g_miss_char,null,
242: null,attribute5, x_attribute5),
243:
244: attribute6 = decode( x_attribute6, fnd_api.g_miss_char,null,
245: null,attribute6, x_attribute6),
240: null,attribute4, x_attribute4),
241: attribute5 = decode( x_attribute5, fnd_api.g_miss_char,null,
242: null,attribute5, x_attribute5),
243:
244: attribute6 = decode( x_attribute6, fnd_api.g_miss_char,null,
245: null,attribute6, x_attribute6),
246: attribute7 = decode( x_attribute7, fnd_api.g_miss_char,null,
247: null,attribute7, x_attribute7),
248: attribute8 = decode( x_attribute8, fnd_api.g_miss_char, null,
242: null,attribute5, x_attribute5),
243:
244: attribute6 = decode( x_attribute6, fnd_api.g_miss_char,null,
245: null,attribute6, x_attribute6),
246: attribute7 = decode( x_attribute7, fnd_api.g_miss_char,null,
247: null,attribute7, x_attribute7),
248: attribute8 = decode( x_attribute8, fnd_api.g_miss_char, null,
249: null,attribute8, x_attribute8),
250: attribute9= decode( x_attribute9, fnd_api.g_miss_char,null,
244: attribute6 = decode( x_attribute6, fnd_api.g_miss_char,null,
245: null,attribute6, x_attribute6),
246: attribute7 = decode( x_attribute7, fnd_api.g_miss_char,null,
247: null,attribute7, x_attribute7),
248: attribute8 = decode( x_attribute8, fnd_api.g_miss_char, null,
249: null,attribute8, x_attribute8),
250: attribute9= decode( x_attribute9, fnd_api.g_miss_char,null,
251: null,attribute9, x_attribute9),
252: attribute10 = decode( x_attribute10, fnd_api.g_miss_char,null,
246: attribute7 = decode( x_attribute7, fnd_api.g_miss_char,null,
247: null,attribute7, x_attribute7),
248: attribute8 = decode( x_attribute8, fnd_api.g_miss_char, null,
249: null,attribute8, x_attribute8),
250: attribute9= decode( x_attribute9, fnd_api.g_miss_char,null,
251: null,attribute9, x_attribute9),
252: attribute10 = decode( x_attribute10, fnd_api.g_miss_char,null,
253: null,attribute10, x_attribute10),
254:
248: attribute8 = decode( x_attribute8, fnd_api.g_miss_char, null,
249: null,attribute8, x_attribute8),
250: attribute9= decode( x_attribute9, fnd_api.g_miss_char,null,
251: null,attribute9, x_attribute9),
252: attribute10 = decode( x_attribute10, fnd_api.g_miss_char,null,
253: null,attribute10, x_attribute10),
254:
255: attribute11 = decode( x_attribute11, fnd_api.g_miss_char,null,
256: null,attribute11, x_attribute11),
251: null,attribute9, x_attribute9),
252: attribute10 = decode( x_attribute10, fnd_api.g_miss_char,null,
253: null,attribute10, x_attribute10),
254:
255: attribute11 = decode( x_attribute11, fnd_api.g_miss_char,null,
256: null,attribute11, x_attribute11),
257:
258: attribute12 = decode( x_attribute10, fnd_api.g_miss_char,null,
259: null,attribute12, x_attribute12),
254:
255: attribute11 = decode( x_attribute11, fnd_api.g_miss_char,null,
256: null,attribute11, x_attribute11),
257:
258: attribute12 = decode( x_attribute10, fnd_api.g_miss_char,null,
259: null,attribute12, x_attribute12),
260:
261: attribute13 = decode( x_attribute10, fnd_api.g_miss_char,null,
262: null,attribute13, x_attribute13),
257:
258: attribute12 = decode( x_attribute10, fnd_api.g_miss_char,null,
259: null,attribute12, x_attribute12),
260:
261: attribute13 = decode( x_attribute10, fnd_api.g_miss_char,null,
262: null,attribute13, x_attribute13),
263: attribute14 = decode( x_attribute10, fnd_api.g_miss_char,null,
264: null,attribute14, x_attribute14),
265: attribute15 = decode( x_attribute15, fnd_api.g_miss_char,null,
259: null,attribute12, x_attribute12),
260:
261: attribute13 = decode( x_attribute10, fnd_api.g_miss_char,null,
262: null,attribute13, x_attribute13),
263: attribute14 = decode( x_attribute10, fnd_api.g_miss_char,null,
264: null,attribute14, x_attribute14),
265: attribute15 = decode( x_attribute15, fnd_api.g_miss_char,null,
266: null,attribute15, x_attribute15),
267:
261: attribute13 = decode( x_attribute10, fnd_api.g_miss_char,null,
262: null,attribute13, x_attribute13),
263: attribute14 = decode( x_attribute10, fnd_api.g_miss_char,null,
264: null,attribute14, x_attribute14),
265: attribute15 = decode( x_attribute15, fnd_api.g_miss_char,null,
266: null,attribute15, x_attribute15),
267:
268: last_updated_by = decode( x_last_updated_by, fnd_api.g_miss_num,null,
269: null,last_updated_by, x_last_updated_by),
264: null,attribute14, x_attribute14),
265: attribute15 = decode( x_attribute15, fnd_api.g_miss_char,null,
266: null,attribute15, x_attribute15),
267:
268: last_updated_by = decode( x_last_updated_by, fnd_api.g_miss_num,null,
269: null,last_updated_by, x_last_updated_by),
270: last_update_date = decode( x_last_update_date, fnd_api.g_miss_date,null,
271: null,last_update_date, x_last_update_date),
272: last_update_login = decode( x_last_update_login, fnd_api.g_miss_num,null,
266: null,attribute15, x_attribute15),
267:
268: last_updated_by = decode( x_last_updated_by, fnd_api.g_miss_num,null,
269: null,last_updated_by, x_last_updated_by),
270: last_update_date = decode( x_last_update_date, fnd_api.g_miss_date,null,
271: null,last_update_date, x_last_update_date),
272: last_update_login = decode( x_last_update_login, fnd_api.g_miss_num,null,
273: null,last_update_login, x_last_update_login)
274:
268: last_updated_by = decode( x_last_updated_by, fnd_api.g_miss_num,null,
269: null,last_updated_by, x_last_updated_by),
270: last_update_date = decode( x_last_update_date, fnd_api.g_miss_date,null,
271: null,last_update_date, x_last_update_date),
272: last_update_login = decode( x_last_update_login, fnd_api.g_miss_num,null,
273: null,last_update_login, x_last_update_login)
274:
275: WHERE bali_filter_id = x_bali_filter_ID;
276: