6: new_sequence_number NUMBER;
7: BEGIN
8: SELECT rg_row_orders_s.nextval
9: INTO new_sequence_number 10: FROM dual; 11:
12: RETURN(new_sequence_number);
13: END new_row_order_id;
14:
Line 50: SELECT 1 INTO dummy FROM sys.dual
46:
47: PROCEDURE check_references(X_row_order_id NUMBER) IS
48: dummy NUMBER;
49: BEGIN 50: SELECT 1 INTO dummy FROM sys.dual 51: WHERE NOT EXISTS
52: (SELECT 1
53: FROM rg_reports
54: WHERE row_order_id = X_row_order_id);