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

Line 31: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),

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

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

28: LAST_UPDATED_BY,
29: OBJECT_VERSION_NUMBER
30: ) values (
31: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
32: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
33: DECODE( X_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
34: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
35: HZ_UTILITY_V2PUB.CREATION_DATE,
36: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 33: DECODE( X_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),

29: OBJECT_VERSION_NUMBER
30: ) values (
31: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
32: DECODE( X_STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
33: DECODE( X_DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
34: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
35: HZ_UTILITY_V2PUB.CREATION_DATE,
36: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
37: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

35: HZ_UTILITY_V2PUB.CREATION_DATE,
36: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
37: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
38: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
39: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER )
40: );
41:
42: insert into HZ_STYLE_FORMATS_TL (
43: STYLE_FORMAT_CODE,

Line 54: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),

50: LAST_UPDATED_BY,
51: LANGUAGE,
52: SOURCE_LANG
53: ) select
54: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
55: DECODE( X_STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
56: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
57: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
58: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 55: DECODE( X_STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),

51: LANGUAGE,
52: SOURCE_LANG
53: ) select
54: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
55: DECODE( X_STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
56: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
57: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
58: HZ_UTILITY_V2PUB.CREATION_DATE,
59: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

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

52: SOURCE_LANG
53: ) select
54: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
55: DECODE( X_STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
56: DECODE( X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
57: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.CREATED_BY),
58: HZ_UTILITY_V2PUB.CREATION_DATE,
59: NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
60: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 149: STYLE_CODE = DECODE( X_STYLE_CODE, NULL, STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),

145: X_OBJECT_VERSION_NUMBER IN NUMBER
146: ) is
147: begin
148: update HZ_STYLE_FORMATS_B set
149: STYLE_CODE = DECODE( X_STYLE_CODE, NULL, STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
150: DEFAULT_FLAG = DECODE( X_DEFAULT_FLAG, NULL, DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
151: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
153: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

Line 150: DEFAULT_FLAG = DECODE( X_DEFAULT_FLAG, NULL, DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),

146: ) is
147: begin
148: update HZ_STYLE_FORMATS_B set
149: STYLE_CODE = DECODE( X_STYLE_CODE, NULL, STYLE_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_CODE ),
150: DEFAULT_FLAG = DECODE( X_DEFAULT_FLAG, NULL, DEFAULT_FLAG, FND_API.G_MISS_CHAR, NULL, X_DEFAULT_FLAG ),
151: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
153: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
154: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,

Line 155: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)

151: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
153: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
154: OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER,
155: FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
156: where STYLE_FORMAT_CODE = X_STYLE_FORMAT_CODE;
157:
158: if (sql%notfound) then
159: raise no_data_found;

Line 163: STYLE_FORMAT_NAME = DECODE( X_STYLE_FORMAT_NAME, NULL, STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),

159: raise no_data_found;
160: end if;
161:
162: update HZ_STYLE_FORMATS_TL set
163: STYLE_FORMAT_NAME = DECODE( X_STYLE_FORMAT_NAME, NULL, STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
164: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
165: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
167: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),

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

160: end if;
161:
162: update HZ_STYLE_FORMATS_TL set
163: STYLE_FORMAT_NAME = DECODE( X_STYLE_FORMAT_NAME, NULL, STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_NAME ),
164: DESCRIPTION = DECODE( X_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_DESCRIPTION ),
165: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATED_BY),
167: LAST_UPDATE_LOGIN = NVL(L_USER_ID_FOR_SEED,HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN),
168: SOURCE_LANG = userenv('LANG')

Line 187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),

183: ) IS
184: BEGIN
185:
186: SELECT
187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
188: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
191: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )

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

184: BEGIN
185:
186: SELECT
187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
188: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
191: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
192: INTO X_STYLE_FORMAT_CODE,

Line 189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),

185:
186: SELECT
187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
188: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
191: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
192: INTO X_STYLE_FORMAT_CODE,
193: X_STYLE_CODE,

Line 190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),

186: SELECT
187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
188: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
191: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
192: INTO X_STYLE_FORMAT_CODE,
193: X_STYLE_CODE,
194: X_DEFAULT_FLAG,

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

187: NVL( B.STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR ),
188: NVL( B.STYLE_CODE, FND_API.G_MISS_CHAR ),
189: NVL( B.DEFAULT_FLAG, FND_API.G_MISS_CHAR ),
190: NVL( T.STYLE_FORMAT_NAME, FND_API.G_MISS_CHAR ),
191: NVL( T.DESCRIPTION, FND_API.G_MISS_CHAR )
192: INTO X_STYLE_FORMAT_CODE,
193: X_STYLE_CODE,
194: X_DEFAULT_FLAG,
195: X_STYLE_FORMAT_NAME,

Line 208: RAISE FND_API.G_EXC_ERROR;

204: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
205: FND_MESSAGE.SET_TOKEN( 'RECORD', 'style_format_rec');
206: FND_MESSAGE.SET_TOKEN( 'VALUE', 'STYLE_FORMAT_CODE' );
207: FND_MSG_PUB.ADD;
208: RAISE FND_API.G_EXC_ERROR;
209: END SELECT_ROW;
210:
211:
212: procedure DELETE_ROW (