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,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login
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,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login
49: ) RETURNING
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,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login
49: ) RETURNING
50: rowid
43: x_geo_element_col),
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login
49: ) RETURNING
50: rowid
51: INTO
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_date,
48: hz_utility_v2pub.last_update_login
49: ) RETURNING
50: rowid
51: INTO
52: x_rowid;
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,
96: last_update_date = hz_utility_v2pub.last_update_date,
97: last_update_login = hz_utility_v2pub.last_update_login
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,
96: last_update_date = hz_utility_v2pub.last_update_date,
97: last_update_login = hz_utility_v2pub.last_update_login
98: WHERE rowid = x_rowid;
99: IF ( SQL%NOTFOUND ) THEN
100: RAISE NO_DATA_FOUND;
93: last_updated_by = hz_utility_v2pub.last_updated_by,
94: creation_date = creation_date,
95: created_by = created_by,
96: last_update_date = hz_utility_v2pub.last_update_date,
97: last_update_login = hz_utility_v2pub.last_update_login
98: WHERE rowid = x_rowid;
99: IF ( SQL%NOTFOUND ) THEN
100: RAISE NO_DATA_FOUND;
101: END IF;