APPS.HZ_GEO_STRUCT_MAP_PVT dependencies on FND_API

Line 28: FND_API.G_MISS_NUM, NULL,

24: last_update_login
25: )
26: VALUES (
27: DECODE(x_map_id,
28: FND_API.G_MISS_NUM, NULL,
29: x_map_id),
30: DECODE(x_country_code,
31: FND_API.G_MISS_CHAR, NULL,
32: x_country_code),

Line 31: FND_API.G_MISS_CHAR, NULL,

27: DECODE(x_map_id,
28: FND_API.G_MISS_NUM, NULL,
29: x_map_id),
30: DECODE(x_country_code,
31: FND_API.G_MISS_CHAR, NULL,
32: x_country_code),
33: DECODE(x_loc_tbl_name,
34: FND_API.G_MISS_CHAR, NULL,
35: x_loc_tbl_name),

Line 34: FND_API.G_MISS_CHAR, NULL,

30: DECODE(x_country_code,
31: FND_API.G_MISS_CHAR, NULL,
32: x_country_code),
33: DECODE(x_loc_tbl_name,
34: FND_API.G_MISS_CHAR, NULL,
35: x_loc_tbl_name),
36: DECODE(x_address_style,
37: FND_API.G_MISS_CHAR, NULL,
38: x_address_style),

Line 37: FND_API.G_MISS_CHAR, NULL,

33: DECODE(x_loc_tbl_name,
34: FND_API.G_MISS_CHAR, NULL,
35: x_loc_tbl_name),
36: DECODE(x_address_style,
37: FND_API.G_MISS_CHAR, NULL,
38: x_address_style),
39: hz_utility_v2pub.last_updated_by,
40: hz_utility_v2pub.creation_date,
41: hz_utility_v2pub.created_by,

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

105: ) IS
106: BEGIN
107:
108: SELECT
109: NVL(map_id, FND_API.G_MISS_NUM),
110: NVL(country_code, FND_API.G_MISS_CHAR),
111: NVL(loc_tbl_name, FND_API.G_MISS_CHAR),
112: NVL(address_style, FND_API.G_MISS_CHAR)
113: INTO

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

106: BEGIN
107:
108: SELECT
109: NVL(map_id, FND_API.G_MISS_NUM),
110: NVL(country_code, FND_API.G_MISS_CHAR),
111: NVL(loc_tbl_name, FND_API.G_MISS_CHAR),
112: NVL(address_style, FND_API.G_MISS_CHAR)
113: INTO
114: x_map_id,

Line 111: NVL(loc_tbl_name, FND_API.G_MISS_CHAR),

107:
108: SELECT
109: NVL(map_id, FND_API.G_MISS_NUM),
110: NVL(country_code, FND_API.G_MISS_CHAR),
111: NVL(loc_tbl_name, FND_API.G_MISS_CHAR),
112: NVL(address_style, FND_API.G_MISS_CHAR)
113: INTO
114: x_map_id,
115: x_country_code,

Line 112: NVL(address_style, FND_API.G_MISS_CHAR)

108: SELECT
109: NVL(map_id, FND_API.G_MISS_NUM),
110: NVL(country_code, FND_API.G_MISS_CHAR),
111: NVL(loc_tbl_name, FND_API.G_MISS_CHAR),
112: NVL(address_style, FND_API.G_MISS_CHAR)
113: INTO
114: x_map_id,
115: x_country_code,
116: x_loc_tbl_name,

Line 127: RAISE FND_API.G_EXC_ERROR;

123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
124: FND_MESSAGE.SET_TOKEN('RECORD', 'geo structure map');
125: FND_MESSAGE.SET_TOKEN('VALUE', x_map_id);
126: FND_MSG_PUB.ADD;
127: RAISE FND_API.G_EXC_ERROR;
128:
129: END Select_Row;
130:
131: PROCEDURE Delete_Row (