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,
73: hz_utility_v2pub.last_update_date,
74: hz_utility_v2pub.last_update_login,
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,
73: hz_utility_v2pub.last_update_date,
74: hz_utility_v2pub.last_update_login,
75: DECODE(x_application_id,
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,
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,
69: x_created_by_module),
70: hz_utility_v2pub.last_updated_by,
71: hz_utility_v2pub.creation_date,
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),
70: hz_utility_v2pub.last_updated_by,
71: hz_utility_v2pub.creation_date,
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,
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,
81: x_program_login_id),
82: hz_utility_v2pub.program_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,
85: FND_API.G_MISS_CHAR, NULL,
86: x_addr_val_level)
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,
85: FND_API.G_MISS_CHAR, NULL,
86: x_addr_val_level)
87: ) RETURNING
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,
154: last_update_date = hz_utility_v2pub.last_update_date,
155: last_update_login = hz_utility_v2pub.last_update_login,
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,
154: last_update_date = hz_utility_v2pub.last_update_date,
155: last_update_login = hz_utility_v2pub.last_update_login,
156: application_id =
157: DECODE(x_application_id,
158: NULL, application_id,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: creation_date = creation_date,
153: created_by = created_by,
154: last_update_date = hz_utility_v2pub.last_update_date,
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,
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,
164: NULL, program_login_id,
165: FND_API.G_MISS_NUM, NULL,
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;
170:
171: IF ( SQL%NOTFOUND ) THEN
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;
170:
171: IF ( SQL%NOTFOUND ) THEN
172: RAISE NO_DATA_FOUND;