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

Line 37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,

33: application_id
34: )
35: VALUES (
36: DECODE(x_usage_id,
37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,

Line 41: FND_API.G_MISS_NUM, NULL,

37: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGES_S.NEXTVAL,
38: NULL, HZ_ADDRESS_USAGES_S.NEXTVAL,
39: x_usage_id),
40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,
42: x_map_id),
43: DECODE(x_usage_code,
44: FND_API.G_MISS_CHAR, NULL,
45: x_usage_code),

Line 44: FND_API.G_MISS_CHAR, NULL,

40: DECODE(x_map_id,
41: FND_API.G_MISS_NUM, NULL,
42: x_map_id),
43: DECODE(x_usage_code,
44: FND_API.G_MISS_CHAR, NULL,
45: x_usage_code),
46: DECODE(x_status_flag,
47: FND_API.G_MISS_CHAR, NULL,
48: x_status_flag),

Line 47: FND_API.G_MISS_CHAR, NULL,

43: DECODE(x_usage_code,
44: FND_API.G_MISS_CHAR, NULL,
45: x_usage_code),
46: DECODE(x_status_flag,
47: FND_API.G_MISS_CHAR, NULL,
48: x_status_flag),
49: hz_utility_v2pub.created_by,
50: hz_utility_v2pub.creation_date,
51: hz_utility_v2pub.last_updated_by,

Line 55: FND_API.G_MISS_NUM, NULL,

51: hz_utility_v2pub.last_updated_by,
52: hz_utility_v2pub.last_update_date,
53: hz_utility_v2pub.last_update_login,
54: DECODE(x_object_version_number,
55: FND_API.G_MISS_NUM, NULL,
56: x_object_version_number),
57: DECODE(x_created_by_module,
58: FND_API.G_MISS_CHAR, NULL,
59: x_created_by_module),

Line 58: FND_API.G_MISS_CHAR, NULL,

54: DECODE(x_object_version_number,
55: FND_API.G_MISS_NUM, NULL,
56: x_object_version_number),
57: DECODE(x_created_by_module,
58: FND_API.G_MISS_CHAR, NULL,
59: x_created_by_module),
60: DECODE(x_application_id,
61: FND_API.G_MISS_NUM, NULL,
62: x_application_id)

Line 61: FND_API.G_MISS_NUM, NULL,

57: DECODE(x_created_by_module,
58: FND_API.G_MISS_CHAR, NULL,
59: x_created_by_module),
60: DECODE(x_application_id,
61: FND_API.G_MISS_NUM, NULL,
62: x_application_id)
63: ) RETURNING
64: rowid,
65: usage_id

Line 120: FND_API.G_MISS_NUM, NULL,

116: SET
117: usage_id =
118: DECODE(x_usage_id,
119: NULL, usage_id,
120: FND_API.G_MISS_NUM, NULL,
121: x_usage_id),
122: map_id =
123: DECODE(x_map_id,
124: NULL, map_id,

Line 125: FND_API.G_MISS_NUM, NULL,

121: x_usage_id),
122: map_id =
123: DECODE(x_map_id,
124: NULL, map_id,
125: FND_API.G_MISS_NUM, NULL,
126: x_map_id),
127: usage_code =
128: DECODE(x_usage_code,
129: NULL, usage_code,

Line 130: FND_API.G_MISS_CHAR, NULL,

126: x_map_id),
127: usage_code =
128: DECODE(x_usage_code,
129: NULL, usage_code,
130: FND_API.G_MISS_CHAR, NULL,
131: x_usage_code),
132: status_flag =
133: DECODE(x_status_flag,
134: NULL, status_flag,

Line 135: FND_API.G_MISS_CHAR, NULL,

131: x_usage_code),
132: status_flag =
133: DECODE(x_status_flag,
134: NULL, status_flag,
135: FND_API.G_MISS_CHAR, NULL,
136: x_status_flag),
137: created_by = created_by,
138: creation_date = creation_date,
139: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 145: FND_API.G_MISS_NUM, NULL,

141: last_update_login = hz_utility_v2pub.last_update_login,
142: object_version_number =
143: DECODE(x_object_version_number,
144: NULL, object_version_number,
145: FND_API.G_MISS_NUM, NULL,
146: x_object_version_number),
147: created_by_module =
148: DECODE(x_created_by_module,
149: NULL, created_by_module,

Line 150: FND_API.G_MISS_CHAR, NULL,

146: x_object_version_number),
147: created_by_module =
148: DECODE(x_created_by_module,
149: NULL, created_by_module,
150: FND_API.G_MISS_CHAR, NULL,
151: x_created_by_module),
152: application_id =
153: DECODE(x_application_id,
154: NULL, application_id,

Line 155: FND_API.G_MISS_NUM, NULL,

151: x_created_by_module),
152: application_id =
153: DECODE(x_application_id,
154: NULL, application_id,
155: FND_API.G_MISS_NUM, NULL,
156: x_application_id)
157: WHERE rowid = x_rowid;
158:
159: IF ( SQL%NOTFOUND ) THEN

Line 256: NVL(usage_id, FND_API.G_MISS_NUM),

252: ) IS
253: BEGIN
254:
255: SELECT
256: NVL(usage_id, FND_API.G_MISS_NUM),
257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 257: NVL(map_id, FND_API.G_MISS_NUM),

253: BEGIN
254:
255: SELECT
256: NVL(usage_id, FND_API.G_MISS_NUM),
257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),
261: NVL(application_id, FND_API.G_MISS_NUM)

Line 258: NVL(usage_code, FND_API.G_MISS_CHAR),

254:
255: SELECT
256: NVL(usage_id, FND_API.G_MISS_NUM),
257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),
261: NVL(application_id, FND_API.G_MISS_NUM)
262: INTO

Line 259: NVL(status_flag, FND_API.G_MISS_CHAR),

255: SELECT
256: NVL(usage_id, FND_API.G_MISS_NUM),
257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),
261: NVL(application_id, FND_API.G_MISS_NUM)
262: INTO
263: x_usage_id,

Line 260: NVL(created_by_module, FND_API.G_MISS_CHAR),

256: NVL(usage_id, FND_API.G_MISS_NUM),
257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),
261: NVL(application_id, FND_API.G_MISS_NUM)
262: INTO
263: x_usage_id,
264: x_map_id,

Line 261: NVL(application_id, FND_API.G_MISS_NUM)

257: NVL(map_id, FND_API.G_MISS_NUM),
258: NVL(usage_code, FND_API.G_MISS_CHAR),
259: NVL(status_flag, FND_API.G_MISS_CHAR),
260: NVL(created_by_module, FND_API.G_MISS_CHAR),
261: NVL(application_id, FND_API.G_MISS_NUM)
262: INTO
263: x_usage_id,
264: x_map_id,
265: x_usage_code,

Line 278: RAISE FND_API.G_EXC_ERROR;

274: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
275: FND_MESSAGE.SET_TOKEN('RECORD', 'address_usages_rec');
276: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_usage_id));
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279:
280: END Select_Row;
281:
282: PROCEDURE Delete_Row (