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_PROPERTIES_B

Line 112: GR_PROPERTIES_B B

108:
109: CURSOR c_get_property_id is
110: SELECT 1
111: FROM
112: GR_PROPERTIES_B B
113: where B.PROPERTY_ID = p_property_id;
114:
115: CURSOR c_get_property_flag is
116: SELECT 1

Line 118: GR_PROPERTIES_B B

114:
115: CURSOR c_get_property_flag is
116: SELECT 1
117: FROM
118: GR_PROPERTIES_B B
119: where B.PROPERTY_ID = p_property_id
120: and property_type_indicator = 'F';
121:
122: CURSOR c_get_gr_properties_tl

Line 203: -- Validate that the value of Property Id does not already exist in the table GR_PROPERTIES_B.

199:
200: IF p_action = 'I' then
201:
202: IF p_object = 'C' then
203: -- Validate that the value of Property Id does not already exist in the table GR_PROPERTIES_B.
204: -- If it does, write an error to the log file.
205:
206: dummy:= 0;
207: OPEN c_get_property_id;

Line 259: -- Decimal Precision, Minimum Value and Maximum Value will be written to the GR_PROPERTIES_B table.

255: END IF;
256: END IF; -- IF p_range_min is not null and p_range_max is not null then
257:
258: -- The values for Property Id, Property Type, Length,
259: -- Decimal Precision, Minimum Value and Maximum Value will be written to the GR_PROPERTIES_B table.
260:
261: GR_PROPERTIES_B_PKG.Insert_Row
262: (p_commit => 'F',
263: p_called_by_form => 'F',

Line 261: GR_PROPERTIES_B_PKG.Insert_Row

257:
258: -- The values for Property Id, Property Type, Length,
259: -- Decimal Precision, Minimum Value and Maximum Value will be written to the GR_PROPERTIES_B table.
260:
261: GR_PROPERTIES_B_PKG.Insert_Row
262: (p_commit => 'F',
263: p_called_by_form => 'F',
264: p_property_id => p_property_id,
265: p_property_type_indicator => p_property_type_indicator,

Line 396: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.

392:
393:
394: ELSIF p_object = 'L' then
395:
396: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.
397: -- If it does not, write an error to the log file
398:
399: dummy:= 0;
400: l_property_id := p_property_id;

Line 451: --Validate that the value of Property Id exists in the table GR_PROPERTIES_B and that it is

447:
448:
449: ELSE -- object = V value
450:
451: --Validate that the value of Property Id exists in the table GR_PROPERTIES_B and that it is
452: -- of property type Flag If it does not, write an error to the log file.
453: dummy:= 0;
454: OPEN c_get_property_flag;
455: FETCH c_get_property_flag INTO dummy;

Line 521: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.

517: /*************************************************************************************/
518:
519: ELSIF p_action = 'U' then
520:
521: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.
522: -- If it does not, an error message will be written to the log file.
523:
524: dummy:= 0;
525: OPEN c_get_property_id;

Line 538: -- length, decimal precision, minimum value and maximum value will be updated in the GR_PROPERTIES_B table.

534:
535: IF p_object = 'C' then
536:
537: -- Any non-null, valid values passed in for property type,
538: -- length, decimal precision, minimum value and maximum value will be updated in the GR_PROPERTIES_B table.
539:
540: UPDATE GR_PROPERTIES_B
541: SET length = nvl(p_length,length),
542: precision = nvl(p_precision,precision),

Line 540: UPDATE GR_PROPERTIES_B

536:
537: -- Any non-null, valid values passed in for property type,
538: -- length, decimal precision, minimum value and maximum value will be updated in the GR_PROPERTIES_B table.
539:
540: UPDATE GR_PROPERTIES_B
541: SET length = nvl(p_length,length),
542: precision = nvl(p_precision,precision),
543: range_min = nvl(p_range_min,range_min),
544: range_max = nvl(p_range_max,range_max),

Line 605: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B

601: END IF;
602:
603: ELSE -- object = V (Value)
604:
605: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B
606: -- and that it is of property type Flag If it does not, write an error to the log file
607:
608: dummy:= 0;
609: OPEN c_get_property_flag;

Line 667: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.

663: END IF; -- IF p_object = 'C' then
664:
665: ELSE -- action is D (delete)
666:
667: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B.
668: -- If it does not, an error message will be written to the log file.
669:
670: dummy:= 0;
671: OPEN c_get_property_id;

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 691: DELETE FROM GR_PROPERTIES_B

687:
688: delete from GR_PROPERTIES_TL T
689: where t.PROPERTY_ID = p_PROPERTY_ID;
690:
691: DELETE FROM GR_PROPERTIES_B
692: where PROPERTY_ID = p_PROPERTY_ID;
693:
694: IF SQL%NOTFOUND THEN
695: l_msg_token := p_PROPERTY_ID;

Line 749: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B

745:
746:
747: ELSE -- object = V(value)
748:
749: -- Validate that the value of Property Id exists in the table GR_PROPERTIES_B
750: -- and that it is of property type Flag If it does not, write an error to the log file
751:
752: dummy:= 0;
753: OPEN c_get_property_flag;