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

Line 35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,

31: application_id
32: )
33: VALUES (
34: DECODE(x_usage_dtl_id,
35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,

Line 39: FND_API.G_MISS_NUM, NULL,

35: FND_API.G_MISS_NUM, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
36: NULL, HZ_ADDRESS_USAGE_DTLS_S.NEXTVAL,
37: x_usage_dtl_id),
38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_usage_id),
41: DECODE(x_geography_type,
42: FND_API.G_MISS_CHAR, NULL,
43: x_geography_type),

Line 42: FND_API.G_MISS_CHAR, NULL,

38: DECODE(x_usage_id,
39: FND_API.G_MISS_NUM, NULL,
40: x_usage_id),
41: DECODE(x_geography_type,
42: FND_API.G_MISS_CHAR, NULL,
43: x_geography_type),
44: hz_utility_v2pub.created_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.last_updated_by,

Line 50: FND_API.G_MISS_NUM, NULL,

46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
51: x_object_version_number),
52: DECODE(x_created_by_module,
53: FND_API.G_MISS_CHAR, NULL,
54: x_created_by_module),

Line 53: FND_API.G_MISS_CHAR, NULL,

49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
51: x_object_version_number),
52: DECODE(x_created_by_module,
53: FND_API.G_MISS_CHAR, NULL,
54: x_created_by_module),
55: DECODE(x_application_id,
56: FND_API.G_MISS_NUM, NULL,
57: x_application_id)

Line 56: FND_API.G_MISS_NUM, NULL,

52: DECODE(x_created_by_module,
53: FND_API.G_MISS_CHAR, NULL,
54: x_created_by_module),
55: DECODE(x_application_id,
56: FND_API.G_MISS_NUM, NULL,
57: x_application_id)
58: ) RETURNING
59: rowid,
60: usage_dtl_id

Line 112: FND_API.G_MISS_NUM, NULL,

108: SET
109: usage_dtl_id =
110: DECODE(x_usage_dtl_id,
111: NULL, usage_dtl_id,
112: FND_API.G_MISS_NUM, NULL,
113: x_usage_dtl_id),
114: usage_id =
115: DECODE(x_usage_id,
116: NULL, usage_id,

Line 117: FND_API.G_MISS_NUM, NULL,

113: x_usage_dtl_id),
114: usage_id =
115: DECODE(x_usage_id,
116: NULL, usage_id,
117: FND_API.G_MISS_NUM, NULL,
118: x_usage_id),
119: geography_type =
120: DECODE(x_geography_type,
121: NULL, geography_type,

Line 122: FND_API.G_MISS_CHAR, NULL,

118: x_usage_id),
119: geography_type =
120: DECODE(x_geography_type,
121: NULL, geography_type,
122: FND_API.G_MISS_CHAR, NULL,
123: x_geography_type),
124: created_by = created_by,
125: creation_date = creation_date,
126: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 132: FND_API.G_MISS_NUM, NULL,

128: last_update_login = hz_utility_v2pub.last_update_login,
129: object_version_number =
130: DECODE(x_object_version_number,
131: NULL, object_version_number,
132: FND_API.G_MISS_NUM, NULL,
133: x_object_version_number),
134: created_by_module =
135: DECODE(x_created_by_module,
136: NULL, created_by_module,

Line 137: FND_API.G_MISS_CHAR, NULL,

133: x_object_version_number),
134: created_by_module =
135: DECODE(x_created_by_module,
136: NULL, created_by_module,
137: FND_API.G_MISS_CHAR, NULL,
138: x_created_by_module),
139: application_id =
140: DECODE(x_application_id,
141: NULL, application_id,

Line 142: FND_API.G_MISS_NUM, NULL,

138: x_created_by_module),
139: application_id =
140: DECODE(x_application_id,
141: NULL, application_id,
142: FND_API.G_MISS_NUM, NULL,
143: x_application_id)
144: WHERE rowid = x_rowid;
145:
146: IF ( SQL%NOTFOUND ) THEN

Line 238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),

234: ) IS
235: BEGIN
236:
237: SELECT
238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),
239: NVL(usage_id, FND_API.G_MISS_NUM),
240: NVL(geography_type, FND_API.G_MISS_CHAR),
241: NVL(created_by_module, FND_API.G_MISS_CHAR),
242: NVL(application_id, FND_API.G_MISS_NUM)

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

235: BEGIN
236:
237: SELECT
238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),
239: NVL(usage_id, FND_API.G_MISS_NUM),
240: NVL(geography_type, FND_API.G_MISS_CHAR),
241: NVL(created_by_module, FND_API.G_MISS_CHAR),
242: NVL(application_id, FND_API.G_MISS_NUM)
243: INTO

Line 240: NVL(geography_type, FND_API.G_MISS_CHAR),

236:
237: SELECT
238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),
239: NVL(usage_id, FND_API.G_MISS_NUM),
240: NVL(geography_type, FND_API.G_MISS_CHAR),
241: NVL(created_by_module, FND_API.G_MISS_CHAR),
242: NVL(application_id, FND_API.G_MISS_NUM)
243: INTO
244: x_usage_dtl_id,

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

237: SELECT
238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),
239: NVL(usage_id, FND_API.G_MISS_NUM),
240: NVL(geography_type, FND_API.G_MISS_CHAR),
241: NVL(created_by_module, FND_API.G_MISS_CHAR),
242: NVL(application_id, FND_API.G_MISS_NUM)
243: INTO
244: x_usage_dtl_id,
245: x_usage_id,

Line 242: NVL(application_id, FND_API.G_MISS_NUM)

238: NVL(usage_dtl_id, FND_API.G_MISS_NUM),
239: NVL(usage_id, FND_API.G_MISS_NUM),
240: NVL(geography_type, FND_API.G_MISS_CHAR),
241: NVL(created_by_module, FND_API.G_MISS_CHAR),
242: NVL(application_id, FND_API.G_MISS_NUM)
243: INTO
244: x_usage_dtl_id,
245: x_usage_id,
246: x_geography_type,

Line 258: RAISE FND_API.G_EXC_ERROR;

254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
255: FND_MESSAGE.SET_TOKEN('RECORD', 'address_usage_dtls_rec');
256: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_usage_dtl_id));
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259:
260: END Select_Row;
261:
262: PROCEDURE Delete_Row (