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_STYLES_PKG dependencies on FND_API

Line 29: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),

25: LAST_UPDATE_DATE,
26: LAST_UPDATED_BY,
27: OBJECT_VERSION_NUMBER
28: ) values (
29: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
30: DECODE( X_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),
31: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
32: HZ_UTILITY_V2PUB.CREATION_DATE,
33: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 30: DECODE( X_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),

26: LAST_UPDATED_BY,
27: OBJECT_VERSION_NUMBER
28: ) values (
29: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
30: DECODE( X_DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),
31: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
32: HZ_UTILITY_V2PUB.CREATION_DATE,
33: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
34: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 36: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )

32: HZ_UTILITY_V2PUB.CREATION_DATE,
33: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
34: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
35: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
36: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
37: );
38:
39: insert into HZ_STYLES_TL (
40: STYLE_CODE,

Line 51: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),

47: LAST_UPDATE_LOGIN,
48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY
50: ) select
51: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
52: DECODE( X_STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),
53: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
54: L.LANGUAGE_CODE,
55: userenv('LANG'),

Line 52: DECODE( X_STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),

48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY
50: ) select
51: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
52: DECODE( X_STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),
53: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
54: L.LANGUAGE_CODE,
55: userenv('LANG'),
56: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),

Line 53: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),

49: LAST_UPDATED_BY
50: ) select
51: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
52: DECODE( X_STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),
53: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
54: L.LANGUAGE_CODE,
55: userenv('LANG'),
56: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
57: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 142: DATABASE_OBJECT_NAME = DECODE( X_DATABASE_OBJECT_NAME, NULL, DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),

138: X_OBJECT_VERSION_NUMBER IN NUMBER
139: ) is
140: begin
141: update HZ_STYLES_B set
142: DATABASE_OBJECT_NAME = DECODE( X_DATABASE_OBJECT_NAME, NULL, DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR, NULL, X_DATABASE_OBJECT_NAME ),
143: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
145: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
146: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,

Line 147: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

143: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
144: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
145: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
146: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
147: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
148:
149: where STYLE_CODE = X_STYLE_CODE;
150:
151: if (sql%notfound) then

Line 156: STYLE_NAME = DECODE( X_STYLE_NAME, NULL, STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),

152: raise no_data_found;
153: end if;
154:
155: update HZ_STYLES_TL set
156: STYLE_NAME = DECODE( X_STYLE_NAME, NULL, STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),
157: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
158: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
159: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
160: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 157: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),

153: end if;
154:
155: update HZ_STYLES_TL set
156: STYLE_NAME = DECODE( X_STYLE_NAME, NULL, STYLE_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_NAME ),
157: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
158: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
159: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
160: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
161: SOURCE_LANG = userenv('LANG')

Line 179: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),

175: ) IS
176: BEGIN
177:
178: SELECT
179: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
180: NVL( B.DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR ),
181: NVL( T.STYLE_NAME, FND_API.G_MISS_CHAR ),
182: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
183: INTO X_STYLE_CODE,

Line 180: NVL( B.DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR ),

176: BEGIN
177:
178: SELECT
179: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
180: NVL( B.DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR ),
181: NVL( T.STYLE_NAME, FND_API.G_MISS_CHAR ),
182: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
183: INTO X_STYLE_CODE,
184: X_DATABASE_OBJECT_NAME,

Line 181: NVL( T.STYLE_NAME, FND_API.G_MISS_CHAR ),

177:
178: SELECT
179: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
180: NVL( B.DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR ),
181: NVL( T.STYLE_NAME, FND_API.G_MISS_CHAR ),
182: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
183: INTO X_STYLE_CODE,
184: X_DATABASE_OBJECT_NAME,
185: X_STYLE_NAME,

Line 182: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )

178: SELECT
179: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
180: NVL( B.DATABASE_OBJECT_NAME, FND_API.G_MISS_CHAR ),
181: NVL( T.STYLE_NAME, FND_API.G_MISS_CHAR ),
182: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
183: INTO X_STYLE_CODE,
184: X_DATABASE_OBJECT_NAME,
185: X_STYLE_NAME,
186: X_DESCRIPTION

Line 198: RAISE FND_API.G_EXC_ERROR;

194: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
195: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_rec');
196: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_CODE' );
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199:
200: END SELECT_ROW;
201:
202: