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

Line 40: FND_API.G_MISS_CHAR, NULL,

36: request_id
37: )
38: VALUES (
39: DECODE(x_geography_type,
40: FND_API.G_MISS_CHAR, NULL,
41: x_geography_type),
42: DECODE(x_object_version_number,
43: FND_API.G_MISS_NUM, NULL,
44: x_object_version_number),

Line 43: FND_API.G_MISS_NUM, NULL,

39: DECODE(x_geography_type,
40: FND_API.G_MISS_CHAR, NULL,
41: x_geography_type),
42: DECODE(x_object_version_number,
43: FND_API.G_MISS_NUM, NULL,
44: x_object_version_number),
45: DECODE(x_geography_use,
46: FND_API.G_MISS_CHAR, NULL,
47: x_geography_use),

Line 46: FND_API.G_MISS_CHAR, NULL,

42: DECODE(x_object_version_number,
43: FND_API.G_MISS_NUM, NULL,
44: x_object_version_number),
45: DECODE(x_geography_use,
46: FND_API.G_MISS_CHAR, NULL,
47: x_geography_use),
48: DECODE(x_postal_code_range_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_postal_code_range_flag),

Line 49: FND_API.G_MISS_CHAR, NULL,

45: DECODE(x_geography_use,
46: FND_API.G_MISS_CHAR, NULL,
47: x_geography_use),
48: DECODE(x_postal_code_range_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_postal_code_range_flag),
51: DECODE(x_limited_by_geography_id,
52: FND_API.G_MISS_NUM, NULL,
53: x_limited_by_geography_id),

Line 52: FND_API.G_MISS_NUM, NULL,

48: DECODE(x_postal_code_range_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_postal_code_range_flag),
51: DECODE(x_limited_by_geography_id,
52: FND_API.G_MISS_NUM, NULL,
53: x_limited_by_geography_id),
54: DECODE(x_created_by_module,
55: FND_API.G_MISS_CHAR, NULL,
56: x_created_by_module),

Line 55: FND_API.G_MISS_CHAR, NULL,

51: DECODE(x_limited_by_geography_id,
52: FND_API.G_MISS_NUM, NULL,
53: x_limited_by_geography_id),
54: DECODE(x_created_by_module,
55: FND_API.G_MISS_CHAR, NULL,
56: x_created_by_module),
57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,

Line 63: FND_API.G_MISS_NUM, NULL,

59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,
63: FND_API.G_MISS_NUM, NULL,
64: x_application_id),
65: hz_utility_v2pub.program_id,
66: DECODE(x_program_login_id,
67: FND_API.G_MISS_NUM, NULL,

Line 67: FND_API.G_MISS_NUM, NULL,

63: FND_API.G_MISS_NUM, NULL,
64: x_application_id),
65: hz_utility_v2pub.program_id,
66: DECODE(x_program_login_id,
67: FND_API.G_MISS_NUM, NULL,
68: x_program_login_id),
69: hz_utility_v2pub.program_application_id,
70: hz_utility_v2pub.request_id
71: ) RETURNING

Line 94: FND_API.G_MISS_CHAR, NULL,

90: LANGUAGE,
91: SOURCE_LANG
92: ) select
93: DECODE(x_geography_type,
94: FND_API.G_MISS_CHAR, NULL,
95: x_geography_type),
96: DECODE(x_geography_type_name,
97: FND_API.G_MISS_CHAR, NULL,
98: x_geography_type_name),

Line 97: FND_API.G_MISS_CHAR, NULL,

93: DECODE(x_geography_type,
94: FND_API.G_MISS_CHAR, NULL,
95: x_geography_type),
96: DECODE(x_geography_type_name,
97: FND_API.G_MISS_CHAR, NULL,
98: x_geography_type_name),
99: DECODE(x_created_by_module,
100: FND_API.G_MISS_CHAR, NULL,
101: x_created_by_module),

Line 100: FND_API.G_MISS_CHAR, NULL,

96: DECODE(x_geography_type_name,
97: FND_API.G_MISS_CHAR, NULL,
98: x_geography_type_name),
99: DECODE(x_created_by_module,
100: FND_API.G_MISS_CHAR, NULL,
101: x_created_by_module),
102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,

Line 108: FND_API.G_MISS_NUM, NULL,

104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,
108: FND_API.G_MISS_NUM, NULL,
109: x_application_id),
110: hz_utility_v2pub.program_id,
111: DECODE(x_program_login_id,
112: FND_API.G_MISS_NUM, NULL,

Line 112: FND_API.G_MISS_NUM, NULL,

108: FND_API.G_MISS_NUM, NULL,
109: x_application_id),
110: hz_utility_v2pub.program_id,
111: DECODE(x_program_login_id,
112: FND_API.G_MISS_NUM, NULL,
113: x_program_login_id),
114: hz_utility_v2pub.program_application_id,
115: hz_utility_v2pub.request_id,
116: L.LANGUAGE_CODE,

Line 149: FND_API.G_MISS_CHAR, NULL,

145: SET
146: geography_type =
147: DECODE(x_geography_type,
148: NULL, geography_type,
149: FND_API.G_MISS_CHAR, NULL,
150: x_geography_type),
151: object_version_number =
152: DECODE(x_object_version_number,
153: NULL, object_version_number,

Line 154: FND_API.G_MISS_NUM, NULL,

150: x_geography_type),
151: object_version_number =
152: DECODE(x_object_version_number,
153: NULL, object_version_number,
154: FND_API.G_MISS_NUM, NULL,
155: x_object_version_number),
156: geography_use =
157: DECODE(x_geography_use,
158: NULL, geography_use,

Line 159: FND_API.G_MISS_CHAR, NULL,

155: x_object_version_number),
156: geography_use =
157: DECODE(x_geography_use,
158: NULL, geography_use,
159: FND_API.G_MISS_CHAR, NULL,
160: x_geography_use),
161: postal_code_range_flag =
162: DECODE(x_postal_code_range_flag,
163: NULL, postal_code_range_flag,

Line 164: FND_API.G_MISS_CHAR, NULL,

160: x_geography_use),
161: postal_code_range_flag =
162: DECODE(x_postal_code_range_flag,
163: NULL, postal_code_range_flag,
164: FND_API.G_MISS_CHAR, NULL,
165: x_postal_code_range_flag),
166: limited_by_geography_id =
167: DECODE(x_limited_by_geography_id,
168: NULL, limited_by_geography_id,

Line 169: FND_API.G_MISS_NUM, NULL,

165: x_postal_code_range_flag),
166: limited_by_geography_id =
167: DECODE(x_limited_by_geography_id,
168: NULL, limited_by_geography_id,
169: FND_API.G_MISS_NUM, NULL,
170: x_limited_by_geography_id),
171: created_by_module =
172: DECODE(x_created_by_module,
173: NULL, created_by_module,

Line 174: FND_API.G_MISS_CHAR, NULL,

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

Line 184: FND_API.G_MISS_NUM, NULL,

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

Line 190: FND_API.G_MISS_NUM, NULL,

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

Line 203: FND_API.G_MISS_NUM, NULL,

199:
200: update HZ_GEOGRAPHY_TYPES_TL set
201: GEOGRAPHY_TYPE_NAME = decode(X_GEOGRAPHY_TYPE_NAME,
202: NULL, GEOGRAPHY_TYPE_NAME,
203: FND_API.G_MISS_NUM, NULL,
204: X_GEOGRAPHY_TYPE_NAME),
205: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
206: FND_API.G_MISS_NUM, NULL,
207: hz_utility_v2pub.last_update_date),

Line 206: FND_API.G_MISS_NUM, NULL,

202: NULL, GEOGRAPHY_TYPE_NAME,
203: FND_API.G_MISS_NUM, NULL,
204: X_GEOGRAPHY_TYPE_NAME),
205: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
206: FND_API.G_MISS_NUM, NULL,
207: hz_utility_v2pub.last_update_date),
208: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),

Line 209: FND_API.G_MISS_NUM, NULL,

205: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
206: FND_API.G_MISS_NUM, NULL,
207: hz_utility_v2pub.last_update_date),
208: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),
211: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
212: FND_API.G_MISS_NUM, NULL,
213: hz_utility_v2pub.LAST_UPDATE_LOGIN),

Line 212: FND_API.G_MISS_NUM, NULL,

208: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),
211: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
212: FND_API.G_MISS_NUM, NULL,
213: hz_utility_v2pub.LAST_UPDATE_LOGIN),
214: SOURCE_LANG = userenv('LANG')
215: where GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
216: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

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

349: ) IS
350: BEGIN
351:
352: SELECT
353: NVL(geography_type, FND_API.G_MISS_CHAR),
354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),

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

350: BEGIN
351:
352: SELECT
353: NVL(geography_type, FND_API.G_MISS_CHAR),
354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),

Line 355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),

351:
352: SELECT
353: NVL(geography_type, FND_API.G_MISS_CHAR),
354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),
359: NVL(program_login_id, FND_API.G_MISS_NUM)

Line 356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),

352: SELECT
353: NVL(geography_type, FND_API.G_MISS_CHAR),
354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),
359: NVL(program_login_id, FND_API.G_MISS_NUM)
360: INTO

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

353: NVL(geography_type, FND_API.G_MISS_CHAR),
354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),
359: NVL(program_login_id, FND_API.G_MISS_NUM)
360: INTO
361: x_geography_type,

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

354: NVL(geography_use, FND_API.G_MISS_CHAR),
355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),
359: NVL(program_login_id, FND_API.G_MISS_NUM)
360: INTO
361: x_geography_type,
362: x_geography_use,

Line 359: NVL(program_login_id, FND_API.G_MISS_NUM)

355: NVL(postal_code_range_flag, FND_API.G_MISS_CHAR),
356: NVL(limited_by_geography_id, FND_API.G_MISS_NUM),
357: NVL(created_by_module, FND_API.G_MISS_CHAR),
358: NVL(application_id, FND_API.G_MISS_NUM),
359: NVL(program_login_id, FND_API.G_MISS_NUM)
360: INTO
361: x_geography_type,
362: x_geography_use,
363: x_postal_code_range_flag,

Line 377: RAISE FND_API.G_EXC_ERROR;

373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
374: FND_MESSAGE.SET_TOKEN('RECORD', 'geography');
375: FND_MESSAGE.SET_TOKEN('VALUE', x_geography_type);
376: FND_MSG_PUB.ADD;
377: RAISE FND_API.G_EXC_ERROR;
378:
379: END Select_Row;
380:
381: PROCEDURE Delete_Row (

Line 529: FND_API.G_MISS_NUM, NULL,

525: x_postal_code_range_flag),
526: limited_by_geography_id =
527: DECODE(x_limited_by_geography_id,
528: NULL, limited_by_geography_id,
529: FND_API.G_MISS_NUM, NULL,
530: x_limited_by_geography_id),
531: last_updated_by = l_user_id,
532: last_update_date = hz_utility_v2pub.last_update_date,
533: last_update_login = hz_utility_v2pub.last_update_login,

Line 537: FND_API.G_MISS_NUM, NULL,

533: last_update_login = hz_utility_v2pub.last_update_login,
534: application_id =
535: DECODE(x_application_id,
536: NULL, application_id,
537: FND_API.G_MISS_NUM, NULL,
538: x_application_id),
539: program_login_id =
540: DECODE(x_program_login_id,
541: NULL, program_login_id,

Line 542: FND_API.G_MISS_NUM, NULL,

538: x_application_id),
539: program_login_id =
540: DECODE(x_program_login_id,
541: NULL, program_login_id,
542: FND_API.G_MISS_NUM, NULL,
543: x_program_login_id)
544: WHERE rowid = l_row_id;
545:
546: -- so far hz_geography_types_b table has data. Now update tl table

Line 551: FND_API.G_MISS_NUM, NULL,

547:
548: UPDATE HZ_GEOGRAPHY_TYPES_TL SET
549: GEOGRAPHY_TYPE_NAME = decode(X_GEOGRAPHY_TYPE_NAME,
550: NULL, GEOGRAPHY_TYPE_NAME,
551: FND_API.G_MISS_NUM, NULL,
552: X_GEOGRAPHY_TYPE_NAME),
553: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
554: hz_utility_v2pub.last_update_date),
555: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,

Line 558: FND_API.G_MISS_NUM, NULL,

554: hz_utility_v2pub.last_update_date),
555: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
556: l_user_id),
557: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
558: FND_API.G_MISS_NUM, NULL,
559: l_user_id),
560: SOURCE_LANG = USERENV('LANG')
561: WHERE GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
562: AND USERENV('LANG') in (LANGUAGE, SOURCE_LANG);

Line 599: FND_API.G_MISS_NUM, NULL,

595: 1,
596: x_geography_use,
597: x_postal_code_range_flag,
598: DECODE(x_limited_by_geography_id,
599: FND_API.G_MISS_NUM, NULL,
600: x_limited_by_geography_id),
601: x_created_by_module,
602: l_user_id,
603: hz_utility_v2pub.creation_date,

Line 608: FND_API.G_MISS_NUM, NULL,

604: l_user_id,
605: hz_utility_v2pub.last_update_date,
606: hz_utility_v2pub.last_update_login,
607: DECODE(x_application_id,
608: FND_API.G_MISS_NUM, NULL,
609: x_application_id),
610: hz_utility_v2pub.program_id,
611: DECODE(x_program_login_id,
612: FND_API.G_MISS_NUM, NULL,

Line 612: FND_API.G_MISS_NUM, NULL,

608: FND_API.G_MISS_NUM, NULL,
609: x_application_id),
610: hz_utility_v2pub.program_id,
611: DECODE(x_program_login_id,
612: FND_API.G_MISS_NUM, NULL,
613: x_program_login_id),
614: hz_utility_v2pub.program_application_id,
615: hz_utility_v2pub.request_id
616: ) ;

Line 638: FND_API.G_MISS_CHAR, NULL,

634: SOURCE_LANG
635: ) SELECT
636: x_geography_type,
637: DECODE(x_geography_type_name,
638: FND_API.G_MISS_CHAR, NULL,
639: x_geography_type_name),
640: x_created_by_module,
641: l_user_id,
642: hz_utility_v2pub.creation_date,

Line 647: FND_API.G_MISS_NUM, NULL,

643: l_user_id,
644: hz_utility_v2pub.last_update_date,
645: hz_utility_v2pub.last_update_login,
646: DECODE(x_application_id,
647: FND_API.G_MISS_NUM, NULL,
648: x_application_id),
649: hz_utility_v2pub.program_id,
650: DECODE(x_program_login_id,
651: FND_API.G_MISS_NUM, NULL,

Line 651: FND_API.G_MISS_NUM, NULL,

647: FND_API.G_MISS_NUM, NULL,
648: x_application_id),
649: hz_utility_v2pub.program_id,
650: DECODE(x_program_login_id,
651: FND_API.G_MISS_NUM, NULL,
652: x_program_login_id),
653: hz_utility_v2pub.program_application_id,
654: hz_utility_v2pub.request_id,
655: L.LANGUAGE_CODE,