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,
42: hz_utility_v2pub.last_update_date,
43: hz_utility_v2pub.last_update_login
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,
42: hz_utility_v2pub.last_update_date,
43: hz_utility_v2pub.last_update_login
44: ) RETURNING
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,
42: hz_utility_v2pub.last_update_date,
43: hz_utility_v2pub.last_update_login
44: ) RETURNING
45: rowid
38: x_address_style),
39: hz_utility_v2pub.last_updated_by,
40: hz_utility_v2pub.creation_date,
41: hz_utility_v2pub.created_by,
42: hz_utility_v2pub.last_update_date,
43: hz_utility_v2pub.last_update_login
44: ) RETURNING
45: rowid
46: INTO
39: hz_utility_v2pub.last_updated_by,
40: hz_utility_v2pub.creation_date,
41: hz_utility_v2pub.created_by,
42: hz_utility_v2pub.last_update_date,
43: hz_utility_v2pub.last_update_login
44: ) RETURNING
45: rowid
46: INTO
47: x_rowid;