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.FND_VAL_ATTRIBUTE_TYPES_PKG dependencies on FND_VALUE_ATTRIBUTE_TYPES

Line 25: cursor C is select ROWID from FND_VALUE_ATTRIBUTE_TYPES

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from FND_VALUE_ATTRIBUTE_TYPES
26: where APPLICATION_ID = X_APPLICATION_ID
27: and ID_FLEX_CODE = X_ID_FLEX_CODE
28: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
29: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE

Line 32: insert into FND_VALUE_ATTRIBUTE_TYPES (

28: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
29: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE
30: ;
31: begin
32: insert into FND_VALUE_ATTRIBUTE_TYPES (
33: APPLICATION_ID,
34: ID_FLEX_CODE,
35: SEGMENT_ATTRIBUTE_TYPE,
36: VALUE_ATTRIBUTE_TYPE,

Line 140: from FND_VALUE_ATTRIBUTE_TYPES

136: LOOKUP_TYPE,
137: DERIVATION_RULE_CODE,
138: DERIVATION_RULE_VALUE1,
139: DERIVATION_RULE_VALUE2
140: from FND_VALUE_ATTRIBUTE_TYPES
141: where APPLICATION_ID = X_APPLICATION_ID
142: and ID_FLEX_CODE = X_ID_FLEX_CODE
143: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
144: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE

Line 227: update FND_VALUE_ATTRIBUTE_TYPES set

223: X_LAST_UPDATED_BY in NUMBER,
224: X_LAST_UPDATE_LOGIN in NUMBER
225: ) is
226: begin
227: update FND_VALUE_ATTRIBUTE_TYPES set
228: REQUIRED_FLAG = X_REQUIRED_FLAG,
229: APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME,
230: DEFAULT_VALUE = X_DEFAULT_VALUE,
231: LOOKUP_TYPE = X_LOOKUP_TYPE,

Line 272: delete from FND_VALUE_ATTRIBUTE_TYPES

268: X_SEGMENT_ATTRIBUTE_TYPE in VARCHAR2,
269: X_VALUE_ATTRIBUTE_TYPE in VARCHAR2
270: ) is
271: begin
272: delete from FND_VALUE_ATTRIBUTE_TYPES
273: where APPLICATION_ID = X_APPLICATION_ID
274: and ID_FLEX_CODE = X_ID_FLEX_CODE
275: and SEGMENT_ATTRIBUTE_TYPE = X_SEGMENT_ATTRIBUTE_TYPE
276: and VALUE_ATTRIBUTE_TYPE = X_VALUE_ATTRIBUTE_TYPE;

Line 305: from FND_VALUE_ATTRIBUTE_TYPES B

301:
302: delete from FND_VAL_ATTRIBUTE_TYPES_TL T
303: where not exists
304: (select NULL
305: from FND_VALUE_ATTRIBUTE_TYPES B
306: where B.APPLICATION_ID = T.APPLICATION_ID
307: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
308: and B.SEGMENT_ATTRIBUTE_TYPE = T.SEGMENT_ATTRIBUTE_TYPE
309: and B.VALUE_ATTRIBUTE_TYPE = T.VALUE_ATTRIBUTE_TYPE