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

Line 52: FND_API.G_MISS_NUM, NULL,

48: request_id
49: )
50: VALUES (
51: DECODE(x_geography_id,
52: FND_API.G_MISS_NUM, NULL,
53: x_geography_id),
54: DECODE(x_identifier_subtype,
55: FND_API.G_MISS_CHAR, NULL,
56: x_identifier_subtype),

Line 55: FND_API.G_MISS_CHAR, NULL,

51: DECODE(x_geography_id,
52: FND_API.G_MISS_NUM, NULL,
53: x_geography_id),
54: DECODE(x_identifier_subtype,
55: FND_API.G_MISS_CHAR, NULL,
56: x_identifier_subtype),
57: DECODE(x_identifier_value,
58: FND_API.G_MISS_CHAR, NULL,
59: x_identifier_value),

Line 58: FND_API.G_MISS_CHAR, NULL,

54: DECODE(x_identifier_subtype,
55: FND_API.G_MISS_CHAR, NULL,
56: x_identifier_subtype),
57: DECODE(x_identifier_value,
58: FND_API.G_MISS_CHAR, NULL,
59: x_identifier_value),
60: DECODE(x_geo_data_provider,
61: FND_API.G_MISS_CHAR, NULL,
62: x_geo_data_provider),

Line 61: FND_API.G_MISS_CHAR, NULL,

57: DECODE(x_identifier_value,
58: FND_API.G_MISS_CHAR, NULL,
59: x_identifier_value),
60: DECODE(x_geo_data_provider,
61: FND_API.G_MISS_CHAR, NULL,
62: x_geo_data_provider),
63: DECODE(x_object_version_number,
64: FND_API.G_MISS_NUM, NULL,
65: x_object_version_number),

Line 64: FND_API.G_MISS_NUM, NULL,

60: DECODE(x_geo_data_provider,
61: FND_API.G_MISS_CHAR, NULL,
62: x_geo_data_provider),
63: DECODE(x_object_version_number,
64: FND_API.G_MISS_NUM, NULL,
65: x_object_version_number),
66: DECODE(x_identifier_type,
67: FND_API.G_MISS_CHAR, NULL,
68: x_identifier_type),

Line 67: FND_API.G_MISS_CHAR, NULL,

63: DECODE(x_object_version_number,
64: FND_API.G_MISS_NUM, NULL,
65: x_object_version_number),
66: DECODE(x_identifier_type,
67: FND_API.G_MISS_CHAR, NULL,
68: x_identifier_type),
69: DECODE(x_primary_flag,
70: FND_API.G_MISS_CHAR, NULL,
71: x_primary_flag),

Line 70: FND_API.G_MISS_CHAR, NULL,

66: DECODE(x_identifier_type,
67: FND_API.G_MISS_CHAR, NULL,
68: x_identifier_type),
69: DECODE(x_primary_flag,
70: FND_API.G_MISS_CHAR, NULL,
71: x_primary_flag),
72: DECODE(x_language_code,
73: FND_API.G_MISS_CHAR, NULL,
74: x_language_code),

Line 73: FND_API.G_MISS_CHAR, NULL,

69: DECODE(x_primary_flag,
70: FND_API.G_MISS_CHAR, NULL,
71: x_primary_flag),
72: DECODE(x_language_code,
73: FND_API.G_MISS_CHAR, NULL,
74: x_language_code),
75: DECODE(x_geography_use,
76: FND_API.G_MISS_CHAR, NULL,
77: x_geography_use),

Line 76: FND_API.G_MISS_CHAR, NULL,

72: DECODE(x_language_code,
73: FND_API.G_MISS_CHAR, NULL,
74: x_language_code),
75: DECODE(x_geography_use,
76: FND_API.G_MISS_CHAR, NULL,
77: x_geography_use),
78: DECODE(x_geography_type,
79: FND_API.G_MISS_CHAR, NULL,
80: x_geography_type),

Line 79: FND_API.G_MISS_CHAR, NULL,

75: DECODE(x_geography_use,
76: FND_API.G_MISS_CHAR, NULL,
77: x_geography_use),
78: DECODE(x_geography_type,
79: FND_API.G_MISS_CHAR, NULL,
80: x_geography_type),
81: DECODE(x_created_by_module,
82: FND_API.G_MISS_CHAR, NULL,
83: x_created_by_module),

Line 82: FND_API.G_MISS_CHAR, NULL,

78: DECODE(x_geography_type,
79: FND_API.G_MISS_CHAR, NULL,
80: x_geography_type),
81: DECODE(x_created_by_module,
82: FND_API.G_MISS_CHAR, NULL,
83: x_created_by_module),
84: hz_utility_v2pub.last_updated_by,
85: hz_utility_v2pub.creation_date,
86: hz_utility_v2pub.created_by,

Line 90: FND_API.G_MISS_NUM, NULL,

86: hz_utility_v2pub.created_by,
87: hz_utility_v2pub.last_update_date,
88: hz_utility_v2pub.last_update_login,
89: DECODE(x_application_id,
90: FND_API.G_MISS_NUM, NULL,
91: x_application_id),
92: hz_utility_v2pub.program_id,
93: DECODE(x_program_login_id,
94: FND_API.G_MISS_NUM, NULL,

Line 94: FND_API.G_MISS_NUM, NULL,

90: FND_API.G_MISS_NUM, NULL,
91: x_application_id),
92: hz_utility_v2pub.program_id,
93: DECODE(x_program_login_id,
94: FND_API.G_MISS_NUM, NULL,
95: x_program_login_id),
96: hz_utility_v2pub.program_application_id,
97: hz_utility_v2pub.request_id
98: ) RETURNING

Line 130: FND_API.G_MISS_NUM, NULL,

126: SET
127: geography_id =
128: DECODE(x_geography_id,
129: NULL, geography_id,
130: FND_API.G_MISS_NUM, NULL,
131: x_geography_id),
132: identifier_subtype =
133: DECODE(x_identifier_subtype,
134: NULL, identifier_subtype,

Line 135: FND_API.G_MISS_CHAR, NULL,

131: x_geography_id),
132: identifier_subtype =
133: DECODE(x_identifier_subtype,
134: NULL, identifier_subtype,
135: FND_API.G_MISS_CHAR, NULL,
136: x_identifier_subtype),
137: identifier_value =
138: DECODE(x_identifier_value,
139: NULL, identifier_value,

Line 140: FND_API.G_MISS_CHAR, NULL,

136: x_identifier_subtype),
137: identifier_value =
138: DECODE(x_identifier_value,
139: NULL, identifier_value,
140: FND_API.G_MISS_CHAR, NULL,
141: x_identifier_value),
142: geo_data_provider =
143: DECODE(x_geo_data_provider,
144: NULL, geo_data_provider,

Line 145: FND_API.G_MISS_CHAR, NULL,

141: x_identifier_value),
142: geo_data_provider =
143: DECODE(x_geo_data_provider,
144: NULL, geo_data_provider,
145: FND_API.G_MISS_CHAR, NULL,
146: x_geo_data_provider),
147: object_version_number =
148: DECODE(x_object_version_number,
149: NULL, object_version_number,

Line 150: FND_API.G_MISS_NUM, NULL,

146: x_geo_data_provider),
147: object_version_number =
148: DECODE(x_object_version_number,
149: NULL, object_version_number,
150: FND_API.G_MISS_NUM, NULL,
151: x_object_version_number),
152: identifier_type =
153: DECODE(x_identifier_type,
154: NULL, identifier_type,

Line 155: FND_API.G_MISS_CHAR, NULL,

151: x_object_version_number),
152: identifier_type =
153: DECODE(x_identifier_type,
154: NULL, identifier_type,
155: FND_API.G_MISS_CHAR, NULL,
156: x_identifier_type),
157: primary_flag =
158: DECODE(x_primary_flag,
159: NULL, primary_flag,

Line 160: FND_API.G_MISS_CHAR, NULL,

156: x_identifier_type),
157: primary_flag =
158: DECODE(x_primary_flag,
159: NULL, primary_flag,
160: FND_API.G_MISS_CHAR, NULL,
161: x_primary_flag),
162: language_code =
163: DECODE(x_language_code,
164: NULL, language_code,

Line 165: FND_API.G_MISS_CHAR, NULL,

161: x_primary_flag),
162: language_code =
163: DECODE(x_language_code,
164: NULL, language_code,
165: FND_API.G_MISS_CHAR, NULL,
166: x_language_code),
167: geography_use =
168: DECODE(x_geography_use,
169: NULL, geography_use,

Line 170: FND_API.G_MISS_CHAR, NULL,

166: x_language_code),
167: geography_use =
168: DECODE(x_geography_use,
169: NULL, geography_use,
170: FND_API.G_MISS_CHAR, NULL,
171: x_geography_use),
172: geography_type =
173: DECODE(x_geography_type,
174: NULL, geography_type,

Line 175: FND_API.G_MISS_CHAR, NULL,

171: x_geography_use),
172: geography_type =
173: DECODE(x_geography_type,
174: NULL, geography_type,
175: FND_API.G_MISS_CHAR, NULL,
176: x_geography_type),
177: created_by_module =
178: DECODE(x_created_by_module,
179: NULL, created_by_module,

Line 180: FND_API.G_MISS_CHAR, NULL,

176: x_geography_type),
177: created_by_module =
178: DECODE(x_created_by_module,
179: NULL, created_by_module,
180: FND_API.G_MISS_CHAR, NULL,
181: x_created_by_module),
182: last_updated_by = hz_utility_v2pub.last_updated_by,
183: creation_date = creation_date,
184: created_by = created_by,

Line 190: FND_API.G_MISS_NUM, NULL,

186: last_update_login = hz_utility_v2pub.last_update_login,
187: application_id =
188: DECODE(x_application_id,
189: NULL, application_id,
190: FND_API.G_MISS_NUM, NULL,
191: x_application_id),
192: program_id = hz_utility_v2pub.program_id,
193: program_login_id =
194: DECODE(x_program_login_id,

Line 196: FND_API.G_MISS_NUM, NULL,

192: program_id = hz_utility_v2pub.program_id,
193: program_login_id =
194: DECODE(x_program_login_id,
195: NULL, program_login_id,
196: FND_API.G_MISS_NUM, NULL,
197: x_program_login_id),
198: program_application_id = hz_utility_v2pub.program_application_id,
199: request_id = hz_utility_v2pub.request_id
200: WHERE rowid = x_rowid;

Line 341: NVL(geography_id, FND_API.G_MISS_NUM),

337: ) IS
338: BEGIN
339:
340: SELECT
341: NVL(geography_id, FND_API.G_MISS_NUM),
342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),

Line 342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),

338: BEGIN
339:
340: SELECT
341: NVL(geography_id, FND_API.G_MISS_NUM),
342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),

Line 343: NVL(identifier_value, FND_API.G_MISS_CHAR),

339:
340: SELECT
341: NVL(geography_id, FND_API.G_MISS_NUM),
342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),

Line 344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),

340: SELECT
341: NVL(geography_id, FND_API.G_MISS_NUM),
342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),

Line 345: NVL(identifier_type, FND_API.G_MISS_CHAR),

341: NVL(geography_id, FND_API.G_MISS_NUM),
342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),

Line 346: NVL(primary_flag, FND_API.G_MISS_CHAR),

342: NVL(identifier_subtype, FND_API.G_MISS_CHAR),
343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 347: NVL(language_code, FND_API.G_MISS_CHAR),

343: NVL(identifier_value, FND_API.G_MISS_CHAR),
344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),

Line 348: NVL(geography_use, FND_API.G_MISS_CHAR),

344: NVL(geo_data_provider, FND_API.G_MISS_CHAR),
345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),
352: NVL(program_login_id, FND_API.G_MISS_NUM)

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

345: NVL(identifier_type, FND_API.G_MISS_CHAR),
346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),
352: NVL(program_login_id, FND_API.G_MISS_NUM)
353: INTO

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

346: NVL(primary_flag, FND_API.G_MISS_CHAR),
347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),
352: NVL(program_login_id, FND_API.G_MISS_NUM)
353: INTO
354: x_geography_id,

Line 351: NVL(application_id, FND_API.G_MISS_NUM),

347: NVL(language_code, FND_API.G_MISS_CHAR),
348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),
352: NVL(program_login_id, FND_API.G_MISS_NUM)
353: INTO
354: x_geography_id,
355: x_identifier_subtype,

Line 352: NVL(program_login_id, FND_API.G_MISS_NUM)

348: NVL(geography_use, FND_API.G_MISS_CHAR),
349: NVL(geography_type, FND_API.G_MISS_CHAR),
350: NVL(created_by_module, FND_API.G_MISS_CHAR),
351: NVL(application_id, FND_API.G_MISS_NUM),
352: NVL(program_login_id, FND_API.G_MISS_NUM)
353: INTO
354: x_geography_id,
355: x_identifier_subtype,
356: x_identifier_value,

Line 380: RAISE FND_API.G_EXC_ERROR;

376: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
377: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_identifiers_rec');
378: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381:
382: END Select_Row;
383:
384: PROCEDURE Delete_Row (