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

Line 47: FND_API.G_MISS_NUM, NULL,

43: addr_val_level
44: )
45: VALUES (
46: DECODE(x_geography_id,
47: FND_API.G_MISS_NUM, NULL,
48: x_geography_id),
49: DECODE(x_geography_type,
50: FND_API.G_MISS_CHAR, NULL,
51: x_geography_type),

Line 50: FND_API.G_MISS_CHAR, NULL,

46: DECODE(x_geography_id,
47: FND_API.G_MISS_NUM, NULL,
48: x_geography_id),
49: DECODE(x_geography_type,
50: FND_API.G_MISS_CHAR, NULL,
51: x_geography_type),
52: DECODE(x_parent_geography_type,
53: FND_API.G_MISS_CHAR, NULL,
54: x_parent_geography_type),

Line 53: FND_API.G_MISS_CHAR, NULL,

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

Line 56: FND_API.G_MISS_NUM, NULL,

52: DECODE(x_parent_geography_type,
53: FND_API.G_MISS_CHAR, NULL,
54: x_parent_geography_type),
55: DECODE(x_object_version_number,
56: FND_API.G_MISS_NUM, NULL,
57: x_object_version_number),
58: DECODE(x_relationship_type_id,
59: FND_API.G_MISS_NUM, NULL,
60: x_relationship_type_id),

Line 59: FND_API.G_MISS_NUM, NULL,

55: DECODE(x_object_version_number,
56: FND_API.G_MISS_NUM, NULL,
57: x_object_version_number),
58: DECODE(x_relationship_type_id,
59: FND_API.G_MISS_NUM, NULL,
60: x_relationship_type_id),
61: DECODE(x_country_code,
62: FND_API.G_MISS_CHAR, NULL,
63: x_country_code),

Line 62: FND_API.G_MISS_CHAR, NULL,

58: DECODE(x_relationship_type_id,
59: FND_API.G_MISS_NUM, NULL,
60: x_relationship_type_id),
61: DECODE(x_country_code,
62: FND_API.G_MISS_CHAR, NULL,
63: x_country_code),
64: DECODE(x_geography_element_column,
65: FND_API.G_MISS_CHAR, NULL,
66: x_geography_element_column),

Line 65: FND_API.G_MISS_CHAR, NULL,

61: DECODE(x_country_code,
62: FND_API.G_MISS_CHAR, NULL,
63: x_country_code),
64: DECODE(x_geography_element_column,
65: FND_API.G_MISS_CHAR, NULL,
66: x_geography_element_column),
67: DECODE(x_created_by_module,
68: FND_API.G_MISS_CHAR, NULL,
69: x_created_by_module),

Line 68: FND_API.G_MISS_CHAR, NULL,

64: DECODE(x_geography_element_column,
65: FND_API.G_MISS_CHAR, NULL,
66: x_geography_element_column),
67: DECODE(x_created_by_module,
68: FND_API.G_MISS_CHAR, NULL,
69: x_created_by_module),
70: hz_utility_v2pub.last_updated_by,
71: hz_utility_v2pub.creation_date,
72: hz_utility_v2pub.created_by,

Line 76: FND_API.G_MISS_NUM, NULL,

72: hz_utility_v2pub.created_by,
73: hz_utility_v2pub.last_update_date,
74: hz_utility_v2pub.last_update_login,
75: DECODE(x_application_id,
76: FND_API.G_MISS_NUM, NULL,
77: x_application_id),
78: hz_utility_v2pub.program_id,
79: DECODE(x_program_login_id,
80: FND_API.G_MISS_NUM, NULL,

Line 80: FND_API.G_MISS_NUM, NULL,

76: FND_API.G_MISS_NUM, NULL,
77: x_application_id),
78: hz_utility_v2pub.program_id,
79: DECODE(x_program_login_id,
80: FND_API.G_MISS_NUM, NULL,
81: x_program_login_id),
82: hz_utility_v2pub.program_application_id,
83: hz_utility_v2pub.request_id,
84: DECODE(x_addr_val_level,

Line 85: FND_API.G_MISS_CHAR, NULL,

81: x_program_login_id),
82: hz_utility_v2pub.program_application_id,
83: hz_utility_v2pub.request_id,
84: DECODE(x_addr_val_level,
85: FND_API.G_MISS_CHAR, NULL,
86: x_addr_val_level)
87: ) RETURNING
88: rowid
89: INTO

Line 114: FND_API.G_MISS_NUM, NULL,

110: SET
111: geography_id =
112: DECODE(x_geography_id,
113: NULL, geography_id,
114: FND_API.G_MISS_NUM, NULL,
115: x_geography_id),
116: geography_type =
117: DECODE(x_geography_type,
118: NULL, geography_type,

Line 119: FND_API.G_MISS_CHAR, NULL,

115: x_geography_id),
116: geography_type =
117: DECODE(x_geography_type,
118: NULL, geography_type,
119: FND_API.G_MISS_CHAR, NULL,
120: x_geography_type),
121: parent_geography_type =
122: DECODE(x_parent_geography_type,
123: NULL, parent_geography_type,

Line 124: FND_API.G_MISS_CHAR, NULL,

120: x_geography_type),
121: parent_geography_type =
122: DECODE(x_parent_geography_type,
123: NULL, parent_geography_type,
124: FND_API.G_MISS_CHAR, NULL,
125: x_parent_geography_type),
126: object_version_number =
127: DECODE(x_object_version_number,
128: NULL, object_version_number,

Line 129: FND_API.G_MISS_NUM, NULL,

125: x_parent_geography_type),
126: object_version_number =
127: DECODE(x_object_version_number,
128: NULL, object_version_number,
129: FND_API.G_MISS_NUM, NULL,
130: x_object_version_number),
131: relationship_type_id =
132: DECODE(x_relationship_type_id,
133: NULL, relationship_type_id,

Line 134: FND_API.G_MISS_NUM, NULL,

130: x_object_version_number),
131: relationship_type_id =
132: DECODE(x_relationship_type_id,
133: NULL, relationship_type_id,
134: FND_API.G_MISS_NUM, NULL,
135: x_relationship_type_id),
136: country_code =
137: DECODE(x_country_code,
138: NULL, country_code,

Line 139: FND_API.G_MISS_CHAR, NULL,

135: x_relationship_type_id),
136: country_code =
137: DECODE(x_country_code,
138: NULL, country_code,
139: FND_API.G_MISS_CHAR, NULL,
140: x_country_code),
141: geography_element_column =
142: DECODE(x_geography_element_column,
143: NULL, geography_element_column,

Line 144: FND_API.G_MISS_CHAR, NULL,

140: x_country_code),
141: geography_element_column =
142: DECODE(x_geography_element_column,
143: NULL, geography_element_column,
144: FND_API.G_MISS_CHAR, NULL,
145: x_geography_element_column),
146: created_by_module =
147: DECODE(x_created_by_module,
148: NULL, created_by_module,

Line 149: FND_API.G_MISS_CHAR, NULL,

145: x_geography_element_column),
146: created_by_module =
147: DECODE(x_created_by_module,
148: NULL, created_by_module,
149: FND_API.G_MISS_CHAR, NULL,
150: x_created_by_module),
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: creation_date = creation_date,
153: created_by = created_by,

Line 159: FND_API.G_MISS_NUM, NULL,

155: last_update_login = hz_utility_v2pub.last_update_login,
156: application_id =
157: DECODE(x_application_id,
158: NULL, application_id,
159: FND_API.G_MISS_NUM, NULL,
160: x_application_id),
161: program_id = hz_utility_v2pub.program_id,
162: program_login_id =
163: DECODE(x_program_login_id,

Line 165: FND_API.G_MISS_NUM, NULL,

161: program_id = hz_utility_v2pub.program_id,
162: program_login_id =
163: DECODE(x_program_login_id,
164: NULL, program_login_id,
165: FND_API.G_MISS_NUM, NULL,
166: x_program_login_id),
167: program_application_id = hz_utility_v2pub.program_application_id,
168: request_id = hz_utility_v2pub.request_id
169: WHERE rowid = x_rowid;

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

291: ) IS
292: BEGIN
293:
294: SELECT
295: NVL(geography_id, FND_API.G_MISS_NUM),
296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),

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

292: BEGIN
293:
294: SELECT
295: NVL(geography_id, FND_API.G_MISS_NUM),
296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),

Line 297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),

293:
294: SELECT
295: NVL(geography_id, FND_API.G_MISS_NUM),
296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 298: NVL(relationship_type_id, FND_API.G_MISS_NUM),

294: SELECT
295: NVL(geography_id, FND_API.G_MISS_NUM),
296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),

Line 299: NVL(country_code, FND_API.G_MISS_CHAR),

295: NVL(geography_id, FND_API.G_MISS_NUM),
296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),
303: NVL(program_login_id, FND_API.G_MISS_NUM)

Line 300: NVL(geography_element_column, FND_API.G_MISS_CHAR),

296: NVL(geography_type, FND_API.G_MISS_CHAR),
297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),
303: NVL(program_login_id, FND_API.G_MISS_NUM)
304: INTO

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

297: NVL(parent_geography_type, FND_API.G_MISS_CHAR),
298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),
303: NVL(program_login_id, FND_API.G_MISS_NUM)
304: INTO
305: x_geography_id,

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

298: NVL(relationship_type_id, FND_API.G_MISS_NUM),
299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),
303: NVL(program_login_id, FND_API.G_MISS_NUM)
304: INTO
305: x_geography_id,
306: x_geography_type,

Line 303: NVL(program_login_id, FND_API.G_MISS_NUM)

299: NVL(country_code, FND_API.G_MISS_CHAR),
300: NVL(geography_element_column, FND_API.G_MISS_CHAR),
301: NVL(created_by_module, FND_API.G_MISS_CHAR),
302: NVL(application_id, FND_API.G_MISS_NUM),
303: NVL(program_login_id, FND_API.G_MISS_NUM)
304: INTO
305: x_geography_id,
306: x_geography_type,
307: x_parent_geography_type,

Line 325: RAISE FND_API.G_EXC_ERROR;

321: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
322: FND_MESSAGE.SET_TOKEN('RECORD', 'geo_structure_levels_rec');
323: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_geography_id));
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326:
327: END Select_Row;
328:
329: PROCEDURE Delete_Row (