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),
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),
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),
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),
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),
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),
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),
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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;
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),
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),
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),
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),
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)
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
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,
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,
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,
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 (