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.HZ_WORD_LISTS_PKG dependencies on FND_API

Line 62: IF ( X_WORD_LIST_ID IS NULL) OR (X_WORD_LIST_ID = FND_API.G_MISS_NUM) THEN

58: X_NON_DELIMITED_FLAG VARCHAR2 DEFAULT 'N')
59: IS
60: CURSOR C2 IS SELECT HZ_WORD_LISTS_s.nextval FROM sys.dual;
61: BEGIN
62: IF ( X_WORD_LIST_ID IS NULL) OR (X_WORD_LIST_ID = FND_API.G_MISS_NUM) THEN
63: OPEN C2;
64: FETCH C2 INTO X_WORD_LIST_ID;
65: CLOSE C2;
66: END IF;

Line 82: decode(X_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL,

78: OBJECT_VERSION_NUMBER,
79: NON_DELIMITED_FLAG
80: )
81: VALUES (
82: decode(X_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL,
83: X_WORD_LIST_ID),
84: decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, NULL,
85: UPPER(X_WORD_LIST_NAME)),
86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,

Line 84: decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, NULL,

80: )
81: VALUES (
82: decode(X_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL,
83: X_WORD_LIST_ID),
84: decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, NULL,
85: UPPER(X_WORD_LIST_NAME)),
86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,
87: X_LANGUAGE),
88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,

Line 86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,

82: decode(X_WORD_LIST_ID, FND_API.G_MISS_NUM, NULL,
83: X_WORD_LIST_ID),
84: decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, NULL,
85: UPPER(X_WORD_LIST_NAME)),
86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,
87: X_LANGUAGE),
88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,
89: X_SOURCE_NAME),
90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,

Line 88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,

84: decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, NULL,
85: UPPER(X_WORD_LIST_NAME)),
86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,
87: X_LANGUAGE),
88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,
89: X_SOURCE_NAME),
90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,
91: X_created_by),
92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,

Line 90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,

86: decode(X_LANGUAGE, FND_API.G_MISS_CHAR, NULL,
87: X_LANGUAGE),
88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,
89: X_SOURCE_NAME),
90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,
91: X_created_by),
92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,
93: X_creation_date),
94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,

Line 92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,

88: decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR, NULL,
89: X_SOURCE_NAME),
90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,
91: X_created_by),
92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,
93: X_creation_date),
94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,
95: X_last_update_login),
96: decode(X_last_update_date, FND_API.G_MISS_DATE, NULL,

Line 94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,

90: decode(X_created_by, FND_API.G_MISS_NUM, NULL,
91: X_created_by),
92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,
93: X_creation_date),
94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,
95: X_last_update_login),
96: decode(X_last_update_date, FND_API.G_MISS_DATE, NULL,
97: X_last_update_date),
98: decode(X_last_updated_by, FND_API.G_MISS_NUM, NULL,

Line 96: decode(X_last_update_date, FND_API.G_MISS_DATE, NULL,

92: decode(X_creation_date, FND_API.G_MISS_DATE, NULL,
93: X_creation_date),
94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,
95: X_last_update_login),
96: decode(X_last_update_date, FND_API.G_MISS_DATE, NULL,
97: X_last_update_date),
98: decode(X_last_updated_by, FND_API.G_MISS_NUM, NULL,
99: X_last_updated_by),
100: 1,

Line 98: decode(X_last_updated_by, FND_API.G_MISS_NUM, NULL,

94: decode(X_last_update_login, FND_API.G_MISS_NUM, NULL,
95: X_last_update_login),
96: decode(X_last_update_date, FND_API.G_MISS_DATE, NULL,
97: X_last_update_date),
98: decode(X_last_updated_by, FND_API.G_MISS_NUM, NULL,
99: X_last_updated_by),
100: 1,
101: decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NULL,X_NON_DELIMITED_FLAG)
102: );

Line 101: decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NULL,X_NON_DELIMITED_FLAG)

97: X_last_update_date),
98: decode(X_last_updated_by, FND_API.G_MISS_NUM, NULL,
99: X_last_updated_by),
100: 1,
101: decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NULL,X_NON_DELIMITED_FLAG)
102: );
103:
104: End Insert_Row;
105:

Line 173: WORD_LIST_NAME = decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, WORD_LIST_NAME,

169:
170:
171: UPDATE HZ_WORD_LISTS
172: SET
173: WORD_LIST_NAME = decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, WORD_LIST_NAME,
174: UPPER(X_WORD_LIST_NAME)),
175: LANGUAGE = decode(X_LANGUAGE , FND_API.G_MISS_CHAR , LANGUAGE,
176: X_LANGUAGE),
177: SOURCE_NAME = decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR , SOURCE_NAME,

Line 175: LANGUAGE = decode(X_LANGUAGE , FND_API.G_MISS_CHAR , LANGUAGE,

171: UPDATE HZ_WORD_LISTS
172: SET
173: WORD_LIST_NAME = decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, WORD_LIST_NAME,
174: UPPER(X_WORD_LIST_NAME)),
175: LANGUAGE = decode(X_LANGUAGE , FND_API.G_MISS_CHAR , LANGUAGE,
176: X_LANGUAGE),
177: SOURCE_NAME = decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR , SOURCE_NAME,
178: X_SOURCE_NAME),
179: -- bug 3032780

Line 177: SOURCE_NAME = decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR , SOURCE_NAME,

173: WORD_LIST_NAME = decode(X_WORD_LIST_NAME, FND_API.G_MISS_CHAR, WORD_LIST_NAME,
174: UPPER(X_WORD_LIST_NAME)),
175: LANGUAGE = decode(X_LANGUAGE , FND_API.G_MISS_CHAR , LANGUAGE,
176: X_LANGUAGE),
177: SOURCE_NAME = decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR , SOURCE_NAME,
178: X_SOURCE_NAME),
179: -- bug 3032780
180: /*
181: CREATED_BY = decode(X_created_by,FND_API.G_MISS_NUM, CREATED_BY,

Line 181: CREATED_BY = decode(X_created_by,FND_API.G_MISS_NUM, CREATED_BY,

177: SOURCE_NAME = decode(X_SOURCE_NAME, FND_API.G_MISS_CHAR , SOURCE_NAME,
178: X_SOURCE_NAME),
179: -- bug 3032780
180: /*
181: CREATED_BY = decode(X_created_by,FND_API.G_MISS_NUM, CREATED_BY,
182: X_created_by),
183: CREATION_DATE = decode(X_CREATION_DATE,FND_API.G_MISS_DATE, CREATION_DATE,
184: X_CREATION_DATE),*/
185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,

Line 183: CREATION_DATE = decode(X_CREATION_DATE,FND_API.G_MISS_DATE, CREATION_DATE,

179: -- bug 3032780
180: /*
181: CREATED_BY = decode(X_created_by,FND_API.G_MISS_NUM, CREATED_BY,
182: X_created_by),
183: CREATION_DATE = decode(X_CREATION_DATE,FND_API.G_MISS_DATE, CREATION_DATE,
184: X_CREATION_DATE),*/
185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,
186: X_LAST_UPDATE_LOGIN),
187: LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,

Line 185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,

181: CREATED_BY = decode(X_created_by,FND_API.G_MISS_NUM, CREATED_BY,
182: X_created_by),
183: CREATION_DATE = decode(X_CREATION_DATE,FND_API.G_MISS_DATE, CREATION_DATE,
184: X_CREATION_DATE),*/
185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,
186: X_LAST_UPDATE_LOGIN),
187: LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
188: X_LAST_UPDATE_DATE),
189: LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,

Line 187: LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,

183: CREATION_DATE = decode(X_CREATION_DATE,FND_API.G_MISS_DATE, CREATION_DATE,
184: X_CREATION_DATE),*/
185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,
186: X_LAST_UPDATE_LOGIN),
187: LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
188: X_LAST_UPDATE_DATE),
189: LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,
190: X_LAST_UPDATED_BY),
191: OBJECT_VERSION_NUMBER = p_object_version_number,

Line 189: LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,

185: LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN,
186: X_LAST_UPDATE_LOGIN),
187: LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,
188: X_LAST_UPDATE_DATE),
189: LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,
190: X_LAST_UPDATED_BY),
191: OBJECT_VERSION_NUMBER = p_object_version_number,
192: NON_DELIMITED_FLAG = decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NON_DELIMITED_FLAG,
193: X_NON_DELIMITED_FLAG)

Line 192: NON_DELIMITED_FLAG = decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NON_DELIMITED_FLAG,

188: X_LAST_UPDATE_DATE),
189: LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,
190: X_LAST_UPDATED_BY),
191: OBJECT_VERSION_NUMBER = p_object_version_number,
192: NON_DELIMITED_FLAG = decode(X_NON_DELIMITED_FLAG,FND_API.G_MISS_CHAR,NON_DELIMITED_FLAG,
193: X_NON_DELIMITED_FLAG)
194: WHERE WORD_LIST_ID = X_WORD_LIST_ID;
195:
196: