DBA Data[Home] [Help]

APPS.PO_ASL_DOCUMENTS_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

    SELECT count(1)
    INTO   x_dummy_count
    FROM   PO_ASL_DOCUMENTS
    WHERE  x_asl_id = asl_id
    AND    x_using_organization_id = using_organization_id
    AND   (x_sequence_num = sequence_num
        OR x_document_header_id = document_header_id);
Line: 35

    IF (x_dummy_count > 0 AND x_record_status = 'INSERT') OR (x_dummy_count > 1 AND x_record_status <> 'INSERT') THEN
	return(FALSE);