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

Line 43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,

39: object_version_number
40: )
41: VALUES (
42: DECODE(x_assignment_id,
43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
44: NULL, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
45: x_assignment_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',

Line 47: FND_API.G_MISS_CHAR, 'A',

43: FND_API.G_MISS_NUM, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
44: NULL, HZ_DSS_ASSIGNMENTS_S.NEXTVAL,
45: x_assignment_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',
48: NULL, 'A',
49: x_status),
50: DECODE(x_owner_table_name,
51: FND_API.G_MISS_CHAR, NULL,

Line 51: FND_API.G_MISS_CHAR, NULL,

47: FND_API.G_MISS_CHAR, 'A',
48: NULL, 'A',
49: x_status),
50: DECODE(x_owner_table_name,
51: FND_API.G_MISS_CHAR, NULL,
52: x_owner_table_name),
53: DECODE(x_owner_table_id1,
54: FND_API.G_MISS_CHAR, NULL,
55: x_owner_table_id1),

Line 54: FND_API.G_MISS_CHAR, NULL,

50: DECODE(x_owner_table_name,
51: FND_API.G_MISS_CHAR, NULL,
52: x_owner_table_name),
53: DECODE(x_owner_table_id1,
54: FND_API.G_MISS_CHAR, NULL,
55: x_owner_table_id1),
56: DECODE(x_owner_table_id2,
57: FND_API.G_MISS_CHAR, NULL,
58: x_owner_table_id2),

Line 57: FND_API.G_MISS_CHAR, NULL,

53: DECODE(x_owner_table_id1,
54: FND_API.G_MISS_CHAR, NULL,
55: x_owner_table_id1),
56: DECODE(x_owner_table_id2,
57: FND_API.G_MISS_CHAR, NULL,
58: x_owner_table_id2),
59: DECODE(x_owner_table_id3,
60: FND_API.G_MISS_CHAR, NULL,
61: x_owner_table_id3),

Line 60: FND_API.G_MISS_CHAR, NULL,

56: DECODE(x_owner_table_id2,
57: FND_API.G_MISS_CHAR, NULL,
58: x_owner_table_id2),
59: DECODE(x_owner_table_id3,
60: FND_API.G_MISS_CHAR, NULL,
61: x_owner_table_id3),
62: DECODE(x_owner_table_id4,
63: FND_API.G_MISS_CHAR, NULL,
64: x_owner_table_id4),

Line 63: FND_API.G_MISS_CHAR, NULL,

59: DECODE(x_owner_table_id3,
60: FND_API.G_MISS_CHAR, NULL,
61: x_owner_table_id3),
62: DECODE(x_owner_table_id4,
63: FND_API.G_MISS_CHAR, NULL,
64: x_owner_table_id4),
65: DECODE(x_owner_table_id5,
66: FND_API.G_MISS_CHAR, NULL,
67: x_owner_table_id5),

Line 66: FND_API.G_MISS_CHAR, NULL,

62: DECODE(x_owner_table_id4,
63: FND_API.G_MISS_CHAR, NULL,
64: x_owner_table_id4),
65: DECODE(x_owner_table_id5,
66: FND_API.G_MISS_CHAR, NULL,
67: x_owner_table_id5),
68: DECODE(x_dss_group_code,
69: FND_API.G_MISS_CHAR, NULL,
70: x_dss_group_code),

Line 69: FND_API.G_MISS_CHAR, NULL,

65: DECODE(x_owner_table_id5,
66: FND_API.G_MISS_CHAR, NULL,
67: x_owner_table_id5),
68: DECODE(x_dss_group_code,
69: FND_API.G_MISS_CHAR, NULL,
70: x_dss_group_code),
71: hz_utility_v2pub.last_update_date,
72: hz_utility_v2pub.last_updated_by,
73: hz_utility_v2pub.creation_date,

Line 77: FND_API.G_MISS_NUM, NULL,

73: hz_utility_v2pub.creation_date,
74: hz_utility_v2pub.created_by,
75: hz_utility_v2pub.last_update_login,
76: DECODE(x_object_version_number,
77: FND_API.G_MISS_NUM, NULL,
78: x_object_version_number)
79: ) RETURNING
80: rowid,
81: assignment_id

Line 136: FND_API.G_MISS_CHAR, NULL,

132: SET
133: status =
134: DECODE(x_status,
135: NULL, status,
136: FND_API.G_MISS_CHAR, NULL,
137: x_status),
138: owner_table_name =
139: DECODE(x_owner_table_name,
140: NULL, owner_table_name,

Line 141: FND_API.G_MISS_CHAR, NULL,

137: x_status),
138: owner_table_name =
139: DECODE(x_owner_table_name,
140: NULL, owner_table_name,
141: FND_API.G_MISS_CHAR, NULL,
142: x_owner_table_name),
143: owner_table_id1 =
144: DECODE(x_owner_table_id1,
145: NULL, owner_table_id1,

Line 146: FND_API.G_MISS_CHAR, NULL,

142: x_owner_table_name),
143: owner_table_id1 =
144: DECODE(x_owner_table_id1,
145: NULL, owner_table_id1,
146: FND_API.G_MISS_CHAR, NULL,
147: x_owner_table_id1),
148: owner_table_id2 =
149: DECODE(x_owner_table_id2,
150: NULL, owner_table_id2,

Line 151: FND_API.G_MISS_CHAR, NULL,

147: x_owner_table_id1),
148: owner_table_id2 =
149: DECODE(x_owner_table_id2,
150: NULL, owner_table_id2,
151: FND_API.G_MISS_CHAR, NULL,
152: x_owner_table_id2),
153: owner_table_id3 =
154: DECODE(x_owner_table_id3,
155: NULL, owner_table_id3,

Line 156: FND_API.G_MISS_CHAR, NULL,

152: x_owner_table_id2),
153: owner_table_id3 =
154: DECODE(x_owner_table_id3,
155: NULL, owner_table_id3,
156: FND_API.G_MISS_CHAR, NULL,
157: x_owner_table_id3),
158: owner_table_id4 =
159: DECODE(x_owner_table_id4,
160: NULL, owner_table_id4,

Line 161: FND_API.G_MISS_CHAR, NULL,

157: x_owner_table_id3),
158: owner_table_id4 =
159: DECODE(x_owner_table_id4,
160: NULL, owner_table_id4,
161: FND_API.G_MISS_CHAR, NULL,
162: x_owner_table_id4),
163: owner_table_id5 =
164: DECODE(x_owner_table_id5,
165: NULL, owner_table_id5,

Line 166: FND_API.G_MISS_CHAR, NULL,

162: x_owner_table_id4),
163: owner_table_id5 =
164: DECODE(x_owner_table_id5,
165: NULL, owner_table_id5,
166: FND_API.G_MISS_CHAR, NULL,
167: x_owner_table_id5),
168: dss_group_code =
169: DECODE(x_dss_group_code,
170: NULL, dss_group_code,

Line 171: FND_API.G_MISS_CHAR, NULL,

167: x_owner_table_id5),
168: dss_group_code =
169: DECODE(x_dss_group_code,
170: NULL, dss_group_code,
171: FND_API.G_MISS_CHAR, NULL,
172: x_dss_group_code),
173: last_update_date = hz_utility_v2pub.last_update_date,
174: last_updated_by = hz_utility_v2pub.last_updated_by,
175: creation_date = creation_date,

Line 181: FND_API.G_MISS_NUM, NULL,

177: last_update_login = hz_utility_v2pub.last_update_login,
178: object_version_number =
179: DECODE(x_object_version_number,
180: NULL, object_version_number,
181: FND_API.G_MISS_NUM, NULL,
182: x_object_version_number)
183: WHERE rowid = x_rowid;
184:
185: IF ( SQL%NOTFOUND ) THEN

Line 298: NVL(assignment_id, FND_API.G_MISS_NUM),

294: ) IS
295: BEGIN
296:
297: SELECT
298: NVL(assignment_id, FND_API.G_MISS_NUM),
299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),

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

295: BEGIN
296:
297: SELECT
298: NVL(assignment_id, FND_API.G_MISS_NUM),
299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),

Line 300: NVL(owner_table_name, FND_API.G_MISS_CHAR),

296:
297: SELECT
298: NVL(assignment_id, FND_API.G_MISS_NUM),
299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),

Line 301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),

297: SELECT
298: NVL(assignment_id, FND_API.G_MISS_NUM),
299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),

Line 302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),

298: NVL(assignment_id, FND_API.G_MISS_NUM),
299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),

Line 303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),

299: NVL(status, FND_API.G_MISS_CHAR),
300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),
307: NVL(object_version_number, FND_API.G_MISS_NUM)

Line 304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),

300: NVL(owner_table_name, FND_API.G_MISS_CHAR),
301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),
307: NVL(object_version_number, FND_API.G_MISS_NUM)
308: INTO

Line 305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),

301: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),
307: NVL(object_version_number, FND_API.G_MISS_NUM)
308: INTO
309: x_assignment_id,

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

302: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),
307: NVL(object_version_number, FND_API.G_MISS_NUM)
308: INTO
309: x_assignment_id,
310: x_status,

Line 307: NVL(object_version_number, FND_API.G_MISS_NUM)

303: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
304: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
306: NVL(dss_group_code, FND_API.G_MISS_CHAR),
307: NVL(object_version_number, FND_API.G_MISS_NUM)
308: INTO
309: x_assignment_id,
310: x_status,
311: x_owner_table_name,

Line 328: RAISE FND_API.G_EXC_ERROR;

324: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
325: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_assignment');
326: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_assignment_id));
327: FND_MSG_PUB.ADD;
328: RAISE FND_API.G_EXC_ERROR;
329:
330: END Select_Row;
331:
332: PROCEDURE Delete_Row (