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

Line 35: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),

31: object_version_number
32: )
33: VALUES (
34: DECODE(x_dss_group_code,
35: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),
36: DECODE(x_rank,
37: FND_API.G_MISS_NUM, NULL,
38: x_rank),
39: DECODE(x_status,

Line 37: FND_API.G_MISS_NUM, NULL,

33: VALUES (
34: DECODE(x_dss_group_code,
35: FND_API.G_MISS_CHAR, NULL, x_dss_group_code),
36: DECODE(x_rank,
37: FND_API.G_MISS_NUM, NULL,
38: x_rank),
39: DECODE(x_status,
40: FND_API.G_MISS_CHAR, 'A',
41: NULL, 'A',

Line 40: FND_API.G_MISS_CHAR, 'A',

36: DECODE(x_rank,
37: FND_API.G_MISS_NUM, NULL,
38: x_rank),
39: DECODE(x_status,
40: FND_API.G_MISS_CHAR, 'A',
41: NULL, 'A',
42: x_status),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,

Line 49: FND_API.G_MISS_CHAR, NULL,

45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
48: DECODE(x_bes_enable_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_bes_enable_flag),
51: DECODE(x_object_version_number,
52: FND_API.G_MISS_NUM, NULL,
53: x_object_version_number)

Line 52: FND_API.G_MISS_NUM, NULL,

48: DECODE(x_bes_enable_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_bes_enable_flag),
51: DECODE(x_object_version_number,
52: FND_API.G_MISS_NUM, NULL,
53: x_object_version_number)
54: ) RETURNING
55: rowid
56: INTO

Line 119: FND_API.G_MISS_NUM, NULL,

115: SET
116: rank =
117: DECODE(x_rank,
118: NULL, rank,
119: FND_API.G_MISS_NUM, NULL,
120: x_rank),
121: status =
122: DECODE(x_status,
123: NULL, status,

Line 124: FND_API.G_MISS_CHAR, NULL,

120: x_rank),
121: status =
122: DECODE(x_status,
123: NULL, status,
124: FND_API.G_MISS_CHAR, NULL,
125: x_status),
126: last_update_date = hz_utility_v2pub.last_update_date,
127: last_updated_by = hz_utility_v2pub.last_updated_by,
128: creation_date = creation_date,

Line 134: FND_API.G_MISS_CHAR, NULL,

130: last_update_login = hz_utility_v2pub.last_update_login,
131: bes_enable_flag =
132: DECODE(x_bes_enable_flag,
133: NULL, bes_enable_flag,
134: FND_API.G_MISS_CHAR, NULL,
135: x_bes_enable_flag),
136: object_version_number=
137: DECODE(x_object_version_number,
138: NULL, object_version_number,

Line 139: FND_API.G_MISS_NUM, NULL,

135: x_bes_enable_flag),
136: object_version_number=
137: DECODE(x_object_version_number,
138: NULL, object_version_number,
139: FND_API.G_MISS_NUM, NULL,
140: x_object_version_number)
141: WHERE rowid = x_rowid
142: returning dss_group_code into l_dss_group_code ;
143: IF ( SQL%NOTFOUND ) THEN

Line 152: FND_API.G_MISS_CHAR, NULL,

148: SET
149: source_lang =
150: DECODE(USERENV('LANG'),
151: NULL, source_lang,
152: FND_API.G_MISS_CHAR, NULL,
153: USERENV('LANG') ),
154: dss_group_name =
155: DECODE(x_dss_group_name,
156: NULL, dss_group_name,

Line 157: FND_API.G_MISS_CHAR, NULL,

153: USERENV('LANG') ),
154: dss_group_name =
155: DECODE(x_dss_group_name,
156: NULL, dss_group_name,
157: FND_API.G_MISS_CHAR, NULL,
158: x_dss_group_name),
159: description =
160: DECODE(x_description,
161: NULL, description,

Line 162: FND_API.G_MISS_CHAR, NULL,

158: x_dss_group_name),
159: description =
160: DECODE(x_description,
161: NULL, description,
162: FND_API.G_MISS_CHAR, NULL,
163: x_description),
164: last_update_date = hz_utility_v2pub.last_update_date,
165: last_updated_by = hz_utility_v2pub.last_updated_by,
166: last_update_login = hz_utility_v2pub.last_update_login

Line 262: NVL(dss_group_code, FND_API.G_MISS_CHAR),

258: x_dummy1 VARCHAR2(2000); x_dummy2 varchar2(2000);
259: BEGIN
260:
261: SELECT
262: NVL(dss_group_code, FND_API.G_MISS_CHAR),
263: NVL(rank, FND_API.G_MISS_NUM),
264: NVL(status, FND_API.G_MISS_CHAR),
265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),
266: NVL(object_version_number, FND_API.G_MISS_NUM)

Line 263: NVL(rank, FND_API.G_MISS_NUM),

259: BEGIN
260:
261: SELECT
262: NVL(dss_group_code, FND_API.G_MISS_CHAR),
263: NVL(rank, FND_API.G_MISS_NUM),
264: NVL(status, FND_API.G_MISS_CHAR),
265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),
266: NVL(object_version_number, FND_API.G_MISS_NUM)
267: INTO

Line 264: NVL(status, FND_API.G_MISS_CHAR),

260:
261: SELECT
262: NVL(dss_group_code, FND_API.G_MISS_CHAR),
263: NVL(rank, FND_API.G_MISS_NUM),
264: NVL(status, FND_API.G_MISS_CHAR),
265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),
266: NVL(object_version_number, FND_API.G_MISS_NUM)
267: INTO
268: x_dss_group_code,

Line 265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),

261: SELECT
262: NVL(dss_group_code, FND_API.G_MISS_CHAR),
263: NVL(rank, FND_API.G_MISS_NUM),
264: NVL(status, FND_API.G_MISS_CHAR),
265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),
266: NVL(object_version_number, FND_API.G_MISS_NUM)
267: INTO
268: x_dss_group_code,
269: x_rank,

Line 266: NVL(object_version_number, FND_API.G_MISS_NUM)

262: NVL(dss_group_code, FND_API.G_MISS_CHAR),
263: NVL(rank, FND_API.G_MISS_NUM),
264: NVL(status, FND_API.G_MISS_CHAR),
265: NVL(bes_enable_flag, FND_API.G_MISS_CHAR),
266: NVL(object_version_number, FND_API.G_MISS_NUM)
267: INTO
268: x_dss_group_code,
269: x_rank,
270: x_status,

Line 278: NVL(dss_group_code, FND_API.G_MISS_CHAR),

274: WHERE dss_group_code = x_dss_group_code;
275:
276:
277: SELECT
278: NVL(dss_group_code, FND_API.G_MISS_CHAR),
279: NVL(dss_group_name, FND_API.G_MISS_CHAR),
280: NVL(description, FND_API.G_MISS_CHAR)
281: INTO
282: x_dss_group_code, x_dummy1, x_dummy2

Line 279: NVL(dss_group_name, FND_API.G_MISS_CHAR),

275:
276:
277: SELECT
278: NVL(dss_group_code, FND_API.G_MISS_CHAR),
279: NVL(dss_group_name, FND_API.G_MISS_CHAR),
280: NVL(description, FND_API.G_MISS_CHAR)
281: INTO
282: x_dss_group_code, x_dummy1, x_dummy2
283: FROM HZ_DSS_GROUPS_TL

Line 280: NVL(description, FND_API.G_MISS_CHAR)

276:
277: SELECT
278: NVL(dss_group_code, FND_API.G_MISS_CHAR),
279: NVL(dss_group_name, FND_API.G_MISS_CHAR),
280: NVL(description, FND_API.G_MISS_CHAR)
281: INTO
282: x_dss_group_code, x_dummy1, x_dummy2
283: FROM HZ_DSS_GROUPS_TL
284: WHERE dss_group_code = x_dss_group_code AND

Line 293: RAISE FND_API.G_EXC_ERROR;

289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
290: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_group_rec');
291: FND_MESSAGE.SET_TOKEN('VALUE', x_dss_group_code);
292: FND_MSG_PUB.ADD;
293: RAISE FND_API.G_EXC_ERROR;
294:
295: END Select_Row;
296:
297: PROCEDURE Delete_Row (