DBA Data[Home] [Help]

APPS.HZ_TRANSFORMATIONS_PKG dependencies on DUAL

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;