DBA Data[Home] [Help]

APPS.HZ_GEO_STRUCTURE_LEVELS_PKG dependencies on HZ_UTILITY_V2PUB

Line 70: hz_utility_v2pub.last_updated_by,

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,

Line 71: hz_utility_v2pub.creation_date,

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,

Line 72: hz_utility_v2pub.created_by,

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,

Line 73: hz_utility_v2pub.last_update_date,

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

Line 74: hz_utility_v2pub.last_update_login,

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,

Line 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,

Line 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)

Line 83: hz_utility_v2pub.request_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)
87: ) RETURNING

Line 151: last_updated_by = hz_utility_v2pub.last_updated_by,

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,

Line 154: last_update_date = hz_utility_v2pub.last_update_date,

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,

Line 155: last_update_login = hz_utility_v2pub.last_update_login,

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,

Line 161: program_id = hz_utility_v2pub.program_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,
164: NULL, program_login_id,
165: FND_API.G_MISS_NUM, NULL,

Line 167: program_application_id = hz_utility_v2pub.program_application_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;
170:
171: IF ( SQL%NOTFOUND ) THEN

Line 168: request_id = hz_utility_v2pub.request_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
172: RAISE NO_DATA_FOUND;