DBA Data[Home] [Help]

APPS.PO_ACCEPTANCES_INS_PVT dependencies on DUAL

Line 66: FROM SYS.DUAL;

62: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
63: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
64: CURSOR c_next_id IS
65: SELECT PO_ACCEPTANCES_S.nextval
66: FROM SYS.DUAL;
67:
68: BEGIN
69:
70: IF (x_acceptance_id IS NULL) THEN

Line 73: FROM SYS.DUAL;

69:
70: IF (x_acceptance_id IS NULL) THEN
71: SELECT PO_ACCEPTANCES_S.nextval
72: INTO l_id
73: FROM SYS.DUAL;
74: ELSE
75: l_id := x_acceptance_id;
76: END IF;
77: