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

Line 30: FND_API.G_MISS_NUM, NULL,

26: last_update_login
27: )
28: VALUES (
29: DECODE(x_map_id,
30: FND_API.G_MISS_NUM, NULL,
31: x_map_id),
32: DECODE(x_loc_seq_num,
33: FND_API.G_MISS_NUM, NULL,
34: x_loc_seq_num),

Line 33: FND_API.G_MISS_NUM, NULL,

29: DECODE(x_map_id,
30: FND_API.G_MISS_NUM, NULL,
31: x_map_id),
32: DECODE(x_loc_seq_num,
33: FND_API.G_MISS_NUM, NULL,
34: x_loc_seq_num),
35: DECODE(x_loc_component,
36: FND_API.G_MISS_CHAR, NULL,
37: x_loc_component),

Line 36: FND_API.G_MISS_CHAR, NULL,

32: DECODE(x_loc_seq_num,
33: FND_API.G_MISS_NUM, NULL,
34: x_loc_seq_num),
35: DECODE(x_loc_component,
36: FND_API.G_MISS_CHAR, NULL,
37: x_loc_component),
38: DECODE(x_geography_type,
39: FND_API.G_MISS_CHAR, NULL,
40: x_geography_type),

Line 39: FND_API.G_MISS_CHAR, NULL,

35: DECODE(x_loc_component,
36: FND_API.G_MISS_CHAR, NULL,
37: x_loc_component),
38: DECODE(x_geography_type,
39: FND_API.G_MISS_CHAR, NULL,
40: x_geography_type),
41: DECODE(x_geo_element_col,
42: FND_API.G_MISS_CHAR, NULL,
43: x_geo_element_col),

Line 42: FND_API.G_MISS_CHAR, NULL,

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

Line 71: FND_API.G_MISS_NUM, NULL,

67: SET
68: map_id =
69: DECODE(x_map_id,
70: NULL, map_id,
71: FND_API.G_MISS_NUM, NULL,
72: x_map_id),
73: loc_seq_num =
74: DECODE(x_loc_seq_num,
75: NULL, loc_seq_num,

Line 76: FND_API.G_MISS_NUM, NULL,

72: x_map_id),
73: loc_seq_num =
74: DECODE(x_loc_seq_num,
75: NULL, loc_seq_num,
76: FND_API.G_MISS_NUM, NULL,
77: x_loc_seq_num),
78: loc_component =
79: DECODE(x_loc_component,
80: NULL, loc_component,

Line 81: FND_API.G_MISS_CHAR, NULL,

77: x_loc_seq_num),
78: loc_component =
79: DECODE(x_loc_component,
80: NULL, loc_component,
81: FND_API.G_MISS_CHAR, NULL,
82: x_loc_component),
83: geography_type =
84: DECODE(x_geography_type,
85: NULL, geography_type,

Line 86: FND_API.G_MISS_CHAR, NULL,

82: x_loc_component),
83: geography_type =
84: DECODE(x_geography_type,
85: NULL, geography_type,
86: FND_API.G_MISS_CHAR, NULL,
87: x_geography_type),
88: geo_element_col =
89: DECODE(x_geo_element_col,
90: NULL, geo_element_col,

Line 91: FND_API.G_MISS_CHAR, NULL,

87: x_geography_type),
88: geo_element_col =
89: DECODE(x_geo_element_col,
90: NULL, geo_element_col,
91: FND_API.G_MISS_CHAR, NULL,
92: x_geo_element_col),
93: last_updated_by = hz_utility_v2pub.last_updated_by,
94: creation_date = creation_date,
95: created_by = created_by,

Line 165: NVL(map_id, FND_API.G_MISS_NUM),

161: ) IS
162: BEGIN
163:
164: SELECT
165: NVL(map_id, FND_API.G_MISS_NUM),
166: NVL(loc_seq_num, FND_API.G_MISS_NUM),
167: NVL(loc_component, FND_API.G_MISS_CHAR),
168: NVL(geography_type, FND_API.G_MISS_CHAR)
169: INTO

Line 166: NVL(loc_seq_num, FND_API.G_MISS_NUM),

162: BEGIN
163:
164: SELECT
165: NVL(map_id, FND_API.G_MISS_NUM),
166: NVL(loc_seq_num, FND_API.G_MISS_NUM),
167: NVL(loc_component, FND_API.G_MISS_CHAR),
168: NVL(geography_type, FND_API.G_MISS_CHAR)
169: INTO
170: x_map_id,

Line 167: NVL(loc_component, FND_API.G_MISS_CHAR),

163:
164: SELECT
165: NVL(map_id, FND_API.G_MISS_NUM),
166: NVL(loc_seq_num, FND_API.G_MISS_NUM),
167: NVL(loc_component, FND_API.G_MISS_CHAR),
168: NVL(geography_type, FND_API.G_MISS_CHAR)
169: INTO
170: x_map_id,
171: x_loc_seq_num,

Line 168: NVL(geography_type, FND_API.G_MISS_CHAR)

164: SELECT
165: NVL(map_id, FND_API.G_MISS_NUM),
166: NVL(loc_seq_num, FND_API.G_MISS_NUM),
167: NVL(loc_component, FND_API.G_MISS_CHAR),
168: NVL(geography_type, FND_API.G_MISS_CHAR)
169: INTO
170: x_map_id,
171: x_loc_seq_num,
172: x_loc_component,

Line 183: RAISE FND_API.G_EXC_ERROR;

179: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
180: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map dtl');
181: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184:
185: END Select_Row;
186:
187: PROCEDURE Delete_Row (