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

Line 47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,

43: object_version_number
44: )
45: VALUES (
46: DECODE(x_entity_id,
47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,
48: NULL, HZ_DSS_ENTITIES_S.NEXTVAL,
49: x_entity_id),
50: DECODE(x_status,
51: FND_API.G_MISS_CHAR, 'A',

Line 51: FND_API.G_MISS_CHAR, 'A',

47: FND_API.G_MISS_NUM, HZ_DSS_ENTITIES_S.NEXTVAL,
48: NULL, HZ_DSS_ENTITIES_S.NEXTVAL,
49: x_entity_id),
50: DECODE(x_status,
51: FND_API.G_MISS_CHAR, 'A',
52: NULL, 'A',
53: x_status),
54: DECODE(x_object_id,
55: FND_API.G_MISS_NUM, NULL,

Line 55: FND_API.G_MISS_NUM, NULL,

51: FND_API.G_MISS_CHAR, 'A',
52: NULL, 'A',
53: x_status),
54: DECODE(x_object_id,
55: FND_API.G_MISS_NUM, NULL,
56: x_object_id),
57: DECODE(x_instance_set_id,
58: FND_API.G_MISS_NUM, NULL,
59: x_instance_set_id),

Line 58: FND_API.G_MISS_NUM, NULL,

54: DECODE(x_object_id,
55: FND_API.G_MISS_NUM, NULL,
56: x_object_id),
57: DECODE(x_instance_set_id,
58: FND_API.G_MISS_NUM, NULL,
59: x_instance_set_id),
60: DECODE(x_parent_entity_id,
61: FND_API.G_MISS_NUM, NULL,
62: x_parent_entity_id),

Line 61: FND_API.G_MISS_NUM, NULL,

57: DECODE(x_instance_set_id,
58: FND_API.G_MISS_NUM, NULL,
59: x_instance_set_id),
60: DECODE(x_parent_entity_id,
61: FND_API.G_MISS_NUM, NULL,
62: x_parent_entity_id),
63: DECODE(x_parent_fk_column1,
64: FND_API.G_MISS_CHAR, NULL,
65: x_parent_fk_column1),

Line 64: FND_API.G_MISS_CHAR, NULL,

60: DECODE(x_parent_entity_id,
61: FND_API.G_MISS_NUM, NULL,
62: x_parent_entity_id),
63: DECODE(x_parent_fk_column1,
64: FND_API.G_MISS_CHAR, NULL,
65: x_parent_fk_column1),
66: DECODE(x_parent_fk_column2,
67: FND_API.G_MISS_CHAR, NULL,
68: x_parent_fk_column2),

Line 67: FND_API.G_MISS_CHAR, NULL,

63: DECODE(x_parent_fk_column1,
64: FND_API.G_MISS_CHAR, NULL,
65: x_parent_fk_column1),
66: DECODE(x_parent_fk_column2,
67: FND_API.G_MISS_CHAR, NULL,
68: x_parent_fk_column2),
69: DECODE(x_parent_fk_column3,
70: FND_API.G_MISS_CHAR, NULL,
71: x_parent_fk_column3),

Line 70: FND_API.G_MISS_CHAR, NULL,

66: DECODE(x_parent_fk_column2,
67: FND_API.G_MISS_CHAR, NULL,
68: x_parent_fk_column2),
69: DECODE(x_parent_fk_column3,
70: FND_API.G_MISS_CHAR, NULL,
71: x_parent_fk_column3),
72: DECODE(x_parent_fk_column4,
73: FND_API.G_MISS_CHAR, NULL,
74: x_parent_fk_column4),

Line 73: FND_API.G_MISS_CHAR, NULL,

69: DECODE(x_parent_fk_column3,
70: FND_API.G_MISS_CHAR, NULL,
71: x_parent_fk_column3),
72: DECODE(x_parent_fk_column4,
73: FND_API.G_MISS_CHAR, NULL,
74: x_parent_fk_column4),
75: DECODE(x_parent_fk_column5,
76: FND_API.G_MISS_CHAR, NULL,
77: x_parent_fk_column5),

Line 76: FND_API.G_MISS_CHAR, NULL,

72: DECODE(x_parent_fk_column4,
73: FND_API.G_MISS_CHAR, NULL,
74: x_parent_fk_column4),
75: DECODE(x_parent_fk_column5,
76: FND_API.G_MISS_CHAR, NULL,
77: x_parent_fk_column5),
78: DECODE(x_group_assignment_level,
79: FND_API.G_MISS_CHAR, NULL,
80: x_group_assignment_level),

Line 79: FND_API.G_MISS_CHAR, NULL,

75: DECODE(x_parent_fk_column5,
76: FND_API.G_MISS_CHAR, NULL,
77: x_parent_fk_column5),
78: DECODE(x_group_assignment_level,
79: FND_API.G_MISS_CHAR, NULL,
80: x_group_assignment_level),
81: hz_utility_v2pub.last_update_date,
82: hz_utility_v2pub.last_updated_by,
83: hz_utility_v2pub.creation_date,

Line 87: FND_API.G_MISS_NUM, NULL,

83: hz_utility_v2pub.creation_date,
84: hz_utility_v2pub.created_by,
85: hz_utility_v2pub.last_update_login,
86: DECODE(x_object_version_number,
87: FND_API.G_MISS_NUM, NULL,
88: x_object_version_number)
89: ) RETURNING
90: rowid,
91: entity_id

Line 148: FND_API.G_MISS_CHAR, NULL,

144: SET
145: status =
146: DECODE(x_status,
147: NULL, status,
148: FND_API.G_MISS_CHAR, NULL,
149: x_status),
150: --Bug:2620112 Allow updates to following columns
151: parent_entity_id =
152: DECODE(x_parent_entity_id,

Line 154: FND_API.G_MISS_NUM, NULL,

150: --Bug:2620112 Allow updates to following columns
151: parent_entity_id =
152: DECODE(x_parent_entity_id,
153: NULL, parent_entity_id,
154: FND_API.G_MISS_NUM, NULL,
155: x_parent_entity_id),
156: parent_fk_column1 =
157: DECODE(x_parent_fk_column1,
158: NULL, parent_fk_column1,

Line 159: FND_API.G_MISS_CHAR, NULL,

155: x_parent_entity_id),
156: parent_fk_column1 =
157: DECODE(x_parent_fk_column1,
158: NULL, parent_fk_column1,
159: FND_API.G_MISS_CHAR, NULL,
160: x_parent_fk_column1),
161: parent_fk_column2 =
162: DECODE(x_parent_fk_column2,
163: NULL, parent_fk_column2,

Line 164: FND_API.G_MISS_CHAR, NULL,

160: x_parent_fk_column1),
161: parent_fk_column2 =
162: DECODE(x_parent_fk_column2,
163: NULL, parent_fk_column2,
164: FND_API.G_MISS_CHAR, NULL,
165: x_parent_fk_column2),
166: parent_fk_column3 =
167: DECODE(x_parent_fk_column3,
168: NULL, parent_fk_column3,

Line 169: FND_API.G_MISS_CHAR, NULL,

165: x_parent_fk_column2),
166: parent_fk_column3 =
167: DECODE(x_parent_fk_column3,
168: NULL, parent_fk_column3,
169: FND_API.G_MISS_CHAR, NULL,
170: x_parent_fk_column3),
171: parent_fk_column4 =
172: DECODE(x_parent_fk_column4,
173: NULL, parent_fk_column4,

Line 174: FND_API.G_MISS_CHAR, NULL,

170: x_parent_fk_column3),
171: parent_fk_column4 =
172: DECODE(x_parent_fk_column4,
173: NULL, parent_fk_column4,
174: FND_API.G_MISS_CHAR, NULL,
175: x_parent_fk_column4),
176: parent_fk_column5 =
177: DECODE(x_parent_fk_column5,
178: NULL, parent_fk_column5,

Line 179: FND_API.G_MISS_CHAR, NULL,

175: x_parent_fk_column4),
176: parent_fk_column5 =
177: DECODE(x_parent_fk_column5,
178: NULL, parent_fk_column5,
179: FND_API.G_MISS_CHAR, NULL,
180: x_parent_fk_column5),
181: group_assignment_level =
182: DECODE(x_group_assignment_level,
183: NULL, group_assignment_level,

Line 184: FND_API.G_MISS_CHAR, NULL,

180: x_parent_fk_column5),
181: group_assignment_level =
182: DECODE(x_group_assignment_level,
183: NULL, group_assignment_level,
184: FND_API.G_MISS_CHAR, NULL,
185: x_group_assignment_level),
186: last_update_date = hz_utility_v2pub.last_update_date,
187: last_updated_by = hz_utility_v2pub.last_updated_by,
188: creation_date = creation_date,

Line 194: FND_API.G_MISS_NUM, NULL,

190: last_update_login = hz_utility_v2pub.last_update_login,
191: object_version_number =
192: DECODE(x_object_version_number,
193: NULL, object_version_number,
194: FND_API.G_MISS_NUM, NULL,
195: x_object_version_number)
196: WHERE rowid = x_rowid;
197:
198: IF ( SQL%NOTFOUND ) THEN

Line 320: NVL(entity_id, FND_API.G_MISS_NUM),

316: ) IS
317: BEGIN
318:
319: SELECT
320: NVL(entity_id, FND_API.G_MISS_NUM),
321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),

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

317: BEGIN
318:
319: SELECT
320: NVL(entity_id, FND_API.G_MISS_NUM),
321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),

Line 322: NVL(object_id, FND_API.G_MISS_NUM),

318:
319: SELECT
320: NVL(entity_id, FND_API.G_MISS_NUM),
321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),

Line 323: NVL(instance_set_id, FND_API.G_MISS_NUM),

319: SELECT
320: NVL(entity_id, FND_API.G_MISS_NUM),
321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),

Line 324: NVL(parent_entity_id, FND_API.G_MISS_NUM),

320: NVL(entity_id, FND_API.G_MISS_NUM),
321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),

Line 325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),

321: NVL(status, FND_API.G_MISS_CHAR),
322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),

Line 326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),

322: NVL(object_id, FND_API.G_MISS_NUM),
323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),

Line 327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),

323: NVL(instance_set_id, FND_API.G_MISS_NUM),
324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),
331: NVL(object_version_number, FND_API.G_MISS_NUM)

Line 328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),

324: NVL(parent_entity_id, FND_API.G_MISS_NUM),
325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),
331: NVL(object_version_number, FND_API.G_MISS_NUM)
332: INTO

Line 329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),

325: NVL(parent_fk_column1, FND_API.G_MISS_CHAR),
326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),
331: NVL(object_version_number, FND_API.G_MISS_NUM)
332: INTO
333: x_entity_id,

Line 330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),

326: NVL(parent_fk_column2, FND_API.G_MISS_CHAR),
327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),
331: NVL(object_version_number, FND_API.G_MISS_NUM)
332: INTO
333: x_entity_id,
334: x_status,

Line 331: NVL(object_version_number, FND_API.G_MISS_NUM)

327: NVL(parent_fk_column3, FND_API.G_MISS_CHAR),
328: NVL(parent_fk_column4, FND_API.G_MISS_CHAR),
329: NVL(parent_fk_column5, FND_API.G_MISS_CHAR),
330: NVL(group_assignment_level, FND_API.G_MISS_CHAR),
331: NVL(object_version_number, FND_API.G_MISS_NUM)
332: INTO
333: x_entity_id,
334: x_status,
335: x_object_id,

Line 354: RAISE FND_API.G_EXC_ERROR;

350: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
351: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_entity_profile');
352: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_entity_id));
353: FND_MSG_PUB.ADD;
354: RAISE FND_API.G_EXC_ERROR;
355:
356: END Select_Row;
357:
358: PROCEDURE Delete_Row (