Line 13: CURSOR C2 IS SELECT HZ_TRANSFORMATIONS_S.nextval FROM sys.dual ;
9: x_object_version_number IN NUMBER
10: ) IS
11:
12: 13: CURSOR C2 IS SELECT HZ_TRANSFORMATIONS_S.nextval FROM sys.dual ; 14: l_success VARCHAR2(1) := 'N';
15: l_object_version_number NUMBER;
16: l_proc_valid VARCHAR2(10);
17: BEGIN
Line 67: into x_transformation_id FROM sys.dual;
63: BEGIN
64: l_count := 1;
65: WHILE l_count > 0 LOOP
66: SELECT HZ_TRANSFORMATIONS_S.nextval 67: into x_transformation_id FROM sys.dual; 68: BEGIN
69: SELECT 'Y' INTO l_dummy
70: FROM HZ_TRANSFORMATIONS_B
71: WHERE TRANSFORMATION_ID = X_TRANSFORMATION_ID;