DBA Data[Home] [Help]

APPS.OKE_NOTE_PVT dependencies on DUAL

Line 16: -- validate individual attributes

12: RETURN(l_return_status);
13:
14: END validate_record;
15:
16: -- validate individual attributes
17:
18: FUNCTION validate_attributes(
19: p_note_rec IN note_rec_type
20: ) RETURN VARCHAR2 IS

Line 233: /* call individual validation procedure */

229: END IF;
230: END IF;
231:
232:
233: /* call individual validation procedure */
234: -- return status to caller
235: RETURN(x_return_status);
236:
237: END Validate_Attributes;

Line 609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;

605: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
606: RAISE OKE_API.G_EXCEPTION_ERROR;
607: END IF;
608:
609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;
610:
611: INSERT INTO OKE_K_STANDARD_NOTES_B(
612:
613: STANDARD_NOTES_ID ,