295: p_attribute27 => NULL,
296: p_attribute28 => NULL,
297: p_attribute29 => NULL,
298: p_attribute30 => NULL,
299: p_created_by => FND_GLOBAL.USER_ID,
300: p_creation_date => SYSDATE,
301: p_last_updated_by => FND_GLOBAL.USER_ID,
302: p_last_update_date => SYSDATE,
303: p_last_update_login => l_last_update_login,
297: p_attribute29 => NULL,
298: p_attribute30 => NULL,
299: p_created_by => FND_GLOBAL.USER_ID,
300: p_creation_date => SYSDATE,
301: p_last_updated_by => FND_GLOBAL.USER_ID,
302: p_last_update_date => SYSDATE,
303: p_last_update_login => l_last_update_login,
304: x_rowid => row_id,
305: x_return_status => return_status,
327: p_label_class_code => p_field_name_class,
328: p_language => p_language,
329: p_label_class_description => p_description,
330: p_source_lang => p_source_language,
331: p_created_by => fnd_global.user_id,
332: p_creation_date => sysdate,
333: p_last_updated_by => fnd_global.user_id,
334: p_last_update_date => sysdate,
335: p_last_update_login => l_last_update_login,
329: p_label_class_description => p_description,
330: p_source_lang => p_source_language,
331: p_created_by => fnd_global.user_id,
332: p_creation_date => sysdate,
333: p_last_updated_by => fnd_global.user_id,
334: p_last_update_date => sysdate,
335: p_last_update_login => l_last_update_login,
336: x_rowid => row_id,
337: x_return_status => return_status,
431: l_application_id,
432: l_responsibility_id,
433: l_display_sequence,
434: l_allow_create_update,
435: fnd_global.user_id,
436: sysdate,
437: fnd_global.user_id,
438: sysdate,
439: l_last_update_login
433: l_display_sequence,
434: l_allow_create_update,
435: fnd_global.user_id,
436: sysdate,
437: fnd_global.user_id,
438: sysdate,
439: l_last_update_login
440: );
441:
478: p_label_class_code => p_field_name_class,
479: p_language => p_language,
480: p_label_class_description => p_description,
481: p_source_lang => p_source_language,
482: p_created_by => fnd_global.user_id,
483: p_creation_date => sysdate,
484: p_last_updated_by => fnd_global.user_id,
485: p_last_update_date => sysdate,
486: p_last_update_login => l_last_update_login,
480: p_label_class_description => p_description,
481: p_source_lang => p_source_language,
482: p_created_by => fnd_global.user_id,
483: p_creation_date => sysdate,
484: p_last_updated_by => fnd_global.user_id,
485: p_last_update_date => sysdate,
486: p_last_update_login => l_last_update_login,
487: x_rowid => row_id,
488: x_return_status => return_status,
594: l_application_id,
595: l_responsibility_id,
596: l_display_sequence,
597: l_allow_create_update,
598: fnd_global.user_id,
599: sysdate,
600: fnd_global.user_id,
601: sysdate,
602: l_last_update_login
596: l_display_sequence,
597: l_allow_create_update,
598: fnd_global.user_id,
599: sysdate,
600: fnd_global.user_id,
601: sysdate,
602: l_last_update_login
603: );
604:
655: -- The value of Form Block will be updated in the GR_ GR_LABEL_CLASSES_B table.
656:
657: UPDATE gr_label_classes_b
658: SET form_block = l_form_block,
659: last_updated_by = fnd_global.user_id,
660: last_update_date = sysdate,
661: last_update_login = l_last_update_login
662: WHERE label_class_code = p_field_name_class;
663: IF SQL%NOTFOUND THEN
703:
704: UPDATE GR_LABEL_CLASSES_TL
705: SET label_class_description = p_description,
706: source_lang = p_source_language,
707: last_updated_by = FND_GLOBAL.USER_ID,
708: last_update_date = SYSDATE,
709: last_update_login = l_last_update_login
710: WHERE label_class_code = p_field_name_class
711: and language = p_language;