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_ITEM_PROPERTIES_PUB dependencies on GR_PROPERTIES_B

Line 173: GR_PROPERTIES_B B

169:
170: CURSOR c_get_property_id is
171: SELECT 1
172: FROM
173: GR_PROPERTIES_B B
174: where B.PROPERTY_ID = l_property_id;
175:
176: CURSOR c_get_property_flag is
177: SELECT property_type_indicator,

Line 183: GR_PROPERTIES_B B

179: PRECISION,
180: range_min,
181: range_max
182: FROM
183: GR_PROPERTIES_B B
184: where B.PROPERTY_ID = l_property_id;
185:
186: cursor c_get_PROPERTY_values is
187: select 1

Line 510: -- Validate the value for Numeric Value against the property definition in the GR_PROPERTIES_B table.

506: FALSE);
507: RAISE loop_exception;
508: END IF; -- IF l_numeric_value is NULL then
509:
510: -- Validate the value for Numeric Value against the property definition in the GR_PROPERTIES_B table.
511: -- An error message will be written to the log file if the value is invalid
512: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.
513: -- Just the length An error message will be written to the log file if the value is invalid
514: IF (length(l_numeric_value) > l_length ) then

Line 512: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.

508: END IF; -- IF l_numeric_value is NULL then
509:
510: -- Validate the value for Numeric Value against the property definition in the GR_PROPERTIES_B table.
511: -- An error message will be written to the log file if the value is invalid
512: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.
513: -- Just the length An error message will be written to the log file if the value is invalid
514: IF (length(l_numeric_value) > l_length ) then
515: --l_msg_token := l_length;
516: FND_MESSAGE.SET_NAME('GR',

Line 552: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.

548: FALSE);
549: RAISE loop_exception;
550: END IF; -- IF l_alpha_value is NULL then
551:
552: -- Validate the value for Alphanumeric Value against the property definition in the GR_PROPERTIES_B table.
553: -- Just the length An error message will be written to the log file if the value is invalid
554: IF (length(l_alpha_value) > l_length ) then --
555: l_msg_token := (length(l_alpha_value));
556: FND_MESSAGE.SET_NAME('GR',