eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_FIELD_NAME_PROPERTIES_PUB dependencies on GR_PROPERTY_VALUES_TL

Line 356: -- Insert all associated property values into the GR_PROPERTY_VALUES_TL table

352: END IF;
353:
354: END IF; -- IF l_missing_count > 0 THEN
355:
356: -- Insert all associated property values into the GR_PROPERTY_VALUES_TL table
357:
358:
359: FOR i IN 1 .. p_label_prop_values_tab.count LOOP
360:

Line 368: gr_property_values_tl_pkg.Insert_Row

364:
365:
366: IF l_display_order is NOT NULL or l_value is NOT NULL then
367:
368: gr_property_values_tl_pkg.Insert_Row
369: (p_commit => 'F',
370: p_called_by_form => 'F',
371: p_property_id => p_property_id,
372: p_language => p_language,

Line 470: -- Validate that the value of Language for the specified property exists in the table GR_PROPERTY_VALUES_TL.

466: l_display_order := p_label_prop_values_tab(i).display_order;
467: l_value := p_label_prop_values_tab(i).value;
468: l_value_description := p_label_prop_values_tab(i).value_description;
469:
470: -- Validate that the value of Language for the specified property exists in the table GR_PROPERTY_VALUES_TL.
471: -- If it does , write an error to the log file
472:
473: gr_property_values_tl_pkg.Check_Primary_Key
474: (p_property_id,

Line 473: gr_property_values_tl_pkg.Check_Primary_Key

469:
470: -- Validate that the value of Language for the specified property exists in the table GR_PROPERTY_VALUES_TL.
471: -- If it does , write an error to the log file
472:
473: gr_property_values_tl_pkg.Check_Primary_Key
474: (p_property_id,
475: p_language,
476: l_value,
477: 'F',

Line 489: gr_property_values_tl_pkg.Insert_Row

485:
486:
487: IF l_display_order is NOT NULL or l_value is NOT NULL then
488:
489: gr_property_values_tl_pkg.Insert_Row
490: (p_commit => 'F',
491: p_called_by_form => 'F',
492: p_property_id => p_property_id,
493: p_language => p_language,

Line 619: -- table GR_PROPERTY_VALUES_TL. If it does, write an error to the log file.

615: RAISE Row_Missing_Error;
616: END IF;
617:
618: -- Validate that the value of Language for the specified property exists in the
619: -- table GR_PROPERTY_VALUES_TL. If it does, write an error to the log file.
620:
621: gr_properties_tl_pkg.Check_Primary_Key
622: (p_property_id,
623: p_language,

Line 633: -- The values for Language, Value and Value Description will be written to the GR_PROPERTY_VALUES_TL table.

629: l_msg_token := p_property_id || ' ' || p_language;
630: RAISE LT_Exists_Error;
631: END IF;
632:
633: -- The values for Language, Value and Value Description will be written to the GR_PROPERTY_VALUES_TL table.
634: FOR i IN 1 .. p_label_prop_values_tab.count LOOP
635:
636: l_display_order := p_label_prop_values_tab(i).display_order;
637: l_value := p_label_prop_values_tab(i).value;

Line 643: UPDATE GR_PROPERTY_values_TL

639:
640:
641: IF l_value is NOT NULL then
642:
643: UPDATE GR_PROPERTY_values_TL
644: SET meaning = l_value_description,
645: last_updated_by = FND_GLOBAL.USER_ID,
646: last_update_date = SYSDATE,
647: last_update_login = l_last_update_login

Line 683: -- Delete all of the property related records in the GR_PROPERTIES_B, GR_PROPERTIES_TL and GR_PROPERTY_VALUES_TL tables.

679:
680:
681: IF p_object = 'C' then
682:
683: -- Delete all of the property related records in the GR_PROPERTIES_B, GR_PROPERTIES_TL and GR_PROPERTY_VALUES_TL tables.
684:
685: delete from GR_PROPERTY_VALUES_TL T
686: where t.PROPERTY_ID = p_PROPERTY_ID;
687:

Line 685: delete from GR_PROPERTY_VALUES_TL T

681: IF p_object = 'C' then
682:
683: -- Delete all of the property related records in the GR_PROPERTIES_B, GR_PROPERTIES_TL and GR_PROPERTY_VALUES_TL tables.
684:
685: delete from GR_PROPERTY_VALUES_TL T
686: where t.PROPERTY_ID = p_PROPERTY_ID;
687:
688: delete from GR_PROPERTIES_TL T
689: where t.PROPERTY_ID = p_PROPERTY_ID;

Line 772: -- Validate that the value of specified property and language and value does exists in the table GR_PROPERTY_VALUES_TL.

768: l_display_order := p_label_prop_values_tab(i).display_order;
769: l_value := p_label_prop_values_tab(i).value;
770: l_value_description := p_label_prop_values_tab(i).value_description;
771:
772: -- Validate that the value of specified property and language and value does exists in the table GR_PROPERTY_VALUES_TL.
773: -- If it does not , write an error to the log file
774:
775: gr_property_values_tl_pkg.Check_Primary_Key
776: (p_property_id,

Line 775: gr_property_values_tl_pkg.Check_Primary_Key

771:
772: -- Validate that the value of specified property and language and value does exists in the table GR_PROPERTY_VALUES_TL.
773: -- If it does not , write an error to the log file
774:
775: gr_property_values_tl_pkg.Check_Primary_Key
776: (p_property_id,
777: p_language,
778: l_value,
779: 'F',

Line 788: -- Delete the record in GR_PROPERTY_VALUES_TL table for the specified language. .

784: l_msg_token := p_property_id|| ' ' || p_language || ' ' || l_value;
785: RAISE Row_Missing_Error;
786: END IF;
787:
788: -- Delete the record in GR_PROPERTY_VALUES_TL table for the specified language. .
789:
790: IF l_value is NOT NULL then
791:
792:

Line 793: delete from GR_PROPERTY_values_TL

789:
790: IF l_value is NOT NULL then
791:
792:
793: delete from GR_PROPERTY_values_TL
794: WHERE property_id = p_property_id
795: and language = p_language
796: and value = l_value;
797: IF SQL%NOTFOUND THEN