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

Line 49: FND_API.G_MISS_NUM, NULL,

45: request_id
46: )
47: VALUES (
48: DECODE(x_geography_id,
49: FND_API.G_MISS_NUM, NULL,
50: x_geography_id),
51: DECODE(x_geography_from,
52: FND_API.G_MISS_CHAR, NULL,
53: x_geography_from),

Line 52: FND_API.G_MISS_CHAR, NULL,

48: DECODE(x_geography_id,
49: FND_API.G_MISS_NUM, NULL,
50: x_geography_id),
51: DECODE(x_geography_from,
52: FND_API.G_MISS_CHAR, NULL,
53: x_geography_from),
54: DECODE(x_start_date,
55: FND_API.G_MISS_DATE, TO_DATE(NULL),
56: x_start_date),

Line 55: FND_API.G_MISS_DATE, TO_DATE(NULL),

51: DECODE(x_geography_from,
52: FND_API.G_MISS_CHAR, NULL,
53: x_geography_from),
54: DECODE(x_start_date,
55: FND_API.G_MISS_DATE, TO_DATE(NULL),
56: x_start_date),
57: DECODE(x_object_version_number,
58: FND_API.G_MISS_NUM, NULL,
59: x_object_version_number),

Line 58: FND_API.G_MISS_NUM, NULL,

54: DECODE(x_start_date,
55: FND_API.G_MISS_DATE, TO_DATE(NULL),
56: x_start_date),
57: DECODE(x_object_version_number,
58: FND_API.G_MISS_NUM, NULL,
59: x_object_version_number),
60: DECODE(x_geography_to,
61: FND_API.G_MISS_CHAR, NULL,
62: x_geography_to),

Line 61: FND_API.G_MISS_CHAR, NULL,

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

Line 64: FND_API.G_MISS_CHAR, NULL,

60: DECODE(x_geography_to,
61: FND_API.G_MISS_CHAR, NULL,
62: x_geography_to),
63: DECODE(x_identifier_type,
64: FND_API.G_MISS_CHAR, NULL,
65: x_identifier_type),
66: DECODE(x_end_date,
67: FND_API.G_MISS_DATE, TO_DATE(NULL),
68: x_end_date),

Line 67: FND_API.G_MISS_DATE, TO_DATE(NULL),

63: DECODE(x_identifier_type,
64: FND_API.G_MISS_CHAR, NULL,
65: x_identifier_type),
66: DECODE(x_end_date,
67: FND_API.G_MISS_DATE, TO_DATE(NULL),
68: x_end_date),
69: DECODE(x_geography_type,
70: FND_API.G_MISS_CHAR, NULL,
71: x_geography_type),

Line 70: FND_API.G_MISS_CHAR, NULL,

66: DECODE(x_end_date,
67: FND_API.G_MISS_DATE, TO_DATE(NULL),
68: x_end_date),
69: DECODE(x_geography_type,
70: FND_API.G_MISS_CHAR, NULL,
71: x_geography_type),
72: DECODE(x_geography_use,
73: FND_API.G_MISS_CHAR, NULL,
74: x_geography_use),

Line 73: FND_API.G_MISS_CHAR, NULL,

69: DECODE(x_geography_type,
70: FND_API.G_MISS_CHAR, NULL,
71: x_geography_type),
72: DECODE(x_geography_use,
73: FND_API.G_MISS_CHAR, NULL,
74: x_geography_use),
75: DECODE(x_master_ref_geography_id,
76: FND_API.G_MISS_NUM, NULL,
77: x_master_ref_geography_id),

Line 76: FND_API.G_MISS_NUM, NULL,

72: DECODE(x_geography_use,
73: FND_API.G_MISS_CHAR, NULL,
74: x_geography_use),
75: DECODE(x_master_ref_geography_id,
76: FND_API.G_MISS_NUM, NULL,
77: x_master_ref_geography_id),
78: DECODE(x_created_by_module,
79: FND_API.G_MISS_CHAR, NULL,
80: x_created_by_module),

Line 79: FND_API.G_MISS_CHAR, NULL,

75: DECODE(x_master_ref_geography_id,
76: FND_API.G_MISS_NUM, NULL,
77: x_master_ref_geography_id),
78: DECODE(x_created_by_module,
79: FND_API.G_MISS_CHAR, NULL,
80: x_created_by_module),
81: hz_utility_v2pub.last_updated_by,
82: hz_utility_v2pub.creation_date,
83: hz_utility_v2pub.created_by,

Line 87: FND_API.G_MISS_NUM, NULL,

83: hz_utility_v2pub.created_by,
84: hz_utility_v2pub.last_update_date,
85: hz_utility_v2pub.last_update_login,
86: DECODE(x_application_id,
87: FND_API.G_MISS_NUM, NULL,
88: x_application_id),
89: hz_utility_v2pub.program_id,
90: DECODE(x_program_login_id,
91: FND_API.G_MISS_NUM, NULL,

Line 91: FND_API.G_MISS_NUM, NULL,

87: FND_API.G_MISS_NUM, NULL,
88: x_application_id),
89: hz_utility_v2pub.program_id,
90: DECODE(x_program_login_id,
91: FND_API.G_MISS_NUM, NULL,
92: x_program_login_id),
93: hz_utility_v2pub.program_application_id,
94: hz_utility_v2pub.request_id
95: ) RETURNING

Line 125: FND_API.G_MISS_NUM, NULL,

121: SET
122: geography_id =
123: DECODE(x_geography_id,
124: NULL, geography_id,
125: FND_API.G_MISS_NUM, NULL,
126: x_geography_id),
127: geography_from =
128: DECODE(x_geography_from,
129: NULL, geography_from,

Line 130: FND_API.G_MISS_CHAR, NULL,

126: x_geography_id),
127: geography_from =
128: DECODE(x_geography_from,
129: NULL, geography_from,
130: FND_API.G_MISS_CHAR, NULL,
131: x_geography_from),
132: start_date =
133: DECODE(x_start_date,
134: NULL, start_date,

Line 135: FND_API.G_MISS_DATE, NULL,

131: x_geography_from),
132: start_date =
133: DECODE(x_start_date,
134: NULL, start_date,
135: FND_API.G_MISS_DATE, NULL,
136: x_start_date),
137: object_version_number =
138: DECODE(x_object_version_number,
139: NULL, object_version_number,

Line 140: FND_API.G_MISS_NUM, NULL,

136: x_start_date),
137: object_version_number =
138: DECODE(x_object_version_number,
139: NULL, object_version_number,
140: FND_API.G_MISS_NUM, NULL,
141: x_object_version_number),
142: geography_to =
143: DECODE(x_geography_to,
144: NULL, geography_to,

Line 145: FND_API.G_MISS_CHAR, NULL,

141: x_object_version_number),
142: geography_to =
143: DECODE(x_geography_to,
144: NULL, geography_to,
145: FND_API.G_MISS_CHAR, NULL,
146: x_geography_to),
147: identifier_type =
148: DECODE(x_identifier_type,
149: NULL, identifier_type,

Line 150: FND_API.G_MISS_CHAR, NULL,

146: x_geography_to),
147: identifier_type =
148: DECODE(x_identifier_type,
149: NULL, identifier_type,
150: FND_API.G_MISS_CHAR, NULL,
151: x_identifier_type),
152: end_date =
153: DECODE(x_end_date,
154: NULL, end_date,

Line 155: FND_API.G_MISS_DATE, NULL,

151: x_identifier_type),
152: end_date =
153: DECODE(x_end_date,
154: NULL, end_date,
155: FND_API.G_MISS_DATE, NULL,
156: x_end_date),
157: geography_type =
158: DECODE(x_geography_type,
159: NULL, geography_type,

Line 160: FND_API.G_MISS_CHAR, NULL,

156: x_end_date),
157: geography_type =
158: DECODE(x_geography_type,
159: NULL, geography_type,
160: FND_API.G_MISS_CHAR, NULL,
161: x_geography_type),
162: geography_use =
163: DECODE(x_geography_use,
164: NULL, geography_use,

Line 165: FND_API.G_MISS_CHAR, NULL,

161: x_geography_type),
162: geography_use =
163: DECODE(x_geography_use,
164: NULL, geography_use,
165: FND_API.G_MISS_CHAR, NULL,
166: x_geography_use),
167: master_ref_geography_id =
168: DECODE(x_master_ref_geography_id,
169: NULL, master_ref_geography_id,

Line 170: FND_API.G_MISS_NUM, NULL,

166: x_geography_use),
167: master_ref_geography_id =
168: DECODE(x_master_ref_geography_id,
169: NULL, master_ref_geography_id,
170: FND_API.G_MISS_NUM, NULL,
171: x_master_ref_geography_id),
172: created_by_module =
173: DECODE(x_created_by_module,
174: NULL, created_by_module,

Line 175: FND_API.G_MISS_CHAR, NULL,

171: x_master_ref_geography_id),
172: created_by_module =
173: DECODE(x_created_by_module,
174: NULL, created_by_module,
175: FND_API.G_MISS_CHAR, NULL,
176: x_created_by_module),
177: last_updated_by = hz_utility_v2pub.last_updated_by,
178: creation_date = creation_date,
179: created_by = created_by,

Line 185: FND_API.G_MISS_NUM, NULL,

181: last_update_login = hz_utility_v2pub.last_update_login,
182: application_id =
183: DECODE(x_application_id,
184: NULL, application_id,
185: FND_API.G_MISS_NUM, NULL,
186: x_application_id),
187: program_id = hz_utility_v2pub.program_id,
188: program_login_id =
189: DECODE(x_program_login_id,

Line 191: FND_API.G_MISS_NUM, NULL,

187: program_id = hz_utility_v2pub.program_id,
188: program_login_id =
189: DECODE(x_program_login_id,
190: NULL, program_login_id,
191: FND_API.G_MISS_NUM, NULL,
192: x_program_login_id),
193: program_application_id = hz_utility_v2pub.program_application_id,
194: request_id = hz_utility_v2pub.request_id
195: WHERE rowid = x_rowid;

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

332: ) IS
333: BEGIN
334:
335: SELECT
336: NVL(geography_id, FND_API.G_MISS_NUM),
337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),

Line 337: NVL(geography_from, FND_API.G_MISS_CHAR),

333: BEGIN
334:
335: SELECT
336: NVL(geography_id, FND_API.G_MISS_NUM),
337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),

Line 338: NVL(start_date, FND_API.G_MISS_DATE),

334:
335: SELECT
336: NVL(geography_id, FND_API.G_MISS_NUM),
337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),

Line 339: NVL(geography_to, FND_API.G_MISS_CHAR),

335: SELECT
336: NVL(geography_id, FND_API.G_MISS_NUM),
337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),

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

336: NVL(geography_id, FND_API.G_MISS_NUM),
337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),

Line 341: NVL(end_date, FND_API.G_MISS_DATE),

337: NVL(geography_from, FND_API.G_MISS_CHAR),
338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),

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

338: NVL(start_date, FND_API.G_MISS_DATE),
339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),

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

339: NVL(geography_to, FND_API.G_MISS_CHAR),
340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),
347: NVL(program_login_id, FND_API.G_MISS_NUM)

Line 344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),

340: NVL(identifier_type, FND_API.G_MISS_CHAR),
341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),
347: NVL(program_login_id, FND_API.G_MISS_NUM)
348: INTO

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

341: NVL(end_date, FND_API.G_MISS_DATE),
342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),
347: NVL(program_login_id, FND_API.G_MISS_NUM)
348: INTO
349: x_geography_id,

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

342: NVL(geography_type, FND_API.G_MISS_CHAR),
343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),
347: NVL(program_login_id, FND_API.G_MISS_NUM)
348: INTO
349: x_geography_id,
350: x_geography_from,

Line 347: NVL(program_login_id, FND_API.G_MISS_NUM)

343: NVL(geography_use, FND_API.G_MISS_CHAR),
344: NVL(master_ref_geography_id, FND_API.G_MISS_NUM),
345: NVL(created_by_module, FND_API.G_MISS_CHAR),
346: NVL(application_id, FND_API.G_MISS_NUM),
347: NVL(program_login_id, FND_API.G_MISS_NUM)
348: INTO
349: x_geography_id,
350: x_geography_from,
351: x_start_date,

Line 372: RAISE FND_API.G_EXC_ERROR;

368: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
369: FND_MESSAGE.SET_TOKEN('RECORD', 'geography_ranges_rec');
370: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
371: FND_MSG_PUB.ADD;
372: RAISE FND_API.G_EXC_ERROR;
373:
374: END Select_Row;
375:
376: PROCEDURE Delete_Row (