APPS.HZ_TRANSFORMATIONS_PKG dependencies on FND_API

Line 26: IF ( x_transformation_id IS NULL) OR (x_transformation_id = FND_API.G_MISS_NUM) THEN

22: fnd_message.set_token('PROC',x_procedure_name);
23: app_exception.raise_exception;
24: end if;
25: l_object_version_number := x_object_version_number;
26: IF ( x_transformation_id IS NULL) OR (x_transformation_id = FND_API.G_MISS_NUM) THEN
27: OPEN C2;
28: FETCH C2 INTO x_transformation_id;
29: CLOSE C2;
30: END IF;

Line 31: IF ( l_object_version_number IS NULL) OR (l_object_version_number = FND_API.G_MISS_NUM) THEN

27: OPEN C2;
28: FETCH C2 INTO x_transformation_id;
29: CLOSE C2;
30: END IF;
31: IF ( l_object_version_number IS NULL) OR (l_object_version_number = FND_API.G_MISS_NUM) THEN
32: l_object_version_number :=1;
33: END IF;
34:
35: WHILE l_success = 'N' LOOP

Line 49: DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),

45: last_update_date
46: )
47: VALUES (
48: x_transformation_id,
49: DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),
50: l_object_version_number,
51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,

Line 136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),

132: fnd_message.set_token('PROC',x_procedure_name);
133: app_exception.raise_exception;
134: end if;
135: UPDATE HZ_TRANSFORMATIONS_B set
136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
137: object_version_number = p_object_version_number,
138: last_updated_by = hz_utility_v2pub.last_updated_by,
139: last_update_login = hz_utility_v2pub.last_update_login,
140: last_update_date = hz_utility_v2pub.last_update_date

Line 148: transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),

144: raise no_data_found;
145: end if;
146:
147: update HZ_TRANSFORMATIONS_TL set
148: transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),
149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
150: object_version_number = p_object_version_number,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: last_update_login = hz_utility_v2pub.last_update_login,

Line 149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),

145: end if;
146:
147: update HZ_TRANSFORMATIONS_TL set
148: transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),
149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
150: object_version_number = p_object_version_number,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: last_update_login = hz_utility_v2pub.last_update_login,
153: last_update_date = hz_utility_v2pub.last_update_date,