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_FLEX_VDATION_RULES_PKG dependencies on FND_FLEX_VALIDATION_RULES

Line 22: cursor C is select ROWID from FND_FLEX_VALIDATION_RULES

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from FND_FLEX_VALIDATION_RULES
23: where APPLICATION_ID = X_APPLICATION_ID
24: and ID_FLEX_CODE = X_ID_FLEX_CODE
25: and ID_FLEX_NUM = X_ID_FLEX_NUM
26: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME

Line 29: insert into FND_FLEX_VALIDATION_RULES (

25: and ID_FLEX_NUM = X_ID_FLEX_NUM
26: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME
27: ;
28: begin
29: insert into FND_FLEX_VALIDATION_RULES (
30: APPLICATION_ID,
31: ID_FLEX_CODE,
32: ID_FLEX_NUM,
33: FLEX_VALIDATION_RULE_NAME,

Line 125: from FND_FLEX_VALIDATION_RULES

121: ENABLED_FLAG,
122: ERROR_SEGMENT_COLUMN_NAME,
123: START_DATE_ACTIVE,
124: END_DATE_ACTIVE
125: from FND_FLEX_VALIDATION_RULES
126: where APPLICATION_ID = X_APPLICATION_ID
127: and ID_FLEX_CODE = X_ID_FLEX_CODE
128: and ID_FLEX_NUM = X_ID_FLEX_NUM
129: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME

Line 199: update FND_FLEX_VALIDATION_RULES set

195: X_LAST_UPDATED_BY in NUMBER,
196: X_LAST_UPDATE_LOGIN in NUMBER
197: ) is
198: begin
199: update FND_FLEX_VALIDATION_RULES set
200: ENABLED_FLAG = X_ENABLED_FLAG,
201: ERROR_SEGMENT_COLUMN_NAME = X_ERROR_SEGMENT_COLUMN_NAME,
202: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
203: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 251: delete from FND_FLEX_VALIDATION_RULES

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: delete from FND_FLEX_VALIDATION_RULES
252: where APPLICATION_ID = X_APPLICATION_ID
253: and ID_FLEX_CODE = X_ID_FLEX_CODE
254: and ID_FLEX_NUM = X_ID_FLEX_NUM
255: and FLEX_VALIDATION_RULE_NAME = X_FLEX_VALIDATION_RULE_NAME;

Line 274: from FND_FLEX_VALIDATION_RULES B

270:
271: delete from FND_FLEX_VDATION_RULES_TL T
272: where not exists
273: (select NULL
274: from FND_FLEX_VALIDATION_RULES B
275: where B.APPLICATION_ID = T.APPLICATION_ID
276: and B.ID_FLEX_CODE = T.ID_FLEX_CODE
277: and B.ID_FLEX_NUM = T.ID_FLEX_NUM
278: and B.FLEX_VALIDATION_RULE_NAME = T.FLEX_VALIDATION_RULE_NAME