APPS.HZ_TRANS_ATTRIBUTES_PKG dependencies on HZ_TRANS_ATTRIBUTES_S
Line 19: CURSOR C2 IS SELECT HZ_TRANS_ATTRIBUTES_s.nextval FROM sys.dual;
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER,
17: X_OBJECT_VERSION_NUMBER in NUMBER
18: ) is 19: CURSOR C2 IS SELECT HZ_TRANS_ATTRIBUTES_s.nextval FROM sys.dual; 20: l_success VARCHAR2(1) := 'N';
21: begin
22: WHILE l_success = 'N' LOOP
23: BEGIN
Line 67: SELECT HZ_TRANS_ATTRIBUTES_s.nextval
63: l_dummy VARCHAR2(1);
64: BEGIN
65: l_count := 1;
66: WHILE l_count > 0 LOOP 67: SELECT HZ_TRANS_ATTRIBUTES_s.nextval 68: into X_ATTRIBUTE_ID FROM sys.dual;
69: BEGIN
70: SELECT 'Y' INTO l_dummy
71: FROM HZ_TRANS_ATTRIBUTES_B