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

Line 43: FND_API.G_MISS_NUM, HZ_DSS_CRITERIA_S.NEXTVAL,

39: object_version_number
40: )
41: VALUES (
42: DECODE(x_secured_item_id,
43: FND_API.G_MISS_NUM, HZ_DSS_CRITERIA_S.NEXTVAL,
44: NULL, HZ_DSS_CRITERIA_S.NEXTVAL,
45: x_secured_item_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_CRITERIA_S.NEXTVAL,
44: NULL, HZ_DSS_CRITERIA_S.NEXTVAL,
45: x_secured_item_id),
46: DECODE(x_status,
47: FND_API.G_MISS_CHAR, 'A',
48: NULL, 'A',
49: x_status),
50: DECODE(x_dss_group_code,
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_dss_group_code,
51: FND_API.G_MISS_CHAR, NULL,
52: x_dss_group_code),
53: DECODE(x_owner_table_name,
54: FND_API.G_MISS_CHAR, NULL,
55: x_owner_table_name),

Line 54: FND_API.G_MISS_CHAR, NULL,

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

Line 57: FND_API.G_MISS_CHAR, NULL,

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

Line 60: FND_API.G_MISS_CHAR, NULL,

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

Line 63: FND_API.G_MISS_CHAR, NULL,

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

Line 66: FND_API.G_MISS_CHAR, NULL,

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

Line 69: FND_API.G_MISS_CHAR, NULL,

65: DECODE(x_owner_table_id4,
66: FND_API.G_MISS_CHAR, NULL,
67: x_owner_table_id4),
68: DECODE(x_owner_table_id5,
69: FND_API.G_MISS_CHAR, NULL,
70: x_owner_table_id5),
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: secured_item_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: /*
139: dss_group_code =
140: DECODE(x_dss_group_code,

Line 142: FND_API.G_MISS_CHAR, NULL,

138: /*
139: dss_group_code =
140: DECODE(x_dss_group_code,
141: NULL, dss_group_code,
142: FND_API.G_MISS_CHAR, NULL,
143: x_dss_group_code),
144: owner_table_name =
145: DECODE(x_owner_table_name,
146: NULL, owner_table_name,

Line 147: FND_API.G_MISS_CHAR, NULL,

143: x_dss_group_code),
144: owner_table_name =
145: DECODE(x_owner_table_name,
146: NULL, owner_table_name,
147: FND_API.G_MISS_CHAR, NULL,
148: x_owner_table_name),
149: owner_table_id1 =
150: DECODE(x_owner_table_id1,
151: NULL, owner_table_id1,

Line 152: FND_API.G_MISS_CHAR, NULL,

148: x_owner_table_name),
149: owner_table_id1 =
150: DECODE(x_owner_table_id1,
151: NULL, owner_table_id1,
152: FND_API.G_MISS_CHAR, NULL,
153: x_owner_table_id1),
154: owner_table_id2 =
155: DECODE(x_owner_table_id2,
156: NULL, owner_table_id2,

Line 157: FND_API.G_MISS_CHAR, NULL,

153: x_owner_table_id1),
154: owner_table_id2 =
155: DECODE(x_owner_table_id2,
156: NULL, owner_table_id2,
157: FND_API.G_MISS_CHAR, NULL,
158: x_owner_table_id2),
159: owner_table_id3 =
160: DECODE(x_owner_table_id3,
161: NULL, owner_table_id3,

Line 162: FND_API.G_MISS_CHAR, NULL,

158: x_owner_table_id2),
159: owner_table_id3 =
160: DECODE(x_owner_table_id3,
161: NULL, owner_table_id3,
162: FND_API.G_MISS_CHAR, NULL,
163: x_owner_table_id3),
164: owner_table_id4 =
165: DECODE(x_owner_table_id4,
166: NULL, owner_table_id4,

Line 167: FND_API.G_MISS_CHAR, NULL,

163: x_owner_table_id3),
164: owner_table_id4 =
165: DECODE(x_owner_table_id4,
166: NULL, owner_table_id4,
167: FND_API.G_MISS_CHAR, NULL,
168: x_owner_table_id4),
169: owner_table_id5 =
170: DECODE(x_owner_table_id5,
171: NULL, owner_table_id5,

Line 172: FND_API.G_MISS_CHAR, NULL,

168: x_owner_table_id4),
169: owner_table_id5 =
170: DECODE(x_owner_table_id5,
171: NULL, owner_table_id5,
172: FND_API.G_MISS_CHAR, NULL,
173: x_owner_table_id5),
174: */
175: last_update_date = hz_utility_v2pub.last_update_date,
176: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 183: FND_API.G_MISS_NUM, NULL,

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

Line 301: NVL(secured_item_id, FND_API.G_MISS_NUM),

297: ) IS
298: BEGIN
299:
300: SELECT
301: NVL(secured_item_id, FND_API.G_MISS_NUM),
302: NVL(status, FND_API.G_MISS_CHAR),
303: NVL(dss_group_code, FND_API.G_MISS_CHAR),
304: NVL(owner_table_name, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id1, FND_API.G_MISS_CHAR),

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

298: BEGIN
299:
300: SELECT
301: NVL(secured_item_id, FND_API.G_MISS_NUM),
302: NVL(status, FND_API.G_MISS_CHAR),
303: NVL(dss_group_code, FND_API.G_MISS_CHAR),
304: NVL(owner_table_name, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
306: NVL(owner_table_id2, FND_API.G_MISS_CHAR),

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

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

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

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

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

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

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

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

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

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

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

304: NVL(owner_table_name, FND_API.G_MISS_CHAR),
305: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
306: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
307: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
308: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
309: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
310: NVL(object_version_number, FND_API.G_MISS_NUM)
311: INTO
312: x_secured_item_id,

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

305: NVL(owner_table_id1, FND_API.G_MISS_CHAR),
306: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
307: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
308: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
309: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
310: NVL(object_version_number, FND_API.G_MISS_NUM)
311: INTO
312: x_secured_item_id,
313: x_status,

Line 310: NVL(object_version_number, FND_API.G_MISS_NUM)

306: NVL(owner_table_id2, FND_API.G_MISS_CHAR),
307: NVL(owner_table_id3, FND_API.G_MISS_CHAR),
308: NVL(owner_table_id4, FND_API.G_MISS_CHAR),
309: NVL(owner_table_id5, FND_API.G_MISS_CHAR),
310: NVL(object_version_number, FND_API.G_MISS_NUM)
311: INTO
312: x_secured_item_id,
313: x_status,
314: x_dss_group_code,

Line 331: RAISE FND_API.G_EXC_ERROR;

327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
328: FND_MESSAGE.SET_TOKEN('RECORD', 'dss_secured_rel');
329: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_secured_item_id));
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_ERROR;
332:
333: END Select_Row;
334:
335: PROCEDURE Delete_Row (